数据库无法启动 ORA-27154,27300,27301,27302
来源:互联网 发布:java长字符串 编辑:程序博客网 时间:2024/06/06 00:53
数据库版本
SQL> select * from v$version
2 ;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
启动错误
Connected to an idle instance.
SQL> startup
ORA-27154: post/wait create failed
ORA-27300: OS system dependent operation:semget failedwith status: 28
ORA-27301: OS failure message: No space left on device
ORA-27302: failure occurred at: sskgpsemsper
解决办法:
[oracle@shadow ~]$ vim /proc/sys/kernel/sem
[oracle@shadow ~]$ su - root
Password:
[root@shadow ~]# echo "110 10000 100 128">/proc/sys/kernel/sem
[root@shadow ~]# exit
logout
问题是否解决
SQL> select status from v$instance;
STATUS
------------
OPEN
说明:
[oracle@shadow ~]$ cat /proc/sys/kernel/sem
110 10000 100 128
以上4个数据分别对应
SEMMSL SEMMNS SEMOPM SEMMNI
SEMMSL 100 Defines the minimum recommended value,
for initial installation only
SEMMNS 256 Defines the maximum semaphores on thesystem.
This setting is a minimum recommended value,
for initial installation only. The SEMMNS parameter
should be set to the sum of the PROCESSES parameter
for each Oracle database, adding the largest onetwice,
and then adding an additional 10 for each database.
SEMOPM 100 Defines the maximum number of operationsfor each semop call
SEMMNI 100 Defines the maximum number ofsemaphore sets in the entire system
- 数据库无法启动 ORA-27154,27300,27301,27302
- 数据库启动报ORA-27154 ORA-27300 ORA-27301 ORA-27302错误
- 数据库启动报错ORA-27154,27300,27301,27302
- 数据库无法启动 ORA-1033
- 因信号量问题导致ORA-27154无法启动数据库
- 在启动DB时报错ORA-27154 ORA-27300 ORA-27301 ORA-27302
- oracle启动的时候报 ORA-27154、ORA-27300、ORA-27301、ORA-27302
- oracle启动的时候报 ORA-27154、ORA-27300、ORA-27301、ORA-27302
- ORA-01171 掉电引起数据库无法启动
- ORA-01109:数据库无法启动问题
- ORA-01109:数据库无法启动问题
- ORA-03113数据库无法正常启动
- 数据库异常关闭后无法启动问题处理(ORA-01102)
- SPFILE 错误导致数据库无法启动(ORA-01565)
- SPFILE 错误导致数据库无法启动(ORA-01565)
- oracle非法关机数据库无法启动ORA-00600: [kcratr1_lostwrt],解决办法
- SPFILE 错误导致数据库无法启动(ORA-01565)
- SPFILE 错误导致数据库无法启动(ORA-01565)
- android ViewPager 实现点击小圆点切换页面 案例
- Android下Affinities和Task!!!!!!!!!!!!
- 气泡状path
- C语言中一种更优雅的异常处理机制
- sicp习题2.1
- 数据库无法启动 ORA-27154,27300,27301,27302
- 关于file_operations结构体
- Flash2Cocos2d-x
- 构造方法
- oauth认证介绍 android在调用第三方开放平台时经常要用到
- lucene的基本用法
- 瀑布流加载数据
- UIView设置阴影
- 如何过滤 adb logcat 输出