PL/SQL Developer connecting 64-bit Oracle server-side Solutions

PL/SQL is a + -bit programs, only through + bit of Oracle Drive Connection Oracle server. If the Oracle server is 64-bit, you can only build the connection by using a single -bit Oracle client.

download a client to the website: http://www.oracle.com/technetwork/topics/winsoft-085727.html. Depending on the version number of the Oracle server, the corresponding client: Instantclient-basic-win32-11.2.0.1.0.zip is saved to the client under any path, such as d:\ Software\

1. Unzip Instantclient-basic-win32-11.2.0.1.0.zip to the current directory, the default is to generate instantclient_11_2 directory,

2. Enter instantclient_11_2 directory, new NETWORK Catalogue, enter NETWORK directory, new ADMIN directory, the last generated directory structure is as follows

3. in the ADMIN directory to create a new text file, named Tnsnames.ora, with this file as a monitoring service configuration file, the contents of the writing can refer to the official information, You can also refer to this example
orawin10g =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.8.3) (PORT = 1521))

(Connect_data =

(SERVER = dedicated)

(service_name = orawin)

)
)

Of course, copy can also be obtained from the corresponding directory of the Oracle server already installed.

4. After configuring these, open PL/SQL, click Cancel to not login, directly into the interface

5. Select Tools-preferences on the menu
Configure the path to the Oracle Instant Client in the lower right corner of the Options page .
Oracle Home input D:\software\oracle-instantclient\instantclient_11_2
OCI Library input D:\software\oracle-instantclient\instantclient_11_2\oci.dll
6.
Click OK , restart PL/SQL that's complete.

PL/SQL Developer connecting 64-bit Oracle server-side Solutions