RMAN-04006: error from auxiliary database: ORA-01017: invalid username/password; logon denied
This error may occur 95% of the time due to wrong listener entry in the network configuration files. The error itself is some what misleading to the original cause.
Steps taken for ora-01017 – Multiple times changed the password for sys user, recreated password files and also copied from primary to standby. It frustrate a lot with waste of valuable time for this simple error with no solution.
Even though the error states that the user credentials and password are incorrect, still this error may occur due to dynamic listener registration.
[oracle@xstdby dbs]$ rman target sys/password@db9zx auxiliary sys/password@xstdb
Recovery Manager: Release 19.0.0.0.0 - Production on Mon Jun 26 10:08:23 2023
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: DB9ZX (DBID=1041852011)
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04006: error from auxiliary database: ORA-01017: invalid username/password; logon denied
In listener status, there are two output’s, one with unknown and other with blocked. This says that the listener is not dynamically registered and need to statistically configured. Even though there are lot of formats for static registration of listener over the internet, none of them works properly due to spaces or parenthesis etc.
[oracle@xstdby admin]$ lsnrctl status
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 26-JUN-2023 10:13:45
Copyright (c) 1991, 2019, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date 26-JUN-2023 10:11:54
Uptime 0 days 0 hr. 1 min. 52 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/19.0.0/db_home/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/xstdby/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xstdby)(PORT=1521)))
Services Summary...
Service "XSTDB" has 2 instance(s).
Instance "xstdb", status UNKNOWN, has 1 handler(s) for this service...
Instance "xstdb", status BLOCKED, has 1 handler(s) for this service...
The command completed successfully
Use the below format for static listener configuration which works correctly.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.1)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=xstdb)
(SID_NAME=xstdb)
(ORACLE_HOME=/u01/app/oracle/product/19.0.0/db_home/)
)
)