DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: users not able to connect the new connections

  1. #1
    Join Date
    Jul 2002
    Posts
    42
    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

  2. #2
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    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

  3. #3
    Join Date
    Jul 2002
    Posts
    42
    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

  4. #4
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    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

  5. #5
    Join Date
    Jul 2002
    Posts
    42
    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
  •  


Click Here to Expand Forum to Full Width