[dgoli]

Hello everyone,

Thanks for your time in replying.

Let me explain my situation here.Pls apologise for not providing complete details before.

We have our DB server,Oracle 10g,running on a different machine,say m1.
Also we have OTM 5.5 instance running on Unix platform on a machine m2.
Now we are installing OTM 5.5 on a Windows machine,say m3,so that some users can use this instance.

we have executed the set_*_roles.sql(don't remember exact name) as mentioned in the ADMIN guide.

The OTM instance on m3 is trying to connect to DB instance running on m1.
Sometimes we get the following error in weblogic\console.log when i start the OTMAPP55,OTMWEB55 AND OTMWEBTOMCAT55

INFO | jvm 1 | 2008/06/05 19:57:02 | cause.WorkflowManager.0006 (classesItem=class glog.server.workflow.process.ProcessControlTimer)
INFO | jvm 1 | 2008/06/05 19:57:02 | java.sql.SQLException: Listener refused the connection with the following error:
INFO | jvm 1 | 2008/06/05 19:57:02 | ORA-12519, TNS:no appropriate service handler found
INFO | jvm 1 | 2008/06/05 19:57:02 | The Connection descriptor used by the client was:
INFO | jvm 1 | 2008/06/05 19:57:02 | fqdn:1521:OTMDEV
INFO | jvm 1 | 2008/06/05 19:57:02 |
INFO | jvm 1 | 2008/06/05 19:57:02 |
INFO | jvm 1 | 2008/06/05 19:57:02 | java.sql.SQLException: Listener refused the connection with the following error:
INFO | jvm 1 | 2008/06/05 19:57:02 | ORA-12519, TNS:no appropriate service handler found

under weblogic\weblogic.log,we found this exception

weblogic.common.ResourceException: 96:Could not create pool connection. The DBMS driver exception was: Listener refused the connection with the following error:
ORA-12519, TNS:no appropriate service handler found
The Connection descriptor used by the client was:
fqdn:1521:OTMDEV
- with nested exception:
[weblogic.common.ResourceException: Could not create pool connection. The DBMS driver exception was: Listener refused the connection with the following error:
ORA-12519, TNS:no appropriate service handler found
The Connection descriptor used by the client was:
fqdn:1521:OTMDEV

When i attempt login,I found the following errors for different users under tomcat/console.log

INFO | jvm 1 | 2008/06/05 20:12:03 | cause.Security_UserBadCredential (userName=DBA.ADMIN)

for GUEST.ADMIN
INFO | jvm 1 | 2008/06/05 20:13:25 | java.sql.SQLException: Pool connect failed : java.sql.SQLException: Connection Pool PRIMARY_JTS does not exist.

for SERVPROV.ADMIN
INFO | jvm 1 | 2008/06/05 20:13:25 | java.sql.SQLException: Pool connect failed : java.sql.SQLException: Connection Pool PRIMARY_JTS does not exist.

Sometimes when I attempt login we get the following error
INFO | jvm 1 | 2008/06/05 20:33:52 | java.sql.SQLException: ORA-00942: table or view does not exist

Don't really understand what is happening here.
My point is that,since we are making use of DB instance which is upgraded to CU4 and already being used by OTM instance on m2,I don't feel the necessity to go through all the steps mentioned in the section "Installing Oracle Transportation Management on the Database Server" and running the DB patch scripts to update the schema to CU04.

Pls correct me if I assumed anything wrong.

Thanks for your time in reading my posting.
Durga