ODI Error After DIPC-C Provision "ORA-01017: invalid username/password; logon denied" Using Correct Login Information
(Doc ID 2435248.1)
Last updated on APRIL 26, 2021
Applies to:
Data Integration Platform Cloud Classic - Version 18.3.3 and laterInformation in this document applies to any platform.
Symptoms
After a clean provision of Data Integrator Platform Cloud Classic, there are error messages in the log when starting up Studio and another error in the UI when attempting to log in:
Start up:
org.xml.sax.SAXParseException; systemId: file:/u01/app/oracle/tools/home/oracle/.odi/oracledi/snps_login_work_12.xml; lineNumber: 5; columnNumber: 86; An invalid XML character (Unicode: 0x0) was found in the CDATA section.
Login:
oracle.odi.core.config.MasterRepositoryResourceFailureException: ODI-10182: Uncategorized exception during repository access.
Could not get JDBC Connection; nested exception is java.sql.SQLException: Unable to start the Universal Connection Pool: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLException: ORA-01017: invalid username/password; logon denied
...
Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Unable to start the Universal Connection Pool: oracle.ucp.UniversalConnectionPoolException:
...
Cannot get Connection from Datasource: java.sql.SQLException: ORA-01017: invalid username/password; logon denied
...
Caused by: java.sql.SQLException: Unable to start the Universal Connection Pool: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLException: ORA-01017: invalid username/password; logon denied
...
Caused by: java.sql.SQLException: Unable to start the Universal Connection Pool: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLException: ORA-01017: invalid username/password; logon denied
...
Caused by: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLException: ORA-01017: invalid username/password; logon denied
...
Caused by: java.sql.SQLException: ORA-01017: invalid username/password; logon denied
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 |