ORA-00018 issues

  • From: Maureen English <sxmte@xxxxxxxxxxxxxxxx>
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 26 Feb 2009 09:25:36 -0900

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 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 sqlnet.
Then the consultant tries his connection, gets the error and we can no longer
connect via sqlnet.

Any suggestions for further troubleshooting?  We're looking into java issues,
as well as system/database issues, but so far nothing is obvious.

- Maureen


Other related posts: