Re: Cannot connect...:(

Thanks!

I actually got it work after I copied the exact same config files from $ORACLE_HOME/network/admin/ on NT to my linux client machine.

On Thu, 15 Apr 1999, Frank van Bortel wrote:

> Zailong Bian wrote:
>
> > I installed Oracle for linux 8.05. When I try to use sqlplus to access a
> > NT box, i always get error like:
> >
> > ERROR:
> > ORA-06401: NETCMN: invalid driver designator
> >
> > I set TWO_TASK=T:oracle7:ORCL.
> >
>
> That's oracle 7 - you said you installed 805?
>
> > Anyone knows how to access a remote oracle server with sqlplus? Which
> > configuration files I need to change?
>
> Seems mistical as always...
> First, the two task driver was abondoned with O8, you'll now have to use
> the bequeth driver. This won't help you, as you want to access a _remote_
> server!
> Assuming you have tcp/ip set up as protocol:
> 1) PING the NT machine (let's call it ORANT) from the Linux box. If you can
> ping it by address, fine
> 2) If that works (if it doesn't get your network in order first!),
> edit your tnsnames.ora file.
> Add the following line:
> orant.world=(DESCRIPTION = (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP) (Host = orant) (Port = 1521))) (CONNECT_DATA
> = (SID = orant SID)))
>
> The Host= bit may have the IP-address in stead of the name, e.g.
>
> orant.world=(DESCRIPTION = (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP) (Host = xxx.yyy.aa.b) (Port = 1521)))
> (CONNECT_DATA = (SID = orant SID)))
>
> 3) Tho not sure if this is available with Linux, test the above by using
> 'tnsping orant'
> 4) You should now be able to connect by using:
> PLUS80 uid/passwd_at_orant
>
> One remark: the orant in orant.world may be anything, but I like to keep it
> the same as the machine name.
> I have been administrating several instances, and the official naming
> conventions where machine_instance,
> which resulted in things like NLNT10_DES2, or UKUX22_TOOLS - but I always
> added a second, 'shorthand'
> notation like D132 for a designer/2000 V132 repository instance. In that
> case, the entries in tnsnames.ora
> were:
> nlnt10_des2.world=(DESCRIPTION = (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP) (Host = nlnt10) (Port = 1521))) (CONNECT_DATA
> = (SID = des2)))
>
> d132.world=(DESCRIPTION = (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP) (Host = nlnt10) (Port = 1521))) (CONNECT_DATA
> = (SID = des2)))
>
> See what I mean? Two aliases, the same machine/instance.
>
> All of the above is also assuming, you can access the remote NT machine from
> other locations,
> using SQL, or anything else that uses SQL*Net.
> --
> Met vriendelijke groet,
> kind regards,
>
> Frank van Bortel
> Technical consultant Oracle
> V&L Informatica BV
> -----------------------------------------------
> Work Home
> Postbus 545 Hunzestraat 4
> 7500 AM Enschede 7555 WB Hengelo
> (31)53.434.1500 (31)74.242.5046
>
>
Received on Thu Apr 15 1999 - 07:34:43 CDT