Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Correct way to know the number of Database instances

Rafi (Oracle DBA)Jan 6 2010 — edited Mar 3 2010
Hi All,
I have a clustered Database which has two instance.

When I check the number of instances using SQL PLUS >select *from gv$instance

I can see two instances running on two different servers


But,
When I use srvctl as:
$srvctl status database -d DB_NAME

I'm seeing 3 instances:
Among which 2 are running
1 is not running.


Q)Is the 3rd instance is removed from Database using Oracle Enterprise Manager Grid Control
Because from my Grid control Account also I can see 2 instances Up and running.


Thanks,
Rafi.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 31 2010
Added on Jan 6 2010
7 comments
1,071 views