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, 2023
Applies to:
Oracle Fusion Middleware - Version 11.1.1.7.0 and laterInformation in this document applies to any platform.
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |