Re: Connection with Oracle database through internet

The variable SHARED_SOCKET is not found in the Oracle documentation... In which configuration file should I use this variable? Thanx for your reply.

Michael Gruys

• Original Message ----- From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk> Newsgroups: comp.databases.oracle.server Sent: Monday, January 15, 2001 1:13 PM Subject: 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.
> > > >
> > > >
> > >
> > >
> >
> >
>
>
Received on Mon Jan 15 2001 - 06:48:30 CST