Re: and one more: dbca hangs at 50% (Solaris 8 + Oracle 9i)

frank_ratzlow_at_hotmail.com (Frank Ratzlow) wrote in message news:<5ef29569.0205061433.4d98ad08_at_posting.google.com>...
> Hallo NG,
>
> I think to have read any article regarding this well know prob on
> google but it obviously didn't help.
> Problem: I installed the Oracle9i Server. Everything went smooth till
> I got to the point of creating an "General purpose database". At 50%
> the wizard hangs. (Yes, I waited for several hours)
> I changed settings in /etc/system to the ones specified in the Oracle
> Doku. No change. I made further modification and finally I finished
> with getting a load of error message boxes. I quick look in
> bdump/alert_<SID>.log showed the following lines:
> ---------------------------------------
> Tue May 7 00:01:01 2002
> Starting ORACLE instance (normal)
> Tue May 7 00:01:03 2002
> Errors in file /opt/Oracle/admin/paul/udump/paul_ora_501.trc:
> 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

• check /usr/include/sys/errno.h for error #28. It's ENOSPC (No space left on device).
• note the error name (ENOSPC)
• now have a look at semget (man semget): [ENOSPC] A semaphore identifier is to be created, but the system-imposed limit on the maximum number of allowed semaphore identifiers system wide would be exceeded.

So it's nothing to do with disk space. You just don't have enough semaphores to startup the instance. Either increase values in /etc/system (semsys parameters) or decrease 'processes' parameter in init.ora file.

Cheers,
Igor

> ORA-27302: failure occurred at: sskgpcreates
> Tue May 7 00:01:03 2002
> Errors in file /opt/Oracle/admin/paul/udump/paul_ora_501.trc:
> 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: sskgpcreates
> ---------------------------------------
> I checked the amount of available disk space and memory - no prob, a
> plenty was free.
>
> Settings in /etc/system:
> ---------------------------------------
> set shmsys:shminfo_shmmax=4294967296
> set shmsys:shminfo_shmmin=1
> set shmsys:shminfo_shmmni=100
> set shmsys:shminfo_shmseg=10
> set shmsys:shminfo_semmni=400
> set shmsys:shminfo_semmsl=100
> set shmsys:shminfo_semmns=350
> set shmsys:shminfo_semopm=100
> set shmsys:shminfo_semvmx=32767
> ---------------------------------------
>
> Configuration of the machine:
> SUN E250
> 2 CPUs
> 1 GB mem
> 4 x 36 GB SW-based RAID
> about 1.7 GB swap space
> Solaris 8 with latest patches
>
> I would be very very grateful for any advice enabling me to create a
> damn db. I have no idea what exactly went wrong or where to beginn
> troubleshooting. There are lots of requests of the same kind in the
> archive but unfortunately I couldn't find any note stating: change
> this to build up your db.
> Or is Oracle just charging provision from all the therapists out there
> ...?
>
> If you can point me to a page showing how to calculate what values to
> fix this prob I would be very grateful.
>
> TIA
>
> Frank
> frank_ratzlow_at_nojunk.hotmail.com
Received on Thu May 09 2002 - 05:44:37 CDT