Technote (troubleshooting)
Problem
When running the Validate-Database task, an exception occurs:
[java] [02/14/11 15:40:19.345 EST] Attempting to make connection using:
jdbc:oracle:thin:@<hostname>:1521:<dbname> :: <db user name> :: PASSWORD_REMOVED
[java] [02/14/11 15:40:20.165 EST] ERROR: Error obtaining connecting for
jdbc:oracle:thin:@<hostname>:1521:<dbname>
[java] java.sql.SQLException: ORA-01017: invalid username/password; logon denied
...
[java] at com.ibm.wps.config.db.Database.init(Database.java:155)
[java] at com.ibm.wps.config.db.validation.ValidationDriver.main(ValidationDriver.java:281)
[java] Exception in thread "main" java.sql.SQLException: ORA-01017:
invalid username/password; logon denied
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
Cause
There can be several reasons for this exception.
Resolving the problem
Because it is failing at the Validate-Database task, we can narrow the areas to check:
1. The wrong username or password used in wkplc_dbdomain.properties file
2. The user does not exist in Oracle DB
3. Trying to connect to the wrong DB
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.