在備庫上建配置文件
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
]
監聽正常
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
更多文章、技術交流、商務合作、聯系博主
微信掃碼或搜索:z360901061

微信掃一掃加我為好友
QQ號聯系: 360901061
您的支持是博主寫作最大的動力,如果您喜歡我的文章,感覺我的文章對您有幫助,請用微信掃描下面二維碼支持博主2元、5元、10元、20元等您想捐的金額吧,狠狠點擊下面給點支持吧,站長非常感激您!手機微信長按不能支付解決辦法:請將微信支付二維碼保存到相冊,切換到微信,然后點擊微信右上角掃一掃功能,選擇支付二維碼完成支付。
【本文對您有幫助就好】元
