Shulou(Shulou.com)06/01 Report--

Environment: win7 64bit flagship oracle 11g

Required software and download address:

Oracle 64bit client

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

PL/SQL DEV

Http://www.plsqldev.com/

Configure tnsnames.ora file instance

# tnsnames.oraNetworkConfigurationFile:F:\ oracle\ product\ 11.2.0\ client_1\ network\ admin\ tnsnames.ora# Generated by Oracle configuration tools. Local name = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = host ip address) (PORT = port number)) (CONNECT_DATA = (SERVICE_NAME = service name)

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

NLS_LANG=AMERICAN_AMERICA.AL32UTF8

There will be problems if the character set is not consistent with that of the oracle server.

Can be queried through select userenv ('language') from dual

TNS_ADMIN=D:\ product\ 11.2.0\ client_1\ network\ admin

Add D:\ product\ 11.2.0\ client_1\ bin to the Path environment variable

Installing the Oracle 64-bit client and then connecting to the oracle server with PL/SQL DEV will report an error

I need to go at this time.

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

Download instantclient-basic-nt-11.2.0.2.0.zip

Extract the instantclient-basic-nt-11.2.0.2.0.zip to the oracle client installation directory client_1

Open PL/SQL DEV and 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

Reopen PL/SQL DEV and enter the user name and password to successfully connect to the oracle database.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.