If HOST is the host name, remove the domain name behind the host name )ģ. Then confirm whether the HOST configuration is correct. (Note: The tnsnames.ora file can also be copied from the NETWORK\ADMIN directory of the Oracle database HOME directory, and sqlnet.ora should be copied over. ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = chiclewu-PC)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) ) Then create a new NETWORK\ADMIN directory in the decompressed C:\instantclient_11_2 directory, create a new tnsnames.ora file in the ADMIN directory, and add the database TNS. Unzip the downloaded Oracle Client file instantclient-basic-win32-11.2.0.1.0.zip to the C drive (note! 64-bit is not allowed). This is a green version of the Oracle Client, so as long as it needs to be decompressed, it can be.
#Pl sql developer oracle 64 bit download#
According to the above error message, it seems that only a 32-bit version of Oracle Client is installed.įirst go to the Oracle official website to download an Oracle 11g Client, but you need to apply for an Oracle account before downloading. However, it was found that PL/SQL Deleloper does not distinguish between 64-bit and 32-bit.
#Pl sql developer oracle 64 bit install#
It seems that you want to install a 64-bit PL/SQL Deleloper, so I searched the Internet for the 64-bit version of PL/SQL Deleloper. Still can't choose database TNS, try to log in without database, and see what errors are reported.įinally found the key point of the problem, the installed PL/SQL Deleloper can only recognize 32 oci.dll. Under the option of Oracle Home, the Oracle Home directory is not automatically recognized, so manually specify the Oracle Home path.Ĭlick "OK" to exit PL/SQL Developer and log in again.
![pl sql developer oracle 64 bit pl sql developer oracle 64 bit](https://www.allroundautomations.com/wp/inhoud/uploads/pls140-git-programwindow.png)
What about it? First log in to PL/SQL Developer in a non-login mode, set up Oracle Home and OCI Libaray. It stands to reason that when installing PL/SQL Developer, Oracle Home and OCI Libaray have been identified. I wonder why I can't choose the TNS of the database here? I installed the database first, and then installed PL/SQL Developer. Note that when installing PL/SQL Developer software, do not install it in the Program Files (x86) directory, otherwise PL/SQL Developer cannot be started. The installation steps of Oracle database and PL/SQL Developer are omitted here.