hi friends,
I have installed OTM5.5 CU4 on Windows Server 2003 Enterprise Edition SP2.
After starting otmapp55,otmweb55 and otmwebtomcat55 in sequence,I can access the OTM instance using the url http://systemName
But when I try to login using the default users dba.admin or guest.admin or servprov.admin,I get an error saying
A connection to the server could not be established: {exception=null} (user=GUEST.ADMIN)
When I check the cosole.log located under OTM_HOME/logs/weblogic/,it says
INFO | jvm 1 | 2008/06/04 18:20:31 | java.sql.SQLException: ORA-00942: table or view does not exist
INFO | jvm 1 | 2008/06/04 18:20:31 |
INFO | jvm 1 | 2008/06/04 18:20:31 | at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:112)
INFO | jvm 1 | 2008/06/04 18:20:31 | at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoe r.java:331)
INFO | jvm 1 | 2008/06/04 18:20:31 | at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoe r.java:28
INFO | jvm 1 | 2008/06/04 18:20:31 | at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java: 745)
INFO | jvm 1 | 2008/06/04 18:20:31 | at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4 CPreparedStatement.java:216)
INFO | jvm 1 | 2008/06/04 18:20:31 | at oracle.jdbc.driver.T4CPreparedStatement.executeFor Describe(T4CPreparedStatement.java:810)
INFO | jvm 1 | 2008/06/04 18:20:31 | at oracle.jdbc.driver.OracleStatement.executeMaybeDes cribe(OracleStatement.java:1039)
INFO | jvm 1 | 2008/06/04 18:20:31 | at oracle.jdbc.driver.T4CPreparedStatement.executeMay beDescribe(T4CPreparedStatement.java:850)
INFO | jvm 1 | 2008/06/04 18:20:31 | at oracle.jdbc.driver.OracleStatement.doExecuteWithTi meout(OracleStatement.java:1134)
INFO | jvm 1 | 2008/06/04 18:20:31 | at oracle.jdbc.driver.OraclePreparedStatement.execute Internal(OraclePreparedStatement.java:3339)
INFO | jvm 1 | 2008/06/04 18:20:31 | at oracle.jdbc.driver.OraclePreparedStatement.execute Query(OraclePreparedStatement.java:3384)
INFO | jvm 1 | 2008/06/04 18:20:31 | at weblogic.jdbc.wrapper.PreparedStatement.executeQue ry(PreparedStatement.java:124)
INFO | jvm 1 | 2008/06/04 18:20:31 | at glog.util.jdbc.noserver.SqlQuery.executeQuery(SqlQ uery.java:146)
INFO | jvm 1 | 2008/06/04 18:20:31 | at glog.util.jdbc.noserver.SqlQuery.resetArguments(Sq lQuery.java:124)
INFO | jvm 1 | 2008/06/04 18:20:31 | at glog.util.jdbc.noserver.SqlQuery.open(SqlQuery.jav a:94)
INFO | jvm 1 | 2008/06/04 18:20:31 | at glog.server.useraccess.UserAccessSessionBean.getUs erAccess(UserAccessSessionBean.java:151)
INFO | jvm 1 | 2008/06/04 18:20:31 | at glog.server.useraccess.UserAccessSessionServerSide EJBWrapper.getUserAccess(UserAccessSessionServerSi deEJBWrapper.java:70)
INFO | jvm 1 | 2008/06/04 18:20:31 | at glog.server.useraccess.UserAccessSessionHome_uzvgz z_EOImpl.getUserAccess(UserAccessSessionHome_uzvgz z_EOImpl.java:154)
INFO | jvm 1 | 2008/06/04 18:20:31 | at glog.server.useraccess.UserAccessSessionHome_uzvgz z_EOImpl_WLSkel.invoke(ILweblogic.rmi.spi.InboundR equest;Lweblogic.rmi.spi.OutboundResponse;Ljava.la ng.Object
Lweblogic.rmi.spi.OutboundResponse;(Unknown Source)
INFO | jvm 1 | 2008/06/04 18:20:31 | at weblogic.rmi.internal.BasicServerRef.invoke(BasicS erverRef.java:477)
INFO | jvm 1 | 2008/06/04 18:20:31 | at weblogic.rmi.cluster.ReplicaAwareServerRef.invoke( ReplicaAwareServerRef.java:10
INFO | jvm 1 | 2008/06/04 18:20:31 | at weblogic.rmi.internal.BasicServerRef$1.run(BasicSe rverRef.java:420)
INFO | jvm 1 | 2008/06/04 18:20:31 | at weblogic.security.acl.internal.AuthenticatedSubjec t.doAs(AuthenticatedSubject.java:363)
INFO | jvm 1 | 2008/06/04 18:20:31 | at weblogic.security.service.SecurityManager.runAs(Se curityManager.java:147)
INFO | jvm 1 | 2008/06/04 18:20:31 | at weblogic.rmi.internal.BasicServerRef.handleRequest (BasicServerRef.java:415)
INFO | jvm 1 | 2008/06/04 18:20:31 | at weblogic.rmi.internal.BasicExecuteRequest.execute( BasicExecuteRequest.java:30)
INFO | jvm 1 | 2008/06/04 18:20:31 | at weblogic.kernel.ExecuteThread.execute(ExecuteThrea d.java:219)
INFO | jvm 1 | 2008/06/04 18:20:31 | at weblogic.kernel.ExecuteThread.run(ExecuteThread.ja va:17
I have run the "Setup Security Roles" procedure as glogowner in the d/b.
Can someone suggest what could be the problem.
Thanks for your time,
Durga
I have installed OTM5.5 CU4 on Windows Server 2003 Enterprise Edition SP2.
After starting otmapp55,otmweb55 and otmwebtomcat55 in sequence,I can access the OTM instance using the url http://systemName
But when I try to login using the default users dba.admin or guest.admin or servprov.admin,I get an error saying
A connection to the server could not be established: {exception=null} (user=GUEST.ADMIN)
When I check the cosole.log located under OTM_HOME/logs/weblogic/,it says
INFO | jvm 1 | 2008/06/04 18:20:31 | java.sql.SQLException: ORA-00942: table or view does not exist
INFO | jvm 1 | 2008/06/04 18:20:31 |
INFO | jvm 1 | 2008/06/04 18:20:31 | at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:112)
INFO | jvm 1 | 2008/06/04 18:20:31 | at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoe r.java:331)
INFO | jvm 1 | 2008/06/04 18:20:31 | at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoe r.java:28

INFO | jvm 1 | 2008/06/04 18:20:31 | at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java: 745)
INFO | jvm 1 | 2008/06/04 18:20:31 | at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4 CPreparedStatement.java:216)
INFO | jvm 1 | 2008/06/04 18:20:31 | at oracle.jdbc.driver.T4CPreparedStatement.executeFor Describe(T4CPreparedStatement.java:810)
INFO | jvm 1 | 2008/06/04 18:20:31 | at oracle.jdbc.driver.OracleStatement.executeMaybeDes cribe(OracleStatement.java:1039)
INFO | jvm 1 | 2008/06/04 18:20:31 | at oracle.jdbc.driver.T4CPreparedStatement.executeMay beDescribe(T4CPreparedStatement.java:850)
INFO | jvm 1 | 2008/06/04 18:20:31 | at oracle.jdbc.driver.OracleStatement.doExecuteWithTi meout(OracleStatement.java:1134)
INFO | jvm 1 | 2008/06/04 18:20:31 | at oracle.jdbc.driver.OraclePreparedStatement.execute Internal(OraclePreparedStatement.java:3339)
INFO | jvm 1 | 2008/06/04 18:20:31 | at oracle.jdbc.driver.OraclePreparedStatement.execute Query(OraclePreparedStatement.java:3384)
INFO | jvm 1 | 2008/06/04 18:20:31 | at weblogic.jdbc.wrapper.PreparedStatement.executeQue ry(PreparedStatement.java:124)
INFO | jvm 1 | 2008/06/04 18:20:31 | at glog.util.jdbc.noserver.SqlQuery.executeQuery(SqlQ uery.java:146)
INFO | jvm 1 | 2008/06/04 18:20:31 | at glog.util.jdbc.noserver.SqlQuery.resetArguments(Sq lQuery.java:124)
INFO | jvm 1 | 2008/06/04 18:20:31 | at glog.util.jdbc.noserver.SqlQuery.open(SqlQuery.jav a:94)
INFO | jvm 1 | 2008/06/04 18:20:31 | at glog.server.useraccess.UserAccessSessionBean.getUs erAccess(UserAccessSessionBean.java:151)
INFO | jvm 1 | 2008/06/04 18:20:31 | at glog.server.useraccess.UserAccessSessionServerSide EJBWrapper.getUserAccess(UserAccessSessionServerSi deEJBWrapper.java:70)
INFO | jvm 1 | 2008/06/04 18:20:31 | at glog.server.useraccess.UserAccessSessionHome_uzvgz z_EOImpl.getUserAccess(UserAccessSessionHome_uzvgz z_EOImpl.java:154)
INFO | jvm 1 | 2008/06/04 18:20:31 | at glog.server.useraccess.UserAccessSessionHome_uzvgz z_EOImpl_WLSkel.invoke(ILweblogic.rmi.spi.InboundR equest;Lweblogic.rmi.spi.OutboundResponse;Ljava.la ng.Object

INFO | jvm 1 | 2008/06/04 18:20:31 | at weblogic.rmi.internal.BasicServerRef.invoke(BasicS erverRef.java:477)
INFO | jvm 1 | 2008/06/04 18:20:31 | at weblogic.rmi.cluster.ReplicaAwareServerRef.invoke( ReplicaAwareServerRef.java:10

INFO | jvm 1 | 2008/06/04 18:20:31 | at weblogic.rmi.internal.BasicServerRef$1.run(BasicSe rverRef.java:420)
INFO | jvm 1 | 2008/06/04 18:20:31 | at weblogic.security.acl.internal.AuthenticatedSubjec t.doAs(AuthenticatedSubject.java:363)
INFO | jvm 1 | 2008/06/04 18:20:31 | at weblogic.security.service.SecurityManager.runAs(Se curityManager.java:147)
INFO | jvm 1 | 2008/06/04 18:20:31 | at weblogic.rmi.internal.BasicServerRef.handleRequest (BasicServerRef.java:415)
INFO | jvm 1 | 2008/06/04 18:20:31 | at weblogic.rmi.internal.BasicExecuteRequest.execute( BasicExecuteRequest.java:30)
INFO | jvm 1 | 2008/06/04 18:20:31 | at weblogic.kernel.ExecuteThread.execute(ExecuteThrea d.java:219)
INFO | jvm 1 | 2008/06/04 18:20:31 | at weblogic.kernel.ExecuteThread.run(ExecuteThread.ja va:17

I have run the "Setup Security Roles" procedure as glogowner in the d/b.
Can someone suggest what could be the problem.
Thanks for your time,
Durga
Comment