Re: Microsoft Loopback adapter problem with Oracle 11G

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Sun, 28 Oct 2007 11:30:27 +0100
Message-ID: <fg1obv$71k$1@news3.zwoll1.ov.home.nl>

augie wrote:
> This is for a home PC. I have Microsoft Loopback adapter installed for
> use with Oracle 11G for Windows but it block my internet connection. I
> have IP address 10.10.10.. etc and the subnet
> mask 255 etc. and the host file all of that done correctly. It works
> fine but there is no Internet connection. I have to disable Loopback
> and then reboot computer to restore Internet connection. The DSL is
> dynamic DHCP Would it help if I had the loopback get its IP address
> automatically instead of fixed?
> thanks.
>

Don't use TCP/IP (which is meant
for bad telephone lines) for your
local connecttions, use IPC, or
-better yet- BEQ.

IPC requires a listener, BEQ does not.

An example of a BEQ connectstring, as to be defined in your tnsnames.ora:

augie.home.local =
(DESCRIPTION=
(ADDRESS = (PROTOCOL = BEQ)(PROGRAM=oracle)

      (ARGV0=oracleBeta11)
      (ARGS='(DESCRIPTION=(LOCAL=yes)(ADDRESS=(PROTOCOL=BEQ)))')

    )
    (CONNECT_DATA=(service_name=BETA11.home.local)     )
  )

And it works - no listener!
C:\>sqlplus system_at_augie

SQL*Plus: Release 10.2.0.3.0 - Production on Sun Oct 28 11:27:58 2007

Enter password:

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.4.0 - Beta With the Partitioning, OLAP and Data Mining options

SQL>

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...

Received on Sun Oct 28 2007 - 05:30:27 CDT