Re: Oracle & Modem

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 19 Jun 2002 23:34:35 +0200
Message-ID: <n1u1huso0u8mtlpoushtnbvgt1igokmrar_at_4ax.com>


On 19 Jun 2002 14:05:51 -0700, philipwinfield_at_hotmail.com (Phil) wrote:

>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)
> )
> )
>
>

NO
He means, set ORACLE_SID in the registry correctly

The alternative solutions are
- define the IPC protocol in listener.ora and tnsnames.ora (do so using the net8 assistant)
- use the name of your machine as host name or use localhost as host name for the protocol tcp
localhost should be defined in c:\winnt\system32\drivers\etc\hosts (NT) or c:\windows\hosts
as
127.0.0.1 localhost

The protocol 'LOCAL' doesn't exist at all.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Jun 19 2002 - 23:34:35 CEST

Original text of this message