Menu Close

RMAN -> ORA-01017: invalid username/password; logon denied

The Error:

Recovery Manager: Release 12.1.0.2.0 - Production on Thu Sep 12 14:14:16 2019

Copyright (c) 1982, 2014, 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

Of course the problem might always be due to actual wrong password or the lack of password file. However, in some strange circumstances the error is due to inaccurate connection string (or TNS entry). It has nothing to do with the password on several occasions. You may need to modify your connection string:

As an example, the below connection string may not work:

rman target sys/somepassword@"(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=rac01.testserver.com)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=TESTDB)))"

With a slight modification by adding the INSTANCE_NAME, now it would work:

rman target sys/somepassword@"(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=rac01.testserver.com)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=TESTDB)(INSTANCE_NAME=TESTDB1)))"

So, modify your connection string or TNS entry to contain the INSTANCE_NAME

Posted in RMAN, Troubleshooting