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

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:0jricuo5hue8fte0e40ae2350nov1ostv8_at_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

Yes, it is true - when I am working localy. But when I am working on other computer (my2.host.net with other Oracle 9i installation) and I want to connect to my database? Then I must enter something like the first syntax. If it is not correct what is the correct one?
Or I should correct tnsnames.ora? But what if I have not necessary privileges?
Help me please.

CZORNY Received on Fri Apr 26 2002 - 19:56:10 CDT