64-bit Oracle client deployment

In this article, the server environment is win2008r2 64bit. The Oracle client used belongs to the developer edition, which is only 53 MB and has no UI operation interface. The installation is manual;

Applicable to the formal running environment;

: Odac112021xcopy_x64.zip

1. decompress the package and run CMD in the directory. If you want to run it directly, such as "C: \ odac112021xcopy_x64 \ install. Bat", an error is reported. The installation takes about one minute. Don't be nervous!

Note: If you only want to call the client and do not use odp.net, you do not need to install all. Just install basic and copy instantclient_11_2 directly to drive C and rename it to Oracle.

 

2. add the Oracle path "C: \ oracle" in the environment variable "path"; create the environment variable ORACLE_HOME = c: \ oracle, you can also use the following command line (I do not know why it is invalid)

Add the file Network --> admin --> tnsnames. ora

 

3. Add tnsnames. ora

Create folder network, admin, create tansnames. ora

4. to configure PL/SQL, a 32-bit client is required.

 

Support for PL/SQL: Download odac112021xcopy_32bit.zip, install it in basic, copy instantclient_11_2 to drive C, and change it to oracle32,

If you have configured a 64-bit Oracle, you do not need to add the tnsnames. ora file. The program will read the files in the 64-bit oracle.

Add c: \ oracle32 in path and configure PL/SQL

Successful:

Conclusion: Put the 32-bit 64-bit client on the C drive and write all the paths, and then OK.

 

2011-11-22

If you only want to install a query tool, you can also use

Oracle SQL developer Release 3.0 (3.0.04.34)

This does not require support from the client. We recommend that you use this function!

 

2012-2-17

If you need ASP to connect to Oracle through oracleinprocserver. xorasession, you need to add and install oo4o. The command line is as follows:

D: \ soft \ odac112021xcopy_32bit> install oo4o c: \ oracle32 myhome true

Garbled query results

Solution: Change nls_lang to simplified chinese_china.zhs16gbk. If it is a 64-bit operating system, make the same modification in the wow6432node directory.

Reprinted: http://www.cnblogs.com/ruijian/archive/2012/06/05/2536513.html