Re: Startup problems with 8.1.7 under RedHat 6.2

Almost exactly the same thing happened to me except It was 8.1.7 Personal Oracle on Windows 2000 Advanced server.

I'd be interested in a suggestion aswell.

Geoff MacGowan

Sybrand Bakker <oradba_at_sybrandb.demon.nl> wrote in message news:m1m7vtkcjjukkrt9qve3m9gq3h4qc7mml3_at_4ax.com...
> On Thu, 15 Nov 2001 13:12:46 +0100, "Frank Erdmann"
> <Frank.Erdman_at_uni-muenster.de> wrote:
>
> >Hello NG!
> >
> >We installed Oracle 8i on Linux RedHat 6.2. Everything works fine except
> >the startup at boot time.
> >This is how we tried to solve the startup:
> >
> >01) Set the right env variables for the oracle user (SID etc.)
> >02) Alter the /etc/oratab, set the option N to Y (dbstart can now startup
> >the dbms)
> >03) Wrote a script and copied it to /etc/rc.d/init.d
> >04) Registered the script via /sbin/chkconfig --add <script's name>
> >05) added a listener startup script with the same method
> >
> >Script contains following lines to start the DBMS:
> >echo "Oracle 8i auto start/stop"
> >
> >ORA_OWNER=oracle
> >ORA_HOME=/u01/app/oracle/product/8.1.7
> >
> >case "$1" in
> > 'start')
> >
> >echo -n "Starting Oracle8i: "
> >su - $ORA_OWNER -c $ORA_HOME/bin/dbstart >>/var/log/oracle
> >touch /var/lock/subsys/oracle8i
> >echo
> >;;
> >
> >When starting the server, the listener starts and it looks like the
Oracle
> >starts, too (message log). But when we try to connect to the DBMS via
> >SQLPLUS the DBMS doesn't seem started up and an error occurs which says
that
> >the program cannot find the memory realm of the DB (ORA-27101) and Oracle
is
> >not available (ORA-01034). SID is set right. Starting the DB with SQLPLUS
> >and user "/ as sysdba", then typing "startup" works - the net8assistant
is
> >able to test the connection.
> >Why doesn't it start automatically?
> >
> >Thanks a lot in advance,
> > Frank
> >
> >
> >
> >
> >
>
> Your script redirects the output to /va/log/oracle. Did you look in
> that file?
> 27101 usually is a result of conflicts between init.ora parameters and
> shared memory configuration.
>
> Hth
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Thu Nov 15 2001 - 21:59:02 CST