Problem Creating Database on HP-UX
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Problem Creating Database on HP-UX

  1. #1
    Join Date
    Jun 2000
    Posts
    179

    Talking

    Platform : HP-UX ver. 10.20
    Oracle Server : 8.0.4
    Occasion : trying to create another database on the server

    Situation : at the moment I have one working database ORCL
    Problem : when trying to create another database ORC1 , I get the incoming error from server manager :

    ORA-00600 internal error code , arguments : [SKGMBUSY],[1],[0], [0], [0], [0],[] ,[] ,[] ,[]
    ORA-27123 Unable to attache to the shared memory segment HP-UX Error :22 : Invalid Argument.

    I tried to create the new database from the installer but also failled and when checked the trace file I witnessed the same error .

    What could be Wrong ???
    Hisham Nagia
    IT Manager For Development
    Oracle Consultant - OCP

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    check your kernal parameters. I would bet one of them is low...
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Oct 2000
    Location
    Dallas:TX:USA
    Posts
    407
    Check the init.ora for both the instances to compare what kind of shared_pool_size you are setting.

    - Rajeev

  4. #4
    Join Date
    Jun 2000
    Posts
    179
    Thank You All , I just forget to tell that the first database was closed when starting to create the second one.

    Thank You
    Hisham Nagia
    IT Manager For Development
    Oracle Consultant - OCP

  5. #5
    Join Date
    Jan 2001
    Posts
    126
    Hi,

    If appears that you do not have any more shared memory segments available.

    Check if some are still in use by typing ipcs command. The database must be down but for some reason the shared memory is not deallocated.

    Re-start UNIX and then try creating the database.

    Baliga

  6. #6
    Join Date
    Jun 2000
    Location
    Chennai/India
    Posts
    90
    Hi,
    I've faced these prblm earlier. Pls check the value of SHMMAX using sam utility of unix. The exact problem is 'cause the sum of the SGA of both Oracle DB is exceeding this value. Try increasing the value of SHMMAX and then start both the DB's
    A Winner never Quits, A Quitter never Wins
    Ganesh .R

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