- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Oracle 10g startup issue
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
тАО12-14-2005 10:23 AM
тАО12-14-2005 10:23 AM
Oracle 10g startup issue
script in /sbin/init.d/ called dbora
link to that from /sbin/rc3.d file is S990dbora
We noticed that Oracle appeared to start and quite a few processes were there but a closer inspection by the dba showed that Oracle was in some sort of "mount" state instead of a started state.
We have been doing troubleshooting today and it appears that the param start_msg is being passed into the dbora/S990dbora script during startup. The case statement in the script does not have start_msg only start and stop. The system then appears to do a stop on Oracle instead of a start.
It must go into the background at that point because later we see some messages during startup from this script.
I don't understand why this param is being passed to it since it doesn't appear to expect it and I would appreciate any ideas anyone has.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-14-2005 12:06 PM
тАО12-14-2005 12:06 PM
Re: Oracle 10g startup issue
When you say "Oracle appeared to start and quite a few processes and later on it is still in mount status. And then about the parameter start_msg". Then you notice that the script does a stop of oracle instead of start.
It would be something to do with the way your oracle start/stop script is written. May be after the start statements, there is no ending in the case and the script is continuing with the next case which is to stop oracle. Also check with you PATH, DISPLAY and export statements. When a database is started it have to be mounted and then in open state for users to be able to use it.
In the case statement this is how one would have.
Check you script
case $1 in
start_msg)
echo "Start Oracle" ;;
stop_msg)
echo "Stopping Oracle" ;;
'start')
this is where you have the db start statements......
........
;;
'stop')
this is where you have the db stop statements....
.........
;;
*)
echo "usage: $0 {start|stop}"
..........
;;
esac
Indira A
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-14-2005 12:45 PM
тАО12-14-2005 12:45 PM
Re: Oracle 10g startup issue
You can find the problem by testing this procedure manually, i.e., using /sbin/init.d/dbora start o stop, to see what is going on, you can put a set -x and set -v at the beginning of dbora.
If you still can't see what happend, you must find alert.ora file from this database, that will have all problems that occured during database startup.
Regards,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-14-2005 03:38 PM
тАО12-14-2005 03:38 PM
Re: Oracle 10g startup issue
did you check the value of the ORACLE_START_STOP paramter in your /etc/rc.config.d/oracle ?
normally, it should be set to 1
hope this helps
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-15-2005 01:00 AM
тАО12-15-2005 01:00 AM
Re: Oracle 10g startup issue
Here are some answers:
Here is the Case statement, the only difference is that the start_msg section at the beginning was added by me. It was not there previously. I would like to know why the system is passing a parameter that the startup script is not expecting.
case $1 in
'start_msg')
echo "$0: startup start_msg"
;;
'start')
echo "$0: starting up" >> $LOG
date >> $LOG
# Start Oracle Net
if [ -f $ORACLE_HOME/bin/tnslsnr ] ; then
echo "starting Oracle Net Listener"
$ORACLE_HOME/bin/lsnrctl start >> $LOG 2>&1 &
fi
echo "Starting Oracle databases"
$ORACLE_HOME/bin/dbstart >> $LOG 2>&1 &
emctl start agent
;;
'stop')
echo "$0: shutting down" >> $LOG
date >> $LOG
# Stop Oracle Net
if [ -f $ORACLE_HOME/bin/tnslsnr ] ; then
echo "stopping Oracle Net Listener"
$ORACLE_HOME/bin/lsnrctl stop >> $LOG 2>&1 &
fi
echo "stopping Oracle databases"
$ORACLE_HOME/bin/dbshut >> $LOG 2>&1 &
emctl stop agent
;;
*)
echo "usage: $0 {start|stop}"
exit
;;
esac
I just spoke with the dba and he said it works if he does things manually. He has reviewed the alert.ora and all comes up but it goes to alter mount state and not started. He is wondering why on a boot the system first tries to shutdown the database. If it is a boot there should not be a database up. We are trying to get a reboot today and will look at the set command. He added echos to the dbstart script on yesterday but we never saw anything from it during startup.
Last but not least, I am unable to find any file related to Oracle in rc.config.d That was something we looked at yesterday based on some other postings we saw.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-15-2005 01:19 AM
тАО12-15-2005 01:19 AM
Re: Oracle 10g startup issue
This is wrong
---
if [ -f $ORACLE_HOME/bin/tnslsnr ] ; then
echo "starting Oracle Net Listener"
$ORACLE_HOME/bin/lsnrctl start >> $LOG 2>&1 &
fi
echo "Starting Oracle databases"
$ORACLE_HOME/bin/dbstart >> $LOG 2>&1 &
emctl start agent
---
You should not start oracle as the root user. In a startup script the ORACLE_HOME variable is not set. Starting oracle as root will make it unaccessible to users and is not supported.
What you should do is run it as the oracle user, which hopefully you used to install it.
/usr/bin/su - oracle -c "path to oracle startup script"
That replaces the code above.
That happens is the system changes to the oracle user, gets the proper environment like ORACLE_HOME and then proceeds to start the databse.
Thats how I've always started oracle products and it's worked pretty well.
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
тАО12-15-2005 01:27 AM
тАО12-15-2005 01:27 AM
Re: Oracle 10g startup issue
su - oracle -c "lsnrctl start" 1>/dev/null 2>&1
su - oracle -c dbstart 1>/dev/null 2>&1
Good Luck,
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
тАО12-15-2005 01:34 AM
тАО12-15-2005 01:34 AM
Re: Oracle 10g startup issue
if [ ! "$2" = "ORA_DB" ] ; then
if [ "$PLATFORM" = "HP-UX" ] ; then
# remsh $HOST -l $ORACLE -n "$0 $1 ORA_DB"
if [ "$1" = "start" ]
then
su - oracle -c '/sbin/rc3.d/S990dbora start ORA_DB'
else
su - oracle -c '/sbin/rc3.d/S990dbora stop ORA_DB'
fi
exit
else
rsh $HOST -l $ORACLE $0 $1 ORA_DB
exit
fi
fi
Apparently this thing runs the first time and then runs itself again as Oracle. This is in a ServiceGuard cluster that was setup for us by a consultant. I have about 2 months experience as an HP admin. This is the development node. SG takes care of Oracle on the prod node so it is totally different startup on the other node. This dbora stuff was put there by the consultant and we are pretty sure that all this was tested and ran correctly before he left.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-15-2005 01:39 AM
тАО12-15-2005 01:39 AM
Re: Oracle 10g startup issue
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-15-2005 01:50 AM
тАО12-15-2005 01:50 AM
Re: Oracle 10g startup issue
# cat dbora
#! /bin/sh -x -v
#
# Change the value of ORACLE_HOME to specify the correct Oracle home
# directory for you installation
date
ORACLE_HOME=/oracle/OraHome_1
#
# change the value of ORACLE to the login name of the
# oracle owner at your site
#
ORACLE=oracle
PATH=${PATH}:$ORACLE_HOME/bin:/usr/bin
HOST=`hostname`
PLATFORM=`uname`
export ORACLE_HOME PATH
#
if [ ! "$2" = "ORA_DB" ] ; then
if [ "$PLATFORM" = "HP-UX" ] ; then
# remsh $HOST -l $ORACLE -n "$0 $1 ORA_DB"
if [ "$1" = "start" ]
then
su - oracle -c '/sbin/rc3.d/S990dbora start ORA_DB'
else
su - oracle -c '/sbin/rc3.d/S990dbora stop ORA_DB'
fi
exit
else
rsh $HOST -l $ORACLE $0 $1 ORA_DB
exit
fi
fi
#
LOG=$ORACLE_HOME/startup.log
touch $LOG
chmod a+r $LOG
#
case $1 in
'start_msg')
echo "$0: startup start_msg"
;;
'start')
echo "$0: starting up" >> $LOG
date >> $LOG
# Start Oracle Net
if [ -f $ORACLE_HOME/bin/tnslsnr ] ; then
echo "starting Oracle Net Listener"
$ORACLE_HOME/bin/lsnrctl start >> $LOG 2>&1 &
fi
echo "Starting Oracle databases"
$ORACLE_HOME/bin/dbstart >> $LOG 2>&1 &
emctl start agent
;;
'stop')
echo "$0: shutting down" >> $LOG
date >> $LOG
# Stop Oracle Net
if [ -f $ORACLE_HOME/bin/tnslsnr ] ; then
echo "stopping Oracle Net Listener"
$ORACLE_HOME/bin/lsnrctl stop >> $LOG 2>&1 &
fi
echo "stopping Oracle databases"
$ORACLE_HOME/bin/dbshut >> $LOG 2>&1 &
emctl stop agent
;;
*)
echo "usage: $0 {start|stop}"
exit
;;
esac
#
date
exit