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

Thread: ORA-27146

  1. 08-07-2002, 08:33 AM #1
    Sameer's Avatar
    Sameer
    Sameer is offline Advisor
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    What is this error....

    ORA-27146: post/wait initialization failed

    Thanks

    Sameer
    Reply With Quote Reply With Quote
  2. 08-07-2002, 08:41 AM #2
    sandycrab
    sandycrab is offline Member
    Join Date
    Jul 2002
    Location
    Lincolnshire, IL
    Posts
    203
    Plz let me know the scenario in which you are getting this error. There can be n number of reasons for the same. also plz tell me what OS you are using, what Oracle version etc...
    Sandy
    "Greatest Rewards come only with Greatest Commitments!"
    Reply With Quote Reply With Quote
  3. 08-07-2002, 08:42 AM #3
    sandycrab
    sandycrab is offline Member
    Join Date
    Jul 2002
    Location
    Lincolnshire, IL
    Posts
    203
    This error occurs if there is not enough memory to start your instance. Check the shmem shseg settings in the /etc/system file and your initSID.ora settings regarding SGA size.
    Sandy
    "Greatest Rewards come only with Greatest Commitments!"
    Reply With Quote Reply With Quote
  4. 08-07-2002, 08:44 AM #4
    Sameer's Avatar
    Sameer
    Sameer is offline Advisor
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    I have using Oracle 8.1.6 on Sun 5.8

    What I did is I just uncommnted the archive log parameters because I wanted to change the lod mode

    I just uncommented

    log_archive_start = true
    log_archive_dest_1 = "location=/opt/oracle/data2/ora4/arch"
    log_archive_format = arch_%t_%s.arc

    And I tried to startup database..

    All directoroes and every thing exists...

    I started getting this error.. I checked init.ora for wrong values and commented again log parameters .. BUT still ...

    What may be wrong?

    Thanks

    Sameer
    Reply With Quote Reply With Quote
  5. 08-07-2002, 08:45 AM #5
    Tarry's Avatar
    Tarry
    Tarry is offline Senior Advisor
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    Regarding installation?
    Metalink note:
    Increase the kernel parameter "SEMMNS".
    You are running out of semaphores (semmns).
    For every "processes=" in the init"SID".ora Oracle needs one semaphore (semmns). So when you try and start a second database the OS doesn't have enough semaphores for Oracle.
    To set the kernel parameter for SEMMNS, use this formula . For
    example, consider a system that has three Oracle instances with the PROCESSES parameter in their init sid.ora files set to the following values:
    ORACLE_SID=A, PROCESSES=100
    ORACLE_SID=B, PROCESSES=100
    ORACLE_SID=C, PROCESSES=200
    The value of SEMMNS is calculated as follows:
    SEMMNS = ((A=100) + (B=100)) + ((C=200) * 2) + ((# of instances=3) * 10) = 630

    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---
    Reply With Quote Reply With Quote
  6. 08-07-2002, 09:03 AM #6
    Sameer's Avatar
    Sameer
    Sameer is offline Advisor
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    I have only one instance is running

    and PROCESS is 50 but still I have set 210 in SEMMNS


    But problem is instance was running well and I just shutdown to change the log mod

    how come this happen :-(

    Sameer
    Reply With Quote Reply With Quote
  7. 08-07-2002, 09:43 AM #7
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    do ipcs -a to check if the resources are freed
    if not use ipcrm to free them
    Reply With Quote Reply With Quote
« Previous Thread | Next 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
  •  

Forum Rules

Click Here to Expand Forum to Full Width