Dbca, dbca create database
Error message:
[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%
Check the alert alarm log:
[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
Problem analysis: the alarm information in the preceding warning log tells us that this system needs to create a segment with a size of 0x0000000000800000 at startup, although not a fatal problem, however, it also tells us that modifying the shm parameter can improve the performance.
Problem handling: Now that the problem has been clarified, it is very easy to solve the problem next. Expand the value of/de/shm.
1. First, check the following size:
[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. Manually resize 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. re-install
[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. Permanently write the final size of tmpfs to the/etc/fstab file.
[Oracle @ db01 ~] $ Cat/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 = Latest/boot ext4 defaults 1 2/dev/mapper/vg_db01-lv_swap swap defaults 0 0 tmpfs/dev/shm tmpfs size = 8g 0 ------- modify the content in this line and change ults to the size to be extended. Then devpts/dev/pts devpts gid = 5, mode = 620 0 0 sysfs/sys sysfs defaults 0 0 proc/proc defaults 0 0
Note: 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.