Home » Infrastructure » Linux » Listener Failed on New SUSE server
Listener Failed on New SUSE server [message #141292] Sat, 08 October 2005 03:15 Go to next message
Pintoguiness
Messages: 5
Registered: October 2005
Junior Member
Hi,

Just installed 10.2 on a new Suse Linux Box (9.3). Everything went fine with the install but after a reboot, the Listener fails to load. Here's the Listener.log:

TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /opt/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /opt/oracle/product/10.2.0/db_1/network/log/listener.log
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
TNS-12555: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00525: Insufficient privilege for operation
Linux Error: 1: Operation not permitted

Listener failed to start. See the error message(s) above...


Here's the Listener.ora file:

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = ICM)
(ORACLE_HOME = /opt/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = quad.site)(PORT = 1521))
)
)

I'm sure its a security issue with the system user, but how to fix?

Thanks

Gerald
Re: Listener Failed on New SUSE server [message #141293 is a reply to message #141292] Sat, 08 October 2005 03:21 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member

Can you start the listener. Try it out first --

login as Oracle user and run the following command on the terminal


 $ lsnrctl start

 


regards,
tarun
Re: Listener Failed on New SUSE server [message #141295 is a reply to message #141293] Sat, 08 October 2005 03:29 Go to previous messageGo to next message
Pintoguiness
Messages: 5
Registered: October 2005
Junior Member
No, I get this message:


/opt/oracle/product/10.2.0/db_1/bin # lsnrctl start
bash: lsnrctl: command not found


Any ideas?
Re: Listener Failed on New SUSE server [message #141297 is a reply to message #141295] Sat, 08 October 2005 03:40 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member


what you get if you run this command

 

 /opt/oracle/product/10.2.0/db_1/bin # ls -l lsn* 

 


can you see lsnrctl in the output.

and one more thing , did you login as oracle user to run this command.

see this

when i logged as oracle user and run the above command

 

dogmatix:SID=testdb=>ls -l lsn*
-rwxr-x--x   1 oracle   oinstall 2829640 Aug  9 10:48 lsnrctl*
-rwxr-xr-x   1 oracle   oinstall 4957040 Apr 29  2002 lsnrctl0*

[ /data1/u01/app/oracle/product/9.2.0/bin ] 

 
 


regards,
tarun
Re: Listener Failed on New SUSE server [message #141298 is a reply to message #141297] Sat, 08 October 2005 03:49 Go to previous messageGo to next message
Pintoguiness
Messages: 5
Registered: October 2005
Junior Member
I am logged in as the Oracle user

but when I run the command- I only see this:

:/opt/oracle/product/10.2.0/db_1/bin # ls -1 lsn*
lsnrctl
lsnrctl0

no details.

What next?

Thanks for your help.

Gerald
Re: Listener Failed on New SUSE server [message #141299 is a reply to message #141298] Sat, 08 October 2005 03:55 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member
Pintoguiness wrote on Sat, 08 October 2005 14:19



but when I run the command- I only see this:

:/opt/oracle/product/10.2.0/db_1/bin # ls -1 lsn*
lsnrctl
lsnrctl0

no details.



the above command is ls -l lsn* not ls -1(one) . replace 1 by l (l for listener).

But the lsnrctl command is present in your computer , now what is the output if you run the following command as Oracle user.

:/opt/oracle/product/10.2.0/db_1/bin #lsnrctl start
 





Re: Listener Failed on New SUSE server [message #141300 is a reply to message #141292] Sat, 08 October 2005 04:01 Go to previous messageGo to next message
Pintoguiness
Messages: 5
Registered: October 2005
Junior Member
I don't know what we did but it looks like its working:

The command completed successfully
oracle@edgecon:~/product/10.2.0/db_1/bin> ls -l lsn*
-rwxr-x--x 1 oracle oinstall 106655 2005-10-07 19:32 lsnrctl
-rwxr-xr-x 1 oracle oinstall 0 2005-06-30 19:16 lsnrctl0

and

oracle@edgecon:~/product/10.2.0/db_1/bin> lsnrctl start

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 07-OCT-2005 22:52:52

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

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

TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /opt/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /opt/oracle/product/10.2.0/db_1/network/log/listener.logListening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=edgecon.site)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 07-OCT-2005 22:52:54
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /opt/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /opt/oracle/product/10.2.0/db_1/network/log/listener.l

So, thank you very much.

Another question: Is it possible to install the Apache webserver after doing the Oracle install?

Thanks again

Gerald
Re: Listener Failed on New SUSE server [message #141302 is a reply to message #141300] Sat, 08 October 2005 04:11 Go to previous messageGo to next message
Pintoguiness
Messages: 5
Registered: October 2005
Junior Member
Also,

Where do I put this command:

lsnrctl start

so that the machine starts the listener on startup?

Thanks

Gerald
Re: Listener Failed on New SUSE server [message #141303 is a reply to message #141302] Sat, 08 October 2005 04:18 Go to previous message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member


Read the installation doc for Linux, the steps are mentioned there.
This is an excerpt from the docs

Quote:


Edit the /etc/oratab file setting the restart flag for each instance to 'Y':
TSH1:/u01/app/oracle/product/9.2.0.1.0:Y

Create a file called /etc/init.d/dbora containing the following:
#!/bin/sh
# description: Oracle auto start-stop script.
# chkconfig: - 20 80
#
# Set ORA_HOME to be equivalent to the $ORACLE_HOME
# from which you wish to execute dbstart and dbshut;
#
# Set ORA_OWNER to the user id of the owner of the
# Oracle database in ORA_HOME.
ORA_HOME=/u01/app/oracle/product/9.2.0.1.0
ORA_OWNER=oracle
if [ ! -f $ORA_HOME/bin/dbstart ]
then
echo "Oracle startup: cannot start"
exit
fi
case "$1" in
'start')
# Start the Oracle databases:
# The following command assumes that the oracle login
# will not prompt the user for any values
su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl start"
su - $ORA_OWNER -c $ORA_HOME/bin/dbstart
;;
'stop')
# Stop the Oracle databases:
# The following command assumes that the oracle login
# will not prompt the user for any values
su - $ORA_OWNER -c $ORA_HOME/bin/dbshut
su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl stop"
;;
esac

Use chmod to set the privileges to 750:

chmod 750 /etc/init.d/dbora

Link the file into the appropriate run-level script directories:

ln -s /etc/init.d/dbora /etc/rc0.d/K10dbora
ln -s /etc/init.d/dbora /etc/rc3.d/S99dbora

Associate the dbora service with the appropriate run levels:

chkconfig --level 345 dbora on





but you also go through the installtion docs. It will help you in future.

regards,
tarun
Previous Topic: Urgent help with ip route!!
Next Topic: Oracle Automatic startup/shutdown on Fedora Core
Goto Forum:
  


Current Time: Fri Mar 29 07:24:17 CDT 2024