asked on query physical standby database with dblink
Hello,
I try to query physical standby database with dblink for monitoring :
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
Process ID: 0
Session ID: 0 Serial number: 0
How can I resolve?
Thanks
Regards
I try to query physical standby database with dblink for monitoring :
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
Process ID: 0
Session ID: 0 Serial number: 0
How can I resolve?
Thanks
Regards
Oracle Database
Last Comment
slightwv (䄆 Netminder)
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
It depends on what Data Guard options they have.
http://www.oracle.com/us/products/database/options/active-data-guard/overview/index.html
Even if it is the 'classic', I think you would need to have the standby server properly licensed to start it up for things like 'reporting'.
http://www.oracle.com/us/products/database/options/active-data-guard/overview/index.html
Read-only access to a physical standby database for production workload offloading
Even if it is the 'classic', I think you would need to have the standby server properly licensed to start it up for things like 'reporting'.
Has it come up completely?
Log into the standby server and check the alert log.