Re: ORA-00018 issues
Date: Thu, 26 Feb 2009 19:29:54 +0000
it'll be him, almost certainly.
- observe v$session with him connecting...
- get him to *not* use his wonderful connection pooling.
Niall - a consultant :)
On Thu, Feb 26, 2009 at 6:25 PM, Maureen English <sxmte_at_email.alaska.edu>wrote:
> We're experiencing a very strange problem...ORA-00018 errors.
> Yes, I know that the error means 'maximum number of sessions exceeded',
> but that is not the case.
> We are running Oracle 10.2.0.3.0 on Solaris 10. We have a consultant
> who is working in this database, using a connection string like:
> where mydb.mydomain.com is the machine and MYDB is the database SID.
> We're trying to figure out if his attempts to connect are messing things
> up, or if there is something else going on.
> If we reboot the machine, the problem disappears -- we can connect via
> Then the consultant tries his connection, gets the error and we can no
> connect via sqlnet.
> Any suggestions for further troubleshooting? We're looking into java
> as well as system/database issues, but so far nothing is obvious.
> - Maureen
-- Niall Litchfield Oracle DBA http://www.orawin.info -- http://www.freelists.org/webpage/oracle-lReceived on Thu Feb 26 2009 - 13:29:54 CST