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