Re: ORA-00018 issues

From: Toon Koppelaars <toon.koppelaars_at_rulegen.com>
Date: Thu, 26 Feb 2009 19:32:43 +0100
Message-ID: <ecf3dae70902261032t40424774gd64b5066f73e1d68_at_mail.gmail.com>

If your consultant is using a dedicated username to log into this instance, you could isolate the problem by creating a profile that limits the number of concurrent sessions, and then attach that profile to the consultant's username.

Toon

On Thu, Feb 26, 2009 at 7: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:
>
>
> jdbc:cp:uPortalPooled;driver=oracle.jdbc.driver.OracleDriver;url=jdbc:oracle:thin:_at_mydb.mydomain.xxx
> ;1234:MYDB
>
> 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
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Toon Koppelaars
RuleGen BV
+31-615907269
Toon.Koppelaars_at_RuleGen.com
www.RuleGen.com

(co)Author: "Applied Mathematics for Database Professionals"

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Feb 26 2009 - 12:32:43 CST