current configuartion
DGMGRL> show configuration
Configuration - broker_config
Protection Mode: MaxPerformance
Databases:
TROY - Primary database
TROY_DR - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
during switchover
DGMGRL> switchover to 'TROY_DR'
Performing switchover NOW, please wait...
New primary database "TROY_DR" is opening...
Operation requires shutdown of instance "TROY1" on database "TROY"
Shutting down instance "TROY1"...
ORACLE instance shut down.
Operation requires startup of instance "TROY1" on database "TROY"
Starting instance "TROY1"...
Unable to connect to database
ORA-12541: TNS:no listener
Failed.
Warning: You are no longer connected to ORACLE.
Please complete the following steps to finish switchover:
start up instance "TROY1" of database "TROY"
permanent fix
check StaticConnectIdentifier and compare it with local listener. it was incosistent with port no. (1521 / 1525)
in local listener we have chnaged the port to 1521 but didn’t recreted the configuration in dgmgrl hence port mismatch
TROY1@ol6-112-dr-rac1 > select inst_id,value from gv$parameter where name like 'local_l%';
VALUE
--------------------------------------------------------------------------------
(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.189.133)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.189.134)(PORT=1521))
TROY1@ol6-112-rac1 > select value from gv$parameter where name like 'local_l%';
VALUE
--------------------------------------------------------------------------------
(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.189.123)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.189.124)(PORT=1521))
in dgmgrl it is still 1525
DGMGRL> show instance verbose 'TROY1' on database 'TROY';
Instance 'TROY1' of database 'TROY'
Host Name: ol6-112-rac1.localdomain
PFILE:
Properties:
SidName = 'TROY1'
StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.189.123)(PORT=1525))(CONNECT_DATA=(SERVICE_NAME=TROY_DGMGRL.localdomain)(INSTANCE_NAME=TROY1)(SERVER=DEDICATED)))'
StandbyArchiveLocation = 'USE_DB_RECOVERY_FILE_DEST'
AlternateLocation = ''
LogArchiveTrace = '0'
LogArchiveFormat = 'TROY_%t_%s_%r.arc'
TopWaitEvents = '(monitor)'
Instance Status:
SUCCESS
DGMGRL> show instance verbose 'TROY2' on database 'TROY';
Instance 'TROY2' of database 'TROY'
Host Name: ol6-112-rac2.localdomain
PFILE:
Properties:
SidName = 'TROY2'
StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.189.124)(PORT=1525))(CONNECT_DATA=(SERVICE_NAME=TROY_DGMGRL.localdomain)(INSTANCE_NAME=TROY2)(SERVER=DEDICATED)))'
StandbyArchiveLocation = 'USE_DB_RECOVERY_FILE_DEST'
AlternateLocation = ''
LogArchiveTrace = '0'
LogArchiveFormat = 'TROY_%t_%s_%r.arc'
TopWaitEvents = '(monitor)'
Instance Status:
SUCCESS
DGMGRL> show instance verbose 'TROY1' on database 'TROY_DR'
Instance 'TROY1' of database 'TROY_DR'
Host Name: ol6-112-dr-rac1.localdomain
PFILE:
Properties:
SidName = 'TROY1'
StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.189.133)(PORT=1525))(CONNECT_DATA=(SERVICE_NAME=TROY_DR_DGMGRL.localdomain)(INSTANCE_NAME=TROY1)(SERVER=DEDICATED)))'
StandbyArchiveLocation = 'USE_DB_RECOVERY_FILE_DEST'
AlternateLocation = ''
LogArchiveTrace = '0'
LogArchiveFormat = 'TROY_%t_%s_%r.arc'
TopWaitEvents = '(monitor)'
Instance Status:
SUCCESS
DGMGRL> show instance verbose 'TROY2' on database 'TROY_DR'
Instance 'TROY2' of database 'TROY_DR'
Host Name: ol6-112-dr-rac2.localdomain
PFILE:
Properties:
SidName = 'TROY2'
StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.189.134)(PORT=1525))(CONNECT_DATA=(SERVICE_NAME=TROY_DR_DGMGRL.localdomain)(INSTANCE_NAME=TROY2)(SERVER=DEDICATED)))'
StandbyArchiveLocation = 'USE_DB_RECOVERY_FILE_DEST'
AlternateLocation = ''
LogArchiveTrace = '0'
LogArchiveFormat = 'TROY_%t_%s_%r.arc'
TopWaitEvents = '(monitor)'
Instance Status:
SUCCESS
so drop and recreate configuartion
https://dbatracker.com/2020/12/23/deleting-broker-configuartion-and-adding-back/