Re: Oracle & Modem

[Quoted] Thanks, Just to clarify; would I change this ...

dsn01 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = phil-11hat7tjlf)(PORT = 1521))     )
    (CONNECT_DATA =
      (SERVICE_NAME = dsn01)
    )
  )

To this ...

dsn01 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = LOCAL)(HOST = phil-11hat7tjlf)(PORT = 1521))     )
    (CONNECT_DATA =
      (SERVICE_NAME = dsn01)
    )
  )

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:<3d0dfccd$0$231$ed9e5944_at_reading.news.pipex.net>...
> For local connects don't connect over TCP/IP, I have ORACLE_SID set in my
> system environment variables and connect directly.
>
> eg in a command window
>
> set oracle_sid=<yoursid>
> sqlplus user/pass.
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> *****************************************
> Please include version and platform
> and SQL where applicable
> It makes life easier and increases the
> likelihood of a good answer
>
> ******************************************
> "Phil" <philipwinfield_at_hotmail.com> 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
Received on Wed Jun 19 2002 - 23:05:51 CEST