High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

how to configure client side TNS entry for data guard

Hello All,

I'm facing problem while configuring client side tns entry for Data Guard env and below I have given tns entry which is not working.

Primary SID: TEST -> tns service name: test

Standby SID: TEST -> tns service name: test

TNS ENTRY:

TEST2=

  (DESCRIPTION=

    (ADDRESS_LIST=

      (ADDRESS=(PROTOCOL=TCP)(HOST=primary)(PORT=1521))

      (ADDRESS=(PROTOCOL=TCP)(HOST=standby)(PORT=1521))

    )

    (CONNECT_DATA=

    (SID = TEST)))

Once I Switchover to standby DB using above TNS entry I'm getting below error 

Error:

ERROR:

ORA-01033: ORACLE initialization or shutdown in progress

Process ID: 0

Session ID: 0 Serial number: 0

Please help me to resolve this issue

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center