Re: Remote connection in SQLplus: ORA-06401: NETCMN....

>"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
news:ucm12l1b1qq387_at_corp.supernews.com...
>
> No
> Yes, once the tnsnames.ora has been setup correctly
> Oracle Client Administrator is dead and has been replaced by the net8
> assistant
> However, it seems you still don't understand or try to understand my reply
> Your tnsnames.ora IS correct, and you should be able to connect using

I know that my TNSNAMES.ORA is correct! And every day I use:
> <username>/<password>@main

But how SQLplus on other computers (i.e. university.computer.edu) can know what and where is "main"?
The F.... Manual (Oracle9i Net Services Administrator's Guide Release 1 (9.0.1) Part Number A90154-01)
describes clearly:

    CONNECT username/password_at_connect_identifier

(http://otn.oracle.com/docs/products/oracle9i/doc_library/901_doc/network.90 1/a90154/connect.htm#430042)
but it says that connect_identifier must describe how to access to my computer and instance. Isn't it?
OK.
Connect_identifier is described in
http://otn.oracle.com/docs/products/oracle9i/doc_library/901_doc/network.901 /a90154/connect.htm#435637
as for example

    CONNECT
scott/tiger@'(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sales-server)

    (PORT=1521))(CONNECT_DATA=(SERVICE_NAME=sales.us.acme.com)))' so I think I can use it everywhere.
As you can see there is no word about tnsnames.ora in original Oracle manual.
I tried:

    CONNECT
system/***@'(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=my.host.net)

    (PORT=1521))(CONNECT_DATA=(SERVICE_NAME=main)))' and:
1. this syntax DOES NOT WORK on remote/university (university.computer.edu) computer - ORA-06401: NETCMN: invalid driver..... (I've wrote this in my first post)
2. this syntax works on my computer (my.host.net) (but it is not necessary because I use CONNECT system/***@main - and it is normal) 3. is there a shorter way? Oracle Manuals don't specify all possible connect_identifier syntaxes

> If you think you can't connect please include any pertinent error messages

> instead of ignoring my reply.

The error number was in my first post.

>
>
> Regards
>
>
> --
> Sybrand Bakker
> Senior Oracle DBA
>
> to reply remove '-verwijderdit' from my e-mail address
>
>
Received on Sun Apr 28 2002 - 17:51:34 CDT