-
Hi,
Our DB is 8.1.7 on running HP ux. running Java applications on that. after certain time period, users connections are not allowed to loging oracle.
what could be the problem. Should i need to change any init.ora parameters. OR Is there any license limit for the users.
Thanx in advance.
Oracle
-
Are they disconnect from system (maybe something about profiles), or the users connect works fine but new connections are not allowed (check max users, licenses ...)
Cheers
Angel
-
Angel,
U r saying is correct. existing connections r working fine. but new connections not allowed. how do v check the max users license. Is there any table to check? I found one table v$mts. Is this related to the maxuser.
thanks.
Oracle
-
Venkat, I think this note if metalink will help you, but next time try to search by yourself (it is more interesting):
Bookmark Fixed font Go to End
Doc ID: Note:1036728.6
Subject: ORA-00018 & ORA-00604 WHEN MAKING NEW CONNECTIONS TO THE DATABASE
Type: PROBLEM
Status: PUBLISHED
Content Type: TEXT/PLAIN
Creation Date: 08-OCT-1997
Last Revision Date: 22-JAN-2002
Problem Description:
====================
You receive the following errors when trying to make new connections:
ORA-00604: error occurred at recursive SQL level 1
Cause: An error occurred while processing a recursive SQL statement.
A recursive SQL statement is one that applies to internal
dictionary tables.
Action: If the situation described in the next message on the stack can
be corrected, do so; otherwise, contact customer support.
ORA-00018: maximum number of sessions exceeded
Cause: An operation requested a resource that was unavailable.
The maximum number of sessions is specified by the
initialization parameter SESSIONS.
When this maximum is reached, no more requests are processed.
Action: Try the operation again in a few minutes.
If this message occurs often, shut down Oracle, increase the
SESSIONS parameter in the initialization parameter file, and
restart Oracle.
NOTE: No new connections are permitted to the database.
Selecting count(*) from V$SESSION returns a value that is less than
the current setting of the SESSIONS parameter which is either derived
(default) or specifically set in the "init.ora".
Solution Description:
=====================
You need to increase the value of the SESSIONS parameter in the "init.ora"
file.
-or-
Increase the value of PROCESSES since SESSIONS is derived off of the PROCESSES
parameter.
SESSIONS: derived (1.1 * PROCESSES + 5)
Explanation:
============
You hit the maximum number of sessions in the database.
SESSIONS specifies the total number of user and system sessions. The default
number is greater than PROCESSES to allow for recursive sessions.
[BUG:480599] and [BUG:456884] document this behavior. The difference between
what V$SESSION shows and the actual number of connections is documented in
[BUG:480599]. "There is a delay between freeing up and cleaning out the
sessions. Hence you see this inconsistent image on V$SESSIONS."
References:
===========
Oracle7 Reference manual pg 1-63.
[BUG:480599] ORA-604 AND ORA-18 WHEN MAKING NEW CONNECTIONS
[BUG:456884] MAXIMUM SESSIONS IS SET AT 300 RECEIVING ORA-604/ORA-18 WITH
UNDER 200 SESSIONS
Search Words:
=============
ora-604 ora-18
Cheers
Angel
-
thanks angel, yeah i have increased my process in the init.ora from 50 to 100 process, since we r runing 2 database on this HP machine. the unix itself it allows only 256 process. if i increase more that then i will get some 'post/invalid' error due to unix kernal problem.
anyway thanks again. i will go thru metalink too. mean time i am thinking of using MTS option to make use of the memory. but my worry is,again there would be the performance probs may occur right.
Oracle
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|