How To Config The Oracle tnsnames.ora

gehy1

Member
Hi:
How To Config The Oracle tnsnames.ora?
Use JDE812/Oracle10, Proddta(DB) is at SERVER1,Prodctl is at SERVER2,My client is can't Logon,How To Config? Link Tne Two Servers?
Thanks!!
 
If you're trying to get tnsnames.ora to look at 2 different database instances, maybe this might help:

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

E1DEV =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.10.29)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = E1DEV)
)
)

E1PROD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.10.28)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = E1PROD)
)
)
 
Back
Top