Problem:
When creating a new Oracle 9i database using dbca (Database Configuration Assistant), the following error appears when the database is being created (at the ‘Creating and starting Oracle instance (46 %)’ step).
ORA-00600: internal error code, arguments: [OSDEP_INTERNAL], [], [], [], [], [], [], [] ORA-27302: failure occurred at: skgpwreset1 ORA-27303: additional information: invalid shared ctx ORA-27146: post/wait initialization 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
Solution:
Change the semaphore settings.
Running ‘df -h’ showed that the system had enough free hard drive space, so the ‘ORA-27301: OS failure message: No space left of device’ message was misleading.
The /etc/sysctl.conf file had the following settings:
kernel.sem = 100 256 100 100
As the root user, edit the /etc/sysctl.conf and change the above line to:
kernel.sem = 256 32768 100 228
After changing the sysctl.conf , run the following command as root user to enable the new settings:
sysctl -p
Reference:
Ora-00600: Internal Error Code, Arguments: [Osdep_internal] [ID 304027.1]
ORA-600/ORA-7445 Error Look-up Tool [ID 153788.1]
0 Comments.