is sqlnet installed?

From: Kirill Richine <kirill_at_cs.ualberta.ca>
Date: 1996/05/07
Message-ID: <4mno9m$ngf_at_scapa.cs.ualberta.ca>#1/1


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
oracle 22958     1 22958 22958 80   Mar 29 ?          2:01 ora_dbwr_prod
oracle 22960     1 22960 22960 80   Mar 29 ?         27:49 ora_smon_prod
oracle 22961     1 22961 22961 80   Mar 29 ?          0:20 ora_reco_prod
oracle 22957     1 22957 22957 80   Mar 29 ?          0:11 ora_pmon_prod

Does anybody know what each of these processes correspond to, how and who decides that they should be launched?

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.

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.

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?

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?

Thank you.
k& Received on Tue May 07 1996 - 00:00:00 CEST

Original text of this message