11g 报错 ORA-27102： out of memory

背景:

阅读新闻

11g 报错 ORA-27102: out of memory Linux Error: 22: Invalid argument

[日期:2012-11-23]

来源:Linux社区

作者:njyxfw

[字体:大 中 小]

没事装了个11g玩,安装软件dbca建库使用一切正常。今天启动发现报错

[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, 2009, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup

ORA-27102: out of memory

Linux Error: 22: Invalid argument

处理流程如下:

1、查看数据库内存大小

[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盈/CC"6Porcl.__db_cache_size=205520896

orcl.__java_pool_size=4194304

orcl.__large_pool_siz九度快排系统 https://www.190seo.come=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

*.processes=150

*.remote_login_passwordfile='EXCLUSIVE'

*.undo_tablespace='UNDOTBS1'

2、切换到root用户,查看内核内存大小

[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

12下一页

Oracle EBS DBA常用SQL - 安装/补丁

使用crs_setperm修改RAC资源的所有者及权限

相关资讯

Oracle错误代码 ORA-27102

Oracle启动报错ORA-27102解决 (09/02/2015 19:30:40)

在Windows上调整SGA大小遭遇ORA- (10/29/2014 19:19:35)

ORA-27102: out of memory报错的处 (08/09/2014 13:47:46)

Oracle错误代码大全 (02/16/2015 21:31:57)

ORA-27102: out of memory (09/27/2014 06:36:21)

ORA-27102:out of memory Linux- (06/14/2014 20:40:53)

本文评论

查看全部评论 (0)

表情:

姓名:

匿名

字数

同意评论声明

评论声明

尊重网上道德,遵守中华人民共和国的各项有关法律法规

承担一切因您的行为而直接或间接导致的民事或刑事法律责任

本站管理人员有权保留或删除其管辖留言中的任意内容

本站有权在网站内转载或引用您的评论

参与本评论即表明您已经阅读并接受上述条款

最新资讯

XtraBackup备份与恢复实践

MySQL 5.6.25 修改字符集

XtraBackup全备与增量备份

Oracle BBED 修改数据内容

GitHub为MySQL社区贡献了新的在线更改表定

MySQL/MariaDB数据库备份与恢复之mysqlpump

MySQL备份之mydumper入门学习

Oracle官方并行逻辑备份工具mysqlpump

MySQL 5.7 mysqlpump 备份工具说明

MySQL5.7.11 mysqlpump 多线程逻辑备份工具