Automatic database startup issues after switchiver (split from hijacked topic) [message #682373] |
Tue, 20 October 2020 16:01 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](//www.gravatar.com/avatar/8d5b325f29e525989f936d7baf704d28?s=64&d=mm&r=g) |
Dusca16
Messages: 5 Registered: October 2020
|
Junior Member |
|
|
Dear all,
Sorry for recover this old topic but I'm facing the same issue, my standby never startup automatically in mount mode after a switchover, always related with error: "ORA-12514: TNS: listener does not currently know of service requested in connect descriptor." I always start it layter manually.
Some of you are reporting the observer, but in my opinion in production environment, the FSFO option should be disabled. Switchover and Failover are typical DBA jobs.
I have Data Guard installed in several environments, with exactly the same configuration. This error only happens in some, not all.
Have you found the solution?
Thanks
|
|
|
|
|
Re: Automatic database startup issues after SWITCHOVER! [message #682383 is a reply to message #682378] |
Wed, 21 October 2020 08:35 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8964 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
When using Data Guard, you have to define static registrations, a SID_LIST, for the instance and the DG Broker service in your listener.ora file(s). You have not done this, so when you do a switchover the instance de-registers from the listener as it shuts down and the Broker can't reconnect to start it up again.
|
|
|
|
|
|
|
|
|