Configuring Plsqldeveloper under Windows 8

Win 8 64-bit system installed 64-bit Oracle, but there is no 64-bit PL/SQL, can not connect to the Oracle database, how to do? The method is: we can implement the connection by installing a 32-bit Oracle client.

Tools/Materials

• PL/SQL Developer 9

• 32-bit Oracle Client

Method/Step

1. First, download the 32-bit Oracle client from the Web: Instantclient-basic-win32, unzip it after downloading to the local disk

2. Run PL/SQL Developer, do not enter user name, password, press "Cancel" to enter PL/SQL interface

3. Click "Tools"--"preferences"

4. In the Preferences window, enter the path of the Oracle client in the Oraclehome directory name , and enter the path to the Oci.dll in the OCI library

5. Desktop right-click on "Computer" and select "Properties"; In the System window, select "Advanced System Settings"

6. In System Properties, select Advanced--environment variables, create a new system variable, variable name: tns_admin, the variable value is the path to which the Tnsnames.ora file resides

7. 7

   Run PL/SQL again, enter the user name and password to log in

Configuring Plsqldeveloper under Windows 8