“TestConfiguration” error in WebLogic Server

[John Paterson]

Hi Folks,

I posted this in another forum a couple of days back, as I am still finding for a solution, thought of posting it here as well. I was trying to configure a data source in the weblogic server. After entering/selecting the necessary values for: JNDI Name: jdbc/OracleDS Database Type: Oracle Database Driver: Oracle's Driver (Thin XA)for Instance connections; Versions:9.0.1 and later Database Name: XE HostName:localhost Port:1521 Database User Name: OE Password: OE Confirm Password: OE
I do a "Test Configuration", by clicking on the button with that name and I get the following error:

Connection test failed.

ORA-01017: invalid username/password; logon denied 
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:389)
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:382)
oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:600)
oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:445)
oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:380)
oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:760)
oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:401)
oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:546)
oracle.jdbc.driver.T4CConnection.(T4CConnection.java:236)
oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:280)
oracle.jdbc.xa.client.OracleXADataSource.getPooledConnection(OracleXADataSource.java:469)
oracle.jdbc.xa.client.OracleXADataSource.getXAConnection(OracleXADataSource.java:156)
oracle.jdbc.xa.client.OracleXADataSource.getXAConnection(OracleXADataSource.java:101)
weblogic.jdbc.common.internal.DataSourceUtil.testConnection(DataSourceUtil.java:314)
com.bea.console.utils.jdbc.JDBCUtils.testConnection(JDBCUtils.java:746)

I have already confirmed that the oracle database is up and running when this error took place.
I am not sure why I am getting this, hope someone can advise. Thanks.

[John Paterson]

I am actually going through the 'Java EE Development with Eclipse' book by packt publishing. I have encountered this problem in the 1st chapter("EJB 3.0 database persistence") under the section "configuring a data source". I did everything as per instruction but I am getting the error. Really hope someone can help.

[German Gonzalez-Morris]

The ORA error is self-explanatory :

ORA-01017: invalid username/password; logon denied

Cause: An invalid username or password was entered in an attempt to log on to Oracle. The username and password must be the same as was specified in a GRANT CONNECT statement. If the username and password are entered together, the format is: username/password.

Action: Enter a valid username and password combination in the correct format.

from http://www.dba-oracle.com/t_ora_01017.htm


Try connecting with the same values thru SQL*Plus or other SQL IDE, such us, Oracle SQL Developer, SQL SQuirreL, etc.

[John Paterson]

Hi German Gonzalez-Morris,

Thanks for the reply. Just curious, must the particular database first be created before I 'configure a datasource'? The reason why I am asking is I noticed that if I were to go through the same process in weblogic for a database that already exists, and can be connected via Oracle SQL Developer, than the 'TestConfiguration' works fine. There was no mention in the book of first creating the database, it immediately went about configuring the datasource.

[German Gonzalez-Morris]

John Paterson wrote:Hi German Gonzalez-Morris,

Thanks for the reply. Just curious, must the particular database first be created before I 'configure a datasource'? The reason why I am asking is I noticed that if I were to go through the same process in weblogic for a database that already exists, and can be connected via Oracle SQL Developer, than the 'TestConfiguration' works fine. There was no mention in the book of first creating the database, it immediately went about configuring the datasource.

That's right.
The database must exist. WLS tries to connect to the real DB when testing.