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

What Sybrand has been saying to you is that your tnsnames.ora file is perfectly correct, and the correct syntax for any connection, remotely or not, is connect X/Y_at_MAIN (ie, you put the tnsnames alias after the "@", not the stuff you were putting there).

However, I think the point that may have been missed is that your remote connection needs to be made from a machine onto which the Oracle client has been installed. You will then, on that remote machine, have an ORACLE_HOME\network\admin directory. You need then simply copy the tnsnames.ora that you already have working on the one machine into that directory on the other, and then you should be able to connect in the fashion I've described above (ie, using the tnsnames.ora alias).

HJR "czorny" <czorny_news_at_o2.pl> wrote in message news:aab48m$9jg$1_at_sunsite.icm.edu.pl...
> I try to connect to my database from another host using SQLplus and the
> statement:
> connect system/***@my.host.net:1521:mysid;
> but it cause only an error:
> ORA-06401: NETCMN: .....
> When I'm using
> CONNECT
> system/***@'(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=my.host.net)
> (PORT=1521))(CONNECT_DATA=(SERVICE_NAME=mysid)))'
> everything is OK.
> My tnsnames.ora contains:
> MAIN =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = tcp)(HOST = my.host.net)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = mysid)
> )
> )
> Anyone knows where is the mistake/bug? How can I connect remotely?
>
>
Received on Fri Apr 26 2002 - 17:24:40 CDT