| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Limiting Concurrent Sessions Not Working
OK,
now watch out for Oracle bug 643709 which can send your users a
pile of "ORA-02394: exceeded session limit on IO usage, you are
being logged off" even though you don't have any IO limits set. It's
fixed in 8.1.x.
Dick GouletSenior Oracle DBAOracle Certified 8i DBA
<FONT face=Tahoma
size=2>-----Original Message-----From: Sam Bootsma
[mailto:[EMAIL PROTECTED]Sent: Wednesday, June 04, 2003 3:30
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Limiting Concurrent Sessions Not Working
<SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Bingo!
<SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">
<SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Thanks Dick, it is
working now.
<SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">
<SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Sam
<SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">GBC
<SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">
<SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">-----Original
Message-----From: Goulet, Dick
[mailto:[EMAIL PROTECTED] <SPAN
style="FONT-WEIGHT: bold">Sent: <FONT face=Tahoma
size=2>June 4,
2003<SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma"> <FONT face=Tahoma
size=2>2:30
PM<SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma"><SPAN
style="FONT-WEIGHT: bold">To: Multiple recipients of list
ORACLE-LSubject: RE: Limiting
Concurrent Sessions Not Working
<FONT face="Times New Roman"
size=3>
<FONT face=Arial color=blue
size=2>Do you
have "resource_limit = true" in init.ora? If you don't it defaults to
FALSE & the profile has no effect.
<FONT face="Times New Roman"
size=3>
<SPAN
style="FONT-SIZE: 10pt">Dick GouletSenior Oracle DBAOracle Certified 8i
DBA
<P class=MsoNormal
style="MARGIN-BOTTOM: 12pt; MARGIN-LEFT: 36pt; MARGIN-RIGHT: 0cm"><FONT
face=Tahoma size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">-----Original
Message-----From: Sam Bootsma
[mailto:[EMAIL PROTECTED]<SPAN
style="FONT-WEIGHT: bold">Sent: Wednesday, June 04, 2003 2:10
PMTo: Multiple recipients of
list ORACLE-LSubject: Limiting
Concurrent Sessions Not Working
<SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Oracle7 Server Release 7.3.4.5.0
(yes, I know, old); AIX 4.3.3
<FONT face="Times New Roman"
size=3>
<SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Hello All,
<FONT face="Times New Roman"
size=3>
<SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">I am trying to limit concurrent
sessions on my database. The Oracle documentation says I can do it.
However, when I follow the steps (create profile with sessions per user set to
one, then assign Oracle user to this profile) the user is not stopped from
exceeding the number of concurrent sessions. I tested this by connecting
using Sql Plus. I even tried bouncing the database, to see if that makes a
difference, but to no avail.
<FONT face="Times New Roman"
size=3>
<SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Any ideas what is happening?
Am I missing something? Is this a problem/bug with Oracle 7.3.4? The
output below shows the steps I followed to create the profile and user. It
also shows multiple connections to the database after bouncing the
instance.
<FONT face="Times New Roman"
size=3>
<SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Thanks for any
suggestions!
<FONT face="Times New Roman"
size=3>
<SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Sam.
<DIV
style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0cm; BORDER-TOP: medium none; PADDING-LEFT: 0cm; PADDING-BOTTOM: 1pt; BORDER-LEFT: medium none; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 3pt dotted">
<FONT face="Times New Roman"
size=3>
<FONT face="Times New Roman"
size=3>
<SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">SQL> create profile sam limit
sessions_per_user 1;
<FONT face="Times New Roman"
size=3>
<SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Profile created.
<FONT face="Times New Roman"
size=3>
<SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">SQL> create user sam identified
by sam;
<FONT face="Times New Roman"
size=3>
<SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">User created.
<FONT face="Times New Roman"
size=3>
<SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">SQL> alter user sam profile
sam;
<FONT face="Times New Roman"
size=3>
<SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">User altered.
<FONT face="Times New Roman"
size=3>
<SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">SQL> grant create session to
sam;
<FONT face="Times New Roman"
size=3>
<SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Grant succeeded.
<FONT face="Times New Roman"
size=3>
<SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">SQL>
<FONT face="Times New Roman"
size=3>
<SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">SQL> l
<SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> 1 select
limit
<SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> 2 from
dba_profiles
<SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> 3 where
profile=''
<SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> 4* and resource_name =
'SESSIONS_PER_USER'
<SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">SQL> /
<FONT face="Times New Roman"
size=3>
<SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">LIMIT
<SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">----------------------------------------
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">------------------------------
Size
Size
Buffers
USERNAME
<SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">---------------
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">oracle
<SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">oracle
<SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">oracle
<SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">oracle
<SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">oracle
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">oracle
<SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">oracle
<SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">oracle
<SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">oracle
<SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">oracle
<SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">oracle
<SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">oracle
SYS
<SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">12 rows selected.
<SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">SVRMGR> select osuser, username
from v$session;
<SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">OSUSER
USERNAME
<SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">---------------
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">oracle
<SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">oracle
<SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">oracle
<SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">oracle
<SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">oracle
<SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">oracle
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">oracle
<SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">oracle
<SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">oracle
<SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">oracle
<SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">oracle
SYS
<SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">sam
SAM
<SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">sam
SAM
<SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">14 rows selected.
<SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">SVRMGR>
<FONT face="Times New Roman"
size=3>
<SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Sam
<FONT face=Arial color=navy
size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">GBC
<FONT face="Times New Roman"
size=3><SPAN
style="FONT-SIZE: 12pt">
Received on Thu Jun 05 2003 - 07:57:31 CDT
 |
 |