Operating System - HP-UX
1748089 Members
5157 Online
108758 Solutions
New Discussion юеВ

Re: Oracle 9i HPUX 11. 64 bit Startup/shutdown

 
daud azimi
Occasional Advisor

Re: Oracle 9i HPUX 11. 64 bit Startup/shutdown

su - oracle(user) -c /.../dbshut ist not working ? i dont know what the Problems is, and manualy su - oracle and ./../dbhsut ist working ,.. so i came to idea to .....

But where can i set the ORACLE_TRACE ?
and how to debug the root.cron ?? or the dbshut script ?



Yogeeraj_1
Honored Contributor

Re: Oracle 9i HPUX 11. 64 bit Startup/shutdown

hi,

you can set this in the .profile of the oracle user in your case.

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)
daud azimi
Occasional Advisor

Re: Oracle 9i HPUX 11. 64 bit Startup/shutdown

i set ORACLE_TRACE in .profile of oracle user
but after runing the dbshut script says:
ksh: LD_LIBRARY_PATH: parameter not set
daud azimi
Occasional Advisor

Re: Oracle 9i HPUX 11. 64 bit Startup/shutdown

I have now some stupied questions :

where and how to check the correct Environemnt is set ?
I think the environemnt is not correct set by doing su - oracle(user)
Yogeeraj_1
Honored Contributor

Re: Oracle 9i HPUX 11. 64 bit Startup/shutdown

hi,

three places to check!

1. the script itself
2. the /etc/profile
3. the .profile in the user home

hope this helps!

kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Steven E. Protter
Exalted Contributor

Re: Oracle 9i HPUX 11. 64 bit Startup/shutdown

dbshut has a bug.

Change where it says shutdown to shutdown immediate.

Environment:
/etc/profile
/home directory/.profile

Anything sourced from in there.

The oracle start/stop scripts provided also set environment.

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
daud azimi
Occasional Advisor

Re: Oracle 9i HPUX 11. 64 bit Startup/shutdown

I think the orginal dbhsut script is modified:
....
case $VERSION in
"6") sqldba command=shutdown ;;
"internal") $SQLDBA <connect internal
shutdown immediate
EOF
;;
*) $SQLDBA <connect / as sysdba
shutdown immediate
EOF
............



Yogeeraj_1
Honored Contributor

Re: Oracle 9i HPUX 11. 64 bit Startup/shutdown

hi,

dbshut makes use of the ORATAB. Did you verify this?

it should contain something like:
mydb:/u01/app/oracle/product/8.1.7:Y


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: Oracle 9i HPUX 11. 64 bit Startup/shutdown

hi again,

attached a copy of the dbshut script that you may wish to verify with that of yours.

I would not recommend using dbstart and dbshut though. This is because you cannot control it completely. I never use dbstart/dbshut.

starting and stopping a database typically involves MORE than just the database.

I use an "orastart" script to do whatever I need to have done -- eg:

"start listener,
start db,
start processes that need to be running when db is up"

with dbstart you get

start db


and that is all....

hope this helps!

kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
James R. Ferguson
Acclaimed Contributor

Re: Oracle 9i HPUX 11. 64 bit Startup/shutdown

Hi Daud:

You asked how to check how your environment is/was setup.

A simple way is to add 'env' to your script.

If you run the script via 'cron' or 'at', without redirection of the 'env' call, a mail message will be generated detailing the various envioronmental settings. Otherwise you can redirect the output of 'env' to a file of your choice.

Regards!

...JRF...