Re: Oracle 9i Installation problem on Solaris 8 - Wrong Kernel Parameters?

On 14 Mar 2002 02:54:53 -0800, mk_at_smartlingua.com (Mark Kessler) wrote:

>Hello,
>I tried to install the Oracle 9i Database on a Sun Solaris SPARC
>machine and ran into a problem with creating databses.
>
>The installation went fine without any errors. But when the Oracle
>Databse Configuration Assistant was started, it stopped with an error
>while trying to create and start the oracle instance. When clicking on
>'Ignore', it continues with more errors. The error messages:
>
>ORA-2730: failure occured at: skgpwreset1
>
>ORA-27303: additional information: invalid 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 occured at sskgpcreates
>
>ORA-01304: ORACLE not available
>
>..and so on..
>
>There is enough space on the mount point of the oracle database, I
>added the following lines to /etc/system:
>
>set shmsys:shminfo_shmmax=4924967295
>set shmsys:shminfo_shmmin=1
>set shmsys:shminfo_shmmni=100
>set shmsys:shminfo_shmseg=10
>set semsys:seminfo_semmni=400
>set semsys:seminfo_semmsl=100
>set semsys:seminfo_semmns=200
>set semsys:seminfo_semopm=100
>set semsys:seminfo_semvmx=32767
>
>I would be deeply grateful if anyone can help me with this.
>
>BTW, the same errors occured when I started dbca manually, also after
>a reboot of the machine.
>
>Mark Kessler

27164 is usually caused by a too high processes parameter in init<sid>.ora
semmns must be 2 * processes + 10
either reduce the number of processes or increase semmns

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Mar 14 2002 - 05:11:02 CST