Install the Oracle client to configure PL/SQL Developer

1. Configure the listener for the Oracle server
 
Modify the listener. ora and tnsnames. ora files in the <installation directory>/network/admin/directory. Where
The listener file is roughly as follows:
# Listener. ora Network Configuration File:/oracle/app/product/10.1.0/db_1/network/admin/listener. ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME =/oracle/app/product/10.1.0/db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = demo1) # demo1 is the oracle Instance name
(ORACLE_HOME =/oracle/app/product/10.1.0/db_1)
(SID_NAME = demo1) # Do not change SID_NAME to demo1
)
) LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1 ))
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.0.100) (PORT = 1521) # The ip address is the oracle server.
)
)
The tnsnames. ora file is roughly modified as follows:
# Tnsnames. ora Network Configuration File:/oracle/app/product/10.1.0/db_1/network/admin/tnsnames. ora
# Generated by Oracle configuration tools.
DEMO1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.0.100) (PORT = 1521) # The ip address is the oracle server.
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = DEMO1) # demo1 is the name of the oracle instance, or the service name can be modified through netmgr or netca.
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1 )))
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
The preceding modifications can also be configured through netmgr and netca on the graphic interface. Restart the listener after modification.
2. download and install the oracle client.
The oracle client must be installed on the local machine where pl/SQL developer is installed (the pointer here is for the oracle 10g version, or you can only install the relevant driver, such as the oci driver,
Details are not available. And the client is not necessarily set to 10g, 8i, 9i ).
1. Download the client from the Internet:
Clients with emp.exeand emp.exe Functions
 
2. After installation, and in the admin directory under the network directory, the structure is as follows:
<Client directory>/network/admin: Create the tnsnames. ora file in the admin directory. The content is roughly as follows:
Demo1 = # oracle service name (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.0.100) (PORT = 1521) # oracle server ADDRESS and PORT) (CONNECT_DATA = (SERVICE_NAME = demo1) 3. Configure the client information in PL/SQL developer.
Open PL/SQL developer and do not log on. Choose tools> preferences> connection and set the following items:
 
Oracle Home: D: \ Program Files \ instantclient_11_1 # unzip the Client Directory
OCI library: D: \ Program Files \ instantclient_11_1 \ oci. dll # oci library file path. oci. dll should be in the client directory.
Save and restart PL/SQL developer. You can see the "demo1" service instance on the remote server you Just configured in the "Database drop-down" option of the logon box.
 
The character set in pl/SQL developer in the client is different from that in the database. You need to find HKEY_LOCAL_USER/SOFTWARE/ORACLE/key_1_lient10g_home10 in the registry of the client's system to modify NLS_LANG.