Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle 10g Not starting automatically

Ranjith_5
Honored Contributor

Oracle 10g Not starting automatically

Hi Gurus,

* System is HPUX 11.23 with Oracle 10g

I am unable to make the Oracle autostart during system boot. It was working before ..I dont how Oracle instance got suddenly stopped starting, automatically. But the listener starts automatically.

I am able to start oracle and listener manually but not during automatically during system boot.

startup & shutdown scripts are there in the system. Startup script is /sbin/rc2.d/S990oracle.

Any idea where I need to look at..

Many thanks in advance.

Regards,
Syam
10 REPLIES
Arunvijai_4
Honored Contributor

Re: Oracle 10g Not starting automatically

Syam, Have you checked the log files ? As you know, log files are the best starting point for debugging.

-Arun
"A ship in the harbor is safe, but that is not what ships are built for"

Re: Oracle 10g Not starting automatically

Do you have a config file for startup in /etc/rc.config.d?
If so, is it set to autostart in there?
What does the /etc/rc.log say for this script at system boot time?
What do the Oracle logs say?
My house is the bank's, my money the wife's, But my opinions belong to me, not HP!
Ranjith_5
Honored Contributor

Re: Oracle 10g Not starting automatically

Hi Arun,

I have checked all log files mentioned in the startup scripts..Main problem is that I am neither getting any errors during system startup nor in the log files.

Can any one tell me which all the log files I need to look apart from the user defined log files.


Regards
Syam
Sivakumar TS
Honored Contributor

Re: Oracle 10g Not starting automatically

Dear Syam,

In oracle 9 there used to be a file "oratab" in which you have make the control variable from N to Y in the corresponding database instance.

Could you find for this file and try.

I Hope it will be problem

With Regards,

Siva.
Nothing is Impossible !
Steven E. Protter
Exalted Contributor

Re: Oracle 10g Not starting automatically

Database soft link should be in /sbin/init.d/rc3.d

Kill soff linke

/sbin/init.d/rc2.d

Starting the database at run level 3 is not neeeded.

The soft link should point to a start script in /sbin/init.d/

This script must have a start and stop section in the same syntax as /etc/init.d/template

Back in my Oracle 9 days I always had to do this myself on HP-UX. I was surprised on Linux to see the oracle install do this stuff all by itself on 10g.

The /etc/oratab stuff is important and will prevent the database from starting even if everything else is okay.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Ranjith_5
Honored Contributor

Re: Oracle 10g Not starting automatically

Hi Friends,

Thaks for all our replies.

Burnard,

My listener is starting from the same script. Only the oracle instance is not starting. that means there is no problem with the awitch file in /etc/rc.config.d. Still I checked the file /etc/rc.confi.d/oracle. The ORACLE_START=1 is present there.


Sivakumar,

Oratab we have already checked and its fine. It is set to Y.


SEP,

I had already tried copying the /sbin/rc2.d/S990oracle to /sbin/rc3.d/S990oracle. It is not working.

I feel that rc.x directories are in /sbin and not in /sbin/init.d


My problem is during the startup it reads the startup script /sbin/rc2.d/S990oracle but only the oracle instance startup part is not working.

If required I can post all the required script file for your reference.


Thanks once agin for your replies.

Thank you
Syam
Jean-Luc Oudart
Honored Contributor

Re: Oracle 10g Not starting automatically

Hi

could you post the script ?

Regards
Jean-Luc
fiat lux
Yogeeraj_1
Honored Contributor

Re: Oracle 10g Not starting automatically

hi,

can you also post the part from your /etc/rc.log which shows information about the Oracle Startup process?

kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Eric Antunes
Honored Contributor

Re: Oracle 10g Not starting automatically

Hi Syam,

I think your problem may be in the /sbin/init.d/dbora script to witch the S990oracle link points. Here is my script:

ORA_HOME=/...
ORA_OWNER=oracle
SCRIPT_PATH=/...

case "$1" in
'start')

echo "Oracle starting..."

/bin/su - $ORA_OWNER -c $SCRIPT_PATH/start_boot.sh
;;
'stop')

echo "Oracle stoping..."

/bin/su - $ORA_OWNER -c $SCRIPT_PATH/stop_boot.sh
;;



And $SCRIPT_PATH/start_boot.sh and $SCRIPT_PATH/stop_boot.sh:

ORA_ENVFILE="/.../.env"
DB_NAME=""

ORACLE_SID=""
export ORACLE_SID

sqlplus << EOT
connect / as sysdba;
startup; -- for start_boot.sh
shutdown immediate; -- for stop_boot.sh
exit
EOT

Best Regards,

Eric Antunes
Each and every day is a good day to learn.
Ranjith_5
Honored Contributor

Re: Oracle 10g Not starting automatically

Sorry for replying late..I was not able to login to ITRC for quite some time as I was very busy with a project...how ever i cud solve the issue with the help of our oracle dba.

regards,
Syam