WIN7 after installing ODAC, the directory "C:\app\client\xushunyi\product\12.1.0\client_1\Network\Admin" Generates a Tnsnames.ora file that is used to configure Oracle DB instance information, which can typically be configured by referring to the Tnsname.ora file in the sample directory. The example contents are as follows:
# Every line, begins with # are a comment line
#
# Create Oracle Net service names, or aliases, for each database server
# need to connect to.
#
# Tnsnames.ora Sample Entry
#
# alias =
# (DESCRIPTION =
# (ADDRESS = (PROTOCOL = TCP) (HOST = myserver.mycompany.com) (PORT = 1521))
# (Connect_data =
# (SERVER = dedicated)
# (service_name = ORCL)
# )
# )
#
# can modify the entry below for your own database.
# <data Source alias> = Name to use in the connection string data source
# # <port> = database server machine
# <database Service name> = name of the database service on the server
<data Source alias> =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = (Connect_data =
(SERVER = dedicated)
(service_name = <database SERVICE name>)
)
)
ODAC's Tnsnames.ora file