I installed the Oracle 11g version of the database service on the PC, and I always connect to the database through PL/SQL.becausePlsqlNo --bit version, through32bitof thePlsqlConnection -bit ofOracleerror, the first one needs to install a +bit ofOracleClient Toolsinstantclientfor conversion, the second typePlsqlcannot install to a directory name that contains parentheses()directory, otherwise the operation is unsuccessful. Below is a detailed description of the installation environment.
After the oracle11g is properly installed, you also install the ORACLE10G Client tool. There are two ways to solve this:
A Download the installation version
Download the oracle10g client, or download the oracle10g installation Client tool,
Then install, when the installation is complete, copy the oracle11g D:\oralce11g\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora to the oracle10g installation directory D:\ Oracle\product\10.2.0\client_1\network\admin\ under, if any, overwrite. \
then configure plsql to open the tools-->preferences window to configure Oracle Home and Oracle library, because Plsql does not display, I just described under the text, configure the Oci.dll library, open plsql, do not need to login, window--preferences/ Preferences--oracle (upper left corner of the window)---Connect to the/connection--configuration to the right of the Oracle directory to the oracle10g installation directory, OCI Library executes the Oci.dll file under the Oracle Directory Bin (when the directory is configured, the Oci.dll File selection dropdown box can be automatically identified)
Second, download the green version
1 , download Oracle Client
Download Instantclient-basic-win32-10.2.0.5.zip ,: http://www.oracle.com/technetwork/topics/winsoft-085727.html
2 , installation instantclient
Unpacking the installation package Instantclient-basic-win32-10.2.0.5.zip , unzip the directory: D:\Program files\destination files\oracleclient
then create a directory D:\Program files\destination files\oracleclient\network\admin
3 , copy Tnsnames.ora
will be D:\oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN under the directory Tnsnames.ora files are copied to D:\ProgramFiles\destination files\oracleclient\network\admin under
4. Configure the Plsql Oracle directory and the Oci.dll file.
Since Plsql does not display, I will describe the text, configure the Oci.dll library, open plsql, do not need to login, window--preferences/preferences--oracle (upper left corner of the window)---connection/connection--configuration to the right of The Oracle directory points to the installation directory of the oracle10g, and the OCI library executes the Oci.dll file under the Oracle Directory Bin (when the directory is configured, the Oci.dll File selection dropdown box is automatically recognized)