468,554 Members | 1,435 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,554 developers. It's quick & easy.

tnsnames.ora

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
2 19501
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
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.

Similar topics

1 post views Thread by Wayne Happ | last post: by
1 post views Thread by Adam Ruth | last post: by
6 posts views Thread by bdj | last post: by
6 posts views Thread by Bala Nagarajan | last post: by
1 post views Thread by Miori | last post: by
reply views Thread by NPC403 | last post: by
1 post views Thread by UniDue | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.