| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Wierd problem with MTS & Oracle Java connectivity
Howdy folks,
We're having a really bizzare problem. Our application environment is Sun
Solaris for both the Oracle RDBMS and for the middle tier and presentation
(Web) layers. Everything works fine with the SQL*NET dedicated approach, but
because of so many shadow processes we have been trying to move to MTS; its a
good fit for the type of user activity we have.
We are using Oracle JDBC to talk to the RDBMS. There is a non-standard config file that points these guys to the right port and service to access Oracle and it works just fine (apart from a zillion processes.)
When we bring up the RDBMS with the proper entries in initSID.ora and as far as we can tell all the right stuff in LISTENER.ORA, we have connectivity through the Web application for about 5 minutes and then we get Login Invalid messages. It's very very consistent. I have never before had this sort of thing happen with MTS. Tracing the listener at the SUPPORT level revealed nothing interesting to me.
We're going after Oracle Support today to try to resolve this, but if anyone else out there has had this problem I would be much obliged if you could share what you found and how you fixed it (hopefully this is fixable!) I just can't see how it would make a difference, since everything past the Oracle listener service is a black box as far as applications connecting via SQLNET from remote machines is concerned. Naturally, the web/asp/middleware running on the same box as the Oracle RDBMS is unaffected by this, it's the stuff running on the other boxes that can't get in after a certain amount of time.
Thanks in advance!
 |
 |