Re: install problem,8.1.7 on solaris8_x86

From: Trifon Anguelov <trifona_at_pacbell.net>
Date: Mon, 11 Feb 2002 05:51:20 GMT
Message-ID: <sZI98.567$kn3.506751094@newssvr13.news.prodigy.com>

Mark,

Check your PROCESSES parameter setting in init${ORACLE_SID}.ora file.

From your logs: set shmsys:shminfo_semmns=200, looks like that if PROCESSES is setup more than 95 (semmns = (2*largest_processes_parameter)+10) you will get ORA-03113: end-of-file on communication channel.

You can change set shmsys:shminfo_shmmax=209715200 to 4Gb if you running Solaris as well.

Most probably it insufficient shared memory or semaphores setup. Double check your calculations.

Hope that helps.

Trifon Anguelov
Senior Oracle DBA

---

---

Join the new Oracle DBA forums at:
http://www.dbaclick.com/cgi-bin/ib3/ikonboard.cgi

"mark a thomas" <marktuid4att_at_att.net> wrote in message news:3C66E747.9C54FB70_at_att.net...
> I am not able to start the database.
> I followed the quick start instructions on bolthole.
>
> $ cat .profile
> ORACLE_BASE=$HOME
> ORACLE_HOME=/opt/oracle/OraHome1
> ORACLE_SID=ora1sid
> PATH=/usr/sbin:/usr/bin:$ORACLE_HOME/bin
>

LD_LIBRARY_PATH=/usr/local/lib:/usr/lib:/usr/dt/lib:/usr/openwin/lib:$ORACLE _HOME/lib
>
> export LD_LIBRARY PATH ORACLE_SID ORACLE_HOME ORACLE_BASE
>
> $ tail /etc/system
>
> set shmsys:shminfo_shmmax=209715200
> set shmsys:shminfo_shmmin=1
> set shmsys:shminfo_shmmni=100
> set shmsys:shminfo_shmseg=10
> set shmsys:seminfo_semmni=100
> set shmsys:shminfo_semmsl=100
> set shmsys:shminfo_semmns=200
> set shmsys:shminfo_semopm=100
> set shmsys:shminfo_semvmx=32767
>
> I think the dbstart script in 8.1.7 is NOT broken, but I could be
> wrong.
>
>
> $ which dbstart
> /opt/oracle/OraHome1/bin/dbstart
> $
> $ id
> uid=1002(oracle) gid=420(sysoper)
> $ groups
> sysoper oinstall
> $
> $ dbstart
>
> Oracle Server Manager Release 3.1.7.0.0 - Production
>
> Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.
>
> Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
> With the Partitioning option
> JServer Release 8.1.7.0.0 - Production
>
> SVRMGR> Connected.
> SVRMGR> ORA-03113: end-of-file on communication channel
> SVRMGR>
> Server Manager complete.
>
> Database "ora1sid" warm started.
>
> I did a "standard/default" install since this is just for learning.
>
> If anyone has done this successfully let me know and also if you have
> any hints on who to fix
> this problem let me know.
>
> Thanks.
>
> /markt
>
>
>
>
Received on Sun Feb 10 2002 - 23:51:20 CST