- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: auto startup listener fails
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
тАО03-22-2010 12:44 AM
тАО03-22-2010 12:44 AM
auto startup listener fails
we are using dbora script for startup & shutdown od oracle database & listeners
which is running scessfully.
We try implement same script for another server.
it start and stops dabase manaully & on run level
But fails listner startup
any input to resolve this issue
atcched dbscript for you review
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-22-2010 12:49 AM
тАО03-22-2010 12:49 AM
Re: auto startup listener fails
You omitted the script...
Horia.
Horia.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-22-2010 12:50 AM
тАО03-22-2010 12:50 AM
Re: auto startup listener fails
Should look for any error code/message provided.
Read the logs.
Horia
Horia.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-22-2010 12:51 AM
тАО03-22-2010 12:51 AM
Re: auto startup listener fails
could you please send how do you try to start the oracle listener ??
are you running only one listener on the DB server or you have more instances and listeners ???
mikap
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-22-2010 12:53 AM
тАО03-22-2010 12:53 AM
Re: auto startup listener fails
set -x
ORACLE_SID=cieho;export ORACLE_SID
# oracle owner at your site.
ORACLE=oracle
# CHANGED: PATH=${PATH}:$ORACLE_HOME/bin
export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
export ORACLE_HOME_LISTNER=$ORACLE_HOME
export PATH=${PATH}:/usr/sbin:/bin:/usr/bin:/sbin:$ORACLE_HOME/bin
HOST=`hostname`
PLATFORM=`uname`
#export ORACLE_HOME PATH
#
LOG=$ORACLE_HOME/stop1.log
touch $LOG
chmod a+r $LOG
#
case $1 in
'start')
echo "$0: starting up" >> $LOG
date >> $LOG
# Start Oracle Net
echo $ORACLE_HOME
if [ -f $ORACLE_HOME/bin/tnslsnr ] ;
then
echo "starting Oracle Net Listener" >> $LOG 2>&1
su - $ORACLE -c "lsnrctl start" >> $LOG 2>&1
fi
echo "Starting Oracle databases" >> $LOG 2>&1
echo $ORACLE $PATH "dbstart $ORACLE_HOME" >> $LOG 2>&1
which su >> $LOG 2>&1
su - $ORACLE -c "$ORACLE_HOME/bin/dbstart" >> $LOG 2>&1
;;
'stop')
echo "$0: shutting down" >> $LOG
date >> $LOG
# Stop Oracle Net
if [ -f $ORACLE_HOME/bin/tnslsnr ] ;
then
echo "stopping Oracle Net Listener">> $LOG 2>&1
su - $ORACLE -c "lsnrctl stop" >> $LOG 2>&1
fi
echo "stopping Oracle databases">>$LOG 2>&1
su - $ORACLE -c "$ORACLE_HOME/bin/dbshut" >> $LOG 2>&1
;;
# YOU NEED THIS AS WELL, as rc will supply this parameters:
*start_msg) echo "starting oracle " ;;
*stop_msg) echo "stopping oracle " ;;
*)
echo "usage: $0 {start[_msg]|stop[_msg}"
# SUPPLY AN EXIT CODE FOR exit
retcode=1
;;
# MISSING ESAC
esac
# USUALLY you work with a variable retcode (e.g.) in rc scripts
exit ${retcode:-0}
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-22-2010 12:59 AM
тАО03-22-2010 12:59 AM
Re: auto startup listener fails
i have a one question, if you start the listener and DB instance manually, is it working ??
this script that you are using is very common, but the question is if the listener config is correct.
mikap
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-22-2010 05:51 AM
тАО03-22-2010 05:51 AM
Re: auto startup listener fails
...
su - $ORACLE -c "lsnrctl start" >> $LOG 2>&1
So how does it look like $ORACLE_HOME/stop1.log file? Any messages about listner?
Horia.
Horia.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-22-2010 08:11 AM
тАО03-22-2010 08:11 AM
Re: auto startup listener fails
Following meesage is seen in stop1.log
./dbora: shutting down
Mon Mar 22 12:45:49 IST 2010
stopping Oracle Net Listener
-bash: lsnrctl: command not found
stopping Oracle databases
thanks
(Shabir)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-22-2010 11:31 AM
тАО03-22-2010 11:31 AM
Re: auto startup listener fails
pls try to incorporate $PATH for "lsnrct" in your script .
if you are able to start listener manually as per below, suspecting could be absolute path problem for "lsnrctl" in your script
su - $ORACLE -c "lsnrctl start"
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-22-2010 11:36 AM
тАО03-22-2010 11:36 AM
Re: auto startup listener fails
set this variables :
ORACLE_BASE=/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/app/10.2.0; export ORACLE_HOME
ORACLE_SID=orcl; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLA
SSPATH
for example
mikap