Common shm problems of ORACLE11G in ORA-00845

ORA-00845 ORACLE11G common shm problem error process

srv-bioradb:~> sqlplus / as sysdbaSQL*Plus: Release 11.2.0.3.0 Production on Thu Jul 25 18:27:45 2013Copyright (c) 1982, 2011, Oracle.  All rights reserved.Connected to an idle instance.SQL> startupORA-00845: MEMORY_TARGET not supported on this systemSQL> show sga;ORA-01034: ORACLE not availableProcess ID: 0Session ID: 0 Serial number: 0

 

Internet access google found that shm is too small to set shm1) uninstall shm, encountered an error

srv-bioradb:~> df -hdf: `/root/.gvfs': Permission deniedFilesystem                       Size  Used Avail Use% Mounted on/dev/mapper/system-lv_root       358G  8.5G  331G   3% /devtmpfs                         127G  624K  127G   1% /devtmpfs                            195G  932K  195G   1% /dev/shm/dev/cciss/c0d0p1                1.6G  106M  1.4G   8% /boot/dev/mapper/data-lv_data         2.3T  1.8T  364G  84% /oracle/dev/mapper/oraclevg-oraclelv01  2.9T  201M  2.7T   1% /oracle1srv-bioradb:~> more /etc/fstab/dev/system/lv_swap  swap                 swap       defaults              0 0/dev/system/lv_root  /                    ext3       acl,user_xattr        1 1/dev/disk/by-id/cciss-3600508b1001c59983f902a5494c7d076-part1 /boot   ext3       acl,user_xattr        1 2#/dev/data/lv_data    /oracle_bk           ext3       acl,user_xattr        1 2/dev/data/lv_data    /oracle              ext3       defaults              0 0proc                 /proc                proc       defaults              0 0sysfs                /sys                 sysfs      noauto                0 0debugfs              /sys/kernel/debug    debugfs    noauto                0 0usbfs                /proc/bus/usb        usbfs      noauto                0 0devpts               /dev/pts             devpts     mode=0620,gid=5       0 0#/dev/mapper/oraclevg-oraclelv01  /oracle           ext3  defaults         0 0#/dev/mapper/oraclevg-oraclelv02  /oracle/oradata2  ext3  defaults         0 0srv-bioradb:~>srv-bioradb:~>srv-bioradb:~> umount /dev/shmumount: /dev/shm is not in the fstab (and you are not root)srv-bioradb:~> exitexitsrv-bioradb:~ #srv-bioradb:~ # umount /dev/shmumount: /dev/shm: device is busy.        (In some cases useful info about processes that use         the device is found by lsof(8) or fuser(1))srv-bioradb:~ #

 

2) check who is using shm and kill it.

srv-bioradb:~ # fuser -cu /dev/shm/dev/shm:            12555m(root) 12614m(root) 12622m(root)srv-bioradb:~ # ps -ef | grep 12555root     12555     1  0 Jul24 ?        00:00:05 /usr/lib/gnome-settings-daemon/gnome-settings-daemonroot     43817 43683  0 18:36 pts/2    00:00:00 grep 12555srv-bioradb:~ # ps -ef | grep  12614root     12614 12445  0 Jul24 ?        00:00:00 gnome-volume-control-appletroot     43819 43683  0 18:37 pts/2    00:00:00 grep 12614srv-bioradb:~ # ps -ef | grep  12622root     12622     1  0 Jul24 ?        00:00:00 /usr/bin/pulseaudio --startroot     43821 43683  0 18:37 pts/2    00:00:00 grep 12622srv-bioradb:~ # kill -9  12555srv-bioradb:~ # kill -9 12614srv-bioradb:~ # kill -9 12622

 

Here, the process you find must ps to see what processes are occupying the shm file system. If the application occupies the shm file system, exit the program. If it is a zombie process or an unimportant shell terminal, kill it directly. 3) uninstall shm again.

srv-bioradb:~ #srv-bioradb:~ # umount /dev/shmsrv-bioradb:~ #srv-bioradb:~ # df -hFilesystem                       Size  Used Avail Use% Mounted on/dev/mapper/system-lv_root       358G  8.5G  331G   3% /devtmpfs                         127G  624K  127G   1% /dev/dev/cciss/c0d0p1                1.6G  106M  1.4G   8% /boot/dev/mapper/data-lv_data         2.3T  1.8T  364G  84% /oracle/dev/mapper/oraclevg-oraclelv01  2.9T  201M  2.7T   1% /oracle1srv-bioradb:~ #

 

4) reset the shm size.

srv-bioradb:~ # vi /etc/fstabSQL> host more /etc/fstab/dev/system/lv_swap  swap                 swap       defaults              0 0/dev/system/lv_root  /                    ext3       acl,user_xattr        1 1/dev/disk/by-id/cciss-3600508b1001c59983f902a5494c7d076-part1 /boot   ext3       acl,user_xattr        1 2#/dev/data/lv_data    /oracle_bk           ext3       acl,user_xattr        1 2/dev/data/lv_data    /oracle              ext3       defaults              0 0proc                 /proc                proc       defaults              0 0sysfs                /sys                 sysfs      noauto                0 0debugfs              /sys/kernel/debug    debugfs    noauto                0 0usbfs                /proc/bus/usb        usbfs      noauto                0 0devpts               /dev/pts             devpts     mode=0620,gid=5       0 0tmpfs                /dev/shm             tmpfs      defaults,size=256G    0 0#/dev/mapper/oraclevg-oraclelv01  /oracle           ext3  defaults         0 0#/dev/mapper/oraclevg-oraclelv02  /oracle/oradata2  ext3  defaults         0 0srv-bioradb:~ # mount /dev/shmsrv-bioradb:~ # df -hFilesystem                       Size  Used Avail Use% Mounted on/dev/mapper/system-lv_root       358G  8.5G  331G   3% /devtmpfs                         127G  624K  127G   1% /dev/dev/cciss/c0d0p1                1.6G  106M  1.4G   8% /boot/dev/mapper/data-lv_data         2.3T  1.8T  364G  84% /oracle/dev/mapper/oraclevg-oraclelv01  2.9T  201M  2.7T   1% /oracle1tmpfs                            256G     0  256G   0% /dev/shmsrv-bioradb:~ #srv-bioradb:~ #srv-bioradb:~ #

 

Start oracle and no error is reported. The problem is solved.

srv-bioradb:~ # whoamirootsrv-bioradb:~ # su - oraclesrv-bioradb:~> sqlplus / as sysdbaSQL*Plus: Release 11.2.0.3.0 Production on Thu Jul 25 18:46:06 2013Copyright (c) 1982, 2011, Oracle.  All rights reserved.Connected to an idle instance.SQL> startupORACLE instance started.Total System Global Area 2.1913E+11 bytesFixed Size                  2241384 bytesVariable Size            1.0469E+11 bytesDatabase Buffers         1.1435E+11 bytesRedo Buffers               88821760 bytesDatabase mounted.Database opened.SQL>