Re: Oracle9i installation - Oracle Net Services problems

On 27 Sep 2004 04:09:56 -0700, nomorezpam3_at_hotmail.com (Alan) wrote:

>I'm not an Oracle DBA and have no real experience with Oracle as yet -
>but as a Java developer - I need to install Oracle9i on my Solaris8
>machine and then try to get it running.
>
>This is not proving to be an easy task. I've run through most of the
>installation instructions (although I've no idea on what an "Oracle
>Real Application Cluster" is and it's importance in a single machine
>environment and have therefore skipped it for now)
>
>Anyway - I'm trying to start my Oracle Net Services - running "lsnrctl
>start listener" as root from my Solaris8 machine - and I get the error
>
>
>=====
>root> lsnrctl start listener
>
>LSNRCTL for Solaris: Version 9.2.0.1.0 - Production on 27-SEP-2004
>12:52:50
>
>Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
>
>Starting /apps/vendor/oracle/Database/9i/u01/app/oracle/product/9.2.0.1.0/bin/tnslsnr:
>please wait...
>
> TNSLSNR for Solaris: Version 9.2.0.1.0 - Production
> NL-00280: error creating log stream
>/apps/vendor/oracle/Database/9i/u01/app/oracle/product/9.2.0.1.0/network/log/listener.log
> NL-00278: cannot open log file
> SNL-00016: snlfohd: error opening file
> Solaris Error: 13: Permission denied
>
> Listener failed to start. See the error message(s) above...
>=====
>
>Firstly - shouldn't root have all permissions regardless of anything
>else. Secondly, this /log directory has "drwxr-xr-x" permission for
>orac9i (my oracle9i owner user) and oinst9i (my oinstall group for
>oracle9i) - and the listener.log file has -rw-rw-r-- for the same
>user/group pair.
>And finally - as the orac9i user I can echo "testing" successfully
>into this listener.log file - without any permission problems.
>
>So what goes on?
>Anyone got any thoughts?
>Many thanks
>Alan

*Always* use Oracle owner for core Oracle administration. Period.

Issue "lsnrctl start" as user orac9i and it will work. And keep root out of Oracle admin hereafter.

• Kenneth Koenraadt