Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2002
    Posts
    2

    Unanswered: Oracle 9i installation problem - Out of Memory

    I try to install Oracle 9i Enterprise (Soalris 64bit version) on Solaris 9 at Sun Ultra 30 workstation with 512M physical memory and 1G swap space. At the last some stage of installation - database configuration assistant setup, it finished copy the database successfully but pop up a error message when it create and initialize the database instance. The error message said "out of memory".

    The Solris 9 is a fresh installation. I did not run anything else in memory.

    The manual said the minimum memory is 512M. I think my system should be OK. Could you please tell me what is the problem? Do I need to expend the physical memory? How about expend 256M more?

    /etc/system has the following kernel setup:
    set shmsys:shminfo_semmn=100
    set hmsys:shminfo_semmns=1024
    set hmsys:shminfo_semmsl=256
    set hmsys:shminfo_shmmax=4294967295
    set hmsys:shminfo_shmmin=1
    set hmsys:shminfo_shmmni=100
    set hmsys:shminfo_shmseg=10

    Following are the printout of prstat commandAfter got the error message)

    PID USERNAME SIZE RSS STATE PRI NICE TIME CPU PROCESS/NLWP
    446 oracle 190M 84M run 49 0 0:32:46 9.6% java/20
    17282 oracle 4584K 4376K cpu0 59 0 0:00:00 0.3% prstat/1
    17276 oracle 2576K 1912K sleep 59 0 0:00:00 0.1% bash/1
    298 root 127M 9000K sleep 59 0 0:00:24 0.1% Xsun/1
    17278 root 1688K 1184K sleep 59 0 0:00:00 0.0% rquotad/1
    1 root 1208K 176K sleep 59 0 0:00:00 0.0% init/1
    230 root 1728K 576K sleep 59 0 0:00:00 0.0% smcboot/1
    228 root 1728K 904K sleep 59 0 0:00:00 0.0% smcboot/1
    229 root 1728K 576K sleep 59 0 0:00:00 0.0% smcboot/1
    219 root 1040K 616K sleep 59 0 0:00:00 0.0% utmpd/1
    241 root 2664K 1120K sleep 59 0 0:00:00 0.0% vold/3
    424 oracle 3144K 1480K sleep 59 0 0:00:00 0.0% dtexec/1
    199 root 2944K 1912K sleep 59 0 0:00:00 0.0% nscd/18
    186 root 2304K 1304K sleep 59 0 0:00:00 0.0% cron/1
    162 root 2184K 984K sleep 59 0 0:00:00 0.0% lockd/2
    164 daemon 2464K 1096K sleep 59 0 0:00:00 0.0% statd/1
    178 root 3344K 1632K sleep 59 0 0:00:00 0.0% syslogd/12
    414 smmsp 4312K 976K sleep 59 0 0:00:00 0.0% sendmail/1
    207 root 1400K 648K sleep 59 0 0:00:00 0.0% powerd/2
    145 root 2432K 1256K sleep 59 0 0:00:00 0.0% inetd/1
    169 root 3704K 1432K sleep 59 0 0:00:00 0.0% automountd/3
    Total: 58 processes, 154 lwps, load averages: 0.51, 0.54, 0.55


    Following are the disk space condifiotn:
    Filesystem kbytes used avail capacity Mounted on
    /dev/dsk/c0t1d0s0 5607746 2653120 2898549 48% /
    /dev/dsk/c0t0d0s0 7670973 2560684 5033580 34% /usr
    /proc 0 0 0 0% /proc
    mnttab 0 0 0 0% /etc/mnttab
    fd 0 0 0 0% /dev/fd
    swap 1272736 40 1272696 1% /var/run
    /dev/dsk/c0t1d0s1 2034054 23501 1949532 2% /home
    /dev/dsk/c0t1d0s3 985507 816297 110080 89% /tmp


    The oracle is isntallated at /u01 which is at / partition. I am wondering why it not use swap sapce.

    Thank you for your advice,
    Iris
    Last edited by irishuang; 06-28-02 at 12:24.

  2. #2
    Join Date
    Apr 2002
    Location
    California, USA
    Posts
    482

    Cool

    You have the following parameters on your system:

    set hmsys:shminfo_semmsl=256
    set hmsys:shminfo_shmseg=10


    Those two parameters are set low.

    semmsl = (parameter PROCESSES in init.ora)*2 + 10

    shmseg = should be 4096 (max shared memory segments attached to one process) . 10 is ridiculous low.

    For more installation tips and procedures, check this
    One

    Hope that helps,



    clio_usa
    OCP DBA
    visit our web site: Click Here
    .
    .
    .

  3. #3
    Join Date
    Jun 2002
    Posts
    2
    It seems Solaris 9 is the problem here. I installed Oracle 9i in Solaris 8. Now it is fine.

    Thanks,
    Iris

Posting Permissions

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