Oracle link configuration-product \ 11.2.0 \ client_1 \ Network \ admin \ tnsnames. ora

 

Oracle client installation path \ product \ 11.2.0 \ client_1 \ Network \ admin \ tnsnames. ora has the following content: # tnsnames. ora network configuration file: e: \ Oracle11g-client2-manager \ product \ 11.2.0 \ client_1 \ Network \ admin \ tnsnames. ora # generated by Oracle configuration tools. dev = (description = (address_list = (address = (Protocol = TCP) (host = 192.168.30.71) (Port = 1521) (CONNECT_DATA = (SERVICE_NAME = Dev ))) ceshistu = (Description = (Address_list = (address = (Protocol = TCP) (host = 192.168.30.71) (Port = 1521) (CONNECT_DATA = (SERVICE_NAME = orcl ))) myorcl = (description = (address_list = (address = (Protocol = TCP) (host = 127.0.0.1) (Port = 1521) (CONNECT_DATA = (SERVICE_NAME = orcl ))) take this example: ceshistu = (description = (address_list = (address = (Protocol = TCP) (host = 192.168.30.71) (Port = 1521) (CONNECT_DATA = (S Ervice_name = orcl) Here ceshistu is the service name. I will simply call it the alias of the connection, because it is very easy to be confused with the database instance name. This name can be used as needed. It is finally displayed in the third drop-down box database of PL/SQL, and SERVICE_NAME = orcl is used to determine which database to connect. This orcl is the name of the database instance. Its connection address is: (address = (Protocol = TCP) (host = 192.168.30.71) (Port = 1521 )). Of course, there are related management clients to set these things. Otherwise, everyone should learn the configuration of this file, which is too unfriendly. You can configure the content in the net manager in the configuration and porting tool. The essence is to write these things in this file. Therefore, after you understand the principle, the configuration will be faster and more accurate.