Re: LSNRCTL.EXE problem... on VAX/VMS, TCPIP, Multinet

ncartt_at_magnus.acs.ohio-state.edu (Nicki Anne Cartt) wrote:
>
>In article <412rkp$ig6_at_inet-nntp-gw-1.us.oracle.com>,
>Jack Jung <jjung_at_ca.oracle.com> wrote:
>>Nicki;
>>
>>There should be a symbol, lsnrctl, that will invoke the sqlnet listener. This
>>symbol is created by ora_netconfig:etconfiguser.com.
>>At the operating system:
>>
>>$ lsnrctl start
>>
>>Jack
>
>
>Jack pointed me in the right direction here... and I'm writing this to
>thank those people who took the time to reply and try to help me out,
>and in case someone else out there is in the same boat.
>
>This morning we solved the network problems, here's why/how:
>
>1. I looked at NETCONFIGUSER.COM and yep, it calls LSNRCTL.COM, not the
> .EXE version I was attempting to run.
>
>2. I tried to _at_LSNRCTL (run the .COM version), and it displayed an message
> that I was missing 2 system privs necessary to start a listener.
>
>3. Granted the two missing privs to my process and the listener started
> up!
>
>4. Using the Oracle Server Manager via X-windows, was able to connect to
> 2 of our local dbs (that's all we have, a loopback on the host version),
> using "TNS:tnsnames_name" as the service name. Checked it out in
> LSNRCTL.EXE ("services") and saw that the connections looked like they
> were going through the listener.
>
>
>What have I learned... it would have been nice had LSNRCTL.EXE displayed
>a message about missing privs instead of the "file or directory missing"
>error. It would ALSO have been nice had I been able to locate the docs
>(do they exist?) which mention using NETCONFIGUSER.COM (though I did find
>it and play around with it myself)...

This may be too late for Nicki, but....

I was in a hurry and just gave you the answer. There is one command procedure that is run by all OpenVMS users to define all the symbols and logicals necessary to access an Oracle database on OpenVMS. See page Granting Access to Oracle7 Users, page 2-2 of the Oracle7 for Alpha AXP OpenVMS Administrator's Guide Version 7.1. There should be an equivalent section in the VAX OpenVMS Administor's Guide and previous releases of the manuals. On my machine it looks like this:

    $ _at_DKA0:[ORA71.71.DB_V71]ORAUSER_V71

This command procedure eventually runs netconfiguser.com, therefore it is not necessary to mention running netconfiguser.com to define the symbol LSNRCTL just like it is not necessary to run sqlforms30user.com to define the symbols for sqlforms. Run the one command procedure.

The documentation for the listener control utility, LSNRCTL, is Chapter 7 of the SQLNet Administrator's Guide.

Jack

>
>After having read all the vax/vms specific docs on cd, sqlnet and network
>manager docs on cd, and taken the time of 2 Oracle consultants, I feel it was
>mostly an act of sheer luck that I was able to get this puppy up and
>running.
>
>Good luck to every one else out there, and I hope this may be of some
>help to someone...
>
>Thanks!
>
>
>Nicki A Cartt
>
>The Ohio State University
Received on Fri Aug 25 1995 - 00:00:00 CEST