RMAN-00554 RMAN-04005 ORA-01017告警处理

配置第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>