Validate-Database task fails with the exception 'ORA-01017: invalid username/password; logon denied'

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:

(0 users)Average rating

Document information


More support for:

WebSphere Portal

Software version:

6.1, 7.0

Operating system(s):

AIX, Linux, Solaris, Windows, i5/OS, z/OS

Reference #:

1468393

Modified date:

2013-01-31

Translate my page

Machine Translation

Content navigation