[dgoli]

Hi Nick,

Thanks for your reply and sorry for the confusion I have created.
I have reinstalled both DB and OTM instances on WINDOWS(lets talk about only WINDOWS).

I have executed all the OTM scripts and found the following INVALID objects with GLOGOWNER as owner.

DBHEALTH PACKAGE BODY
PKG_QUEUE_MANAGEMENT PACKAGE BODY
BIN$Ibl0WoFGSsaGaAq8MatdZQ==$0 TRIGGER

Do you suggest this is where the actual problem might be?

Even though not necessary,I started my OTM services and got the LOGIN page.
When I tried to login as DBA.ADMIN/GUEST.ADMIN/SERVPROV.ADMIN,I got the following exception in console.log of both weblogic and tomcat.

INFO | jvm 1 | 2008/06/14 12:13:31 | java.sql.SQLException: ORA-00942: table or view does not exist
INFO | jvm 1 | 2008/06/14 12:13:31 |
INFO | jvm 1 | 2008/06/14 12:13:31 | at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:112)
INFO | jvm 1 | 2008/06/14 12:13:31 | at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoe r.java:331)
INFO | jvm 1 | 2008/06/14 12:13:31 | at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoe r.java:28
INFO | jvm 1 | 2008/06/14 12:13:31 | at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java: 745)
INFO | jvm 1 | 2008/06/14 12:13:31 | at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4 CPreparedStatement.java:216)
INFO | jvm 1 | 2008/06/14 12:13:31 | at oracle.jdbc.driver.T4CPreparedStatement.executeFor Describe(T4CPreparedStatement.java:810)
INFO | jvm 1 | 2008/06/14 12:13:31 | at oracle.jdbc.driver.OracleStatement.executeMaybeDes cribe(OracleStatement.java:1039)
INFO | jvm 1 | 2008/06/14 12:13:31 | at oracle.jdbc.driver.T4CPreparedStatement.executeMay beDescribe(T4CPreparedStatement.java:850)
INFO | jvm 1 | 2008/06/14 12:13:31 | at oracle.jdbc.driver.OracleStatement.doExecuteWithTi meout(OracleStatement.java:1134)
INFO | jvm 1 | 2008/06/14 12:13:31 | at oracle.jdbc.driver.OraclePreparedStatement.execute Internal(OraclePreparedStatement.java:3339)
INFO | jvm 1 | 2008/06/14 12:13:31 | at oracle.jdbc.driver.OraclePreparedStatement.execute Query(OraclePreparedStatement.java:3384)
INFO | jvm 1 | 2008/06/14 12:13:31 | at weblogic.jdbc.wrapper.PreparedStatement.executeQue ry(PreparedStatement.java:124)
INFO | jvm 1 | 2008/06/14 12:13:31 | at glog.util.jdbc.noserver.SqlQuery.executeQuery(SqlQ uery.java:146)
INFO | jvm 1 | 2008/06/14 12:13:31 | at glog.util.jdbc.noserver.SqlQuery.resetArguments(Sq lQuery.java:124)
INFO | jvm 1 | 2008/06/14 12:13:31 | at glog.util.jdbc.noserver.SqlQuery.open(SqlQuery.jav a:94)
INFO | jvm 1 | 2008/06/14 12:13:31 | at glog.server.useraccess.UserAccessSessionBean.getUs erAccess(UserAccessSessionBean.java:151)
INFO | jvm 1 | 2008/06/14 12:13:31 | at glog.server.useraccess.UserAccessSessionServerSide EJBWrapper.getUserAccess(UserAccessSessionServerSi deEJBWrapper.java:70)
INFO | jvm 1 | 2008/06/14 12:13:31 | at glog.server.useraccess.UserAccessSessionHome_uzvgz z_EOImpl.getUserAccess(UserAccessSessionHome_uzvgz z_EOImpl.java:154)
INFO | jvm 1 | 2008/06/14 12:13:31 | at glog.server.useraccess.UserAccessSessionHome_uzvgz z_EOImpl_WLSkel.invoke(Unknown Source)
INFO | jvm 1 | 2008/06/14 12:13:31 | at weblogic.rmi.internal.BasicServerRef.invoke(BasicS erverRef.java:477)
INFO | jvm 1 | 2008/06/14 12:13:31 | at weblogic.rmi.cluster.ReplicaAwareServerRef.invoke( ReplicaAwareServerRef.java:10
INFO | jvm 1 | 2008/06/14 12:13:31 | at weblogic.rmi.internal.BasicServerRef$1.run(BasicSe rverRef.java:420)
INFO | jvm 1 | 2008/06/14 12:13:31 | at weblogic.security.acl.internal.AuthenticatedSubjec t.doAs(AuthenticatedSubject.java:363)
INFO | jvm 1 | 2008/06/14 12:13:31 | at weblogic.security.service.SecurityManager.runAs(Se curityManager.java:147)
INFO | jvm 1 | 2008/06/14 12:13:31 | at weblogic.rmi.internal.BasicServerRef.handleRequest (BasicServerRef.java:415)
INFO | jvm 1 | 2008/06/14 12:13:31 | at weblogic.rmi.internal.BasicExecuteRequest.execute( BasicExecuteRequest.java:30)
INFO | jvm 1 | 2008/06/14 12:13:31 | at weblogic.kernel.ExecuteThread.execute(ExecuteThrea d.java:219)
INFO | jvm 1 | 2008/06/14 12:13:31 | at weblogic.kernel.ExecuteThread.run(ExecuteThread.ja va:17

In the Login page,I found the following error message for the respective user.

A connection to the server could not be established: {exception=null} (user=DBA.ADMIN)
A connection to the server could not be established: {exception=null} (user=GUEST.ADMIN)
A connection to the server could not be established: {exception=null} (user=SERVPROV.ADMIN)


If I try to login with some value for the login,I get the following error msg in the login page
Invalid user name (RFGE) or password. Please try again.

The corresponding log entry is as follows

INFO | jvm 1 | 2008/06/14 12:13:49 | User RFGE not found
INFO | jvm 1 | 2008/06/14 12:13:49 |
INFO | jvm 1 | 2008/06/14 12:13:49 | at jrockit.reflect.NativeConstructorInvoker.newInstan ce([Ljava.lang.ObjectLjava.lang.Object;(Unknown Source)
INFO | jvm 1 | 2008/06/14 12:13:49 | at java.lang.reflect.Constructor.newInstance([Ljava.lang.Object;I)Ljava.lang.Object;(Unknown Source)
INFO | jvm 1 | 2008/06/14 12:13:49 | at glog.util.exception.GLException.factory(GLExceptio n.java:413)
INFO | jvm 1 | 2008/06/14 12:13:49 | at glog.database.security.GLSecurityException.factory (GLSecurityException.java:40)
INFO | jvm 1 | 2008/06/14 12:13:49 | at glog.database.security.SecurityUserImpl.findReq(Se curityUserImpl.java:154)
INFO | jvm 1 | 2008/06/14 12:13:49 | at glog.database.security.SecurityUserImpl.authentica te(SecurityUserImpl.java:180)
INFO | jvm 1 | 2008/06/14 12:13:49 | at glog.database.security.SecurityUtil.authenticateUs er(SecurityUtil.java:74)
INFO | jvm 1 | 2008/06/14 12:13:49 | at glog.database.security.SecuritySessionBean.authent icateUser(SecuritySessionBean.java:171)
INFO | jvm 1 | 2008/06/14 12:13:49 | at glog.database.security.SecuritySessionHome_snlvan_ EOImpl.authenticateUser(SecuritySessionHome_snlvan _EOImpl.java:1720)
INFO | jvm 1 | 2008/06/14 12:13:49 | at glog.database.security.SecuritySessionHome_snlvan_ EOImpl_WLSkel.invoke(ILweblogic.rmi.spi.InboundReq uest;Lweblogic.rmi.spi.OutboundResponse;Ljava.lang .ObjectLweblogic.rmi.spi.OutboundResponse;(Unkno wn Source)
INFO | jvm 1 | 2008/06/14 12:13:49 | at weblogic.rmi.internal.BasicServerRef.invoke(BasicS erverRef.java:477)
INFO | jvm 1 | 2008/06/14 12:13:49 | at weblogic.rmi.cluster.ReplicaAwareServerRef.invoke( ReplicaAwareServerRef.java:10
INFO | jvm 1 | 2008/06/14 12:13:49 | at weblogic.rmi.internal.BasicServerRef$1.run(BasicSe rverRef.java:420)
INFO | jvm 1 | 2008/06/14 12:13:49 | at weblogic.security.acl.internal.AuthenticatedSubjec t.doAs(AuthenticatedSubject.java:363)
INFO | jvm 1 | 2008/06/14 12:13:49 | at weblogic.security.service.SecurityManager.runAs(Se curityManager.java:147)
INFO | jvm 1 | 2008/06/14 12:13:49 | at weblogic.rmi.internal.BasicServerRef.handleRequest (BasicServerRef.java:415)
INFO | jvm 1 | 2008/06/14 12:13:49 | at weblogic.rmi.internal.BasicExecuteRequest.execute( BasicExecuteRequest.java:30)
INFO | jvm 1 | 2008/06/14 12:13:49 | at weblogic.kernel.ExecuteThread.execute(ExecuteThrea d.java:219)
INFO | jvm 1 | 2008/06/14 12:13:49 | at weblogic.kernel.ExecuteThread.run(ExecuteThread.ja va:17
I understand it's not required to make a Login Attempt having INVALID objects.But I wanna provide more information which might help to conclude where the actual problem might be.

Thanks for your time,
Durga