Re: ORA-00018 issues
Date: Thu, 26 Feb 2009 19:32:43 +0100
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.
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:
> 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
-- 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-lReceived on Thu Feb 26 2009 - 12:32:43 CST