今天在搭DG的时候出现了下面的错误:
$ rman target sys/oracle@JXDSP01 auxiliary sys/oracle@JXDSP03
…………
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04006: error from auxiliary database: ORA-01017: invalid username/password; logon denied
查询发现发生这个错误大概有 3 个原因:
1. 主备库的密码文件不一致
2. remote_login_passwordfile 必须设成 exclusive
3. 密码文件名称错误,就是该原因导致的,我的ORACLE_SID 为 jxdsp ,但我当时创建密码文件的命令如下:
orapwd file=$ORACLE_HOME/dbs/orapworcl password=oracle entries=5
用下面命令重新创建后,问题顺利解决
orapwd file=$ORACLE_HOME/dbs/orapwjxdsp password=oracle entries=5
二 、
RMAN> duplicate target database for standby from active database nofilenamecheck;
Starting Duplicate Db at 2018/05/17 17:41:40
using channel ORA_AUX_DISK_1
contents of Memory Script:
{
backup as copy reuse
targetfile '/oracle/database/11.2.0/db_1/dbs/orapwjxdsp1' auxiliary format
'/oracle/database/11.2.0/db_1/dbs/orapwjxdsp' ;
}
executing Memory Script
Starting backup at 2018/05/17 17:41:40
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 05/17/2018 17:41:42
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 05/17/2018 17:41:42
ORA-17629: Cannot connect to the remote database server
ORA-17627: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
ORA-17629: Cannot connect to the remote database server
有可能是源端连接目的端出错,在源端检查连接目的端的连接串,发现确实存在问题 ,改正后,该错误解决