- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- 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-28-2002 08:11 AM
тАО09-28-2002 08:11 AM
Can only start the Oracle listener as root!
Oracle8i Enterprise Edition Release 8.1.5.0.0 -Production With the Partitioning and Java options PL/SQL Release 8.1.5.0.0 - Production
I am trying to figure out why it is that after we reboot we can only start the listener as root. When we attempt to start it as another user, for example as Oracle, the following error is displayed:
=========================================
TNSLSNR for Intel SVR4 UNIX: Version 8.1.5.0.0 - Production on 28-SEP-02 10:23:14
(c) Copyright 1998 Oracle Corporation. All rights reserved.
System parameter file is /oracle/network/admin/listener.ora Log messages written to /oracle/network/log/listener.log Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
Attempted to listen on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
TNS-12541: TNS:no listener
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
(c) Copyright 1998 Oracle Corporation. All rights reserved.
System parameter file is /oracle/network/admin/listener.ora Log messages written to /oracle/network/log/listener.log
=========================================
However, after the system has restarted and the listener is reinitialized, we can stop and then re-start it as Oracle???
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-28-2002 12:33 PM
тАО09-28-2002 12:33 PM
Re: Can only start the Oracle listener as root!
One thing I would look for is files that have root ownership that should be owned by oracle.
live free or die
harry
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-28-2002 12:46 PM
тАО09-28-2002 12:46 PM
Re: Can only start the Oracle listener as root!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-29-2002 12:36 AM
тАО09-29-2002 12:36 AM
Re: Can only start the Oracle listener as root!
the "No such file or directory" suggests that a certain file is missing, but if root can start the listener, the file in question must then either have been created or modified by root.
The next time you boot your server you could do a simple search for that file:
1) touch a file immediately before you startup the listener as root, e.g.
# touch /tmp/after_this
2) startup the listener as root
3) # find /oracle -newer /tmp/after_this
This should only show files modified since creation of /tmp/after_this, but if too many files appear, then limit the scope to files with changed inode info:
# find /oracle -newer /tmp/after_thisc
see also man page for find.
regards,
John K.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-29-2002 07:41 AM
тАО09-29-2002 07:41 AM
Re: Can only start the Oracle listener as root!
conversant >find /oracle -newer /tmp/after_this
/oracle/network/log/listener.log
/oracle/oradata/A/control01.ctl
/oracle/oradata/A/control02.ctl
/oracle/.sh_history
However, after checking, I realized that ownerships of those files did not change. What is very weird is that this only happens when trying to initilize the listener right after a reboot. After it is initialized with root, if manually stopped once again, it can be restarted with the oracle login.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-29-2002 07:42 AM
тАО09-29-2002 07:42 AM
Re: Can only start the Oracle listener as root!
Why don't you set SUID on your oracle start up script
chmod g+s oracle
HTH
Steve
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-29-2002 09:35 AM
тАО09-29-2002 09:35 AM
Re: Can only start the Oracle listener as root!
the oracle user may have access problems. Can the oracle user create a file in /oracle/network/log?
Naughty question, but I have to ask: does the listener.log exist after a reboot?
regards,
John K.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-29-2002 09:51 AM
тАО09-29-2002 09:51 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-29-2002 11:27 AM
тАО09-29-2002 11:27 AM
Re: Can only start the Oracle listener as root!
I'm a bit low on ideas now, but perhaps my basic assumption is wrong. Does the error message originally posted by you appear every time the oracle user attempts to start the listener? Is there an error message when root starts the listener?
regards,
John K.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-29-2002 11:46 AM
тАО09-29-2002 11:46 AM
Re: Can only start the Oracle listener as root!
Bill Hassell, sysadmin