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?
 
DavidSenior 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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
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.