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

From: czorny <czorny_news_at_o2.pl>
Date: Fri, 26 Apr 2002 10:49:11 -0700
Message-ID: <aab48m$9jg$1@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 - 12:49:11 CDT