- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Can only start the Oracle listener as root!
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-29-2002 12:03 PM
тАО09-29-2002 12:03 PM
Re: Can only start the Oracle listener as root!
What does "INTEL" SVR5 mean? Is this an install on Solaris??
TNS-12560: TNS:protocol adapter error TNS-00511: No listener
Intel SVR4 UNIX Error: 2: No such file or directory
TNSLSNR for Intel SVR4 UNIX: Version 8.1.5.0.0 - Production on 28-SEP-02 10:24:58
Oracle is so great at it's error messages that future programmers should take note to make sure that they never follow oracle's lead, then maybe sometime in the future we'll have code that actually produces meaningful error messages and clues to the corrective action.
live free or die
harry
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-29-2002 12:37 PM
тАО09-29-2002 12:37 PM
Re: Can only start the Oracle listener as root!
John, the answer to your question is no. The error only appears when a user other than root attempts to restart the listener right after a reboot. It does not appear, however, after root has restarted it and if it is manually stopped after that, it can be re-started by oracle (I have not attempted other users to restart the listener after it is stopped the first time). No error when root does the attempt at any point.
Bill, I certainly am not sure if the installation was performed using root. The installation of oracle was done by AVAYA folks, so I will have to find out. However, everything seems to be working fine with the exception of the described problem.
Harry, this is not an HP-UX. We do use Oracle in two of our HP-UX systems, 10.2 and 11.0. The 11.00 has 8.x What the "Intel SVR4 UNIX Error: 2: No such file or directory" means? I am not sure. This is a "SCO UnixWare 7.1.1" system.
Thanks everyone...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-29-2002 11:57 PM
тАО09-29-2002 11:57 PM
Re: Can only start the Oracle listener as root!
last suggestion... I originally concluded that the "No such file or directory" message meant that a certain file was expected but not present (and could not be created). As the error does not appear for root, it makes me believe that the file in question can be - and is - created by root. Last attempt would be to repeat my first search suggestion, but then not only under the /oracle dir.
regards,
John K.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-30-2002 12:50 AM
тАО09-30-2002 12:50 AM
Re: Can only start the Oracle listener as root!
Check $ORACLE_HOME/bin/dbsnmp permissions, make sure the sticky bit is set.
-rwsr-s--- 1 root dba 9555968 Mar 26 2002 dbsnmp
I believe this talks with the listener.
Share and Enjoy! Ian Dennison
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-30-2002 03:31 AM
тАО09-30-2002 03:31 AM
Re: Can only start the Oracle listener as root!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-30-2002 03:47 AM
тАО09-30-2002 03:47 AM
Re: Can only start the Oracle listener as root!
Why not call Oracle, being that it's those lazy bums that don't know how to write appropriate error messages?
live free or die
harry
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-30-2002 04:55 AM
тАО09-30-2002 04:55 AM
Re: Can only start the Oracle listener as root!
Rgds
Johan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-30-2002 05:42 AM
тАО09-30-2002 05:42 AM
Re: Can only start the Oracle listener as root!
if you delete the /tmp after reboot, you should start searching there.
regards,
John K.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-30-2002 06:45 AM
тАО09-30-2002 06:45 AM
Re: Can only start the Oracle listener as root!
The problem is around file permissions (directory) for socket files.
You would have to check for the right directory re you rsystem :
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
You receive the following messages in the "listener.log" file: TNSLSNR for Solaris: Version 8.0.5.0.0 - Production on 07-JUL-99 18:43:51 (c) Copyright 1997 Oracle Corporation. All rights reserved. System parameter file is /infosys/oracle/tnsadmin/listener.ora Log messages written to /var/log/oracle/sqlnet/lsnr01.log Attempted to listen on: (DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(PROTOCOL=IPC)(KEY=ipckey))) TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener Solaris Error: 2: No such file or directory" Solution: ========= The Listener requires access to the directory '/var/tmp/oracle' in order to write socket files. The socket files are used for internal pipe connections to the database. Make sure that the Oracle user is the owner in this directory and has full permissions to it. Problem Explanation: ==================== The ORA-12541 is actually cause by a Unix/Solaris error #2 :No such file or directory. This can be caused when the Listener attempts to access internal pipes socket files.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Jean-Luc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-30-2002 07:59 AM
тАО09-30-2002 07:59 AM
Re: Can only start the Oracle listener as root!
Also, make sure the port number you are trying to use is > 1024 (not privileged).