Re: Need help for NT client

On Wed, 09 Oct 1996 00:45:37 -0400, Tom Gordon <oomph_at_concentric.com> wrote:

>I'd be grateful for any light on my problems.
>
>OK. I have a Smalltalk application that uses Oracle. Works fine on
>Unix, Mac,
>Windows 3.1 and 95. I am now trying to get the Windows NT Oracle client
>to work.
>
>I called Oracle and ordered SQL Net for NT, for TCP/IP. First of all,
>the box
>that Oracle sent was labeled TCP/IP Adapter; nothing about SQL Net.
>
>I started the installation program on NT and was relieved to find that
>indeed,
>it contained not only the TCP/IP adapter but also SQL Net 1 and 2.
>
>I installed the client and adapter. My Smalltalk program could not load
>the
>oracle libraries. So, I want to test the oracle client by itself to see
>if that
>part is working. Well, the CD contains no NETTEST program, which I have
>seen on
>other platforms, not to mention maybe sqlplus. The only executables I
>have are
>the installation program and the pro-c compiler (I also installed that
>just for fun).
>
>My question is: does Oracle make a nettest program for NT?
>
>Read on if you are interested in why I am disappointed with Oracle.
>
>I have a vague feeling that I am missing the complete SQL Net product.
>First,
>the box makes no mention at all that it contains SQL Net, only the
>TCP/IP
>adapter. That includes my invoice. Second, I am missing any way to
>test
>whether the client that I supposedly installed actually works or not.
>What happened to nettest?
>
>I am aware of the Oracle home page and ftp server. For three nights
>now, I have
>tried to connect to them. I cannot get through. That is one reason I
>am posting
>this article.
>
>The most disappointing thing was Oracle support. I called them, and,
>after waiting
>for the obligatory twenty minutes, they asked for my something-or-rather
>number.
>Then, when I gave it to them, right off my invoice, they said that it
>was
>invalid. They transfered me to someone else so they could verify the
>purchase.
>After waiting for another ten minutes, I got a recording that instructed
>me
>to leave my name and number; they would call me back. I did so, and
>that
>was three days ago, and they have not called me back.
>
>Thanks for any info. It really should not be so hard to determine
>whether
>something I bought works or not, should it?
>
>Tom Gordon
>oomph_at_concentric.net

These would be my suggestions.

1. check the CD that you have, and run the orainst.exe or setup.exe file from the nt_x86/install directory.
2. Once you have the installer up, check the right side to see the components that are available. SQL*Net has 2 components, SQL*NET itself and an adapter of your choice depending on the network protocol you intend to use. So in your case you should select , both SQL*NET and the TCP/IP adapter. (both of these should be on the same CD), if not then you need to get the SQL*Net portion.
3. If you choose to use SQL*Net v2 then you must setup a TNSNAMES.ORA and put it in your ORACLE_HOME\network\admin. Below that dir you have a sample directory that should have a sample you can look at.
4. You can choose to use SQL*NEt v1, then connect string would look something like T:ip:sid
5. Which ever you use check to see if you have an executable called TNSPING.exe or nettest.exe or something similar in ORACLE_HOME/bin. In any case you can also download one from the Oracle User forum on Compuserve, not the pay forum. This was written by someone at Oracle.

Hope this helps,
Jc.
jcarron_at_ca.oracle.com Received on Thu Oct 10 1996 - 00:00:00 CEST