Installing Plsql Developer

Requirements: To connect to the Oracle database, do not want to install Oracle locally, too large, and account for memory, so use Plsql developer.

Read a lot of blogs on the internet, Mom, is not clear, has been prompted to initialize the failure, is that oci,dll and then change a variety of configuration files, useless!

Later, a colleague's Plsql Deveploper, his 9-point version, my 11-point, decisive change over,

1. Install Plsql Developer, here is the 9-point version

2. Installing instantclient-basic-nt-12.2.0.1.0

3. Create a new Tnsnames.ora file under the Unzip folder above, with the content:

Orcl=  (DESCRIPTION = (    address_list = (Address      = (PROTOCOL = TCP) (HOST = server IP) (PORT = 1521))    (CONNECT _data =     (server = dedicated)      (service_name = database name on the server)    )  

4. Not here yet, also configure the environment variables (here to modify according to their own circumstances)

Variable name: tns_admin variable value; E:\app\plsql\instantclient_12_2

Variable name: oracle_home variable value; E:\app\plsql\instantclient_12_2

Variable name: Nls_lang variable value; Simplified Chinese_china. Zhs16gbk

5. Re-login to your Oracle and see the Miracle. Database: IP Address: Port number/database name

1 days and half!!!!!!!

Installing Plsql Developer