Monday, January 7, 2008

Some Oracle RAC Commands on Solaris platform

The following are the set of commands and their output are just to get an overview on how RAC commands output looks like :-)

HOW TO CHECK ORACLE 10G CRS STATUS?

$ /u01/app/oracle/product/10.2.0/crs/bin/crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SM1.asm application ONLINE ONLINE abcracprd1
ora....D1.lsnr application ONLINE ONLINE abcracprd1
ora....rd1.gsd application ONLINE ONLINE abcracprd1
ora....rd1.ons application ONLINE ONLINE abcracprd1
ora....rd1.vip application ONLINE ONLINE abcracprd1
ora....SM2.asm application ONLINE ONLINE abcracprd2
ora....D2.lsnr application ONLINE ONLINE abcracprd2
ora....rd2.gsd application ONLINE ONLINE abcracprd2
ora....rd2.ons application ONLINE ONLINE abcracprd2
ora....rd2.vip application ONLINE ONLINE abcracprd2
ora....SM3.asm application ONLINE ONLINE abcracprd3
ora....D3.lsnr application ONLINE ONLINE abcracprd3
ora....rd3.gsd application ONLINE ONLINE abcracprd3
ora....rd3.ons application ONLINE ONLINE abcracprd3
ora....rd3.vip application ONLINE ONLINE abcracprd3
ora....bprd.db application ONLINE OFFLINE
ora....d1.inst application ONLINE OFFLINE
ora....d2.inst application ONLINE OFFLINE
ora....d3.inst application ONLINE OFFLINE
ora.nbtest.db application ONLINE ONLINE abcracprd2
ora....t1.inst application ONLINE ONLINE abcracprd1
ora....t2.inst application ONLINE ONLINE abcracprd2
ora....t3.inst application ONLINE ONLINE abcracprd3
ora....mcdb.db application ONLINE ONLINE abcracprd3
ora....b1.inst application ONLINE ONLINE abcracprd1
ora....b2.inst application ONLINE ONLINE abcracprd2
ora....b3.inst application ONLINE ONLINE abcracprd3
ora....atch.cs application ONLINE ONLINE abcracprd1
ora....db1.srv application ONLINE ONLINE abcracprd1
ora....orms.cs application ONLINE ONLINE abcracprd3
ora....db1.srv application ONLINE ONLINE abcracprd1
ora....db2.srv application ONLINE ONLINE abcracprd2
ora....db3.srv application ONLINE ONLINE abcracprd3
ora....orts.cs application ONLINE ONLINE abcracprd3
ora....db1.srv application ONLINE ONLINE abcracprd1
ora....db2.srv application ONLINE ONLINE abcracprd2
ora....db3.srv application ONLINE ONLINE abcracprd3
ora....asdb.db application ONLINE ONLINE abcracprd2
ora....b1.inst application ONLINE ONLINE abcracprd1
ora....b2.inst application ONLINE ONLINE abcracprd2
ora....b3.inst application ONLINE ONLINE abcracprd3
ora.testias.db application ONLINE OFFLINE
ora....s1.inst application OFFLINE OFFLINE
ora....s2.inst application OFFLINE OFFLINE
ora....s3.inst application OFFLINE OFFLINE


HOW TO CHECK ORACLE 10G APPLICATION SERVER STATUS (using opmnctl)

$/u01/app/oracle/product/10.1.3.1/OracleAS_1/opmn/bin/opmnctl status

Processes in Instance: iasj2eet.abcmidt3.somecompany.com
---------------------------------+--------------------+---------+---------
ias-component process-type pid status
---------------------------------+--------------------+---------+---------
OC4JGroup:abcwebgrp OC4J:abcweb 27783 Alive
OC4JGroup:default_group OC4J:home 18315 Alive
ASG ASG N/A DownHTTP_Server HTTP_Server 18314 Alive



CHECKING ORACLE LISTENER STATUS/ START / STOP

To see the status of oracle listener:
->lsnrctl status

LSNRCTL for Solaris: Version 10.2.0.3.0 - Production on 18-DEC-2007 09:05:19

Copyright (c) 1991, 2006, Oracle. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Solaris: Version 10.2.0.3.0 - Production
Start Date 17-DEC-2007 06:53:18
Uptime 1 days 2 hr. 12 min. 1 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Log File /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=abcbtchp1.somecompany.com)(PORT=1521)))
Services Summary...
Service "abcrman.somecompany.com" has 1 instance(s).
Instance "abcrman", status READY, has 1 handler(s) for this service...
Service "abcrmanXDB.somecompany.com" has 1 instance(s).
Instance "abcrman", status READY, has 1 handler(s) for this service...
Service "abcrman_XPT.somecompany.com" has 1 instance(s).
Instance "abcrman", status READY, has 1 handler(s) for this service...
The command completed successfully

To start oracle listener:
oracle@servername-> lsnrctl start

To start oracle listener:
oracle@servername-> lsnrctl start

No comments: