- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle 9i HPUX 11. 64 bit Startup/shutdown
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-11-2006 06:56 PM
тАО01-11-2006 06:56 PM
Re: Oracle 9i HPUX 11. 64 bit Startup/shutdown
But where can i set the ORACLE_TRACE ?
and how to debug the root.cron ?? or the dbshut script ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-11-2006 07:02 PM
тАО01-11-2006 07:02 PM
Re: Oracle 9i HPUX 11. 64 bit Startup/shutdown
you can set this in the .profile of the oracle user in your case.
hope this helps
regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-11-2006 07:24 PM
тАО01-11-2006 07:24 PM
Re: Oracle 9i HPUX 11. 64 bit Startup/shutdown
but after runing the dbshut script says:
ksh: LD_LIBRARY_PATH: parameter not set
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-11-2006 08:38 PM
тАО01-11-2006 08:38 PM
Re: Oracle 9i HPUX 11. 64 bit Startup/shutdown
where and how to check the correct Environemnt is set ?
I think the environemnt is not correct set by doing su - oracle(user)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-11-2006 09:03 PM
тАО01-11-2006 09:03 PM
Re: Oracle 9i HPUX 11. 64 bit Startup/shutdown
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-11-2006 09:57 PM
тАО01-11-2006 09:57 PM
Re: Oracle 9i HPUX 11. 64 bit Startup/shutdown
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
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-11-2006 10:15 PM
тАО01-11-2006 10:15 PM
Re: Oracle 9i HPUX 11. 64 bit Startup/shutdown
....
case $VERSION in
"6") sqldba command=shutdown ;;
"internal") $SQLDBA <
shutdown immediate
EOF
;;
*) $SQLDBA <
shutdown immediate
EOF
............
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-12-2006 12:02 AM
тАО01-12-2006 12:02 AM
Re: Oracle 9i HPUX 11. 64 bit Startup/shutdown
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-12-2006 12:11 AM
тАО01-12-2006 12:11 AM
Re: Oracle 9i HPUX 11. 64 bit Startup/shutdown
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-12-2006 12:18 AM
тАО01-12-2006 12:18 AM
Re: Oracle 9i HPUX 11. 64 bit Startup/shutdown
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...