Link to home
Start Free TrialLog in
Avatar of bibi92
bibi92Flag for France

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
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Did you start the standby database?
Has it come up completely?

Log into the standby server and check the alert log.
ASKER CERTIFIED SOLUTION
Avatar of johnsone
johnsone
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
It depends on what Data Guard options they have.

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'.