Re: Oracle & Modem
From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Mon, 17 Jun 2002 16:14:20 +0100
Message-ID: <3d0dfccd$0$231$ed9e5944_at_reading.news.pipex.net>
Date: Mon, 17 Jun 2002 16:14:20 +0100
Message-ID: <3d0dfccd$0$231$ed9e5944_at_reading.news.pipex.net>
[Quoted] 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...Received on Mon Jun 17 2002 - 17:14:20 CEST
> 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