Re: Problem with automatic startup

On Nov 13, 3:17 am, dbm..._at_gmail.com 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 hardcoded  ORACLE_HOME_LISTNER=/ade/vikrkuma_new/oracle to ORACLE_HOME_LISTNER=/oracle/10g ...as it tells you in the original article. Received on Mon Nov 12 2007 - 19:07:56 CST