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