11g error ORA-27102: outofmemoryLinuxError: 22: Invalidarg

Source: Internet
Author: User
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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.