错误信息:
[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告警日志:
[oracle@db01 ~]$ cat $ORACLE_BASE/diag/rdbms/woo/woo/trace/alert_woo.log Thu Jun 11 22:46:03 2015 Starting ORACLE instance (normal) WARNING: The system does not seem to be configured optimally. Creating a segment of size 0x0000000000800000 failed. Please change the shm parameters so that a segment can be created for this size. While this is not a fatal issue, creating one segment may improve performance
问题分析:
从上面的警告日志中的一个告警信息告诉我们这个系统在启动的时候需要创建一个大小为0x0000000000800000 size的segment失败,虽然不是一个致命的问题,但是同时告诉我们去修改shm参数可以提高性能。
问题处理:
既然问题已经弄清楚了,那么下一步我们解决该问题就很简单了,扩大/de/shm 的值
1、首先查看下大小是多少:
[oracle@db01 ~]$ df -h Filesystem 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 -h Filesystem 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% /boot tmpfs 8.0G 0 8.0G 0% /dev/shm
3、重新执行安装
[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文件中
[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.
时间: 2024-09-12 12:39:37