Oracle DataGuard switchover issue

I have registered the static entry with listener.

Oracle 11gR2

AEMF> switchover to "DRTEST";
Performing switchover NOW, please wait...
New primary database "DRTEST" is opening...
Operation requires shutdown of instance "TEST1" on database "TEST"
Shutting down instance "TEST1"...
ORACLE instance shut down.
Operation requires startup of instance "TEST1" on database "TEST"
Starting instance "TEST1"...
Unable to connect to database
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

Failed.
Warning: You are no longer connected to ORACLE.

Please complete the following steps to finish switchover:
        start up and mount instance "TEST1" of database "TEST"

AEMF> exit
themeeper1Asked:
Who is Participating?
 
DavidConnect With a Mentor Senior Oracle Database AdministratorCommented:
The ORA error suggests you may have a malformed TNSNAMES.ORA; would you please post the relevant part as a code snippet.
0
 
DavidSenior Oracle Database AdministratorCommented:
Okay.... what are you asking as a question, and what have you tried on your own to solve this.
0
 
themeeper1Author Commented:
I have tried to reload the listener, and verified that staticconnectidentifier property is correct for both databases. Why am I still receiving this error?
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
themeeper1Author Commented:
I have tried the startup mount of test1 instance as well and it's the same error.
0
 
Geert GOracle dbaCommented:
DR ...
this is a standby database setup you are trying to switchover ?

the database instance name is TEST1 on both servers ?
only the server names are different ?
0
 
themeeper1Author Commented:
Yes this was a DR standby database. DVZ is correct, the TNSNAMES.ora was malformed.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.