My Oracle Support Banner

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 JULY 12, 2019

Applies to:

Oracle Fusion Middleware - Version 11.1.1.7.0 and later
Information 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

 

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
Cause
Solution
References


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