Hello!
On my 12c test RAC environment when I execute the below srvctl command from either node (2 nodes) as the grid or oracle user it displays this:
[grid@rac01 bin]$ srvctl status database -d db1
Instance db1_1 is running on node rac01
Instance db1_2 is not running on node rac02
If I run the following SQL from sessions on both nodes I can see they are logging into both nodes:
SELECT host_name FROM gv$instance WHERE instance_number=userenv('instance');
HOST_NAME
---------
rac01
...
HOST_NAME
---------
rac02
I can execute SQL with no problems and pull up data when logged into either node. I don't see any errors in the alert or cluster logs.
Has srvctl status database been deprecated? If not why is it reporting an incorrect state?
Thanks,
Mary