Home » Infrastructure » Linux » Error starting Listener after applying Startup script (Oracle 10g database on Linux ES 4)
Error starting Listener after applying Startup script [message #316565] Fri, 25 April 2008 14:17 Go to next message
khalilo
Messages: 9
Registered: April 2008
Location: United States
Junior Member
Hello,

I just started learning Oracle products. I installed oracle 10g on Linux. the installed worked fine. I added database shut/start script. after reboot. I am n ot able to connect to Enterprise mnager or start listener:

This is the error I get:
/u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...
/u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr ; error while loeading shared libraries: libclntsh.so.10.1: cannot open shared object file: No such file or directory
TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adaptor error
TNS-00517: lost contact
Linux Error: 32: broken pipe.

P/S oracle is member of DBA group and I archived listener.log file

Please help.

Thanks,

Aziz
Re: Error starting Listener after applying Startup script [message #316578 is a reply to message #316565] Fri, 25 April 2008 19:16 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
GOOGLE is your friend but only when you actually use it.
Results 1 - 10 of about 33,800 for Linux Error: 32: broken pipe
Re: Error starting Listener after applying Startup script [message #316579 is a reply to message #316578] Fri, 25 April 2008 20:27 Go to previous messageGo to next message
khalilo
Messages: 9
Registered: April 2008
Location: United States
Junior Member
I got to this forum from googling the error message. I usually google all my problems before I post.


Thanks,

Aziz
Re: Error starting Listener after applying Startup script [message #316580 is a reply to message #316579] Fri, 25 April 2008 20:50 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Were you ever able to start the listener?

Do you have something else listening on the same port the listener is configured to listen on?
Re: Error starting Listener after applying Startup script [message #316611 is a reply to message #316580] Sat, 26 April 2008 08:10 Go to previous messageGo to next message
khalilo
Messages: 9
Registered: April 2008
Location: United States
Junior Member
No i was not able to start the listener after the startup script.
and I do not have anything listening in the same port.

everyting was working fine, as soon as I added the startup script, rebooted the server to test it that when the problem started.

I can't start database or listener.

the startup script I used is from Oracle's documentation I refrenced to to build install 10g.


Thanks,


Aziz
Re: Error starting Listener after applying Startup script [message #316626 is a reply to message #316611] Sat, 26 April 2008 11:45 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Not really sure what startup script you are referring to?

What does your listener.ora file look like? What happens if you rename your listener.ora file to listener.ora.old and try to start the listener?

Are your environment variables set correctly?
Re: Error starting Listener after applying Startup script [message #316628 is a reply to message #316565] Sat, 26 April 2008 11:47 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Have you correctly set up the path in script?
In 10g listener starts automatically with DBSTART.
Re: Error starting Listener after applying Startup script [message #316629 is a reply to message #316628] Sat, 26 April 2008 11:49 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
varu123 wrote on Sat, 26 April 2008 12:47

In 10g listener starts automatically with DBSTART.

It won't start automatically if OP isn't using default name.
Re: Error starting Listener after applying Startup script [message #316829 is a reply to message #316580] Mon, 28 April 2008 08:48 Go to previous messageGo to next message
khalilo
Messages: 9
Registered: April 2008
Location: United States
Junior Member
Everything was working fine prior to startup script.
Re: Error starting Listener after applying Startup script [message #316831 is a reply to message #316829] Mon, 28 April 2008 08:51 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Help us help you and answer some of the questions posed to you above !
Re: Error starting Listener after applying Startup script [message #316839 is a reply to message #316831] Mon, 28 April 2008 09:12 Go to previous messageGo to next message
khalilo
Messages: 9
Registered: April 2008
Location: United States
Junior Member
I did rename my Listener.ora file to Listener.ora.old it didn't fix the problem.


This a copy of the startup script I used:


#!/bin/sh -x
# change the value of ORACLE_HOME .
# description: Oracle auto start-stop script.

ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1

#
# Change the value of ORACLE to the login name of the # oracle owner # ORACLE=oracle

PATH=${PATH}:$ORACLE_HOME/bin
HOST=`hostname`
PLATFORM=`uname`
export ORACLE_HOME PATH
#
if [ ! "$2" = "ORA_DB" ]; then
if [ "PLATFORM" = "HP-UX" ] ; then
remsh $HOST -1 $ORACLE -n "$0 $1 ORA_DB"
exit
else
rsh $HOST $ORACLE $0 $1 ORA_DB
exit
fi
fi
#
case $1 in
'start')
$ORACLE_HOME/bin/dbstart $ORACLE_HOME &
;;
'stop')
$ORACLE_HOME/bin/dbshut $ORACLE_HOME &
;;
*)
echo "usage: $0 {start|stop}"
exit
;;
esac
#
exit


as for the question about the path I am not sure what I should be looking for.

As I mentioned before I am new to Oracle and this is my first install of the product.

Please let me know if you need more info.


Aziz
Re: Error starting Listener after applying Startup script [message #316874 is a reply to message #316565] Mon, 28 April 2008 12:38 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Who is the user to execute the script?
You are not switching to oracle.Root cannot dbstart/dbshut
...
ORACLE oracle
export ORACLE
case $1 in
'start')
su - $ORACLE -c $ORACLE_HOME/bin/dbstart $ORACLE_HOME &
;;
'stop')
su - $ORACLE -c $ORACLE_HOME/bin/dbshut $ORACLE_HOME &
;;


icon8.gif  Re: Error starting Listener after applying Startup script [message #316879 is a reply to message #316874] Mon, 28 April 2008 13:06 Go to previous messageGo to next message
khalilo
Messages: 9
Registered: April 2008
Location: United States
Junior Member
Root is executing the script at system startup. I edit the script and I am still getting same error message.


thanks,

Re: Error starting Listener after applying Startup script [message #316922 is a reply to message #316879] Mon, 28 April 2008 20:23 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Don't really know how the startup script would cause the listener any problems.

As the user oracle, can you post the output of the following:

id -a
env | egrep "LIBRARY|^PATH|ORA"
netstat -na | grep 1521
mv $ORACLE_HOME/network/admin/listener.ora $ORACLE_HOME/network/admin/listener.ora.old
lsnrctl start


[Updated on: Mon, 28 April 2008 20:24]

Report message to a moderator

Re: Error starting Listener after applying Startup script [message #317073 is a reply to message #316922] Tue, 29 April 2008 07:15 Go to previous messageGo to next message
khalilo
Messages: 9
Registered: April 2008
Location: United States
Junior Member
[oracle@BAN10 /]$ id -a
uid=501(oracle) gid=501(oinstall) groups=501(oinstall),502(dba),503(oper)
[oracle@BAN10 /]$ env | egrep "LIBRARY|^PATH|ORA"
ORACLE_SID=TSH1
ORACLE_BASE=/u01/app/oracle
PATH=/usr/kerberos/sbin:/u01/app/oracle/product/10.2.0/db_1/bin:/usr/sbin:/usr/kerberos/bin:/usr/local/bin:/usr/bin:/bin:/usr/X11R6/b in:/home/oracle/bin
ORACLE_TERM=xterm
ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1


This is the output after I deleted Listener.ora file and tried to start listener.


[oracle@BAN10 admin]$ lsnrctl start

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 29-APR-2008 08:12:12

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Starting /u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...

TNS-12537: TNS:connection closed
TNS-12560: TNS:protocol adapter error
TNS-00507: Connection closed
Linux Error: 29: Illegal seek


please let me know if you need more info:

Thanks,


Aziz
Re: Error starting Listener after applying Startup script [message #317088 is a reply to message #316565] Tue, 29 April 2008 08:27 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Results 1 - 10 of about 4,410 for oracle Linux Error: 29: Illegal seek
GOOGLE is your friend, but only when you use it.
Previous Topic: DBCA Command Fails With Library Error
Next Topic: how to start different database from sqlplus
Goto Forum:
  


Current Time: Fri Mar 29 01:14:12 CDT 2024