Re: Oracle & Modem

philipwinfield_at_hotmail.com (Phil) wrote in message news:<6e25c7f7.0206170228.3f848b18_at_posting.google.com>...
> I am using Oracle on w2K and everything is fine until I connect to the
> internet. If I then close the modem, all Oracle connections are lost
> despite the db running locally. Anyone out there know of an easy
> solution?
> Thanks
> Phil

You can also use not so widely documented BEQ protocol. Setup your tnsnames.ora entry like,

dsn01 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = BEQ)(PROGRAM = <oracle80|oracle>)(ARGV0 = <oracle80|oracle>dsn01)

    (ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=BEQ)))'))     (CONNECT_DATA = (SID = dsn01))
  )

Change PROGRAM = oracle80|oracle and ARGV0 = <oracle80|oracle> according to your version.

HTH Received on Fri Jun 21 2002 - 03:45:58 CEST