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: Connection with Oracle database through internet

Re: Connection with Oracle database through internet

From: Michael Gruys <gruys_at_track4.nl>
Date: Mon, 15 Jan 2001 08:20:30 +0100
Message-ID: <93u8fu$20t0$1@buty.wanadoo.nl>

I still got an error message like this:
ORA-12203: TNS:unable to connect to destination

There may be an error in the fields entered or the server may not be ready for a connection. You can check the server and retry, or continue.

It sounds unbelievable but when you connect through our INTRAnet everything works fine....
When I connect via the telephone line through an internet provider I got the error message described above.
I have checked the trace file of the Listerner on the server and it looks fine, so that's not the problem.
Also a TNSPING via the internet succeeds..... Only when you want to test with Easy Config or with Easy Assistant (test connection option) it goes wrong....

If you have any other things for me to try, or you know the solution of this problem, let met know.
Thanks in advance.

Michael Gruys

Allen Shatzer <cdaspr1_at_erols.com> schreef in berichtnieuws 93qfaa$cv0$1_at_bob.news.rcn.net...
> Yes it is possible, and I am doing it right now. Just set up your
> TNSNAMES.ORA file with the host name (or IP address) set appropriately and
> everything should be fine. The internet is just a larger version of the
 IP
> networks in use at your place of work.
>
> - Allen
>
> "Michael Gruys" <gruys_at_track4.nl> wrote in message
> news:93metn$2hi6$1_at_buty.wanadoo.nl...
> > Is it possible to reach an Oracle database through the internet WITHOUT
 an
> > Oracle Names Server??? In other words is TNSNAMES.ORA enough to define
 the
> > approxiate information to reach the server??? We have an Oracle license
> > which NOT includes de NAMES80.EXE (=Oracle Names Server) component.
> >
> >
>
>
Received on Mon Jan 15 2001 - 01:20:30 CST

Original text of this message

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