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
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
themeeper1Author Commented:
I have tried the startup mount of test1 instance as well and it's the same error.
0
 
Geert GruwezOracle 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
All Courses

From novice to tech pro — start learning today.