Problem with automatic startup

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 blog http://www.dizwell.com/prod/node/50?page=0%2C4 for helping me create dbora script. :))

Please help !! :)) Received on Mon Nov 12 2007 - 10:17:50 CST