which difference inside file tnsnames.ora

From: Ale <nemo_at_nobody.com>
Date: Fri, 25 Feb 2005 00:49:15 +0100
Message-ID: <_JtTd.66749$2h5.57516@tornado.fastwebnet.it>

Hi,
I have installed Oracle Server since few time, so I think I'll make an obvious question.

I would like to know the difference between this two services declared into my tnsnames.ora file:

FIRST = (DESCRIPTION = (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = test1)(PORT = 1526))

)

(CONNECT_DATA =
(SERVER = DEDICATED)

(SERVICE_NAME = SMSTEST)
)

)

SECOND = (DESCRIPTION = (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

)

(CONNECT_DATA =
(SID = mitico)

(SERVER = DEDICATED)
)

)

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 Received on Thu Feb 24 2005 - 17:49:15 CST