Re: Wierd problem with MTS & Oracle Java connectivity

The first thing I would check is the tnsnames ( or oracle names, if you use that) entry to see if a server=dedicated parameter is set;if so, then if no dedicated processes are available, the login will be rejected ... Also check to see if a similar parameter may be set in the sqlnet.ora file the users are using...

robertscothunter_at_aol.comnospam (R. Scott Hunter) wrote:

>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!
>-----------------------------------------------------------------------
>R. Scott Hunter
>Please respond to: rshunter_at_navy.org
>GO NAVY!
>-----------------------------------------------------------------------
  Received on Tue Jan 02 2001 - 10:03:12 CST