Re: SQL*NET questions

In article <30jlqe$3mk_at_apakabar.cc.columbia.edu>, sb63_at_ciao.cc.columbia.edu (Semyon Basin) writes:
|> Hi, Netters!
|> I am an INGRES DBA for our site.
|> For some unknown reason i was asked to perform an ORACLE installation.
|> It went smoothly though.
|> I just can not understand how SQL*NET works.
|> The questions are:
|> 1. What starts it?
|> 2. How can i verify if it's running?
|> 3. How can i stop it?
|> 4. Are there any background processes associated with it?
|> 5. What are their names?
|> I can not get it from just reading a manual.
|> May be because i'm stupid or the manual is not so well written.
|> I know a lot about Unix, but very little about ORACLE.
|> We are running ORACLE version 7.0.16 on DEC Ultrix 4.3.
|> SQL*NET version 2.0 for TCP/IP.
|> Please, help me.
|> If you need any additional info i would be glad to provide it.
|> Thanx in advance.
|> George

The Sql*Net product itself is mostly libraries linked into the Oracle kernel. The associated processes come from listeners for connections coming in using your favorite protocol. Depending on whether you have Sql*Net v1 or v2, there are different scenarios.

In v1, each protocol had its own listener process (eg. orasrv for TCP/IP, spxsrv for SPX etc.) For v2, there is a generic listener process tnslsnr that listens for connections on all protocols. For more info, you can check out the Tools for Unix Administrator's Guide -- it has a chapter on almost every driver and adaptor.

-- 
<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-->->->->->->->->->->->->->->->->->->->->
Sujay Parekh			Technical Assistance Center, Product Line
sparekh_at_us.oracle.com		Worldwide Technical Support