[nick.polites]

Have you verified that the database on your unix instance is on the same CU version as your Windows OTM application? If so then you probably have some sort of problem with your app install as well. I'm assuming that you copied the 3rd party jar files as described in the installer?


At this point since your archive schema is throwing errors and your app may not be installed correctly, I would suggest that you do a complete reinstall of both the data and the application. You have too many problems coming from all sides to try to guess where your problems are. It'll be faster to reinstall than it will be to debug this.

Good Luck,
Nick

[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

[nick.polites]

Are you importing the database as sys? Have you checked to see if you allocated enough space to the data/index tablespace? If you accepted the defaults when you created it, auto extend is not enabled and will cause the import to fail. What does your import log look like? Post it to the forum.