11g error ORA-27102: outofmemoryLinuxError: 22: Invalidargument
11g Error ORA-27102: out of memory Linux Error: 22: Invalid argument
It's okay to install a 11g game, and install the software dbca to create a database. Everything works normally. An error occurred when I started the service today.
[Oracle @ OEL54db11gR2 dbs] $ sqlplus/as sysdba
SQL * Plus: Release 11.2.0.1.0 Production on Thu Nov 22 20:07:45 2012
Copyright (c) 1982,200 9, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORA-27102: out of memory
Linux Error: 22: Invalid argument
The process is as follows:
1. view the database memory size
[Oracle @ OEL54db11gR2 ~] $ Cd/u01/app/oracle/product/11.2.0/db_1/dbs/
[Oracle @ OEL54db11gR2 dbs] $ ls
Hc_DBUA0.dat init. ora orapworcl peshm_orcl_0
Hc_orcl.dat lkORCL peshm_DBUA0_0 spfileorcl. ora
[Oracle @ OEL54db11gR2 dbs] $ cat spfileorcl. ora
C "m profit/CC" 6Porcl. _ db_cache_size = 205520896
Orcl. _ Java _pool_size = 4194304
Orcl. _ large_pool_size = 4194304
Orcl. _ oracle_base = '/u01/app/oracle' # ORACLE_BASE set from environment
Orcl. _ pga_aggregate_target = 218103808
Orcl. _ sga_target = 322961408
Orcl. _ shared_io_pool_size = 0
Orcl. _ shared_pool_size = 100663296
Orcl. _ streams_pool_size = 0
*. Audit_file_dest = '/u01/app/oracle/admin/orcl/adump'
*. Audit_trail = 'db'
*. Compatible = '11. 2.0.0.0'
*. Control_files = '/u01/app/oracle/oradata/orcl/control01.ctl', '/u01/app/oCC "/racle/oradata/orcl/control02.ctl'
*. Db_block_size = 8192
*. Db_domain =''
*. Db_name = 'orcl'
*. Diagnostic_dest = '/u01/app/oracle'
*. Dispatchers = '(PROTOCOL = TCP) (SERVICE = orclXDB )'
*. Memory_target = 541065216
*. Open_cursors = 300
*. Processses = 150
*. Remote_login_passwordfile = 'clusive'
*. Undo_tablespace = 'undotbs1'
2. Switch to the root user and check the kernel memory size.
[Oracle @ OEL54db11gR2 ~] $ Su-
Password:
[Root @ OEL54db11gR2 ~] # Vi/etc/sysctl. conf
# Kernel sysctl configuration file for Oracle Enterprise Linux
#
# For binary values, 0 is disabled, 1 is enabled. See sysctl (8) and
# Sysctl. conf (5) for more details.
# Controls IP packet forwarding
Net. ipv4.ip _ forward = 0
# Controls source route verification
Net. ipv4.conf. default. rp_filter = 2
# Do not accept source routing
Net. ipv4.conf. default. accept_source_route = 0
# Controls the System Request debugging functionality of the kernel
Kernel. sysrq = 0
# Controls whether core dumps will append the PID to the core filename
# Useful for debugging multi-threaded applications
Kernel. core_uses_pid = 1
# Controls the use of TCP syncookies
Net. ipv4.tcp _ syncookies = 1
# Controls the maximum size of a message, in bytes
Kernel. msgmnb = 65536
# Controls the default maxmimum size of a mesage queue
Kernel. msgmax = 65536
# Controls the maximum shared segment size, in bytes
Kernel. shmmax = 68719476736
# Controls the maximum number of shared memory segments, in pages
Kernel. shmall = 322961408
Kernel. shmmni = 4096
Kernel. sem = 250 32000 100 128
Fs. file-max = 6815744
Net. ipv4.ip _ local_port_range = 9000 65500
Net. core. rmem_default = 4194304
Net. core. rmem_max = 4194304
Net. core. wmem_default = 1048576
"/Etc/sysctl. conf" 44L, 1265C written