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

Thread: start the db

  1. #1
    Join Date
    May 2002
    Posts
    232
    Hiii,I have problem to start the database on sunsolaris
    db version 9i
    Thu Aug 8 17:02:56 2002
    Starting ORACLE instance (normal)
    Thu Aug 8 17:02:58 2002
    Errors in file /app/oracle/admin/sghtest/udump/sghtest_ora_27875.trc:
    ORA-27146: post/wait initialization failed
    ORA-27300: OS system dependent operation:semget failed with status: 28
    ORA-27301: OS failure message: No space left on device
    ORA-27302: failure occurred at: sskgpsemsper
    Thu Aug 8 17:02:58 2002
    Errors in file /app/oracle/admin/sghtest/udump/sghtest_ora_27875.trc:
    ORA-27302: failure occurred at: skgpwreset1
    ORA-27303: additional information: invalid shared ctx
    ORA-27146: post/wait initialization failed
    ORA-27300: OS system dependent operation:semget failed with status: 28
    ORA-27301: OS failure message: No space left on device
    ORA-27302: failure occurred at: sskgpsemsper

    when try to connect from sqlprompt i get a one more error**
    SQL> connect websms/sghocs1@sghtest.192.100.86.52;
    ERROR:
    ORA-01034: ORACLE not available
    ORA-27101: shared memory realm does not exist
    SVR4 Error: 2: No such file or directory

    plss reply soon
    thanks
    kavitha

    kavitha

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Increase semaphores in /etc/system: SEMMSL & SEMMNI

    Note: websms/sghocs1@sghtest.192.100.86.52 is a bit too much information given in Internet.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

  3. #3
    Join Date
    Jul 2000
    Location
    Amsterdam
    Posts
    234

    Smile

    Hi,

    Reading your output tells me your shmmax setting is to low.

    Read the installation guide to see how you have to change it and also put some extra semaphores in.

    Kind regards,

    Tycho

  4. #4
    Join Date
    May 2002
    Posts
    232
    hii,many thanks
    can u give detail doc or procedure
    kavitha

  5. #5
    Join Date
    Dec 2001
    Posts
    320
    Originally posted by julian

    Note: websms/sghocs1@sghtest.192.100.86.52 is a bit too much information given in Internet.
    you shouldn't have given all these details, i would change the password if i were you kavithared.

    alter user websms identified by new_password;

    Regards.

  6. #6
    Join Date
    Jul 2002
    Location
    Lincolnshire, IL
    Posts
    203
    Just to add, one more thing, if any one of mount point is 100% full, you cann't start your Oracle. So check if this is the situation if you are not able to solve the problem.
    Always take care of the point pointed out by Hany... :-)
    Sandy
    "Greatest Rewards come only with Greatest Commitments!"

  7. #7
    Join Date
    Apr 2002
    Posts
    135
    login as root
    Use a text editor such as vi to change kernel parameter settings in the /etc/system file

    check the values for the following settings

    SEMMNI 100
    SEMMNS 256
    SEMMSL 256
    SHMMAX 4294967295
    SHMMIN 1
    SHMMNI 100
    SHMSEG 10

    reboot the system if you change any of these values.

    http://www.dbspecialists.com/present...20solaris.html

    go through this link which has the step by step installation process

    [Edited by sona on 08-08-2002 at 07:35 AM]
    Good Judgement comes from Experience.
    Experience comes from Bad Judgement

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