The official Lite driver, which does not support Exp/imp/rman, requires the installation of the Oracle_client client.
Lab Environment:
Centos6.5 x64 Oracle 11.2.0.4.0
Oracle_client Win64_11gr2_client.zip
WIN10 x64 plsql11_x64
Oracle Official Downloads:
Http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html
Win-oracle_client Client Download:
Http://download.oracle.com/otn/nt/oracle11g/112010/win64_11gR2_client.zip
Cloud disk Sharing
Http://pan.baidu.com/s/1bKGstK Password: igj5
00. Installation
Prepare (or prepare to check)
WIN64_11GR2_CLIENT\CLIENT\STAGE\CVU Modify the following two files
Cvu_prereq.xml and Oracle.client_InstantClient.xml, add the information for the corresponding platform
<operating_system release="6.2"> <version value="3"/> <architecture value="64-bit"/> <name value="Windows Ten"/> <ENV_VAR_LIST> <env_var name="PATH"Max_length="1023"/> </ENV_VAR_LIST> </OPERATING_SYSTEM>
01. Installation Type
Instantclient:--equivalent to Oracl's simplest (instantclient_11_2) support Sqlplus
Administrator mode: Most complete client mode (imp,exp,rman,sqlplus)
Basic mode: Frame with basic client, basic Support No (Imp,exp,rman)
02, installation path (see the basic oracl frame)
03. Path length Check (can be ignored)
04. Installation Progress
05. Modify the Listening file Tnsnames.ora
D:\oracle_client\product\11.2.0\client_1\network\admin (according to the corresponding environment modification)
#local:172.24. 0.24 Mvpbang 172.24. 0. 24mvpbang = = 172.24. 0.241521)) = = dedicated) = Mvpbang) ) )
06, set the Oracle_home of Plsql
D:\oracle_client\product\11.2. 0 \client_1d:\oracle_client\product\ 11.2. 0\client_1\bin\oci.dll
Reopen Plsql again and see database.
07. Win-nls_lang Environment Variables
#设置-windows-Client Character set, prevents imp/exp Import from exporting character set issues Nls_lang American_america. Al32utf8
Refer to:
Http://www.cnblogs.com/xiaochina/p/6418793.html
Rouse
1190000007203015
Oracle-client Support Exp|imp|rman