Oracle --- use PL/SQL Developer to connect to Oracle12C (64-bit), oracle --- oracle12c

Oracle --- use PL/SQL Developer to connect to Oracle12C (64-bit), oracle --- oracle12c

Oracle --- connect Oracle12C (64-bit) version with PL/SQL Developer
1. Install Oracle 12c 64-bit
2. Install a 32-bit Oracle client (instantclient-basic-nt-12.1.0.1.0)

Download instantclient-basic-nt-12.1.0.1.0.zip and decompress it to the Product in the Oracle Installation Directory (the local name is instantclient_12 _ 1): C: \ app \ orcl \ product \ instantclient _ 12 _ 1.

Copy a directory C: \ app \ orcl \ product \ 12.1.0 \ dbhome_1 \ NETWORK under the root directory of the database to C: \ app \ orcl \ product \ instantclient_12_1 (in fact, only NETWORK \ ADMIN \ tnsnames is required. ora)

3. Install PL/SQL Developer

Install PL/SQL Developer and set OCI Library and Oracle_Home in tools> preference connection. For example, set the local machine:

OracleHome: C: \ app \ orcl \ product \ instantclient_12_1

OCILibrary: C: \ app \ orcl \ product \ instantclient_12_1 \ oci. dll

 

All the paths that appear in this article are the specific path of your own installation. Each installation may be slightly different, you must set the environment variables when installing Oracle12c and when installing the client.