Plsql Connecting Oracle database issues and explanations

I. Oracle database installation PROCEDURE reference: https://jingyan.baidu.com/article/363872eccfb9266e4aa16f5d.html

Ii. Oracle Client Installation: https://www.jb51.net/article/101306.htm

Third, plsql install or use the free installation version.

Iv. Plsql Connecting Oracle Issues Summary:

Plsql Developer Connecting a 64-bit Oracle database requires two things to find:

1, 32-bit Oci.dll file
Because the Plsql Developer is 32-bit software, when accessing the Oracle 11g 64-bit database, it is necessary to go through the 32-bit oci.dll this middleman to communicate with the 64-bit Oracle database first. Therefore, when you access a 64-bit Oracle database in Plsql Developer, you must be able to find a 32-bit Oci.dll file location. There are two ways to get 32-bit oci.dll, one is to install a 32-bit Oracle 11g client, and the other is to download a simple installation package that contains 32-bit oci.dll directly from the network. So if you install a 64-bit client, using Plsql is not connected to the database. That is, if you are installing 64-bit Oracle, you must install a 32-bit Oracle client if you are using Plsql.
2. Oracle_home directory (i.e. ORACLE home directory)
Looking for Oracle_home to find Tnsnames.ora. Tnsnames.ora Stores database connection information. Tnsnames.ora can be configured with the "Net configuration Assistant" or directly from another computer to be placed in the Oracle client home directory \network\admin.

The Oracle_home home directory can be configured in an environment variable in the operating system.

There are a variety of solutions, but there are two goals to achieve.

Five, environment variable configuration:

Nls_lang
American_america. Al32utf8
or simplified Chinese_china. ZHS16GBK

Vi.. Plsql Settings

Seven, if the installation error client, need to uninstall, uninstall reference: 49443547

Plsql Connecting Oracle database issues and explanations