在備庫(kù)上建配置文件

DGMGRL> create configuration 'sharkdbbork' as primary database is 'sharkdb' connect identifier is sharkdb;
Error: ORA-16501: the Data Guard broker operation failed
Error: ORA-16625: cannot reach database "sharkdb"

?

查看日志
oracle@dg:[/u01/app/database/diag/rdbms/posdg/sharkdb/trace]cat drcsharkdb.log
2013-08-30 16:11:21.758????????????????????? ERROR: Connect Identifier sharkdb_dgmgrl not valid
2013-08-30 16:11:21.759????????????????????? NSV0: Can't get db connect descriptor to database sharkdb (error=16501)
2013-08-30 16:11:21.759????????????????????? NSV0: Failed to connect to 0x01001000
2013-08-30 16:11:21.759????????????????????? NSV0: Failed to send message to site sharkdb. Error code is ORA-16501.
2013-08-30 16:11:21.760 00000000? 1450113128 DMON: failed to forward op ADD_DRC to site sharkdb with error ORA-16501
2013-08-30 16:11:21.760 00000000? 1450113128 DMON: Database sharkdb returned ORA-16501
2013-08-30 16:11:21.760 00000000? 1450113128?????? for opcode = ADD_DRC, phase = NULL, req_id = 2.1.1450113128
2013-08-30 16:11:21.761 00000000? 1450113128 DMON: ADD_DRC operation completed

oracle@dg:[/u01/app/database/diag/rdbms/posdg/sharkdb/trace]? ps -ef|grep dmon
oracle??? 4589???? 1? 0 Aug27 ???????? 00:00:00 ora_dmon_sharkdb
oracle?? 16577 16462? 0 16:13 pts/3??? 00:00:00 grep --color dmon
oracle@dg:[/u01/app/database/diag/rdbms/dg/sharkdb/trace ]

監(jiān)聽正常

LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
STATUS of the LISTENER
------------------------
Alias???????????????????? LISTENER
Version?????????????????? TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date??????????????? 28-AUG-2013 18:40:34
Uptime??????????????????? 1 days 21 hr. 46 min. 4 sec
Trace Level?????????????? off
Security????????????????? ON: Local OS Authentication
SNMP????????????????????? OFF
Listener Parameter File?? /u01/app/11.2.0/grid/network/admin/listener.ora
Listener Log File???????? /u01/app/grid/diag/tnslsnr/node1/listener/alert/log.xml
Listening Endpoints Summary...
? (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
? (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
Services Summary...
Service "sharkdb" has 1 instance(s).
? Instance "sharkdb", status UNKNOWN, has 1 handler(s) for this service...
Service " sharkdb_DGMGRL " has 1 instance(s).
? Instance "sharkdb", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

?

Error: ORA-16501: the Data Guard broker operation failed ORA-16625: cannot reach database