Re: Oracle & Modem
From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Thu, 20 Jun 2002 12:06:42 +0100
Message-ID: <3d11b743$0$238$ed9e5944_at_reading.news.pipex.net>
Date: Thu, 20 Jun 2002 12:06:42 +0100
Message-ID: <3d11b743$0$238$ed9e5944_at_reading.news.pipex.net>
If you have ORACLE_SID set then you don't need to use TNSNAMES at all. Just issue connect username/password in sqlplus. If you do want to use a tnsnames alias then you need to configure your listener to listen on the IPC protocol as well as/instead of the TCP protocol and then modify the tnsnames.ora to use IPC not TCP. This can all be done using the net manager/net assistant applet from the Oracle program groups in your start menu.
HTH
-- 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.0206200026.278c1327_at_posting.google.com...Received on Thu Jun 20 2002 - 13:06:42 CEST
> Sybrand
>
> Many thanks for your reply. I have the name of the machine in the
> tnsnames file and the oracle_sid also (matches registry entry).
> The loss of service is the dropping of connections. If I reattempt to
> connect following modem disconnection we are back in business. I just
> wondered if I could avoid this? Perhaps I should live with it!
>
> Cheers
>
> Phil