PLSQL Developer Connecting Oracle Database

1. Download and install Plsql Developer12

Visit Plsql Developer official website https://www.allroundautomations.com/bodyplsqldevreg.html, download Win64 version

2. Visit the Oracle website, download the instant client and unzip it to the appropriate location

Http://www.oracle.com/technetwork/database/database-technologies/instant-client/downloads/index.html

3.PLSQL Developer Configuration

Open plsql Developer, login window directly select Cancel, select Configure-preferences-connection in main interface

• Set Oracle home to instantclient decompression path
• Set OCI liarary to instantclient decompression path \oci.dll

4. Configure Environment variables

• • Nls_lang Simplified Chinese_china. Zhs16gbk
  • tns_admin instantclient Decompression Path

5. Configure Tnsnames.ora

Create the file Tnsnames.ora under the instantclient decompression path , enter the TNS connection information, and change the red section.

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

PLSQL Developer Connecting Oracle Database