启动oracle出现ORA-27102: out of memory错误

最新推荐文章于 2023-01-25 15:04:27 发布

dragon_1989

最新推荐文章于 2023-01-25 15:04:27 发布

阅读量1.8k

点赞数

分类专栏： ORACLE故障诊断文章标签： oracle system sql 360

本文链接：https://blog.csdn.net/dragon_1989/article/details/7575804

版权

ORACLE故障诊断专栏收录该内容

2 篇文章 0 订阅

订阅专栏

问题：
SQL> alter system set lock_sga=true scope=spfile;

System altered.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
SQL> startup
ORA-27102: out of memory
Linux-x86_64 Error: 12: Cannot allocate memory

解决方法：
修改memlock限制。

[root@localhost ~]# vi /etc/security/limits.conf

在末尾增加
oracle soft memlock unlimited
oracle hard memlock unlimited

[oracle@localhost ~]$ sqlplus /nolog

SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area 236000356 bytes
Fixed Size                   451684 bytes
Variable Size             201326592 bytes
Database Buffers           33554432 bytes
Redo Buffers                 667648 bytes
Database mounted.
Database opened.