Dbca-silent-responsefile built library due to tmpfs too tabloid wrong ora-27102:out of memory

error message:

[Email protected] ~]$ dbca-silent-responsefile dbca.rsp Copying database files1% complete2% complete4% complete12% Comp lete100% Completelook at the log file '/dbsoft/oracle/cfgtoollogs/dbca/woo/woo.log ' for further details. [[email protected] ~]$ CAT/DBSOFT/ORACLE/CFGTOOLLOGS/DBCA/WOO/WOO.LOGSGA size can not be greater than maximum shared memo RY 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 Alert alarm log:

[email protected] ~]$ cat $ORACLE _base/diag/rdbms/woo/woo/trace/alert_woo.log Thu June 22:46:03 2015Starting ORACLE in Stance (normal) warning:the system does not seem to be configuredoptimally. Creating a segment of size 0x0000000000800000failed. The change of the SHM parameters so Thata segment can is created for this size. While this isnot a fatal issue, creating one segment May Improveperformance

Problem analysis: An alert from the warning log above tells us that the system needs to create a 0x0000000000800000 size segment failure at boot time, although not a fatal problem, But it also tells us to modify the SHM parameter to improve performance.


Problem-solving: Now that the problem is clear, the next step is to solve the problem in a simple, expanded/DE/SHM value


1, first look at the size is how much:

[Email protected] ~]$ 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 expand the size of the TMPFS

[[email protected] ~]# Mount Tmpfs/dev/shm-t tmpfs-o size=8g[[email protected] ~]# 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-execute the installation

[Email protected] ~]$ dbca-silent-responsefile DBCA.RSP cleaning up failed steps5% completecopying database files7% com plete9% complete16% complete23% complete30% complete41% completecreating and starting Oracle instance43% complete48% Comp lete53% 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. [[Email protected] ~]$ [[email protected] ~]$ netca/silent/responsefile NETCA.RSP parsing command line arguments:    Pa Rameter "Silent" = True    Parameter "responsefile" = netca.rsporacle Net Configuration Assistant could not find the RESP Onse File at the given location. Oracle Net Services configuration failed.  The exit code is 1

4. After completion, the final size of the TMPFS is permanently written to the/etc/fstab file.

[Email protected] ~]$ Cat/etc/fstab #/etc/fstab# Created by Anaconda on Tue June  9 19:17:12 2015## Accessible files Ystems, by reference, is maintained under '/dev/disk ' # See mans Pages Fstab (5), Findfs (8), mount (8) and/or Blkid (8) for MO Re 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-------Modify this line to change the defaults to the size that you want to expand size=8g to Devpts  /dev/pts devpts gid=5,mode=620  0 0sysfs                   /sys                    sysfs   defaults        0 0proc                    /proc    proc Defaults        0 0

Note Official documentation explains:If The value of Max_target is set to a value greater than the allocation for THE/DEV/SHM size Encounter the error Ora-00845:memory_target not supported on this system.

Dbca-silent-responsefile built library due to tmpfs too tabloid wrong ora-27102:out of memory