配置第3方备份一体机时发现问题
orcl1:/home/oracle@orcl1>rman target USR_RMAN/test1234
Recovery Manager: Release 11.2.0.4.0 - Production on Wed Sep 4 21:57:49 2024
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1077751326)
RMAN> exit
Recovery Manager complete.
orcl1:/home/oracle@orcl1>rman target USR_RMAN/test1234@orcl
Recovery Manager: Release 11.2.0.4.0 - Production on Wed Sep 4 21:58:00 2024
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-01017: invalid username/password; logon denied
orcl1:/home/oracle@orcl1>tnsping orcl
TNS Ping Utility for IBM/AIX RISC System/6000: Version 11.2.0.4.0 - Production on 04-SEP-2024 21:58:08
Copyright (c) 1997, 2013, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.111.100)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))
OK (0 msec)
orcl1:/home/oracle@orcl1>
参考文档：RMAN: RMAN-4005, ORA-1017 Errors Connecting to Remote Target (Doc ID 121500.1)
处理办法
SQL > grant sysdba to USR_RMAN;
SQL > select * from v$pwfile_users;
特别注意：11g rac的orapd的密码文件是本地，2个节点上都必须做赋权处理
赋权后测试正常
orcl1:/home/oracle@orcl1>rman
Recovery Manager: Release 11.2.0.4.0 - Production on Wed Sep 4 22:22:22 2024
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
RMAN> connect target USR_RMAN/test1234@orcl
connected to target database: ORCL (DBID=1077751326)
RMAN>
