"Checking JDBC connection to STAR" Fails When Running the Reporting Database Diagnostic Utility

(Doc ID 1406856.1)

Last updated on SEPTEMBER 05, 2017

Applies to:

Primavera P6 Analytics - Version R2 to R2 [Release R2]
Primavera P6 Reporting Database - Version R3.0 to R3.0 [Release R3]
Information in this document applies to any platform.
***Checked for relevance 08-Jul-2013***

Symptoms

When running the Reporting Database Diagnostic Utility during the installation of Reporting Database R3.0, the following error is thrown

ERROR
------------------
Checking JDBC Connection to STAR... FAIL


The 'checker.log' file contains the following error

<02.06.2012 15:10:03> [ERROR] - Could not connect to jbdc:oracle:thin:@//localhost:1521/star
java.sql.SQLException: ORA-01017: invalid username/password; logon denied

at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:406)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOauth(T4CTTIoauthenticate.java:799)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:368)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:508)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:203)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:510)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.oracle.pgbu.ercheck.checks.JdbcConnectionChecker.b(Unknown Source)
at com.oracle.pgbu.ercheck.checks.JdbcConnectionChecker.runCheck(Unknown Source)
at com.oracle.pgbu.ercheck.AbstractChecks.runChecks(Unknown Source)
at com.oracle.pgbu.ercheck.StarChecks.main(Unknown Source)

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms