ORACLE12C and Plsql developer installation full record

One. Login to Oracle download page http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

Download Oracle for your computer version, Oracle 12c has only 64-bit version,

Select the first, download file1 and file 2, download and extract to the same folder database, first decompression file1, that is, WINX64_12102_DATABASE_1OF2, select Extract to the current folder

Then unzip File2, that is, WINX64_12102_DATABASE_2OF2, right click to select Extract files to the database folder, follow this step, do not think of anything.

Then click on the Setup.exe installation in database, and refer to http://www.wxzzz.com/1244.html for details.

Two. Next we want to download Plsql Developer Oracle Interface management software, http://www.itopdog.cn/soft/6223.html

After installation, do not log in, because there is no link to the database, the connection will be error, such as .... Make sure Hava the "Oracle client ...." such as

This is because the oracle12c you installed is 64-bit, and plsql developer is only 32-bit, so this issue occurs

Now to do is:

Installs the 32-bit Oracle Client (instantclient-basic-nt-12.1.0.1.0.zip). Win8.1 64-bit system is not plsqldeveloper, so the next 32-bit.

Download Instantclient-basic-nt-12.1.0.1.0.zip (must be 32-bit, do not make the wrong version, the Oracle website has to download, this version of the number of their own choice, I choose the latest), Extract it to the Oracle installation directory under product (native named: instantclient_12_1): D:\app\orcl\product\instantclient_12_1

Copy a folder under the root directory of the database installation: D:\app\orcl\product\12.1.0\dbhome_1\NETWORK to the Oracle client directory D:\app\orcl\product\instantclient_12 _1

Then login plsql Developer, choose not to connect the database, cancel, log in and set up the OCI library and Oracle_home in perference->connection, such as the local set to:

Oracle_home:d:\app\orcl\product\instantclient_12_1

OCI Library:d:\app\orcl\product\instantclient_12_1\oci.dll

Three. Set environment variables (modify path and tns_admin environment variables):

For Nls_lang environment variables, it is best to set to the same as the database side, first query the character set information from the database side:

, in order to log on to the system normal users, enter a new SQL WINDOW, input

Sql> Select Userenv (' language ') Nls_lang from dual;

The result of my computer is

Nls_lang

----------------------------------------------------

American_america. Zhs16gbk

Right-click "My Computer"-"Properties"-"advanced"-"Environment variables"-"System environment variables":(win8.1 system, check the Internet to find out how to identify the system variables in advanced.

1> Select "Path"-click "Edit" to add "D:\app\orcl\product\instantclient_12_1;"

2> Click "New", the variable name is set to "Tns_admin", the variable value is set to "D:\app\orcl\product\instantclient_12_1;", click "OK";

3> Click "New" and the variable name is set to "Nls_lang" and the variable value is set to "American_america. ZHS16GBK ", click" OK ";

Finally click "OK" to exit.

So it's all over.

ORACLE12C and Plsql developer installation full record