validate static connect identifier for all - DG Broker - Switchover - Data-guard

 

DGMGRL> validate static connect identifier for all;

Oracle Clusterware is not configured on database "orcldg".

Connecting to database "orcldg" using static connect identifier "(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.202)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcldg_DGMGRL.priyadba.com)(INSTANCE_NAME=orcldg)(SERVER=DEDICATED)(STATIC_SERVICE=TRUE)))" ...

Unable to connect to database using (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.202)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcldg_DGMGRL.priyadba.com)(INSTANCE_NAME=orcldg)(SERVER=DEDICATED)(STATIC_SERVICE=TRUE)))

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

Failed.

Oracle Clusterware is not configured on database "orcl".

Connecting to database "orcl" using static connect identifier "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rac201.priyadba.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcl_DGMGRL.priyadba.com)(INSTANCE_NAME=orcl)(SERVER=DEDICATED)(STATIC_SERVICE=TRUE)))" ...

Unable to connect to database using (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rac201.priyadba.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcl_DGMGRL.priyadba.com)(INSTANCE_NAME=orcl)(SERVER=DEDICATED)(STATIC_SERVICE=TRUE)))

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

Failed.

DGMGRL> connect sys/Welcome@orcl

Connected to "orcl"

Connected as SYSDBA.

DGMGRL>

DGMGRL>

DGMGRL>

DGMGRL> EDIT DATABASE orcl SET STATIC_CONNECT_IDENTIFIER='(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.201)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcl)))';

EDIT DATABASE orcl SET STATIC_CONNECT_IDENTIFIER='(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.201)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcl)))';

                       ^

Syntax error before or at "STATIC_CONNECT_IDENTIFIER"

DGMGRL>

DGMGRL> EDIT DATABASE orcl SET PROPERTY StaticConnectIdentifier='(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.201)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcl)))';

Property "staticconnectidentifier" updated

DGMGRL>

DGMGRL>

DGMGRL> EDIT DATABASE orcldg SET PROPERTY StaticConnectIdentifier='(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.202)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcldg)))';

Property "staticconnectidentifier" updated

DGMGRL>

DGMGRL>

DGMGRL> validate static connect identifier for all;

Oracle Clusterware is not configured on database "orcldg".

Connecting to database "orcldg" using static connect identifier "(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.202)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcldg)(STATIC_SERVICE=TRUE)))" ...

Succeeded.

The static connect identifier allows for a connection to database "orcldg".

Oracle Clusterware is not configured on database "orcl".

Connecting to database "orcl" using static connect identifier "(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.201)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcl)(STATIC_SERVICE=TRUE)))" ...

Succeeded.

The static connect identifier allows for a connection to database "orcl".

DGMGRL>

DGMGRL>

DGMGRL>

DGMGRL> switchover to orcldg;

Performing switchover NOW, please wait...

Operation requires a connection to database "orcldg"

Connecting ...

Connected to "orcldg"

Connected as SYSDBA.

New primary database "orcldg" is opening...

Operation requires start up of instance "orcl" on database "orcl"

Starting instance "orcl"...

Connected to an idle instance.

ORACLE instance started.

Connected to "orcl"

Database mounted.

Switchover succeeded, new primary is "orcldg"

DGMGRL>

DGMGRL>

DGMGRL>