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

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 26 Apr 2002 17:13:42 +0200
Message-ID: <0jricuo5hue8fte0e40ae2350nov1ostv8@4ax.com>

On Fri, 26 Apr 2002 10:49:11 -0700, "czorny" <czorny_news_at_o2.pl> wrote:

>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?

The first connect is simply not proper syntax. period. sqlplus system/manager_at_main (which is your service name in tnsnames.ora should work).
I wonder why Oracle provides manuals.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Apr 26 2002 - 10:13:42 CDT