Operating System - HP-UX
1747983 Members
4457 Online
108756 Solutions
New Discussion юеВ

Re: Could not start Oracle listener

 
zhaogui
Super Advisor

Could not start Oracle listener

How come I could not start Oracle listener? Following is the error message.
Thanks,

$ lsnrctl start EBTCIA

LSNRCTL for HPUX: Version 8.1.7.3.0 - Production on 16-AUG-2002 10:41:43

(c) Copyright 1998 Oracle Corporation. All rights reserved.

Starting /app/oracle/product/8.1.7/bin/tnslsnr: please wait...

TNSLSNR for HPUX: Version 8.1.7.3.0 - Production
System parameter file is /app/oracle/product/8.1.7/network/admin/listener.ora
Log messages written to /app/oracle/product/8.1.7/network/log/ebtcia_listener.log
Trace information written to /app/oracle/product/8.1.7/network/trace/ebtcia_listener.trc
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=msdbp1)(PORT=1523)))
Attempted to listen on: (ADDRESS=(PROTOCOL=ipc)(PARTIAL=yes)(QUEUESIZE=1))
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=msdbp1)(PORT=1523)))
TNS-12546: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00516: Permission denied
HPUX Error: 13: Permission denied
6 REPLIES 6
Yogeeraj_1
Honored Contributor

Re: Could not start Oracle listener

Hi,

Oracle Corporation allows port numbers from 1 to 65535. Port numbers below 1024 are reserved for use by privileged processes on many operating systems.

If your listener is configured to use a port number below 1024, you will not be able to start it using LSNRCTL utility. LSRNCTL, even if it is running as root, cannot start the listener as root (on UNIX systems), however, you can always run the listener executable (tnslsnr) as a root.

This can be done by entering the following command:

tnslsnr listener_name

at the operating system prompt.

Note that after the listener has been started it can be further administered (including stopping it) by the LSNRCTL utility.

Hope this helps!
Best Regards
Yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Steven Sim Kok Leong
Honored Contributor

Re: Could not start Oracle listener

Hi,

Under which user are you attempting to start the Oracle listener? Note that the Oracle listener should be started using the oracle account if oracle is defined as the Oracle administrative account. Otherwise, permission is denied.

Try this:

# su - oracle
$ lsnrctl status EBTCIA

If it is already running, execute the following to restart the Oracle listener, from the Oracle account:

$ lsnrctl stop EBTCIA
$ lsnrctl start EBTCIA

If it is not running, execute the following to start the Oracle listener, from the Oracle account:

$ lsnrctl start EBTCIA

Hope this helps. Regards.

Steven Sim Kok Leong
zhaogui
Super Advisor

Re: Could not start Oracle listener

I am using oracle dba user id to start listener.

I already found out why, which not many people can think of. It is because the access permission for /tmp was set to 770. But how come listener also needs to access /tmp.
T G Manikandan
Honored Contributor

Re: Could not start Oracle listener

I would love to give you some points.

1.check the permission of the /var/tmp directory.
oracle creates some temporary files in the .oracle directory there.
I assume that it is not having permissions there.

the directory should have 1777 permissions
i.e.all permissions with sticky bit set.

2.check that you have logged in as the oracle owner.i.e.'oracle' user

3.check your tnsnames.ora file
and make sure that the alias that you are configuring in the listener.ora file is properly put up in the tnsnames.ora file withe proper alias name with TCP instead of BEQ.

4.Make sure that you don't have additional listener.ora files in the oracle_home/network/admin directory.
T G Manikandan
Honored Contributor

Re: Could not start Oracle listener

the listener creates some temporary socket files there in the /var/tmp and /tmp directories.

The directory is .oracle.
the owner of that directory should be oracle.

Just posted you found the reason.

Nice!
Thanks
harry d brown jr
Honored Contributor

Re: Could not start Oracle listener

How come I could not start Oracle listener?

Good question -> How come you can't spend more time assigning points to the 266+ responses that you have NOT acknowledged?

This member has assigned points to 45 of 311 responses to his/her questions.

http://forums.itrc.hp.com/cm/TopSolutions/1,,CA698738!1!questions,00.html

IT'S REALLY A DISSERVICE TO PEOPLE THAT TAKE THE TIME OUT OF THEIR DAY TO HELP YOU, YET YOU SHOW A WANTON DISREGARD FOR THEIR SERVICES! ISN'T IT A LITTLE SELFISH???

live free or die
harry
Live Free or Die