Question: I have set-up a Primary 11g
database which successfully ships and applies logs to a Single
Standby (on the same server) as expected. Manual switchovers work
fine; however, I cannot do switchovers with the Data Guard Broker
utility.
The switchover is successful- but the broker cannot
restart the Primary instance. The strange thing is that when I
perform a switchover in the opposite direction (i.e. the new Primary
goes back to standby again) it works fine. The error on switchover
is:
ORA-12514: TNS: listener does not currently know
of service requested in connect descriptor.
I can manually start the failover instance, but how do I
get my instance to re-start automatically after a switchover?
Answer: The book "Oracle
Data Guard" has working examples of Data Guard
switchover/failover in the code depot download:
Also see my
notes on the ORA-12514 error
ORA-12514 TNS_listener_does_not_currently_know_service_requested
Here are some issues with the ORA-12514 during Data
Guard failover. First, run these Data Guard broker commands to
see the status of the standby instance:
DGMGRL> show database
verbose ‘mystandbysid’;
DGMGRL> switchover to 'mystandbysid';
Some DBA's suggest that this startup error may be because the
special service db_unique_name_DGMGRL has not been
registered properly with the listener.
If you want to enable
DGMGRL to automatically re-start a standby database instance, you
list create a listener service and register the service with the
local listener on both the primary and failover/standby instance.
The value GLOBAL_DBNAME should be a concatenation of
the db_name and the domain name: e. g.
db_unique_name_DGMGRL.db_domain.
For example:
LISTENER = (DESCRIPTION
=
(ADDRESS_LIST=(
ADDRESS=(PROTOCOL=tcp)(HOST=host_name) (PORT=port_num)
)))
SID_LIST_LISTENER=
(SID_LIST=(
SID_DESC=(SID_NAME=sid_name)
(GLOBAL_DBNAME=db_unique_name_DGMGRL.db_domain)
ORACLE_HOME=oracle_home)))
|
|
Get the Complete
Oracle SQL Tuning Information
The landmark book
"Advanced Oracle
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
buy it
for 30% off directly from the publisher.
|