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

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

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

Then I must enter something like the first syntax.

Absolute nonsense!

And this

>> >system/***@'(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=my.host.net)
>> > (PORT=1521))(CONNECT_DATA=(SERVICE_NAME=mysid)))'
is exactly equivalent to

this

>> > MAIN =
>> > (DESCRIPTION =
>> > (ADDRESS_LIST =
>> > (ADDRESS = (PROTOCOL = tcp)(HOST = my.host.net)(PORT = 1521))
>> > )
>> > (CONNECT_DATA =
>> > (SERVICE_NAME = mysid)
>> > )
>> > )

So this question
>Or I should correct tnsnames.ora?

is also nonsense.

For some reason, you seem to think you need to use sqlnet1 syntax. It looks like this will end you up with a v1 error message as the v1 syntax is
driver designator:hostname:port

You are using net8, not the jdbc driver, aren't you?.

However, you seem to know better,

(>Yes, it is true - when I am working localy.   which is also nonsense, if you have set ORACLE_SID you won't need to enter anything)

so I don't think you can be helped at all.

Regards and RTFM, you're asking for it.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Apr 26 2002 - 11:59:34 CDT