Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Error while creating the database

prakasse
Advisor

Error while creating the database

Hi,

We installed Oracle 10gR2 and the patch 2.0.4.
on HP-UX 11.31 Integrity server.

While creating the database We are getting below error. It seems like Kernel parameter need to be set. Kindly request your help.


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

Thanks,
Senthil.


6 REPLIES
mobidyc
Trusted Contributor

Re: Error while creating the database

Hello,

take a look at this thread

http://forums13.itrc.hp.com/service/forums/questionanswer.do?admit=109447627+1243323447503+28353475&threadId=621483

Regards,
Cedrick Gaillard
Best regards, Cedrick Gaillard
Jozef_Novak
Respected Contributor

Re: Error while creating the database

Hello,

looks like the disk where your datafiles should reside has no space left. Check which one it is and provide more space for your database.

J.
Hein van den Heuvel
Honored Contributor

Re: Error while creating the database

Jozep, please help me understand why this would be a disk space problem. Hint: Try a google for +semget +"No space left on device"

Senthil,

Please review the installation requirements document used. Was it up to date (metadata). Were all requirements met, notably around semaphores (SEMxxx). Are there other significant system resources used that should have been taken into account.

Check with ipcs -s
If need be reboot or clean with ipcrm -s

hth,
Hein.

Jozef_Novak
Respected Contributor

Re: Error while creating the database

Hello Hein,

I noticed the OS error message, so I thought it could give a hint:

ORA-27301: OS failure message: No space left on device

J.
Suraj K Sankari
Honored Contributor

Re: Error while creating the database

Hi,

>>ORA-27301: OS failure message: No space left on device

Check your /tmp or /opt file system as well as location of your database file.

No space left on device : this means no free space lert on device, file system is getting fulled while installing.

Suraj
Jozef_Novak
Respected Contributor

Re: Error while creating the database

Suraj,

that's not really true, the system has actually run out of semaphores (see Hein's post).

I will not comment the accuracy of the OS error message.

Jozef