Local do not install Oracle,plsql still use up

For computers with limited configuration, it is not necessary to use Plsql to install Oracle.

First, download a instantclient (a lighter-weight customer package provided by Oracle)

It is said that Plsql does not support 64-bit instantclient.

Attached address: Link: http://pan.baidu.com/s/1dE5I71v Password: 2n5c

Second, the original instantclient is not containing Sqlnet.ora and tnsnames.ora two files, but the top package I have put in.

Tnsnames.ora file:

ORCL =      = = (PROTOCOL = TCP) (HOST = 127.0.0.1) (PORT = 1521))    =       = dedicated)      = orcl)    )  =       = =      = (PROTOCOL = IPC) (KEY      =    EXTPROC1))) = = Plsextproc)      = RO)   ))

Sqlnet.ora file

Sqlnet. authentication_services= (NTS) NAMES. Directory_path= (tnsnames, ezconnect)

Third, add system variables: tns_admin
Variable Value: D:\Oracle\instantclient_11_2 (place instantclient_11_2 this client package)

Four, open plsql:tools-->preferences

Set the path of the two-variable Oracle home:instantclient
The path of OCI library:instantclient \oci.dll

Five, please restart the next plsql, is not good, good, good

　　

Local do not install Oracle,plsql still use up