Shulou(Shulou.com)05/31 Report--

This article mainly introduces "how to solve the problem of starting Oracle error ORA-27102". In daily operation, I believe many people have doubts about how to solve the problem of starting Oracle error ORA-27102. The editor consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful for you to answer the doubt of "how to solve the problem of starting Oracle error ORA-27102". Next, please follow the editor to study!

SQL > startup pfile='/u01/oracle/product/11gr2/db_home/dbs/initerp.ora'

ORA-27102: out of memory

Linux-x86_64 Error: 28: No space left on device

# reason for reporting error

# looking at the kernel parameter configuration file, it is found that the kernel parameter about memory has been modified to a very small value, which is much lower than the value set by the memory parameters of database SGA and PGA, which causes the database to fail to start.

$cat sysctl.conf

# Controls the maximum shared segment size, in bytes

Kernel.shmmax = 68719476736

# Controls the maximum number of shared memory segments, in pages

Kernel.shmall = 4294967296

Fs.aio-max-nr = 1048576

Fs.file-max = 6815744

Kernel.shmmax = 536870912

Net.ipv4.ip_local_port_range = 9000 65500

Kernel.shmall = 2097152

Kernel.shmmax = 2147483648

# solution

# comment out the wrong parameters and refresh the kernel parameters

[root@erp2] # sysctl-p

Net.ipv4.ip_forward = 0

Net.ipv4.conf.default.rp_filter = 1

Net.ipv4.conf.default.accept_source_route = 0

Kernel.sysrq = 0

Kernel.core_uses_pid = 1

Net.ipv4.tcp_syncookies = 1

Kernel.msgmnb = 65536

Kernel.msgmax = 65536

Kernel.shmmax = 68719476736

Kernel.shmall = 4294967296

Fs.aio-max-nr = 1048576

Fs.file-max = 6815744

Net.ipv4.ip_local_port_range = 9000 65500

Kernel.shmmni = 4096

Kernel.sem = 250 32000 100 128

Net.core.rmem_default = 262144

Net.core.rmem_max = 4194304

Net.core.wmem_default = 262144

Net.core.wmem_max = 1048576

SQL > startup pfile='/u01/oracle/product/11gr2/db_home/dbs/initerp.ora'

ORACLE instance started.

Total System Global Area 1.0689E+10 bytes

Fixed Size 2216344 bytes

Variable Size 1946160744 bytes

Database Buffers 8724152320 bytes

Redo Buffers 16945152 bytes

Database mounted.

Database opened.

SQL > shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

At this point, the study on "how to solve the problem of starting Oracle error ORA-27102" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.