Re: which difference inside file tnsnames.ora

From: Mark Bole <makbo_at_pacbell.net>
Date: Fri, 25 Feb 2005 02:44:43 GMT
Message-ID: <viwTd.9110$Pz7.8561@newssvr13.news.prodigy.com>

DA Morgan wrote:
> Ale wrote:
>
[...]
>> I would like to know the difference between this two services declared
>> into my tnsnames.ora file:
>>
>> FIRST =
>>
>> (ADDRESS = (PROTOCOL = TCP)(HOST = test1)(PORT = 1526))
[...]
>> (SERVICE_NAME = SMSTEST)

[...]
>> SECOND =
>>

[...]
>>
>> (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
[...]
>> (SID = mitico)
>>

[...]
>>
>> The second one is the classic service with a SID, i.e. a DB, but I
>> don't understand the first one, it's a DB too but without SID and with
>> a service_name ? That's the same ?
>> thanx all
>>
>> Ale

> 
> 
> A change Oracle instituted somewhere between 8 and 9i.

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96524/c07dstpr.htm#7853

The other differences are the non-standard port number in the first example, which requires LOCAL_LISTENER parameter to be set in the database for auto-registration to work, and the use of "localhost" in the second, which is unusual.

-Mark Bole Received on Thu Feb 24 2005 - 20:44:43 CST