Re: Oracle9i installation - Oracle Net Services problems

Embedded ...

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.
 

Please look at some of the Oracle resources:

1. documentation is available at - http://docs.oracle.com >> Oracle9i Release 2 >> Vew Library >> List of Books
   • the minimum set of documents that are required reading (skimming) for you include the 'Concepts', 'Application Developer's Guide - Fundamentals' and 'Java Developer's Guide'
2. Oracle By Example provides guidance and screen shotsfor installation and many simple tasks. http://otn.oracle.com/obe ... I'm sure you're smart enough to be able to translate between operating systems.
3. Sample Code is available in the pull-down boxes on the OTN main screen http://otn.oracle.com

> 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...
> =====

Oracle works on the premise that ROOT should almost never be used, therefore all Oracle executables are owned by the userid that installed the product, and group membership is used to permit many operations.

The last thing happening in a proper install is to run a shell script as root that wil change all permissions and ownerships appropriately. After that, root should never be used to start or stop ORacle 'things', and many Oracle products [used to?] actively complain about the attempt to use root.

>
> 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.
>

Either start the listener as the user that installed ORacle, or as a user that has access to the 'DBA' group (usually set to 'dba' during install.)

HTH
/Hans Received on Mon Sep 27 2004 - 09:12:08 CDT