Re: A strange variant of ORA-02391.

From: Alan <alan_at_erols.com>
Date: Wed, 12 Jan 2005 10:01:57 -0500
Message-ID: <34ksfaF4cj0onU1@individual.net>

"Dexter" <vikram_ramakrishnan_at_ieee.org> wrote in message news:1105523556.548305.79880_at_c13g2000cwb.googlegroups.com...
> Hi,
>
> I have a program that runs daily and merges two tables in different DBs
> using DB links.
> This program SOMETIMES errors out saying..
>
> DBD::Oracle::db do failed: ORA-02391: exceeded simultaneous
> SESSIONS_PER_USER limit
> ORA-02063: preceding line from DW_TO_AD (DBD ERROR: OCIStmtExecute)
> [for Statement
>
>
> The "SESSIONS_PER_USER" limit is set to "UNLIMITED" for this user and
> the maximum allowed sessions for this DB is 350.
> I could see that the total session at the time this error happended was
> 104.
>
> What could be causing this problem?
> Pls. share your thoughts on this.
>
> -Dexter.
>

The 2063 error should direct you to the instance that is having the problem. I suspect that whatever DW_TO_AD refers to is where the session limit is the problem. Received on Wed Jan 12 2005 - 09:01:57 CST