[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 424
  • Last Modified:

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
0
themeeper1
Asked:
themeeper1
  • 3
  • 2
1 Solution
 
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
 
themeeper1Author Commented:
I have tried the startup mount of test1 instance as well and it's the same error.
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
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
 
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

Featured Post

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now