Forgot your password?    
+ Reply to Thread
Results 1 to 2 of 2

Thread: database getting hange

  1. #1
    Oracle DBA
    Join Date
    Nov 2011

    database getting hange


    my database getting hange frequently .i found in alert log this error can anyone hel me on this issue.

    Thu Nov 24 15:39:47 IST 2011
    Thu Nov 24 15:51:01 IST 2011
    WARNING: Detected too many memory locking problems.
    WARNING: Performance degradation may occur.
    Thu Nov 24 16:05:07 IST 2011
    Process q004 died, see its trace file
    Thu Nov 24 16:05:07 IST 2011
    ksvcreate: Process(q004) creation failed
    Thu Nov 24 16:11:35 IST 2011
    Beginning log switch checkpoint up to RBA [0x25bc.2.10], SCN: 14826159340
    Thu Nov 24 16:11:35 IST 2011
    Thread 1 advanced to log sequence 9660 (LGWR switch)
    Current log# 10 seq# 9660 mem# 0: /log1/PROD/log10a.dbf
    Current log# 10 seq# 9660 mem# 1: /log1/PROD/log10b.dbf
    Thu Nov 24 16:16:43 IST 2011
    Completed checkpoint up to RBA [0x25bc.2.10], SCN: 14826159340

  2. #2
    Expert Oracle Administrator
    Join Date
    Oct 2011
    New Delhi, India
    Please send the ouput of :

    A) Send the value of job_queue_processes
    and processes init parameter

    B) send the output of 'ulimit -Sa' for the oracle user.

    C) Give the output of :
    cd $ORACLE_HOME/bin
    ls -l oradism

    As per metalink note 374367.1:
    1- cd $ORACLE_HOME/bin
    2- chmod 4550 oradism
    3- chmod g+s oradism
    4- chown root:dba oradism
    5- Bounce the database

+ Reply to Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

DBA Lounge (P) Ltd. deals in Oracle Technologies on Consulting, Resourcing, Corporate Training

Online and corporate training available on Oracle Database 11g, Oracle 11g Real Application Cluster (RAC), Oracle Applications 11i/R12, Oracle Fusion Middleware 11g, Oracle Identity Management-OIM, Oracle Internet Directory 11g-OID, Oracle Business Intelligence Enterprise Edition-OBIEE, Oracle Golden Gate, Oracle Access Management-OAM, Oracle Internet Directory-ODS, Oracle Identity Analytics Architecture-OIA Statistics