Install Oracle instant client for PL/SQL Dev

Oracle is installed on Linux in the Virtual Machine. Since PL/SQL Developer is used on Windows physical machines to connect to Oracle in the virtual machine,But I don't want to reinstall Oracle on the Physical Machine (too big, no more =. = ). Therefore, Oracle Instant Client is used.Okay, I don't have to talk about it anymore. The procedure is as follows:1. Configure the listener in Linux first. The contents of the listener. ora file are as follows:# Listener. ora Network Configuration File:/u01/app/oracle/product/10.2.0/db_1/network/admin/listener. ora# Generated by Oracle configuration tools.SID_LIST_LISTENER =(SID_LIST =(SID_DESC =(SID_NAME = PLSExtProc)(ORACLE_HOME =/u01/app/oracle/product/10.2.0/db_1)(PROGRAM = extproc))(SID_DESC =(GLOBAL_DBNAME = wiseman)(ORACLE_HOME =/u01/app/oracle/product/10.2.0/db_1)(SID_NAME = wiseman)))Note: SID_name must be the same case as SID in Linux. Lower case for me2. After the configuration is completed on the Windows End, first download http://www.oracle.com/technetwork/topics/winsoft-085727.htmlInstantclient-basic-nt-11.2.0.3.0.zipDownload it (my 32-bit system), decompress it to C: \ Oracle \ instantclient_11_2, and copy tnsnames. oraTo C: \ Oracle \ instantclient_11_2 \ network \ admin. The content is as follows:GGDB =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.0.99) (PORT = 1521 ))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = WISEMAN)))3. Finally, set PL/SQL Developer,Tools --> preferencesAs shown in the following figure:

NowRestartClick PL/SQL Developer and log on again.

Supplement:Instant Client does not provide SQL * Plus, so you can download it from the previous page, Instantclient-sqlplus-nt-11.2.0.3.0.zip. After the download,Configure the windows system variables.NLS_lANG = SIMPLIFIED CHINESE_CHINA.ZHS16GBKTNS_ADMIN = C: \ Oracle \ instantclient_11_2Path = C: \ Oracle \ instantclient_11_2


Now you can useSqlplus system/oracle @ GGDBConnected.