dbca -silent -responsefile 建库由于tmpfs太小报错ORA-27102: out of memory

dbca -silent -responsefile 建库由于tmpfs太小报错ORA-27102: out of memory

错误信息:

1. [oracle@db01 ~]$ dbca -silent -responsefile dbca.rsp 
   Copying database files
   1% complete
   2% complete
   4% complete
   12% complete
   100% complete
   Look at the log file "/DBSoft/oracle/cfgtoollogs/dbca/woo/woo.log" for further details.
   [oracle@db01 ~]$ cat /DBSoft/oracle/cfgtoollogs/dbca/woo/woo.log
   SGA size can not be greater than maximum shared memory segment size (0). Refer to Oracle installation guide to configure your operating system kernel parameters.
   Copying database files
   DBCA_PROGRESS : 1%
   DBCA_PROGRESS : 2%
   ORA-27102: out of memory
   
   
   DBCA_PROGRESS : 4%
   ORA-01034: ORACLE not available
   
   
   DBCA_PROGRESS : 12%
   ORA-01034: ORACLE not available
   
   
   DBCA_PROGRESS : 100%
   

检查alert告警日志：

1. [oracle@db01 ~]$ cat $ORACLE_BASE/diag/rdbms/woo/woo/trace/alert_woo.log
   
2. Thu Jun 11 22:46:03 2015
   
3. Starting ORACLE instance (normal)
   
4. WARNING: The system does not seem to be configured
   
5. optimally. Creating a segment of size 0x0000000000800000
   
6. failed. Please change the shm parameters so that
   
7. a segment can be created for this size. While this is
   
8. not a fatal issue, creating one segment may improve
   
9. performance

问题分析:

    从上面的警告日志中的一个告警信息告诉我们这个系统在启动的时候需要创建一个大小为0x0000000000800000 size的segment失败，虽然不是一个致命的问题，但是同时告诉我们去修改shm参数可以提高性能。

问题处理：

        既然问题已经弄清楚了，那么下一步我们解决该问题就很简单了，扩大/de/shm 的值

1、首先查看下大小是多少:

1. [oracle@db01 ~]$ df -h
   
2. Filesystem Size Used Avail Use% Mounted on
   
3. /dev/mapper/vg_db01-lv_root
   
4.                        35G 8.7G 25G 27% /
   
5. tmpfs 947M 0 947M 0% /dev/shm
   
6. /dev/sda1 485M 35M 425M 8% /boot

2、手动扩大tmpfs的大小

1. [root@db01 ~]# mount tmpfs /dev/shm -t tmpfs -o size=8g
   
2. 
   
3. 
   
4. [root@db01 ~]# df -h
   
5. Filesystem Size Used Avail Use% Mounted on
   
6. /dev/mapper/vg_db01-lv_root
   
7.                        35G 8.7G 25G 27% /
   
8. tmpfs 8.0G 0 8.0G 0% /dev/shm
   
9. /dev/sda1 485M 35M 425M 8% /boot
   
10. tmpfs 8.0G 0 8.0G 0% /dev/shm

3、重新执行安装

1. [oracle@db01 ~]$ dbca -silent -responsefile dbca.rsp 
   Cleaning up failed steps
   5% complete
   Copying database files
   7% complete
   9% complete
   16% complete
   23% complete
   30% complete
   41% complete
   Creating and starting Oracle instance
   43% complete
   48% complete
   53% complete
   57% complete
   58% complete
   59% complete
   62% complete
   64% complete
   Completing Database Creation
   68% complete
   71% complete
   75% complete
   85% complete
   96% complete
   100% complete
   Look at the log file "/DBSoft/oracle/cfgtoollogs/dbca/woo/woo7.log" for further details.
   [oracle@db01 ~]$ 
   
   [oracle@db01 ~]$ netca /silent /responsefile netca.rsp 
   
   Parsing command line arguments:
       Parameter "silent" = true
       Parameter "responsefile" = netca.rsp
   Oracle Net Configuration Assistant could not find the Response File at the given location.
   Oracle Net Services configuration failed.  The exit code is 1
   

4、完成之后将tmpfs最终的大小永久写入到/etc/fstab文件中

1. [oracle@db01 ~]$ cat /etc/fstab 
   
   
   #
   # /etc/fstab
   # Created by anaconda on Tue Jun  9 19:17:12 2015
   #
   # Accessible filesystems, by reference, are maintained under '/dev/disk'
   # See man pages fstab(5), findfs(8), mount(8) and/or blkid(8) for more info
   #
   /dev/mapper/vg_db01-lv_root /                       ext4    defaults        1 1
   UUID=9ba8ae31-c918-4ad0-8408-e9e0a7d0beb4 /boot                   ext4    defaults        1 2
   /dev/mapper/vg_db01-lv_swap swap                    swap    defaults        0 0
   tmpfs                   /dev/shm                tmpfs   size=8g        0 0        -------修改这行内容将defaults改为需要扩展的大小size=8g 即可
   
   devpts                  /dev/pts                devpts  gid=5,mode=620  0 0
   sysfs                   /sys                    sysfs   defaults        0 0
   proc                    /proc                   proc    defaults        0 0

备注官方文档解释:

         If the value of max_target is set to a value greater than the allocation for the /dev/shm size, then you may encounter the error ORA-00845: MEMORY_TARGET not supported on this system.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/20674423/viewspace-1696733/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/20674423/viewspace-1696733/