Plsql Developer Connect Oracle

1. Install Plsql Developer

Oracle database and PL/SQL Developer installation steps, here do not narrate, Baidu installation method when you say in the installation of PL/SQL developer software, do not install in program Files (x86) directory, otherwise cannot start pl/ SQL Developer, this I have not tried, since someone encountered this situation, we still do not install directly under the x86.
After the installation is finished running Plsql, the following screen will appear, username and password is your database account password, databases you will find this time is no content, is normal, click Calcle Skip, directly into the main interface.

After entering the main interface, click on the preferences of tools to enter the parameter Settings page

Configure the Oracle home and OCI Library two parameters, the home name can be taken, or set to the database installation directory, OCI library directly pull down, will appear the configuration path, click OK and exit, re-open Plsql, If the database appears in your own installation of the Oracle database information, you can enter the account password with the Plsql to operate the table management, if you install the 64-bit database, may still appear following the above steps, or can not appear the database information, those do the following

2. Install Oracle Cliet

When the installation of the first step is complete, database does not appear, click to skip the error, pop-up message box Mark sure you have the Batis Oracle client installed, This time you need to go to Oracle website to download a oracleclinet installation package, the installation package for the green version, extract and use
Website address: http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html
Remember to download the 32batis version, there is the download resources need to have Oracle account, free of charge, if not registered one on the OK
Extract the downloaded Oracle client file Instantclient-basic-win32 to the drive letter you want to install. Then after the decompression of the D:\instantclient, in the directory under the new Network\admin directory, in the Admin directory under the new Tnsnames.ora file, add database TNS.

ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = chiclewu-pc) (PORT = 1521)) (Connect_data = (SERVER = dedicated) ( service_name = ORCL)))

The Tnsnames.ora file can also be copied from the Network\admin directory in the home directory of the Oracle database, and then placed in the Network\admin directory. Once finished, run Plsql again and skip login, go directly to the parameter setting interface, designate the Oracle home path as the Oracle Client directory (D:\instantclient_11_2), and the home name can be taken by itself. OCI Libaray Path is Oci.dll (D:\instantclient_11_2\oci.dll) of the Oracle client directory.

Save after running Plsql again, you will find database installation information, select the user name password and need to log in the database, click Login, you can enter the main interface management database.

3. Configure Oracle Clinet

Loading win32_11gr2_client.zip to D:\oraclecliect

Catalog D:\Oracle? Create network\admin Directory

D:\Oracle\NETWORK\ADMIN

Create a Tnsnames.ora file under this directory

The contents are as follows

ORCL =
(DESCRIPTION =
(Address_list =
(ADDRESS = (PROTOCOL = TCP) (HOST = 127.0.0.1) (PORT = 1521))
)
(Connect_data =
(service_name = ORCL)
)
)

110 =
(DESCRIPTION =
(Address_list =
(ADDRESS = (PROTOCOL = TCP) (HOST = 11.8.12.110) (PORT = 1521))
)
(Connect_data =
(service_name = EPM1)
)
)

Configuration of the Plsql Developer

Oracle Home "Oracle home Directory" parameter,

To D:\oraclecliect

OCI Library "OCI libraries (automatically detected as empty)"

For

D:\oraclecliect\oci.dll

Open Plsql Developer again to connect to the database.

Plsql Developer Connect Oracle