PL/SQL Dev remote Connect Oracle

Environment:Win7 64bit Ultimate Oracle 11g

Required Software and:

Oracle 64bit Client

Http://www.oracle.com/technetwork/topics/winx64soft-089540.html

PL/SQL DEV

http://www.plsqldev.com/

Configuring Tnsnames.ora file Instances

#tnsnames. oranetworkconfigurationfile:f:\oracle\product\11.2.0\client_1\network\admin\tnsnames.ora# Generated by Oracle configuration Tools. Local named name = (DESCRIPTION = (Address_list = (address = (PROTOCOL = TCP) (host = host IP address) (port = port number)) (Connect_d ATA = (service_name = service name)))

Configure win7 system environment variables (confirm directory based on personal installation)

Nls_lang=american_america. Al32utf8

Character set if it is not consistent with Oracle Server, there is a problem

Can be queried via select Userenv ('language') from dual

Tns_admin=d:\product\11.2.0\client_1\network\admin

P ATH environment variable inside add D:\product\11.2.0\client_1\bin

Install O racle The client, and then use the PL/SQL DEV Connecting to Oracle Server will error

Then you need to go

Http://www.oracle.com/technetwork/topics/winsoft-085727.html

Download Instantclient-basic-nt-11.2.0.2.0.zip

put Instantclient-basic-nt-11.2.0.2.0.zip Extract to Oracle Client Installation directory client_1 below

Open PL/SQL DEV Select tool->preferences

Oracle Home:

D:\product\11.2.0\client_1\instantclient_11_2

Oracle Library:

D:\product\11.2.0\client_1\instantclient_11_2\oci.dll

re-open PL/SQL DEV , enter the user name password to successfully connect to the Oracle database.

This article is from the "Linux_cheng" blog, make sure to keep this source http://6764097.blog.51cto.com/6754097/1612471

PL/SQL Dev remote Connect Oracle