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

Tom,

I tried to respond to the email you sent me, but it bounced back a couple of times, so I will post this to the neswgroup in case you shoul;d find this usefull. Sorry about the uuencode to the ng, figured you might need to use it.

Jc.

550 <oomph_at_concentric.com>... Host unknown (Name server: no.more.mail.concentric.com.: host not found)  

• Original message follows ----- Return-Path: <JCARRON_at_ca.oracle.com> Received: from caofcdec1.ca.oracle.com by inet-smtp-gw-1.us.oracle.com with SMTP (8.6.12/37.7) id LAA31126; Sat, 12 Oct 1996 11:26:58 -0700 Received: by caofcdec1.ca.oracle.com (5.65v3.2/37.7) id AA20582; Sat, 12 Oct 1996 13:55:24 -0400 Message-Id: <9610121755.AA20582_at_caofcdec1.ca.oracle.com> Date: Sat, 12 Oct 1996 13:55:24 -0400 From: "Jerome Carron" <JCARRON_at_ca.oracle.com> To: oomph_at_concentric.com Subject: Re: Need help for NT client Cc: jcarron_at_ca.oracle.com X-Orcl-Application: In-Reply-To:UNIX.CA.ORACLE.COM:oomph_at_concentric.com's message of 11-Oct-96 08:29 Mime-Version: 1.0 Content-Type: multipart/mixed; boundary=Boundary-3655304-0-0

--Boundary-3655304-0-0  

Tom,   

I have included (below) in this message the tnsping.exe program as tnsping.zip. However since I didn't know if your mail gateway supports mime,
I therefore uuencoded the file. All you need is a utility like uudecode for
Windows or any Unix decode should work fine. I suggest you only use this with
SQL*Net v2, I got this from the ORacle 7.3 CD, hopefully it should be fine
even if you are using 7.2 and sqlnet 2.2. Also here is a sample tnsnames.ora.   

CADMSHP1.world =
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS =   
          (COMMUNITY = cadms_tcp.world)  
          (PROTOCOL = TCP)  
          (Host = 140.87.36.11)  
          (Port = 1521)  
        )  

       (SID = ORCL)  
       (GLOBAL_NAME = CADMSHP1.world)  

Remember that if you have a file called SQLNET.ORA in which you have the
following line
names.default_domain = world
name.default_zone = world   

it will always append .wolrd to any connection, so you can remove them or
comment them out with the #.   

Hope this helps,
Jerome.

section 1/1 file tnsping.zip [ Wincode 2.7.2 ]

begin 644 tnsping.zip
<uuencoded_portion_removed>
+`#D```"U]_at_``````
`
end
sum -r/size 19037/63236

section 1/1 file tnsping.zip [ Wincode 2.7.2 ]  

jc,
Thanks for responding to my comp.databases.oracle post. I did run the

installer and
installed both the SQL NET and the TCP/IP adapter. Unfortunately, there
is no
executable in my /bin directory that will allow me to test the installation.
Based on your response, I will look for tnsping.exe or nettest.exe. Alas, I am not
on compuserve, so I will continue to try Oracle's www/ftp server. BTW,
I did
set up two config files, tnsnames and, er, one other whose name escapes
me at
the moment.  

Regards,
Tom Gordon Received on Sun Oct 13 1996 - 00:00:00 CEST