错误信息:[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 -hFilesystemSize Used Avail Use% Mounted on/dev/mapper/vg_db01-lv_root35G 8.7G 25G 27% /tmpfs947M0 947M 0% /dev/shm/dev/sda1485M 35M 425M 8% /boot2、手动扩大tmpfs的大小[root@db01 ~]# mount tmpfs /dev/shm -t tmpfs -o size=8g[root@db01 ~]# df -hFilesystemSize Used Avail Use% Mounted on/dev/mapper/vg_db01-lv_root35G 8.7G 25G 27% /tmpfs8.0G0 8.0G 0% /dev/shm/dev/sda1485M 35M 425M 8% /boottmpfs8.0G0 8.0G 0% /dev/shm3、重新执行安装[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" = trueParameter "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 14、完成之后将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 defaults1 1UUID=9ba8ae31-c918-4ad0-8408-e9e0a7d0beb4 /bootext4 defaults1 2/dev/mapper/vg_db01-lv_swap swapswap defaults0 0tmpfs/dev/shmtmpfs size=8g0 0——-修改这行内容将defaults改为需要扩展的大小size=8g 即可devpts/dev/ptsdevpts gid=5,mode=620 0 0sysfs/syssysfs defaults0 0proc/procproc defaults0 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.
，辽远或偏僻的地方，而会常常想起这一次的旅行，想起那座山，那个城，那些人……
