Problem with Oracle on Sun OS on Intel
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Problem with Oracle on Sun OS on Intel

  1. #1
    Join Date
    Aug 2001
    Posts
    36
    Hi,

    I have installed Oracle8.1.7 on Sun(Intel) OS . While installation, during database creation I had some problem with memory(I did not face any problem till database creation started . Problem started only after the creation of instance ). I have ignored that and continued with installation .

    After installation I have rebooted the system. After bringing up the sytem I have tried to startup nomount stage so that I can create database. But I got following errors

    ORA-27123 Unable to attach to shared memory segment
    Intel SVR4 Unix Error : 24 : Too many open files

    After that I have tried to connect using SQLPLUS I got following error

    ORA-27101 : Shared Memory realm does not exist
    intel SVR4 Unix error : 2 : no such file or directory

    Please suggest a solution for this

    Regards,





  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Your kernal parameters (/etc/system) need to be modified. Re-read the install manual. On a small system, I start with:
    Code:
    set shmsys:shminfo_shmmax=532870192
    set shmsys:shminfo_shmmin=1
    set shmsys:shminfo_shmmni=1024
    set shmsys:shminfo_shmseg=256
    set semsys:seminfo_semmap=100
    set semsys:seminfo_semmni=100
    set semsys:seminfo_semmnu=300
    set semsys:seminfo_semmsl=250
    set semsys:seminfo_semopm=100
    set semsys:seminfo_semume=100
    set semsys:seminfo_semvmx=32767
    set semsys:seminfo_semmns=2000
    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
    Aug 2001
    Posts
    36
    Thanks a lot . I will try this and Let you know.

    Regards,


  4. #4
    Join Date
    Mar 2002
    Posts
    24
    Hi,

    Just tune the kernel(/etc/system) as logged in root
    and reboot the system
    with b -r


    cheers
    G.Laxman
    Oracle DBA

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