Re: Cannot connect...:(

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