Database not starting automatically

[amolik]

Hi All

I have modified my /etc/oratab file to following (9i for RH Linux 7.2)

*:/opt/oracle/product/9.0.1:Y
kdb:/opt/oracle/product/9.0.1:Y

to start my database automatically when machine gets start.
However still the database does not start automatically. I have to start it physically even after modifying after connecting as sysdba.
What can be the problem. Do I have to modify any other file.

Amol

[ngwh]

amol,

besides making setting oratab...u also need a startup script in the startup level in HP-unix eg. '/sbin/rc2.d/S900oracle' that execute 'dbstart' as oracle user...inorder to be "automatic"

rgds,
ngwh

[Shestakov]

Link for this :
http://docs.oracle.com/DOCS_DOT_PDF_Storage/a96167.pdf

Try to find topic : Automating Database Startup and Shutdown for HP, Linux and Solaris.

There describe all steps for startup/shutdown db.

[sanjay92]

In Red Hat Linux, You have put your Oracle start scripts in

/etc/rc.d/rc3.d/S* scripts

e.g. You could create a file name S75Oracle in /etc/rc.d/rc3.d

and that file should contain entry like this

su -c <$ORACLE_HOME>/bin/dbstart

Originally posted by ngwh
amol,

besides making setting oratab...u also need a startup script in the startup level in HP-unix eg. '/sbin/rc2.d/S900oracle' that execute 'dbstart' as oracle user...inorder to be "automatic"

rgds,
ngwh

[amolik]

I have made following setting in S75Oracle file in /etc/rc.d/rc3.d/
su -c /opt/oracle/product/9.0.1/bin/dbstart
and I get OK message when I rebboted the machine for Oracle Startup. Then I tried to coonect sqlplus and found that the database was still not started.
Then I run dbstart file from the ORACLE_HOME/bin and got the message as follows

SQL*Plus: Release 9.0.1.0.0 - Production on Fri Jul 5 03:49:16 2002

(c) Copyright 2001 Oracle Corporation. All rights reserved.

SQL> ERROR:
ORA-24314: service handle not initialized


SQL> ORA-12162: TNS:service name is incorrectly specified
SQL>
Database "" warm started.

ANd after thatt the Database was started. What can be the problem that I got the error of 'service handle not initialised'

Amol

[amolik]

Hi All

Do I need to modify any files for above problem. It still shows me while booting
Starting Oracle (OK)
but when I am $ prompt and start sqlplus scott/tiger i still shows me following error.

--------------------------------------------------------------------------------------
SQL*Plus: Release 9.0.1.0.0 - Production on Sun Jul 7 22:30:09 2002

(c) Copyright 2001 Oracle Corporation. All rights reserved.

ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
----------------------------------------------------------------------------------------
If I connect sys as sysdba and then say startup it works fine.
What can be the problem again. Do I need to do anything with memory

Amol