Do not install Oracle, connect to Oracle using Plsql

Usually when the enterprise development, the database is not installed in our local (nonsense), so when using plsql, when not necessary, we try not to install Oracle, too big;

Next say I plsql, do not install Oracle's use steps;

1. Personal Local Environment

Os:win10

Oracle not installed

2. Download a instantclient, remember to 32-bit, Plsql does not support 64-bit

Http://pan.baidu.com/s/1eSPy7C2

I Baidu cloud disk share, you can directly download

3. Create a directory to store instantclient

Can I as an example: D:\oracle\instantclient_11_2

Create two files under this folder:

Sqlnet.ora and Tnsnames.ora

Sqlnet.ora content is:

  Sqlnet. Authentication_services= (NTS)   NAMES. Directory_path= (TNSNames, Ezconnect)

Tnsnames.ora content is:

Rxzqweb_devdb =  (DESCRIPTION =    (address_list =      172.16.44.132) (PORT = 1521))    (CONNECT _data =      (service_name =orcl)    )  )

The Red font part please revise according to oneself actual situation

Then add a system variable:

Variable name: tns_admin

Variable value: D:\oracle\instantclient_11_2 (that is, the directory created earlier)

4. Install the PL/SQL Developer and configure the connection parameters for Oracle:

Open Pl/sql,tools-->preferences

5. Restart the plsql, test it, OK!

If error: Ora-12154:tns:could not resolve the connect identifier specified.

Then your system variables are not set or set incorrectly! Please check!

The query data may end up being garbled: providing a solution

Create a new system variable, set the variable name: Nls_lang, Variable value: Simplified Chinese_china. ZHS16GBK or American_america. Al32utf8 (according to the actual situation to determine the value of variables), OK

Do not install Oracle, connect to Oracle using Plsql