数据库版本
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