Step 1: Download and download oracle11g and oracle 32-bit client, no installation package to download on the official website, official website url: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html, if you don't know how to download, go directly to my Baidu network disk, Network disk address: http://pan.baidu.com/s/1boiSyzP, extraction code h3cy, download instantclient_11_2.zip, win64_11gR2_database_2of2.zip and win64_11gR2_database_1of2.zip
These three compressed packages (note: mine is a 64-bit system) install oracle 11g (Baidu, "oracle11g illustrated installation tutorial").
Step 2: After installing oracle11g, configure the configuration (when oracle is installed, I install it on the D drive by default)
1. Unzip the oracle 32-bit client and copy it to D:\app\fengyu
After opening, the picture below is like this
2. Find the file (note ora is the suffix), for example, the tnsnames.ora I found is
(D:\app\fengyu\product\11.2.0\dbhome_1\NETWORK\ADMIN), if you don't know where it is, just search for it, as shown in the figure below
, after finding this tnsnames.ora file, copy it to the path of your client, mine
D:\app\fengyu\instantclient_11_2（就是刚刚拷贝复制的路径）。
3. Configure environment variables
Right-click on "Computer", select "Properties", and the image below will appear
Select Advanced System Settings, and then click Environment Variables, as shown below.
After that, click New, the variable named: TNS_ADMIN path is your oracle11g client path, mine is
D:\app\fengyu\instantclient_11_2，不懂看以下截图
3. Configure plsql
First install plsql (will not install your own Baidu "plsql installation diagram"), open plsql after installation, click "cancel",
After that, click "Tools (T)" (I installed plsql is the Chinese version), and then click "Preferences (P)...
, then click "Connect" on the left, and finally in the "Oracle Home Directory Name (Auto-Detected as Empty)", enter the 32-bit client path you just copied oracle11g, mine is D:\app\fengyu\instantclient_11_2, enter the oracle11g 32-bit client path\oci.dll in the OCI library (automatically detected as empty), and mine is D:\app\fengyu\ instantclient_11_2\oci
.dll, the last point is determined, and I don't know how to look at the picture below.
Then exit or close the window. After that, check whether the service is open, right-click "Computer" and select Manage, click "Services and Applications", and then click "Services", as shown in the picture
I started three services, namely: OracleMTRecoveryService, OracleDb11g_home1TNSListener,
OracleServiceORCL is started, as shown in the figure
Next, open plsql, enter the account name and password and the database, I entered the default account and password, the database is the ORCL that comes with it, as shown in the figure, and then click OK.
Look at the success.
Graphic tutorial download:
Tourists, if you want to see the hidden content of this post, please Reply
|
Posted on 3/10/2018 2:00:52 PM
|
|
|
Posted on 3/10/2018 8:40:09 PM
|
Thanks for sharing,