Re: The black art of SQL*Net

Jim Richards (aka Mr Grumpy) wrote:
>
> After having a look through this news group I find there are two types of
> people.
>
> 1. Those who know how to set up and start the tns listener.
> 2. And those who don't ...
>
> I an in the second category. I have a solaris box, oracle 7.3.2 and a win95
> box. I have sql*net v2 ... all the files appear correct, and look nice.
>
> Does anyone have any of the "ah ha" experiences in getting it going that
> they would like to share?
>
> As far as I get when in developer/2000 I enter the connect string of
> devl (the instance name, or SID for the purists) I get the two errors
> PDE-PUP004 which means oracle7 had an error and ORA-12154 and if I use
> the connect string of t:bismark:devl i get the same pup error but
> ORA-6105.
>
> Now because I have the documentation on CD I cannot seem to find the
> error messages.
>
> Any ideas?
>
> --
> "Strive to be the Spock of Programming. Accept only what is logical.
> Reject that which has no explanation."
> This was brought to you by jimr_at_aone.net.au, Access One ... Ph +61 2 391 0727

--

Well not sure about W95 but on NT I use Dev2000 to connect to a DEC Alpha 1000
running DEC UNIX and Oracle 7.2.3 using SQL*Net V2

Make sure you have tnsnames.ora in C:\ORAWIN\NETWORK\ADMIN
(i.e. tnsnames.ora contents)

PRD1 =
  (DESCRIPTION = 
    (ADDRESS_LIST = 
        (ADDRESS = 
          (PROTOCOL = TCP)
          (Host = cimdbs.cob.cummins.com)
          (Port = 1521)
        )
    )
    (CONNECT_DATA = (SID = PRD1)
    )
  ) 

There is a sqlnet.ora file also in the same directory mine is the sample file.

Everything worked out of the box on the NT side.  I installed and had things working
on the UNIX side before installing Dev2000

Hope it helps.

=======================================================================
   CCCCC     Todd A. Wood                tawood_at_cob.cummins.com     
 CC          Senior Systems Analyst      Cummins Engine Company, Inc.  
 CC ummins   Corporate CIM Team          500 Jackson Street, MC 60202  
 CC          Manufacturing Engineering   Columbus, IN  47201           
   CCCCC                                 812-377-4637                  
=======================================================================