In a 64-bit Win8 system, the Pl/SQL connection Oracle setup tutorial, win8oracle

In a 64-bit Win8 system, the Pl/SQL connection Oracle setup tutorial, win8oracle

On Windows 8 64-bit system, 64-bit Oracle is installed, but there is no 64-bit PL/SQL, And the Oracle database cannot be connected. What should I do? There are some methods: we can install a 32-bit Oracle client to achieve the connection.

First, download the 32-bit Oracle client: instantclient-basic-win32, download to the local disk and decompress

Run PL/SQL Developer. If you do not enter the user name or password, press "cancel" to enter the PL/SQL interface.

Choose tools> preferences"

In the "Preferences" window,Oracle main directory nameEnter the decompressed path of the Oracle client,OCI LibraryEnter the path of oci. dll

Right-click computer on the desktop and select properties. In the system window, select Advanced system settings"

In "System Properties", select "advanced"> "environment variables" to create a new system variable. The variable name is tns_admin. The variable value is the path of the tnsnames. ora file.

Run Pl/SQL again and enter the user name and password to log on.