dbca，dbca建立資料庫

dbca，dbca建立資料庫
錯誤資訊:

[oracle@db01 ~]$ dbca -silent -responsefile dbca.rsp Copying database files1% complete2% complete4% complete12% complete100% completeLook at the log file "/DBSoft/oracle/cfgtoollogs/dbca/woo/woo.log" for further details.[oracle@db01 ~]$ cat /DBSoft/oracle/cfgtoollogs/dbca/woo/woo.logSGA 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 filesDBCA_PROGRESS : 1%DBCA_PROGRESS : 2%ORA-27102: out of memoryDBCA_PROGRESS : 4%ORA-01034: ORACLE not availableDBCA_PROGRESS : 12%ORA-01034: ORACLE not availableDBCA_PROGRESS : 100%

檢查alert警示日誌：

[oracle@db01 ~]$ cat $ORACLE_BASE/diag/rdbms/woo/woo/trace/alert_woo.log Thu Jun 11 22:46:03 2015Starting ORACLE instance (normal)WARNING: The system does not seem to be configuredoptimally. Creating a segment of size 0x0000000000800000failed. Please change the shm parameters so thata segment can be created for this size. While this isnot a fatal issue, creating one segment may improveperformance

問題分析:    從上面的警告日誌中的一個警示資訊告訴我們這個系統在啟動的時候需要建立一個大小為0x0000000000800000 size的segment失敗，雖然不是一個致命的問題，但是同時告訴我們去修改shm參數可以提高效能。


問題處理：        既然問題已經弄清楚了，那麼下一步我們解決該問題就很簡單了，擴大/de/shm 的值


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

[oracle@db01 ~]$ df -hFilesystem            Size  Used Avail Use% Mounted on/dev/mapper/vg_db01-lv_root                       35G  8.7G   25G  27% /tmpfs                 947M     0  947M   0% /dev/shm/dev/sda1             485M   35M  425M   8% /boot

2、手動擴大tmpfs的大小

[root@db01 ~]# mount tmpfs /dev/shm -t tmpfs -o size=8g[root@db01 ~]# df -hFilesystem            Size  Used Avail Use% Mounted on/dev/mapper/vg_db01-lv_root                       35G  8.7G   25G  27% /tmpfs                 8.0G     0  8.0G   0% /dev/shm/dev/sda1             485M   35M  425M   8% /boottmpfs                 8.0G     0  8.0G   0% /dev/shm

3、重新執行安裝

[oracle@db01 ~]$ dbca -silent -responsefile dbca.rsp Cleaning up failed steps5% completeCopying database files7% complete9% complete16% complete23% complete30% complete41% completeCreating and starting Oracle instance43% complete48% complete53% complete57% complete58% complete59% complete62% complete64% completeCompleting Database Creation68% complete71% complete75% complete85% complete96% complete100% completeLook 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.rspOracle 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檔案中

[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 1UUID=9ba8ae31-c918-4ad0-8408-e9e0a7d0beb4 /boot                   ext4    defaults        1 2/dev/mapper/vg_db01-lv_swap swap                    swap    defaults        0 0tmpfs                   /dev/shm                tmpfs   size=8g        0 0-------修改這行內容將defaults改為需要擴充的大小size=8g 即可devpts                  /dev/pts                devpts  gid=5,mode=620  0 0sysfs                   /sys                    sysfs   defaults        0 0proc                    /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.