[oracle@RAC1 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....11.inst application ONLINE ONLINE rac1
ora....12.inst application ONLINE OFFLINE
ora.RACDB1.db application ONLINE ONLINE rac1
ora....SM1.asm application ONLINE ONLINE rac1
ora....C1.lsnr application ONLINE ONLINE rac1
ora.rac1.gsd application ONLINE ONLINE rac1
ora.rac1.ons application ONLINE ONLINE rac1
ora.rac1.vip application ONLINE ONLINE rac1
ora....SM2.asm application ONLINE OFFLINE
ora....C2.lsnr application ONLINE OFFLINE
ora.rac2.gsd application ONLINE OFFLINE
ora.rac2.ons application ONLINE OFFLINE
ora.rac2.vip application ONLINE OFFLINE
[oracle@RAC1 ~]$ crs_start -t
Usage: crs_start resource_name [...] [-c cluster_member] [-f] [-q] [" attrib=value ..."]
crs_start -all [-q]
[oracle@RAC1 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....11.inst application ONLINE ONLINE rac1
ora....12.inst application ONLINE ONLINE rac2
ora.RACDB1.db application ONLINE ONLINE rac1
ora....SM1.asm application ONLINE ONLINE rac1
ora....C1.lsnr application ONLINE ONLINE rac1
ora.rac1.gsd application ONLINE ONLINE rac1
ora.rac1.ons application ONLINE ONLINE rac1
ora.rac1.vip application ONLINE ONLINE rac1
ora....SM2.asm application ONLINE ONLINE rac2
ora....C2.lsnr application ONLINE ONLINE rac2
ora.rac2.gsd application ONLINE ONLINE rac2
ora.rac2.ons application ONLINE ONLINE rac2
ora.rac2.vip application ONLINE ONLINE rac2
[oracle@RAC1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Jan 13 08:56:04 2011

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL> show parameter instance

NAME TYPE VALUE
------------------------------------ ----------- --------------------- ---------
active_instance_count integer
cluster_database_instances integer 2
instance_groups string
instance_name string RACDB11
instance_number integer 1
instance_type string RDBMS
open_links_per_instance integer 4
parallel_instance_group string
parallel_server_instances integer 2
SQL> host
[oracle@RAC1 ~]$ lsnrctl

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 13-JAN-2011 08:5 6:16

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

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> status
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER_RAC1
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Prod uction
Start Date 13-JAN-2011 08:48:46
Uptime 0 days 0 hr. 7 min. 32 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /opt/ora10g/product/10.2.0/db_1/network/admi n/listener.ora
Listener Log File /opt/ora10g/product/10.2.0/db_1/network/log/ listener_rac1.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=RAC1)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status BLOCKED, has 1 handler(s) for this service. ..
Service "+ASM_XPT" has 1 instance(s).
Instance "+ASM1", status BLOCKED, has 1 handler(s) for this service. ..
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this ser vice...
Service "RACDB1" has 2 instance(s).
Instance "RACDB11", status READY, has 1 handler(s) for this service. ..
Instance "RACDB12", status READY, has 1 handler(s) for this service. ..
Service "RACDB1XDB" has 2 instance(s).
Instance "RACDB11", status READY, has 1 handler(s) for this service. ..
Instance "RACDB12", status READY, has 1 handler(s) for this service. ..
Service "RACDB1_XPT" has 2 instance(s).
Instance "RACDB11", status READY, has 1 handler(s) for this service. ..
Instance "RACDB12", status READY, has 1 handler(s) for this service. ..
The command completed successfully
LSNRCTL> services
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status BLOCKED, has 1 handler(s) for this service. ..
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "+ASM_XPT" has 1 instance(s).
Instance "+ASM1", status BLOCKED, has 1 handler(s) for this service. ..
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this ser vice...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "RACDB1" has 2 instance(s).
Instance "RACDB11", status READY, has 1 handler(s) for this service. ..
Handler(s):
"DEDICATED" established:0 refused:0 state:blocked
REMOTE SERVER
(ADDRESS=(PROTOCOL=TCP)(HOST=RAC2)(PORT=1521))
Instance "RACDB12", status READY, has 1 handler(s) for this service. ..
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
REMOTE SERVER
(ADDRESS=(PROTOCOL=TCP)(HOST=RAC2)(PORT=1521))
Service "RACDB1XDB" has 2 instance(s).
Instance "RACDB11", status READY, has 1 handler(s) for this service. ..
Handler(s):
"D000" established:0 refused:0 current:0 max:972 state:ready
DISPATCHER
(ADDRESS=(PROTOCOL=tcp)(HOST=RAC1)(PORT=32798))
Instance "RACDB12", status READY, has 1 handler(s) for this service. ..
Handler(s):
"D000" established:0 refused:0 current:0 max:972 state:ready
DISPATCHER
(ADDRESS=(PROTOCOL=tcp)(HOST=RAC2)(PORT=32801))
Service "RACDB1_XPT" has 2 instance(s).
Instance "RACDB11", status READY, has 1 handler(s) for this service. ..
Handler(s):
"DEDICATED" established:0 refused:0 state:blocked
REMOTE SERVER
(ADDRESS=(PROTOCOL=TCP)(HOST=RAC2)(PORT=1521))
Instance "RACDB12", status READY, has 1 handler(s) for this service. ..
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
REMOTE SERVER
(ADDRESS=(PROTOCOL=TCP)(HOST=RAC2)(PORT=1521))
The command completed successfully
LSNRCTL> exit
[oracle@RAC1 ~]$ tsnping racdb11
bash: tsnping: command not found
[oracle@RAC1 ~]$ tnsping racdb11

TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 13-JAN-2011 08:56:56

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter files:
/opt/ora10g/product/10.2.0/db_1/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = racdb1)))
OK (50 msec)
[oracle@RAC1 ~]$ tnsping racdb12

TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 13-JAN-2011 08:57:00

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter files:
/opt/ora10g/product/10.2.0/db_1/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = racdb1)))
OK (110 msec)
[oracle@RAC1 ~]$ tnsping racdb1

TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 13-JAN-2011 08:57:08

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter files:
/opt/ora10g/product/10.2.0/db_1/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip)(PORT = 1521)) (LOAD_BALANCE = yes) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = RACDB1)))
OK (110 msec)

[oracle@RAC1 ~]$ sqlplus scott/abcdef@racdb1

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Jan 13 09:04:14 2011

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL> show parameter instance

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
active_instance_count integer
cluster_database_instances integer 2
instance_groups string
instance_name string RACDB12
instance_number integer 2
instance_type string RDBMS
open_links_per_instance integer 4
parallel_instance_group string
parallel_server_instances integer 2