Re: Startup problems with 8.1.7 under RedHat 6.2

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 - 09:00:24 CST