解决ORA-27154,ORA-27300,ORA-27301:No space left on device
来源:互联网 发布:360浏览器怎么调试js 编辑:程序博客网 时间:2024/05/17 08:27
利用DBCA创建数据库,重启数据库,都可能会出现此类错误,主要原因可能是数据库实例太多,需要比较多的信号量
ORA-27154: post/wait create failed
ORA-27300: OS system dependent operation:semget failed with status: 28
ORA-27301: OS failure message: No space left on device
ORA-27302: failure occurred at: sskgpcreates
解决的办法就是利用 root 登陆修改 Linux 内核参数
[root@linuxserver ~]# /sbin/sysctl -a | grep sem
kernel.sem = 250 1024 100 128
[root@linuxserver ~]# vi /etc/sysctl.conf
# semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 250 32000 100 128
然后执行命令
/sbin/sysctl -p
下面一段是关于一点关于信号量的系统参数的解释:
The kernel parameter sem consists of 4 tokens, SEMMSL, SEMMNS, SEMOPM and SEMMNI. SEMMNS is the result of SEMMSL multiplied by SEMMNI. The database manager requires that the number of arrays (SEMMNI) be increased as necessary. Typically, SEMMNI should be twice the maximum number of connections allowed (MAXAGENTS) multiplied by the number of logical partitions on the database server computer plus the number of local application connections on the database server computer.
翻译:
系统内核包括四个标记参数,SEMMSL, SEMMNS, SEMOPM 和 SEMMNI. SEMMNS应该是SEMMSL 乘以 SEMMNI的结果. 数据库管理程序需要这一组数据都进行相应的增长. 比如 SEMMNI 应该是 2*(服务器允许最大连接数)* (数据库服务器逻辑分区数)+ (数据库允许最大本地应用连接数)
- 解决ORA-27154,ORA-27300,ORA-27301:No space left on device
- 解决ORA-27154,ORA-27300,ORA-27301:No space left on device
- 解决ORA-27154,ORA-27300,ORA-27301:No space left on device
- 解决ORA-27154,ORA-27300,ORA-27301:No space left on device
- 磁盘空间满导致oracle不能正常使用:错误关键字ORA-09817 No space left on device
- ORA-27102:out of memory Linux-X86_64 Error: 28: No space left on device
- ORA-09817: Write to audit file failed Linux-x86_64 Error: 28: No space left on device
- dbca ORA-27102: out of memory Linux-x86_64 Error: 28: No space left on device
- ORA-27102: out of memory Linux-x86_64 Error: 28: No space left on device
- ORA-27102: out of memory Linux-x86_64 Error: 28: No space left on device
- 【ORACLE】ORA-27102 out of memory Linux-X86_64 Error 28 No space left on device
- Upon startup of Linux database get ORA-27102: out of memory Linux-X86_64 Error: 28: No space left on device
- ORA-27102: out of memory Linux-X86_64 Error: 28: No space left on device (Doc ID 301830.1)
- No space left on device错误解决
- No space left on device错误解决
- No space left on device错误解决
- No space left on device
- No space left on device
- 获取MP3歌曲信息 歌曲名 歌手名 专辑等
- 转载--多进程和多线程的优缺点
- UNION.LIKE.charindex.case条件
- 16hibernate hibernate学生、课程、分数设计案例
- Android用SharePreference存取信息
- 解决ORA-27154,ORA-27300,ORA-27301:No space left on device
- vim配置
- domain socket详解
- 开源备份软件bacula安装记录--含备份-恢复演练
- PL/SQL导出JOB创建语句
- DataUml Design 教程7 - 数据库生成模型
- 第23条:请不要在新代码中使用原生态类型
- Android学习笔记(二八):字体
- python开发新浪博客爬虫