PUNE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = racscan)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = pune)
(FAILOVER_MODE=(METHOD=basic)(TYPE=select))
(LOAD_BALANCE=YES)
(FAILOVER=ON)
)
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = racscan)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = pune)
(FAILOVER_MODE=(METHOD=basic)(TYPE=select))
(LOAD_BALANCE=YES)
(FAILOVER=ON)
)
)
SQL> select INSTANCE_NAME, status from v$instance;
INSTANCE_NAME STATUS
---------------- ------------
pune1 OPEN
SQL> select INSTANCE_NAME, status from v$instance;
INSTANCE_NAME STATUS
---------------- ------------
pune2 OPEN
On a different window:
----------------------
INSTANCE_NAME STATUS
---------------- ------------
pune2 OPEN
On a different window:
----------------------
[oracle@rac1pub117 admin]$ sqlplus shoaib/shoaib@pune
sql> select * from dba_source;
On Node 2:
----------
[oracle@rac1pub117 admin]$ sqlplus / as sysdba
sql> select inst_id,username,service_name,failover_type,failover_method,failed_over from gv$session where username='SHOAIB';
INST_ID USERNAME SERVICE_NAME FAILOVER_TYPE FAILOVER_METHOD FAILED-OVER
-------------------------------------------------------------------------
1 SHOAIB pune SELECT BASIC NO
On Node 2:
----------
[oracle@rac1pub117 admin]$ sqlplus / as sysdba
sql> select inst_id,username,service_name,failover_type,failover_method,failed_over from gv$session where username='SHOAIB';
INST_ID USERNAME SERVICE_NAME FAILOVER_TYPE FAILOVER_METHOD FAILED-OVER
-------------------------------------------------------------------------
1 SHOAIB pune SELECT BASIC NO
On Node 1:
----------
----------
sql> shut immediate;
On Node 2:
----------
sql>select inst_id,username,service_name,failover_type,failover_method,failed_over from gv$session where username='SHOAIB';
INST_ID USERNAME SERVICE_NAME FAILOVER_TYPE FAILOVER_METHOD FAILED-OVER
-------------------------------------------------------------------------
2 SHOAIB pune SELECT BASIC YES
On Node 2:
----------
sql>select inst_id,username,service_name,failover_type,failover_method,failed_over from gv$session where username='SHOAIB';
INST_ID USERNAME SERVICE_NAME FAILOVER_TYPE FAILOVER_METHOD FAILED-OVER
-------------------------------------------------------------------------
2 SHOAIB pune SELECT BASIC YES
No comments:
Post a Comment