dbca -silent -responsefile 建庫由於tmpfs太小報錯ORA-27102: out of memory

wuweilong發表於2015-06-12

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


  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/，如需轉載，請註明出處，否則將追究法律責任。

相關文章