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

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

OK OK OK
Don't be so angry :)

I am simply asking if:
- is it possible to connect to remote database using NET8 without editing TNSNAMES.ORA file???
- is it possible to connect to remote database using NET8 without permission to edit TNSNAMES.ORA file???
- is it possible to connect to remote database using NET8 without help of ..... Oracle Clinet administrator???
- and how to do this???

CZORNY Received on Sat Apr 27 2002 - 20:45:56 CDT