首页 > 代码库 > DGMGR-TO PHYSICAL STANDBY Failed (ORA12514 )解决方法
DGMGR-TO PHYSICAL STANDBY Failed (ORA12514 )解决方法
TO PHYSICAL STANDBY Failed (ORA-12514: )解决方法:
==========DG 环境:
DGMGRL> SHOW CONFIGURATION;
Configuration - DRSolution
Protection Mode: MaxAvailability
Databases:
PROD1 - Primary database
SBDB1 - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
切换失败,报错信息:
============执行切换,报网络监听错误(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"
=========检查备数据库的配置:
show database verbose ‘SBDB1‘;----
stand:
StaticConnectIdentifier = ‘(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=edbjr2p2)(PORT=1521))(CONNECT_DATA=http://www.mamicode.com/(SERVICE_NAME=SBDB1_DGMGRL.us.oracle.com)(INSTANCE_NAME=SBDB1)(SERVER=DEDICATED)))‘
解决方法:
==================在备监听添加DGMGRL的静态监听:
==================
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)))
切换成功:
==============在次执行切换测试: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
如果在切换失败时候,手动在sqlplus 执行切换命令,登陆dgmgrl,查看配置肯能遇到如下错误:
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
解决方法:删除配置文件,重新配置。o(^▽^)o
DGMGRL> disable CONFIGURATION;
Disabled.
DGMGRL> remove CONFIGURATION DRSolution;
DGMGR-TO PHYSICAL STANDBY Failed (ORA12514 )解决方法