Oracle Database Installation

First into this trip, the meeting is not difficult, difficult people will not, engaged for a long time to fix, summed up the installation sequence is best Oracle databse \orlacle Client (can be free) \ Plsql (can be installed)

1, Oracle Database installation, the official download, download need to log in, you have to register an account in Oracle to download, this step is the only difficulty is the file is too large, the download is slow (note that the version is 32-bit, 64-bit)

Http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html,

I'm under 64, Win64_11gr2_database_1of2,win64_11gr2_database_2of2. Installation need to WIN64_11GR2_DATABASE_2OF2 decompression copy to Win64_11gr2_database_1of2 to install no difficulty, the other next step to install can, if not peace of mind can search on the Web to install the reference. After the Oracle Database was installed, I was not used to visualizing it, so I decided to install Plsql.

2, before installing the plsql, you need to install Oracle client, you can choose to download and install here (need to note please choose to download 32-bit Client, currently plsql does not support 64-bit), I really do not want to install Oracle client, So look for a solution to install Oracle client software-log in with PL/SQL configuration. Available for official download: http://www.oracle.com/technetwork/topics/winsoft-085727.html (note version).

I download the version is: instantclient-basic-nt-11.2.0.3.0,

2.1 Downloads no need to install, unzip any directory can, here I resolved to the same directory as Oracle database

2.2 Tnsnames.ora files need to be created manually and set accordingly

Under the directory instantcleent-basic-nt-11.2.0.3.0 new Level Two folder network\admin\, under the ADMIN new file Tnsnames.ora (can refer to the online tutorial), Can be copied directly from another directory: 11.2.0 directory has two files "Dbhome_1", "dbhome_2", I copy is dbhome_2\network\admin under the Tnsnames.ora.

2.3 Configuring Environment variables

Right-click on "My Computer" = "Environment variable configuration ="

Nls_lang = Simplified Chinese_china. ZHS16GBK (depending on the situation)

(For example: After Plsql logon, the database character set (AL32UTF8) and the client character set (ZHS16GBK) are not consistent, modify this value to: Simplified Chinese_china. AL32UTF8)

Tns_admin = D:\app\Admin\product\instantclient-basic-nt-11.2.0.3.0\instantclient_11_2 (modified according to the directory you have installed)

　　

3, Plsql installation settings (green version of the Internet does not install)

Open Plsqldev.exe, the first time you open an error can be ignored, go to menu tool->preferences->connection (Tools, preferences, connect), set.

Turn it off and then turn it back on

Thank you, great God, for your reference.

Http://www.2cto.com/database/201503/380111.html

Http://wenku.baidu.com/link?url= Pyluk49a6belklzt6owieibrzusrpo0w9ztawl5ay--ogbvahydpcsil5wi4zkqerxia14e3nplvib5uxhpsoybbfnvbpfpqejaaeczeu_w

Http://jingyan.baidu.com/article/fb48e8be4c7c206e622e1491.html

Http://www.cnblogs.com/ymj126/p/3712727.html

Oracle Database Installation