[dgoli]

Mr.Nick,

Thanks for your reply.

Pls apologise for the confusion I have already created and the one I am about to create in this reply.


We have a working OTM instance(OTM1) on Unix connected to DB instance(DATA1).

Now I have installed OTM(OTM2) on Windows and trying to connect to DB instance(DATA2). The installation is successful.
We have executed all the database related scripts,verified the database structure and finally executed “insert_security_roles.sql” as GLOGOWNER for DATA2.
Everything seems fine as per Admin guide.

Finally,I am getting the Login screen
When I try to login into OTM2,we are getting different errors for different users.

When correct Login information is provided :

For DBA.ADMIN

INFO | jvm 1 | 2008/06/11 12:56:07 | Authentication Failed for user DBA.ADMIN
INFO | jvm 1 | 2008/06/11 12:56:07 |
INFO | jvm 1 | 2008/06/11 12:56:07 | at jrockit.reflect.NativeConstructorInvoker.newInstan ce([Ljava.lang.ObjectLjava.lang.Object;(Unknown Source)

For GUEST.ADMIN and SERVPROV.ADMIN

INFO | jvm 1 | 2008/06/05 20:33:52 | java.sql.SQLException: ORA-00942: table or view does not exist


When I attempt to Login with WRONG information:

For DBA.ADMIN ,GUEST.ADMIN and SERVPROV.ADMIN

INFO | jvm 1 | 2008/06/05 20:33:52 | java.sql.SQLException: ORA-00942: table or view does not exist

We thought the problem is with the DATA2.
So we changed glog.properties and WL config.xml in OTM2 to connect to DATA1.

When CORRECT Login information is provided :

For DBA.ADMIN

INFO | jvm 1 | 2008/06/11 12:56:07 | Authentication Failed for user DBA.ADMIN
INFO | jvm 1 | 2008/06/11 12:56:07 |
INFO | jvm 1 | 2008/06/11 12:56:07 | at jrockit.reflect.NativeConstructorInvoker.newInstan ce([Ljava.lang.ObjectLjava.lang.Object;(Unknown Source)

For GUEST.ADMIN and SERVPROV.ADMIN

INFO | jvm 1 | 2008/06/11 12:57:14 | java.lang.NullPointerException
INFO | jvm 1 | 2008/06/11 12:57:14 | at oracle.jdbc.driver.OracleDriver.connect(OracleDriv er.java:592)


When I attempt to Login with WRONG information:

For DBA.ADMIN ,GUEST.ADMIN and SERVPROV.ADMIN

INFO | jvm 1 | 2008/06/11 12:57:14 | java.lang.NullPointerException
INFO | jvm 1 | 2008/06/11 12:57:14 | at oracle.jdbc.driver.OracleDriver.connect(OracleDriv er.java:592)


Until now we thought the problem is with current database DATA2.On connecting to the WORKING database DATA1,I am suspecting the problem might be somewhere with the WebLogic Connection Pool.

One issue that really confuses is that I am getting different error msg if I attempt to login with CORRECT info and WRONG info.
Pls provide some input as I am unable to conclude anything. Both DATA1 and DATA2 are running on differenet DB Servers.

I am attaching my glog.properties and WebLogic config.xml as text files in case you wish to look into. The domainName in the attached files isn’t actual domain value.I changed it.

glog.txt
config.txt

Thanks for your time,
Durga