Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DG Switchover fails

Matt KingJan 31 2017 — edited Mar 5 2017

I'm attempting to finish my DG connection configuration and it seems from what I'm following I've done this correctly, however; when I attempt to perform a switchover, I get a failure. I'm not quite sure where I have messed up if this is just a naming issue? I have typed out below what I have done as well as the error message I've recieved.

Primary database:

db_name: MDBC2S1

db_unique_name: MDBC2S1

Secondary Database:

db_name:MDBC2S1

db_unique_name:MDBC2S2

DGMGRL > Show configuration

configuration - my_dg_config

protection mode MaxPerformance

members:

mdbc2s1 - Primary database

mdbc2s2 - Physical Standby Database

Fast-Start Failover: DISABLED

Configuration Status: Sucess

DGMGRL> show database mdbc2s1

role: primary

intended state: trandport-on

Instances: MDBC2S1

DGMGRL> show databse mdbc2s2

role Physical Standby

Intended State: Apply-ON

Transport Lag 0 seconds

Apply Lag 0 Seconds

Average Apply Rate: 13.67

Database Status: SUCCESS

Switchover to mdbc2s2

Performing Switchover NOW ... please wait.

Operation requires a connection to instance "MDBC2S1" on database "mdbc2s2"

Connecting to instance "MDBC2S1"

Connected as SYSDBA

New primary databse "mdbc2s2" is opening...

Operation requires start up of instance "MDBC2S1" on database "mdbc2s1"

Starting Instance "MDBC2S1"...

unable to connect to databse using (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp) (HOST= <Primary Oracle Server hostname> ) (Port = 1521) ) (Connect_Data=(Service_Name=MDBC2S1_DGMGRL)(INSTANCE_NAME=MDBC2S1)(SERVER=DEDICATED)))

ORA-12514: TNS:Listner does not currently know of service requested in connect descriptor

Failed

You are no longer conencted to oracle

please complete the following steps to finish switchover:

Startup instance MDBC2S1 of database mdbc2s1

This post has been answered by mseberg on Jan 31 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 2 2017
Added on Jan 31 2017
39 comments
7,073 views