Shulou(Shulou.com)06/01 Report--

TO PHYSICAL STANDBY Failed (ORA-12514: )

======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

Switching failed, error message:

========== Perform handover and report network listening 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 are no longer connected to ORACLE.

Please complete the following steps and reissue the CONVERT command:

start up and mount instance "SBDB1" of database "SBDB1"

======== Check the configuration of the backup 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)))'

Solution:

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

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

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)))

Switching succeeded:

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

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 you manually execute the switch command in sqlplus when the switch fails, log in to dgmgrl and view the configuration, you may 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(^▽^)o

DGMGRL> disable CONFIGURATION;

Disabled.

DGMGRL> remove CONFIGURATION DRSolution;

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.