Switchover is not smooth using dataguard DGMGRL Command line utility
444853May 31 2005 — edited Sep 15 2009Hi,
We have simple oracle 10g(10.1.0.3) dataguard implementation with a primary and
a physical standby database. Basic dataguard functionality works properly. We
are trying to simplyfy the switchover and failover operation using DGMGRL CLI.
After configuring and enabling DR in DGMGRL, i'm trying switchover from primary
to physical standby. While doing this switchover operation, i'm getting
"ORA-12514: TNS:listener does not currently know of service requested in
connect descriptor" error. Did dynamic service registration for net service.
Following are the parameter values from primary.
*.instance_name='TTRORDBP'
*.db_name='TTRORDBP'
*.db_unique_name='ttrordbp'
*.local_listener='TTRORDBP_DGMGRL'
*.service_names='ttrordbp, TTRORDBP_XPT, TTRORDBP_DGMGRL','TTRORDBP_XPT'
Also have attached listener.ora and tnsnames.ora files from primary & standby as an attachment.
Understanding is that, DGMGRL is looking for specific service name (db_unique_name_DGMGRL.domain, i guess in my case TTRORDBP_DGMGRL) in order to complete auto shutdown and restart of primary and standby DBs while performing switchover and failover.
I'm guess the net service is getting de-registered here... Could you please help me in get rid of this
error. Would really appreciate your help on this.
Another question, Is it must to do static service registration for auto
shutdown and restart of DBs by DGMGRL?
Thanks very much.
Following are what i did from primary DB.
DGMGRL> show configuration
Configuration
Name: TTRDR
Enabled: YES
Protection Mode: MaxAvailability
Databases:
TTRORDBS - Physical standby database
TTRORDBP - Primary database
Current status for "TTRDR":
SUCCESS
DGMGRL> SWITCHOVER TO 'TTRORDBS';
Performing switchover NOW. Please wait...
Operation requires shutdown of instance "TTRORDBP" on database "TTRORDBP".
Shutting down instance "TTRORDBP"...
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
Operation requires shutdown of instance "TTRORDBS" on database "TTRORDBS".
Shutting down instance "TTRORDBS"...
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
Operation requires startup of instance "TTRORDBP" on database "TTRORDBP".
Starting instance "TTRORDBP"...
Unable to connect to database
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
Failed.
You are no longer connected to ORACLE
Please connect again.
Unable to start instance "TTRORDBP".
You must start instance "TTRORDBP" manually.
Operation requires startup of instance "TTRORDBS" on database "TTRORDBS".
You must start instance "TTRORDBS" manually.
Switchover succeeded. New primary is "TTRORDBS"
DGMGRL> exit