Ora-27300, Ora-27300, Ora-27302

Ora-27300, Ora-27300, Ora-27302

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:sskgpsemsper

 

[root@pri ~]# ipcs -ls

------ Semaphore Limits --------

max number of arrays = 128

max semaphores per array = 250

max semaphores system wide = 32000

max ops per semop call = 100

semaphore max value = 32767

修改sem

[root@pri ~]# cat /proc/sys/kernel/sem

250     100     32      128

修改后

[root@pri ~]# cat /proc/sys/kernel/sem

250     32000   100     128

 

重新执行dbca，建库完成

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22779291/viewspace-751205/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22779291/viewspace-751205/