Tuesday, 28 June 2011

ORA-12514 during Switchover using DG broker with multiple IP segment

Our new system 2 node RAC Oracle 11.2.0.2 are setup with 1 instance of Standby database. Yesterday we tested to switchover to standby database using 'dgmgrl'. The switchover was ok , only that my Primary Node (Node1) was not automatically restarted instead throwing ORA-12514 - TNS:listener does not currently know of service requested in connect descriptor. 
I checked all my listener for DG broker have been setup with static listener, which usually this is the cause of this error. Everything looks properly setup until I checked each instance Broker configuration "StaticConnectIdentifier"(New parameter in 11g) property :
dgmgrl > show instance verbose "PRD1"
...
StaticConnectIdentifier='(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.22.2.29)(PORT=1532))(CONNECT_DATA=(SERVICE_NAME=PRD_DGMGRL)(INSTANCE_NAME=PRD1)(SERVER=DEDICATED)))';

dgmgrl > show instance verbose "PRD2"
StaticConnectIdentifier='(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.22.2.30)(PORT=1532))(CONNECT_DATA=(SERVICE_NAME=PRD_DGMGRL)(INSTANCE_NAME=PRD2)(SERVER=DEDICATED)))';

Well, we configure all the static listener on 172.22.12.7 (VIP1 - Segment 12) and 172.22.12.9 (VIP2 - Segment 12). I remember that IP segment 172.22.2.xx was the initial VIP segment during the installation. 

Then I just change it to the correct IP and port number.
dgmgrl> edit instance 'PRD1' set property StaticConnectIdentifier='(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.22.12.7)(PORT=1523))(CONNECT_DATA=(SERVICE_NAME=PRD_DGMGRL)(INSTANCE_NAME=PRD1)(SERVER=DEDICATED)))';
dgmgrl> edit instance 'PRD2' set property StaticConnectIdentifier='(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.22.12.9)(PORT=1523))(CONNECT_DATA=(SERVICE_NAME=PRD_DGMGRL)(INSTANCE_NAME=PRD2)(SERVER=DEDICATED)))';

After this changes my switchover was running smoothly without any error. Problem solved!

5 comments:

  1. Thanks for sharing. Excellent.

    ReplyDelete
  2. You're most welcome Sathish.

    ReplyDelete
  3. That is really nice to hear. thank you for the update and good luck. City Index app review

    ReplyDelete
  4. It's the Ravens' day. Lamar Jackson is the front-runner for Offensive MVP after throwing 185 yards and two scores. Mark Andrews broke a Pro Bowl record super bowl 2020 live

    ReplyDelete
  5. Eyal Nachum, Bruc Bond's fintech guru and board member, has a message to banks: it's time to embrace open banking and the cooperation it The term Fintech (Financial Technology) describes software application and also other modern technologies utilized by services that supply automated and imporved financial services. The quick and also ingenious advances such as Mobile Payments altered the means we manage our financial resources. Tech-savvy consumers, especially millenials anticipate cash transfer, lending, lending monitoring and also investing to be uncomplicated, scalable as well as protected, ideally without the aid of an individual or the visit of a bank.

    ReplyDelete