Re: Connection with Oracle database through internet

Then I'll put (virtual) money on the fact that you have a firewall between the database and the internet, on which port 1521 (and maybe 1526) is open. The problem is then easily understood if the connection method for Oracle sessions is understood

1. client talks to listener on port 1521 asking to connect to database X.
2. listener checks that it actually knows about database X and replies Ok
3. connection to database is brokered by listener on a new (random) free port.

tnsping on the other hand just does the first 2 stages - i.e. only uses 1521.

When a firewall is in the way the 3rd stage (the actual connection) gets blocked.

Solutions available to you are

1. buy an Oracle aware firewall.
2. Use Oracles Connection Manager (Enterprise Edition only)
3. Use the variable SHARED_SOCKET = true.

I believe, but am probably wrong, that the implementation of this last option is platform specific. I also have been unable to get it to work with Oracle standard edition, but my attempt was a long time ago and rather half-hearted to be honest. I'd be grateful if others could confirm where this variable gets set under NT4/Oracle 8.1.6 Std.

regards

--
Niall Litchfield
Oracle DBA
Audit Commission UK



"Michael Gruys" <gruys_at_track4.nl> wrote in message
news:93u8fu$20t0$1_at_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.

> > >

> > >

> >

> >

>

>