Follow these steps:
1.
First to Oracle
Official offline Oracle database11g Release 2 client (11.2.0.1.0)
For Microsoft Windows (x64), follow these steps to install SAS:
A. RowsWin64_11gr2_client \ Client \ setup.exeFirst, there is a black border plane. When it disappears, it enters the security area.
B. After entering the security check box, select the desired security check.[General generic version]Security.
C.[Statement]Set the value with counter:[Traditional Chinese] and [English].
D.OracleBasic ObjectivesIngressD: \ oracl11_64.
E. Next, press[Next]Until[Done].
2.
Lower limitPLSQL developer 8, And parse them to specific targets.
3.
ToOracle Official WebsiteLower than instant
Clientfor Microsoft Windows (32-bit.pdf, unzip instantclient-basic-nt-11.2.0.zip, and then unbind ImagesInstantclient_11_2To the projectD: \ oracl11_32.
4.
Import[Console]→ System Security Settings → system → import system settings], Then the following window is displayed:
Click to select 【Environment Change Data].
Point User changes, Point[Zookeeper]In the left-side navigation pane. The following are the metric changes to be modified:
Change Data Name:Tns_admin
Value:D: \ oracl11_64 \ product \ 11.2.0 \ client_1 \ Network \ admin
Change Data Name:Nls_lang
Value:Traditional chinese_taiwan.zht16big5
This value can be usedSqlplusCheck the token as follows:
A. Open sqlplus and merge the following values: XX @ dB string and password: XXX.
B. Explain SQL commands:Selectuserenv ('language') from dual.
Change Data name: Path
Value:AddD: \ oracl11_32 \ instantclient_11_2, Enable the backendPLSQL
Developer 8OfOcilibraryCan be selectedOCI. dll.
5.
Import【PLSQL developer 8 → tools → preference], ModifyConnectionSettings:
[ORACLE_HOME]: PointingD: \ oracl11_32 \ instantclient_11_2.
[OCI]: Click OCI library.
The black box on the left is a blank box, pointingD: \ oracl11_32 \ instantclient_11_2 \ OCI. dll.
6.
PendingTnsnames. oraZookeeperD: \ oracl11_64 \ product \ 11.2.0 \ client_1 \ Network \ adminRouter.
7.
ReactivatePLSQL developer,You can start to use it.