Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: connect and
Have you set RESOURCE_LIMITS = true in the init.ora file and bounced the
database?
Pete
Knut Lambert wrote:
> Hello,
>
> in an application, i have to ensure, that a user can connect only one time
> to the instance. (Oracle 7 and 8, Windows-NT) How can i do this?
>
> i have created a user with
>
> CREATE PROFILE PR_SIMSUSR
> -- all Parameters to default
> SESSIONS_PER_USER 1
> blah blah blah;
>
> and
>
> CREATE USER "XXX"
> blah blah blah
> PROFILE PR_SIMSUSR
> blah blah blah;
>
> But, i still can connect multiple times.
>
> In my application i am looking to V$SESSION to verify if there is already a
> session.
> But when the connection wents down (e.g. Network Problems) the View shows
> a Session (Action 100 - LOGON).
>
> What can i do to solve this problem?
>
> Thanks a lot for your help!
>
> Knut Lambert
> (lambert_at_consilium.de)
Received on Wed Oct 27 1999 - 13:53:00 CDT