1.

How Do We Verify That Rac Instances Are Running?

Answer»

Issue the following QUERY from any one node connecting through SQL*PLUS. $CONNECT sys/sys as sysdba
SQL>select * from V$ACTIVE_INSTANCES;
The query gives the instance NUMBER under INST_NUMBER column,host_:instancename under INST_NAME column.

Issue the following query from any one node connecting through SQL*PLUS. $connect sys/sys as sysdba
SQL>select * from V$ACTIVE_INSTANCES;
The query gives the instance number under INST_NUMBER column,host_:instancename under INST_NAME column.


Discussion

No Comment Found

Related InterviewSolutions