Error: ORA-16501: the Data Guard broker operation failed ORA-16625: cannot reach database解决
Error: ORA-16501: the Data Guard broker operation failed ORA-16625: cannot reach database解决
在备库上建配置文件 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