what is use of tnsnames ora file in oracle

Oracle: listener. ora, sqlnet. ora, tnsnames. ora configuration and example1. Solve the problem: TNS or the database cannot log on.The simplest and most effective method: use the tool netca provided by the

Local name configuration: The local name can access the required database or server information with a simple name, and the information is saved to tnsnames. ora. LOCALNAME: local nameADDRESS: server ADDRESSPROTOCOL: PROTOCOL usedHOST: IP AddressPORT: listening PORTSERVICE_NAME: Database Service nameFirst, make sure that the format in the

Http://hi.baidu.com/yjdzh/blog/item/67e11162278ce6dae7113a80.html Listener Configuration FileTo enable external processes such as the cams background program to access the Oracle databaseSet the Oracle network server environment to configure the Oracle network server environment through the configurationListener. ora

Sqlplus local connection is not a server The error is as follows: SQL> conn hailiang/hailiang @ DBNetSpiderERROR:ORA-12154: TNS: cocould not resolve the connect identifier specified Solution: I forgot to configure the tnsnames. ora file locally... In

During parameter configuration, you must first check the content in tnsnames. ora. If the tns string to be configured already exists in the file, direct the parameter to a tns string. During parameter configuration, you must first check the content in tnsnames. ora. If the t

In the installation directory, such as: E:\Oracle\Ora81\network\ADMIN under the use of WordPad or Notepad to open the Tnsname.ora file, the contents of the file may be as follows: TEST. softone.com = (DESCRIPTION = (Address_list = (address = (PROTOCOL = TCP) (HOST = zcb_8115) (PORT = 1521)) ) (Connect_data = (service_n

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 \

enter the "Net8 Configuration Assistant: network service name Configuration, network service name" window;10) in the "Net8 Configuration Assistant: network service name Configuration, network service name" window, enter the network service name, and the service name is an ORACLE connection string, which can be input at will, for example, test, click "Next" to bring up the following form;11) in the "Net8 Co

Configure tnsnames for the local oracle NET service name. oracle local NET service name configuration tnsnames. the ora file has strict format requirements. Today, a service name is man

In the installation directory, such as: E:oracleora81networkadmin under the use of WordPad or Notepad to open the Tnsname.ora file, the contents of the file may be as follows:TEST. softone.com =(DESCRIPTION =(Address_list =(address = (PROTOCOL = TCP) (HOST = zcb_8115) (PORT = 1521)))(Connect_data =(service_name = test)))The blue section