Help : SQLNET v1.2 on TCP/IP (Multinet)
Date: 27 Jun 94 20:38:54 -0400
Message-ID: <1994Jun27.203854.848_at_rcwusr>
HELP ! HELP ! - SQL*NET V1.2 for TCP/IP (VMS)
Recently I tried to install SQL*NET v1.2 running TCP/IP protocol using Multinet
(VMS version), when I wanted to activate the listener process TCPSRV, a message
showed "TCPUTL : Listener is busy/not responding ". That process TCPSRV indeed
started , but whatever command I used with TCPCTL such STATUS or LOG etc still
gave me the same message. Initially I thought it might be due to the service ,
so I went into MULTINET CONFIGURE/SERVER , and I used SHOW, no service name
with ORASRV started.Then I thought I should add a service physically in
Multinet , and I used ADD ORASRV , it prompted and I entered :
protocol => TCP
PORT => 1525
program to run => ORQ_SQLNET:TCPSRV.EXE
and then I RESTART , and did a SHOW again . The service ORASRV displayed, and then I quit MULTINET and tried to start the listener process again TCPCTL START. This time the message showed "TCPUTL : Listener port is not (yet) available" .
The configurations for MULTINET HOSTS.LOCAL file as follow :
SERVICE : TCP : 1525 : ORASRV : HOST : 192.1.3.2 : MYNODE : MICROVAX : VMS : : HOST : 127.0.0.1 : LOCALHOST : : : : NET : 127.0.0.0 : LOOPBACK-NET :
and to recompile with commands below :
$ MULTINET HOST_TABLE COMPILE
$ _at_MULTINET:INSTALL_DATABASES
and for ORA_SQLNET:CONFIG.ORA file
SQLNET SIDMAP LIVE = ORACLE$DISK:[oracle7_15.util] orauser.com
SQLNET SIDMAPDFLT = LIVE
SQLNET VALIDNODE = MYNODE
SQLNET USERNAMEMAP * = *
SQLNET TCPSRV_DEBUG = Y SQLNET ORASRV_OUTDIR = ora_sqlnet SQLNET TCPSRV_MAXCON = 128 SQLNET ORASRV_PROXY_LOGIN = YES
Can anyone out there had similar setup or problem encountered before , please advice and solution is greatly appreciated . Received on Tue Jun 28 1994 - 02:38:54 CEST