- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- oracle database instances not starting
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
тАО07-05-2001 12:21 PM
тАО07-05-2001 12:21 PM
oracle database instances not starting
Working on L2000 with HP-UX 11.00 and Oracle 8.1.6
Have setup the rc start/shut scripts to start/stop the oracle instances on boot/halt. All looks good except the SIDs are not starting. Looking in the rc.log says they are starting but when it is checked, the SIDs are not running. A sample from the rc.log:
Start Oracle Database(s)
Output from "/sbin/rc3.d/S750oracle start":
----------------------------
Database "mimstst" warm started.
Database "nsmt" warm started.
Database "nsmp" warm started.
There are no errors in the rc.log related to the oracle start. The listener is starting and doing the check shows it is started. Not sure what is going on because the $ORACLE_HOME/bin/dbstart and dbshut are being called and these are standard with the oracle install. Where to go from here?
Many thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-05-2001 12:25 PM
тАО07-05-2001 12:25 PM
Re: oracle database instances not starting
I'd start by trying to run your oracle start script (/sbin/init.d/oracle or whatever) from the command line as root to see if you pick up any complaints. If that doesn't help, you'll have to try putting some extra "echo" statments in the dbstart script to see what is happening.
My guess is that the ORACLE_HOME and the PATH aren't getting set correctly and that it can't find 'svrmgrl'. Just a SWAG.
Is this a new implementation or were these scripts working and then just quit?
JP
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-05-2001 12:35 PM
тАО07-05-2001 12:35 PM
Re: oracle database instances not starting
Will put the echos in the script and double check the PATH and all.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-05-2001 12:43 PM
тАО07-05-2001 12:43 PM
Re: oracle database instances not starting
The echos are showing the correct output.
A stumper no doubt.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-05-2001 12:45 PM
тАО07-05-2001 12:45 PM
Re: oracle database instances not starting
What gets me is the warm started. Your rc.log should contain all of the startup info.
Are you doing a
su - oracle -c "lsnrctl start;dbstart"
in your rc?
You should see the su in you rc.log?
...jcd...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-05-2001 12:49 PM
тАО07-05-2001 12:49 PM
Re: oracle database instances not starting
I'm looking at a copy of the dbstart script for 8.1.6 here. It checks for the return code ($?) from sqlplus for version 8.1.6 when it does the startup. You only get the "warm started" message if you get a return status of zero, so it must be happy with what happens in 'sqlplus'. Either something strange is going on with sqlplus, or maybe the database is dying right after it starts?
JP
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-05-2001 12:57 PM
тАО07-05-2001 12:57 PM
Re: oracle database instances not starting
Do not see the "su" messages but I am inclined to believe that I wouldn't. I have added the set -x to the /sbin/init.d/oracle script as well and the output looks good.
Could it be the $ORACLE_HOME/bin/dbstart script by chance?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-05-2001 01:02 PM
тАО07-05-2001 01:02 PM
Re: oracle database instances not starting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-05-2001 01:02 PM
тАО07-05-2001 01:02 PM
Re: oracle database instances not starting
Have you tried starting all instances from svrmgrl?
Don't know....very strange.
...jcd...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-05-2001 01:05 PM
тАО07-05-2001 01:05 PM
Re: oracle database instances not starting
You won't see the 'su' command in their dbstart script as they do everything as root. To test that you could export your ORACLE_SID, ORACLE_HOME, PATH, and LD_LIBRARY_PATH just like they do in the script, and then try to run the sqlplus commmands manually. That might give some interesting clues.
JP