Sunday, January 24, 2010

Sample tnsnames.ora file

# tnsnames.ora Network Configuration File: E:\oracle\product\10.2.0\db_1\\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

TEST1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = vinay.k.com)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = TEST1)
)
)

TEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.215)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = TEST)
)
)

No comments:

Post a Comment