Re: is sqlnet installed?

In article <4mno9m$ngf_at_scapa.cs.ualberta.ca>, kirill_at_cs.ualberta.ca (Kirill Richine) says:
>
>Hi!
>
>It's UNIX, SunOS 5.3,
>ORACLE7 Server Release 7.0.15.4.0 - Production
>With the procedural and distributed options
>
>The processes are:
>
>oracle 22959 1 22959 22959 80 Mar 29 ? 1:07 ora_lgwr_prod
 Redo Log writer
>oracle 22958 1 22958 22958 80 Mar 29 ? 2:01 ora_dbwr_prod
 Database writer
>oracle 22960 1 22960 22960 80 Mar 29 ? 27:49 ora_smon_prod
 Instance Monitor
>oracle 22961 1 22961 22961 80 Mar 29 ? 0:20 ora_reco_prod
 Not sure, not on my UNIX
>oracle 22957 1 22957 22957 80 Mar 29 ? 0:11 ora_pmon_prod
 Process Monitor
>
>Does anybody know what each of these processes correspond to, how and
>who decides that they should be launched?
>
All part of RDBMS

>My goal is to start sqlnet on the server, but I not only don't know
>how to do it, I don't know how to tell if it's running.

Are you trying to run sqlnet v1 or v2 if so are you using tcp/ip,ipx/spx or named pipes ?
>
>There is a program lsnrctl in $ORACLE_HOME/bin directory. Is it the
>one that starts it?
>
>When I run it and type start, here is what happens:
>LSNRCTL> start
>
>Starting /u01/oracle/oraclebase/product/7.0.15/bin/tnslsnr: please
>wait...
>
>TNSLSNR for SVR4: Version 2.0.14.0.0 - Production
>System parameter file is /var/opt/oracle/listener.ora
>Log messages written to
>/u01/oracle/oraclebase/product/7.0.15/network/log/listener.log
>TNS-01151: Missing listener name, LISTENER, in LISTENER.ORA
>
>LSNRCTL>
>
>After this there are no new processes running, so I guess the command
>failed.
>
>I don't know, for some weirdest reason, why is it looking at
>/var/opt/oracle/listener.ora -- it's an empty file, I don't know why
>it's there, don't know who put it there, and my $ORACLE_HOME is in a
>totally different directory. How do I control which file is an
>initialization file?
>
>Also, how come there is no sqlnet.ora in my network/admin directory?
>
>Somebody said that SqlNet on UNIX is always installed, but protocols
>are optional -- well, this is a very weird set up here, it looks like
>it's all made of bits and pieces.
>

no, if you have got oracle 7.1.6.1 or above it loads sqlnet v2 automatically as it needs it for other processes if you then want to use sqlnet you need to install the 'protocol adaptor' to use the protocol you require.

>I have
>"Oracle Tools for UNIX Administrator's Reference Guide" and
>"Oracle Network Products Messages Manual"
>
>What documentation should I need to figure out all the above?
>
Understanding sqlnet
sqlnet admin guide

>Another thing yet -- where do I get sqlnet for the client (PC without
>any 95 or NT)? Is it the same as getting ODBC, or different?

distribution cd-rom or disks
>
>Thank you.
>k&
>

your'e welcome Received on Tue May 07 1996 - 00:00:00 CEST