背景:
阅读新闻
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 多线程逻辑备份工具
