| Listener Failed on New SUSE server [message #141292] |
Sat, 08 October 2005 03:15  |
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 #141297 is a reply to message #141295] |
Sat, 08 October 2005 03:40  |
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 #141299 is a reply to message #141298] |
Sat, 08 October 2005 03:55 |
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 |
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 #141303 is a reply to message #141302] |
Sat, 08 October 2005 04:18 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
