11g RCU Connect To 12.2 Database Failed With "ORA-01017 Invalid username/password error" or ORA-28104 (Doc ID 2430487.1)

Last updated on SEPTEMBER 11, 2024

Applies to:

Symptoms

11g RCU Schema Creation Error failed with error when connecting to 12c Database using system or sys.
Can connect successfully using sqlplus.  Can also successfully connect using 12c RCU.

Error from rcu log:

2018-06-26 13:54:50.484 NOTIFICATION rcu: oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine::connect: Connecting to database: user:sys, role:sysdba, connectString:(description=(address=(host=<IP ADD>)(protocol=tcp)(port=<PORT>))(connect_data=(service_name=orcl)(server=dedicated)))
2018-06-26 13:54:54.226 ERROR rcu: oracle.sysman.assistants.rcu.backend.validation.StepValidator::isConnectionStepValidated: Failed to connect database: Invalid username/password.
Please enter valid username/password
2018-06-26 13:54:54.228 NOTIFICATION rcu: oracle.sysman.assistants.common.util.SilentMessageHandler::writeToLog: Invalid username/password.
Please enter valid username/password
2018-06-26 13:54:54.228 ERROR rcu: oracle.sysman.assistants.rcu.backend.validation.StepValidator::isConnectionStepValidated: SQLFatalErrorException:
oracle.sysman.assistants.common.dbutil.SQLFatalErrorException: Invalid username/password.
Please enter valid username/password
 at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.connect(JDBCEngine.java:585)
 at oracle.sysman.assistants.rcu.backend.validation.StepValidator.connectDatabase(StepValidator.java:358)
 at oracle.sysman.assistants.rcu.backend.validation.StepValidator.connectDatabase(StepValidator.java:253)
 at oracle.sysman.assistants.rcu.backend.validation.StepValidator.isConnectionStepValidated(StepValidator.java:1352)
 at oracle.sysman.assistants.rcu.backend.SilentRCUModel.performOperation(SilentRCUModel.java:140)
 at oracle.sysman.assistants.rcu.backend.RCUModel.startOperation(RCUModel.java:346)
 at oracle.sysman.assistants.rcu.Rcu.execute(Rcu.java:339)
 at oracle.sysman.assistants.rcu.Rcu.main(Rcu.java:363)

If RCU 11.1.1.9 is used with 12.2 database, it fails with ORA-28040: No matching authentication protocol error.
After configuring sqlnet.ora with below entries then "ORA-01017 Invalid username/password error" is seen

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.