Re: Problem with automatic startup
- From: hjr.pythian@xxxxxxxxx
- Date: Mon, 12 Nov 2007 17:07:56 -0800
On Nov 13, 3:17 am, dbm...@xxxxxxxxx wrote:
Hi all,
Well, I have a problem with database automatic startup. Ok, not
exactly database but listener.
Operating sistem is SLES 10.
I've created dbora script that looks like this:
#!/bin/bash
# chkconfig: 345 99 10
# description: Startup Script for Oracle Databases
# /etc/init.d/dbora
export ORACLE_HOME=/home/oracle/oracle/product/10.2.0/db_2/
export PATH=$PATH:$ORACLE_HOME/bin
case "$1" in
start)
su oracle -c $ORACLE_HOME/bin/dbstart
touch /var/lock/oracle
echo "OK"
;;
stop)
echo -n "Shutdown Oracle: "
su oracle -c $ORACLE_HOME/bin/dbshut
rm -f /var/lock/oracle
echo "OK"
;;
*)
echo "Usage: 'basename $0' start|stop"
exit 1
esac
exit 0
Then, I've edited dbstart script provided by Oracle, changed LISTNER
to LISTENER.
Database itself starts automatically but listener wont start. :(( Here
is the listener error log:
TNSLSNR for Linux: Version 10.2.0.3.0 - Production on 12-NOV-2007
17:45:47
Copyright (c) 1991, 2006, Oracle. All rights reserved.
System parameter file is /home/oracle/oracle/product/10.2.0/db_2/
network/admin/listener.ora
Log messages written to /home/oracle/oracle/product/10.2.0/db_2/
network/log/listener.log
Trace information written to /home/oracle/oracle/product/10.2.0/db_2/
network/trace/listener.trc
Trace level is currently 0
Started with pid=4024
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)
(HOST=172.17.66.24)(PORT=1521)))
TNS-12545: Connect failed because target host or object does not exist
TNS-12560: TNS:protocol adapter error
TNS-00515: Connect failed because target host or object does not
exist
Linux Error: 99: Cannot assign requested address
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)
(KEY=EXTPROC1)))
Given address really is 172.17.66.24 so i dont know what im doing
wrong ?!
Once again, I would like to thank this bloghttp://www.dizwell.com/prod/node/50?page=0%2C4
for helping me create dbora script. :))
Please help !! :))
Why on Earth do you KEEP on asking questions here about things you
should ask on the site where you read the original scripts?!
For starters, who told you to change LISTNER to LISTENER? It wasn't
me: I just happened to remark on the stupidness of the spelling. All
you are required to do in 10g-ish installations is change the hard-
coded ORACLE_HOME_LISTNER=/ade/vikrkuma_new/oracle to
ORACLE_HOME_LISTNER=/oracle/10g ...as it tells you in the original
article.
.
- References:
- Problem with automatic startup
- From: dbmejl
- Problem with automatic startup
- Prev by Date: Re: ORA-0600 in 10g
- Next by Date: Re: How to write
- Previous by thread: Re: Problem with automatic startup
- Next by thread: CLOB Replacement - RTF format data
- Index(es):
Relevant Pages
|
