Operating System - HP-UX
1748150 Members
3734 Online
108758 Solutions
New Discussion юеВ

Re: Auto Shutdown and Startup script for Oracle8.1.7

 
SOLVED
Go to solution
Yogeeraj_1
Honored Contributor

Re: Auto Shutdown and Startup script for Oracle8.1.7

hi,

in /sbin/init.d/

i have the attached script.
(please modify accordingly)

then, two symbolic links created using:
ln -s /sbin/init.d/oracle /sbin/rc3.d/S900oracle
ln -s /sbin/init.d/oracle /sbin/rc2.d/K100oracle

hope this helps!
regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Yogeeraj_1
Honored Contributor

Re: Auto Shutdown and Startup script for Oracle8.1.7

hi again,

also, the /etc/rc.config.d/oracle is indeed also important!
content of file should be:
# ORACLE DATABASE configuration
#
# ORACLE_START_STOP : Set to 1 to start ORACLE DATABASE
#
ORACLE_START_STOP=1

hope this helps too!
regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
vinod_25
Valued Contributor

Re: Auto Shutdown and Startup script for Oracle8.1.7

hi jesse

Do the following steps:

step 1: edit /etc/oratab file

ORACLE_SID:ORACLE_HOME: {Y|N}
y -> for dbstart and dbshut scripts to startup and shutdoen the database

step 2: Create dbora script in the /etc/init.d

see attachment for the script

step 3: Create symbolic links to the dbora script in the appropriate run-level
script directories

# ln -s /etc/init.d/dbora /sbin/rc2.d/K10dbora
# ln -s /etc/init.d/dbora /sbin/rc3.d/S99dbora

step 4: avoidance of "stty is not a typewriter" error message

The not-a-typewriter error is caused by running commands where there is no
controlling tty device; that is, no interactive terminal is present. This would
be true for a script that runs in cron or has su - to run a batch job.

Uncomment all stty commands in /home/$ORA_OWNER/.profile as $ORA_OWNER
Example:
# Set up the terminal:
# if [ "$TERM" = "" ]
# then
# eval ` tset -s -Q -m ':?hp' `
# else
# eval ` tset -s -Q `
# fi
# stty erase "^H" kill "^U" intr "^C" eof "^D"
# stty hupcl ixon ixoff
# tabs

Recheck the scripts before applying...
Any suggestions warmly welcomed...

Good Luck !!

Vinod K
Jesse Delk
Frequent Advisor

Re: Auto Shutdown and Startup script for Oracle8.1.7

Thanks everybody. I'm making the changes and will be testing them next Friday.