Oracle installation Error: SGA size can not be greater than maximum shared memeory segment size

Error when installing the data:

To view operating system parameter settings:

[[email protected] ~]# vi/etc/sysctl.conf # Kernel sysctl configuration file for Red Hat linux## for binary values,  0 is disabled, 1 is enabled.  See Sysctl (8) and# sysctl.conf (5) For more details.# controls IP packet Forwardingnet.ipv4.ip_forward = 0# controls Source Route Verificationnet.ipv4.conf.default.rp_filter = # do not accept source Routingnet.ipv4.conf.default.accept_source  _route = 0# controls the System Request debugging functionality of the KERNELKERNEL.SYSRQ = 0# Controls whether core dumps Would append the PID to the core filename.# useful for debugging multi-threaded applications.kernel.core_uses_pid = # Con Trols the use of TCP syncookiesnet.ipv4.tcp_syncookies = # Disable netfilter on Bridges.net.bridge.bridge-nf-call-ip6tab Les = 0net.bridge.bridge-nf-call-iptables = 0net.bridge.bridge-nf-call-arptables = 0# Controls The default maxmimum size O f a mesage QUEUEKERNEL.MSGMNB = 65536# controls the maximum size of a message, in Byteskernel.msgmax = 65536# controls THe maximum shared segment size, in Bytes#kernel.shmmax = 68719476736<span style= "color: #FF0000;" >kernel.shmmax = 1871947673</span># Controls The maximum number of the shared memory segments, in Pageskernel.shmall = 4294967296fs.aio-max-nr = 1048576fs.file-max = 6815744kernel.shmmni = 4096kernel.sem = 32000 L_port_range = 9000 65500net.core.rmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048576

Seems to be

<span style= "color: #FF0000;" >kernel.shmmax</span>

The limit for this parameter. I also have a database on the same host:

Sql> Show parameter SGA NAME                                 TYPE        VALUE---------------------------------------------------------------- -------------Lock_sga                             boolean     falsepre_page_sga                         boolean     falsesga_max_size                         big Integer 396msga_target                           Big Integer 0

Under the same system, DBCA built the library:

In other words, the SGA for a single database is no more than that limit.

Then another scenario, modify the operating system restrictions:

# Controls The maximum shared segment size, in Byteskernel.shmmax = 68719476736

Of course, don't forget

Sysctl-p

Re-DBCA can be. (If you don't re-DBCA, you will get an error)

Oracle installation Error: SGA size can not be greater than maximum shared memeory segment size