Oracle 10g startup issue

[Yogeeraj_1]

hi mike,

one simple way to do it is:
....
'start')

# source the system configuration variables
if [ -f /etc/rc.config ] ; then
. /etc/rc.config
else
echo "ERROR: /etc/rc.config defaults file MISSING"
fi

# Check to see if this script is allowed to run...
if [ "$ORACLE_START_STOP" != 1 ]; then
rval=2
else

# Execute the commands to start your subsystem
echo "/u01/app/oracle/product/8.1.7/bin/lsnrctl start "| su - oracle
echo "/u01/app/oracle/product/8.1.7/bin/sqlplus /nolog <

[Philippe Vervoort]

There is nothing wrong with your script; is is run twice. Once as root, who changes it to run it as oracle.
The paramaters given to the script are part of the HP-UX startup paradigm ( first a start_msg to show what it's doing on the boot console, then a start to do the actual job ).
What can be the case is that your database is left in an 'unknown' state after starting and interrupting it for instance. What you have to do is: run the startup script and then do a shutdown abort. Then try again to start the database with dbora start

Good luck,
Philippe

[Eric Antunes]

Hi Mike,

In my opinion you aren't doing the right way. You should have 5 files, for example:

/sbin/init.d/dbora10
/sbin/rc3.d/K110dbora10
/sbin/rc2.d/S990dbora10 --> this and the above file are a link to /sbin/init.d/dbora10.
/disc/.../scripts/start_boot.sh -- starts the db and services
/disc/.../scripts/stop_boot.sh -- stops the db and services

Look at my scripts (that works) at:

http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=982198

Best Regards,

Eric Antunes