Client Service name Configuration

The client service name establishes a connection with a remote or local listener. The client uses it to send a connection request to the server.
When installing Oracle, you must specify a global database name, that is, a SID Name. Oracle automatically creates a service name on the server with the specified SID Name. When creating a service name on the client, you must specify the network protocol, protocol-related information, and database SID Name. For the most common TCP/IP protocol, you must specify the server host name or IP address, listener port, and database Sid. These configuration information is stored in the tnsnames. ora file, which is in the same location as listener. ora and is located in the ORACLE_HOME \ Network \ ADMIN directory. You can also use start- Program -Configure the Oracle-OraHome92-Configuration and migration tools-net configuration assistant on the wizard interface. Here we mainly look at the manual configuration process.
The main configuration file in the tnsname. ora file is as follows:
Testservice =
(Description =
(Address_list =
(Address = (Protocol = TCP) (host = 192.168.5.1) (Port = 1521 ))
)
(CONNECT_DATA =
(SERVICE_NAME = chstone)
)
)
In one item, the first is "testservice", which is the service name configured on the client. The name can be obtained at will, but remember that there is no space before it. In the section "(address = (Protocol = TCP) (host = 192.168.5.1) (Port = 1521)", "protocol" indicates the protocol type, where TCP is used; "host" is the IP address or Host Name of the server, and "prot" is the port number. The following "SERVICE_NAME" indicates the service name of the server. Because the SID Name I specified during installation is "chstone", here Oracle uses the specified SID Name to automatically create a default service name "chstone" on the server ". When you use SQL * Plus to log on to the server, enter "testservice" in the host string. If you use this machine as the server, the host string can be left empty.