ORACLE11G is needed in the near future and is managed using PL/SQL.
Hardware and Software description
OS:WIN8 64-bit operating system, Memory: 8G. ORACLE_11G_R2 64-bit version
PL/SQL Developer
Instantclient-basic-win32-11.2.0.1.0.zip (must be 32-bit) , of which Instantclient-basic-win32-11.2.0.1.0.zip is http://www.oracle.com/technetwork/topics/winsoft-085727.html
First, install the oracle11g desktop class
For specific steps, see http://www.cnblogs.com/haoke/articles/2734392.html
(1) Extract the downloaded Oracle 11g (two) to the same file.
(2) Click Setup under File A to install.
(3) Email is not required
(4) Select Create DATABASE Class
(5) Set the base directory and database file location.
(6) can be set to a more concise password
(7) Complete the installation. Shipping
Run SQL PLUS, so the installation is complete.
II. installation of PL/SQL Developer
(1) Click the. exe installation file to install, no longer described.
(2) extract Instantclient-basic-win32-11.2.0.1.0.zip to E:\app\benley\product
(3) Create the Network/admin directory under the Instantclient_12_1 directory and Tnsnames.ora from
E:\app\benley\product\11.2.0\dbhome_1\NETWORK\ADMIN Next Copy
(4) Add environment variable Tns_admin-->e:\app\benley\product\11.2.0\dbhome_1\network\admin
(5) run Plsql, do not record account information, click to cancel access to the main page, click: Tools--〉 Preferences
Oracle Home (home directory) fill in:
ORC Library fill in:
Last Login on
Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.
WIN8 (64) Mounting Oracle11g+pl/sql