Re: sqlnet V1 connect string - Oracle7 ?

Daniel,

In article <2hv56j$dmr_at_gap.cco.caltech.edu> dbikle_at_cco.caltech.edu (Daniel B. Bikle) writes:

>Hi There,
 

>Let me know if you have seen this:
 

>When we attempt to use a sqlnet V1 connect string we get an error:
 

> ORA-06401
 
>Here is a simple demo:
 

>oooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooo
>eve:dbikle% envg orac
>ORACLE_HOME=/db/test
>ORACLE_SID=test
>eve:dbikle% setenv TWO_TASK T:eve:test
>eve:dbikle% sqlplus scott/tiger
 

>SQL*Plus: Release 3.1.2.3.1 - Production on Sat Jan 22 22:57:41 1994
 

>Copyright (c) Oracle Corporation 1979, 1992. All rights reserved.
 

>ERROR: ORA-06401: (Cnct err, can't get err txt. See Servr Msgs & Codes
>Manual)
 

>Enter user-name: ^c
 

>eve:dbikle%

I haven't tried using SQL*Net on Unix yet, but got the same error message when fooling around with SQL*Net for DOS and Windows. Have you tried to define  the sqlnet alias in the /etc/hosts file (as described on page 4-4 of the SQL*Net TCP/IP User's Guide)? Another work-around could be using the /etc/sqlnet file to define an alias for T:eve:test.

Hope this helps,
Karel

| Karel Sprenger, ORACLE coordinator (techn.) | Email: ks_at_ic.uva.nl    |
| Informatiseringscentrum                     | phone: +31-20-525 2302 |
| Universiteit van Amsterdam                  |        +31-20-525 2741 |
| Turfdraagsterpad 9, NL-1012 XT  AMSTERDAM   | fax  : +31-20-525 2084 |
| *** PGP Public Key available on request *** | home : +31-20-675 0989 |