Connect Oracle10g client to server configuration

Oracle10g client tool plsql link Server Configuration

Oracle10g client tools, such as plsql, have many problems in connecting to the server on the network, and often encounter many inexplicable problems. In fact, it is not the configuration of plsql. The problem lies in the client configuration. There are many solutions on the Internet, which are not really useful. The following describes the effective solutions:

Install the client as the Enterprise Manager by default.

After installation, You need to configure the location at: D: \ oracle \ product \ 10.2.0 \ client_1 \ NETWORK \ ADMIN

There are two files to be configured:

Sqlnet. ora

Tnsnames. ora

First look at tns:

# Tnsnames. ora Network Configuration File: d: \ oracle \ product \ 10.2.0 \ client_1 \ network \ admin \ tnsnames. ora # Generated by Oracle configuration tools. EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC0 )) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) ) KFCS = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 10.87.30.44) (PORT = 1521 )) (ADDRESS = (PROTOCOL = TCP) (HOST = 10.87.30.45) (PORT = 1521 )) (ADDRESS = (PROTOCOL = TCP) (HOST = 10.87.30.46) (PORT = 1521 )) (ADDRESS = (PROTOCOL = TCP) (HOST = 10.87.30.47) (PORT = 1521 )) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = KFCS) ) )

The red part is the tns configured on the server, and the service name is KFCS.

Note that you also need to configure a network service file:

# Sqlnet. ora Network Configuration File: D: \ oracle \ product \ 10.2.0 \ db_1 \ network \ admin \ sqlnet. ora # Generated by Oracle configuration tools. # This file is actually generated by netca. But if MERs choose # Install "Software Only", this file wont exist and without the native # Authentication, they will not be able to connect to the database on NT. SQLNET. AUTHENTICATION_SERVICES = (KFCS) NAMES. DIRECTORY_PATH = (TNSNAMES, EZCONNECT)

The above red service name must be consistent with the configuration in the tns file, otherwise there will be problems. Incorrect by default)

The client is not installed by default.

With these two configurations, You can correctly connect to the database through plsql.

-----------------------------------------------------------

Note: The connection to the database through the sqlplus command line may not be related to this configuration. I have tried it and I feel that the connection to sqlplus is successful, that is, plsql is not successful. I think the connection method of sqlplus may be different.

This article is from the "melyan" blog, please be sure to keep this source http://lavasoft.blog.51cto.com/62575/1290320