Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Remote connection in SQLplus: ORA-06401: NETCMN....

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

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 27 Apr 2002 19:16:29 +0200
Message-ID: <ucm12l1b1qq387@corp.supernews.com>

"czorny" <czorny_news_at_o2.pl> wrote in message news:aaeki8$1e1$1_at_sunsite.icm.edu.pl...
>
> "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
>
>

No
Yes, once the tnsnames.ora has been setup correctly Oracle Client Administrator is dead and has been replaced by the net8 assistant
However, it seems you still don't understand or try to understand my reply Your tnsnames.ora IS correct, and you should be able to connect using <username>/<password>@main
If you think you can't connect please include any pertinent error messages instead of ignoring my reply.

Regards

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address
Received on Sat Apr 27 2002 - 12:16:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US