oracle10g 创建数据库时报ORA-27102: out of memory
&&& solaris 9 安装 oracle 10g 创建数据库时报 ORA-27102: out of memory ，通过sysdef | grep SEM ，sysdef | grep SHM 发现通过 /etc/system设置的相关参数没有起作用，后经多方查找终不能找出解决方案，于是请教在存储方面有多年工作经验的同事帮助排查原因。高手就是高手，呵呵，经过一段时间的查找最终查到了原因所在，原因是，在创建数据库之前做过sds raid 1，为测试raid 1是否做成功，测试时通过热插硬盘进行测试，结果导致了硬盘不同步，因此系统启动后所做的更改不能生效。后进行了硬盘同步，reboot后一切正常。
请各位遵纪守法并注意语言文明zui019 的BLOG
用户名：zui019
文章数：67
访问量：57232
注册日期：
阅读量：5863
阅读量：12276
阅读量：394935
阅读量：1085811
51CTO推荐博文
&今天做压力测试的时候，修改数据参数出现ORA-27102: out of memory错误，最后发现是系统参数设置的问题，限制了oracle的sga大小
修改系统参数前，一定要备份参数文件，
create spfile from pfile='/opt/oracle/product/11.1/db_1/dbs/initorcl.ora';
-------&查看sga的大小
SQL& show parameter sga
NAME&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& TYPE&&&&&&& VALUE
------------------------------------ ----------- ------------------------------
lock_sga&&&&&&&&&&&&&&&&&&&&&&&&&&&& boolean&&&& FALSE
pre_page_sga&&&&&&&&&&&&&&&&&&&&&&&& boolean&&&& FALSE
sga_max_size&&&&&&&&&&&&&&&&&&&&&&&& big integer 1552M
sga_target&&&&&&&&&&&&&&&&&&&&&&&&&& big integer 1536M
修改sga_max_size
alter system set sga_max_size=10240M scope=
重新启动数据库
SQL& startup force
ORA-27102: out of memory
Linux-x86_64 Error: 28: No space left on device
出现ORA-27102错误，这是我们可以使用备分的参数文件启动数据库；
startup pfile='/opt/oracle/product/11.1/db_1/dbs/initorcl.ora';
问题到这里，虽然库可以启动，但参数还是没有改。
这是我们可以修改一下系统参数/etc/sysctl.conf文件中的kernel.shmall参数
-------------------------------------------------------------------------------
fs.file-max = 6553600
kernel.shmall=2097152
kernel.shmmax=
kernel.shmmni=4096
-------------------------------------------------------------------------------
--------------------------------------------------------------------------------
fs.file-max = 6553600
kernel.shmall = 4194304
kernel.shmmax =
kernel.shmmni = 4096
---------------------------------------------------------------------------------
修改完这些参数后，我们就可以正常启动了
先创建spfile，然后我们以spfile启动
File created.
SQL& startup force
ORACLE instance started.
Total System Global Area
Fixed Size&&&&&&&&&&&&&&&&& 2144824 bytes
Variable Size&&&&&&&&&&&&
Database Buffers&&&&&&&&&
Redo Buffers&&&&&&&&&&&&&&
Database mounted.
Database opened.
我们再次修改
alter system set sga_max_size=10240M scope=
orcl&force
ORACLE instance started.
Total System Global Area 1.0689E+10 bytes
Fixed Size&&&&&&&&&&&&&&&&& 2147392 bytes
Variable Size&&&&&&&&&&&
Database Buffers&&&&&&&&
Redo Buffers&&&&&&&&&&&&&&
Database mounted.
Database opened.
问题成功解决
原因分析：linux系统默认的共享共存为系统内存的&一半，也就算是说即使系统没有其他任何程序占用系统共享内存，oracle做能使用的内存也不可能个超过2G，这里我们修改了限制共享内存的参数文件，扩大了系统的共享内存，从而使数据库能正常启动。同时也希望大家如非必要，尽量不要修改这个参数，因为你一旦扩大了共享内存，那么就有可能出现应用程序和操作系统争抢内存的状况，试想数据库所依托的操作系统出了问题，你的数据库还能正常么！
了这篇文章
类别：未分类┆阅读(0)┆评论(0)dbca-silent-responsefile建库由于tmpfs太小报错ORA-27102:outofmemory
[oracle@db01 ~]$ dbca -silent -responsefile dbca.rsp
Copying database files
1% complete
2% complete
4% complete
12% complete
100% complete
Look at the log file &/DBSoft/oracle/cfgtoollogs/dbca/woo/woo.log& for further details.
[oracle@db01 ~]$ cat /DBSoft/oracle/cfgtoollogs/dbca/woo/woo.log
SGA size can not be greater than maximum shared memory segment size (0). Refer to
installation guide to configure your operating system kernel parameters.
Copying database files
DBCA_PROGRESS : 1%
DBCA_PROGRESS : 2%
ORA-27102: out of memory
DBCA_PROGRESS : 4%
ORA-01034: ORACLE not available
DBCA_PROGRESS : 12%
ORA-01034: ORACLE not available
DBCA_PROGRESS : 100%
检查alert告警日志：
[oracle@db01 ~]$ cat $ORACLE_BASE/diag/rdbms/woo/woo/trace/alert_woo.log
Thu Jun 11 22:46:03 2015
Starting ORACLE instance (normal)
WARNING: The system does not seem to be configured
optimally. Creating a segment of size 0x0000
failed. Please change the shm parameters so that
a segment can be created for this size. While this is
not a fatal issue, creating one segment may improve
performance
从上面的警告日志中的一个告警信息告诉我们这个在启动的时候需要创建一个大小为0x0000 size的segment失败，虽然不是一个致命的问题，但是同时告诉我们去修改shm参数可以提高性能。
问题处理：
既然问题已经弄清楚了，那么下一步我们解决该问题就很简单了，扩大/de/shm 的值
1、首先查看下大小是多少:
[oracle@db01 ~]$ df -h
Filesystem
Used Avail Use% Mounted on
/dev/mapper/vg_db01-lv_root
0% /dev/shm
2、手动扩大tmpfs的大小
[root@db01 ~]# mount tmpfs /dev/shm -t tmpfs -o size=8g
[root@db01 ~]# df -h
Filesystem
Used Avail Use% Mounted on
/dev/mapper/vg_db01-lv_root
0% /dev/shm
0% /dev/shm
3、重新执行安装
[oracle@db01 ~]$ dbca -silent -responsefile dbca.rsp
Cleaning up failed steps
5% complete
Copying database files
7% complete
9% complete
16% complete
23% complete
30% complete
41% complete
Creating and starting Oracle instance
43% complete
48% complete
53% complete
57% complete
58% complete
59% complete
62% complete
64% complete
Completing Database Creation
68% complete
71% complete
75% complete
85% complete
96% complete
100% complete
Look at the log file &/DBSoft/oracle/cfgtoollogs/dbca/woo/woo7.log& for further details.
[oracle@db01 ~]$
[oracle@db01 ~]$ netca /silent /responsefile netca.rsp
Parsing command line arguments:
Parameter &silent& = true
Parameter &responsefile& = netca.rsp
Oracle Net Configuration Assistant could not find the Response File at the given location.
Oracle Net Services configuration failed.
The exit code is 1
4、完成之后将tmpfs最终的大小永久写入到/etc/fstab文件中
[oracle@db01 ~]$ cat /etc/fstab
# /etc/fstab
# Created by anaconda on Tue Jun
9 19:17:12 2015
# Accessible filesystems, by reference, are maintained under '/dev/disk'
# See man pages fstab(5), findfs(8), mount(8) and/or blkid(8) for more info
/dev/mapper/vg_db01-lv_root /
UUID=9ba8ae31-c918-4ad0-a7d0beb4 /boot
/dev/mapper/vg_db01-lv_swap swap
-------修改这行内容将defaults改为需要扩展的大小size=8g 即可
gid=5,mode=620
(window.slotbydup=window.slotbydup || []).push({
id: '2467140',
container: s,
size: '1000,90',
display: 'inlay-fix'
(window.slotbydup=window.slotbydup || []).push({
id: '2467141',
container: s,
size: '1000,90',
display: 'inlay-fix'
(window.slotbydup=window.slotbydup || []).push({
id: '2467142',
container: s,
size: '1000,90',
display: 'inlay-fix'
(window.slotbydup=window.slotbydup || []).push({
id: '2467143',
container: s,
size: '1000,90',
display: 'inlay-fix'
(window.slotbydup=window.slotbydup || []).push({
id: '2467148',
container: s,
size: '1000,90',
display: 'inlay-fix'博客访问： 3977962
博文数量： 848
注册时间：
认证徽章：
了解并联系warehouse:
http://blog.itpub.net/19602/viewspace-1059211/
ITPUB论坛APP
ITPUB论坛APP
APP发帖 享双倍积分
IT168企业级官微
微信号：IT168qiye
系统架构师大会
微信号：SACC2013
分类： Oracle
SQL> startupORA-27102: out of memoryOSD-00025: additional error informationO/S-Error:
(OS 1453) Insufficient quota to complete the requested serviceoracle的解释是触发了oracle的bug[@more@]metalink上解释：ORA-27102 OSD-00025 O/S-Error: (OS 1453) When Lock_sga is Set to True [ID ]
出现这个错误之后需要把windows服务中的oracle服务停止然后重新启动一下之后才能启动oracle，但是使用一段时侯之后没有规律的再次出现ORA-27102，查了一下发现时由于LOCK_SGA is set to TRUE的缘故。SQL> show parameter sgaORA-01034: ORACLE not availableSQL> startupORA-03113: end-of-file on communication channelSQL> exitDisconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, OLAP and Data Mining optionsC:>sqlplus / as sysdbaSQL*Plus: Release 10.2.0.1.0 - Production on Tue Jul 17 19:27:37 2012Copyright (c) , Oracle.
All rights reserved.Connected to an idle instance.SQL> startupORACLE instance started.Total System Global Area
bytesFixed Size
1248116 bytesVariable Size
bytesDatabase Buffers
bytesRedo Buffers
7139328 bytesDatabase mounted.Database opened.SQL> show parameter sgaNAME
VALUE------------------------------------ ----------- ------------------------------lock_sga
TRUEpre_page_sga
FALSEsga_max_size
big integer 200Msga_target
big integer 200MSQL> alter system set lock_sga=alter system set lock_sga=false
*ERROR at line 1:ORA-02095: specified initialization parameter cannot be modifiedSQL> alter system set lock_sga=false scope=System altered.SQL> shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.SQL> startupORACLE instance started.Total System Global Area
bytesFixed Size
1248116 bytesVariable Size
bytesDatabase Buffers
bytesRedo Buffers
7139328 bytesDatabase mounted.Database opened.SQL> show parameter sgaNAME
VALUE------------------------------------ ----------- ------------------------------lock_sga
FALSEpre_page_sga
FALSEsga_max_size
big integer 200Msga_target
big integer 200MSQL>
阅读(5536) | 评论(0) | 转发(0) |
相关热门文章
给主人留下些什么吧！~~
请登录后评论。}