Dgmgr-to physical STANDBY Failed (ORA12514) workaround

to Physical STANDBY Failed (ORA-12514: ) Workaround:

==========DG Environment:

Dgmgrl> SHOW CONFIGURATION;

Configuration-drsolution

Protection mode:maxavailability

Databases:

Prod1-primary Database

Sbdb1-physical Standby Database

Fast-start failover:disabled

Configuration Status:

SUCCESS

switchover failure, error message:

============ perform switch to report Network Monitor error (ORA-12514: ):

dgmgrl> Convert database ' SBDB1 ' to physical STANDBY;- -------------

Converting database "SBDB1" to a physical Standby database, please wait ...

Operation requires shutdown of instance "SBDB1" on Database "SBDB1"

Shutting down instance "SBDB1" ...

Database closed.

Database dismounted.

ORACLE instance shut down.

Operation requires startup of instance "SBDB1" on Database "SBDB1"

Starting instance "SBDB1" ...

Unable to connect to database

Ora-12514:tns:listener does not currently know of service requested in Connect descriptor

Failed.

Warning:you is no longer connected to ORACLE.

Please complete the following steps and reissue the CONVERT command:

Start up and Mount instance "SBDB1" of the Database "SBDB1"

========= Check the configuration of the database:

Show database verbose ' SBDB1 ';----

Stand:

Staticconnectidentifier = ' (description= (address= (protocol=tcp) (HOST=EDBJR2P2) (port=1521)) (CONNECT_DATA= (SERVICE _name=sbdb1_dgmgrl.us.oracle.com) (INSTANCE_NAME=SBDB1) (server=dedicated))) '

Workaround:

================== add DGMGRL static monitoring on standby monitor :

==================

Sid_list_listener=

(sid_list=

(sid_desc=

(global_dbname=sbdb1.us.oracle.com)

(oracle_home=/u01/app/oracle/product/11.2.0/db_1)

(SID_NAME=SBDB1))

(sid_desc=

(global_dbname=SBDB1_DGMGRL.us.oracle.com)

(oracle_home=/u01/app/oracle/product/11.2.0/db_1)

(SID_NAME=SBDB1)))

Switch Success:

============== to perform a switchover test at a time:OK

dgmgrl> Convert database ' SBDB1 ' to physical STANDBY;

Converting database "SBDB1" to a physical Standby database, please wait ...

Operation requires shutdown of instance "SBDB1" on Database "SBDB1"

Shutting down instance "SBDB1" ...

Database closed.

Database dismounted.

ORACLE instance shut down.

Operation requires startup of instance "SBDB1" on Database "SBDB1"

Starting instance "SBDB1" ...

ORACLE instance started.

Database mounted.

Continuing to convert Database "SBDB1" ...

Operation requires shutdown of instance "SBDB1" on Database "SBDB1"

Shutting down instance "SBDB1" ...

Ora-01109:database not open

Database dismounted.

ORACLE instance shut down.

Operation requires startup of instance "SBDB1" on Database "SBDB1"

Starting instance "SBDB1" ...

ORACLE instance started.

Database mounted.

Database "SBDB1" converted successfully

If the switch fails, manually in the Sqlplus to perform the switch command, log in dgmgrl, view the configuration Ken can encounter the following error:

Dgmgrl> SHOW CONFIGURATION

Configuration-drsolution

Protection mode:maxavailability

Databases:

Prod1-primary Database

Sbdb1-snapshot Standby Database

error:ora-16816:incorrect database role

Fast-start failover:disabled

Configuration Status:

ERROR

Workaround: Delete the configuration file and reconfigure it. O (^Contest^) o

dgmgrl> Disable CONFIGURATION;

Disabled.

dgmgrl> Remove CONFIGURATION drsolution;

Dgmgr-to physical STANDBY Failed (ORA12514) workaround