By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,812 Members | 856 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,812 IT Pros & Developers. It's quick & easy.

tnsnames.ora

P: n/a
Dear all,
We use TCP/IP for our Oracle networking to the database server but I see
2 formats for specifying the definition of a connection string of a
database in tnsnames.ora.

format 1:
testdb =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = myhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = testdb)
)
)

format 2:
testdb =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = myhost)(Port = 1521))
)
(CONNECT_DATA =
(SID = test)
(GLOBAL_NAME = testdb.mydomain)
)
)

What is the difference between these 2 formats, is one for a certain
Oracle DB version and the other for another version for example? I mean
when to use which format or are both of them interchangable?

Many thanks for the replies,
Miori
Jul 19 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Miori wrote:

This is for >=9i
format 1:
testdb =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = myhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = testdb)
)
)
This is for Oracle < 9i
format 2:
testdb =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = myhost)(Port = 1521))
)
(CONNECT_DATA =
(SID = test)
(GLOBAL_NAME = testdb.mydomain)
)
)


Artur

Jul 19 '05 #2

P: 1
Will you please paste your tnsnames.ora here? I get error ORA-12203 TNS: unable to connect to destination
Jun 19 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.