Restart PL/SQL Developer and you should be able to connect now. Under Oracle Home, point to the location where you had extracted Instant client (\instant_client, in this case) and under location of OCI Library, point to the oci.dll file present in location where you had extracted Instant client ( \instant_client\oci.dll). Next, configure PL/SQL Developer to use this version by clicking on Tool menus -> Preferences. First download plsql developer 64-bit installation note, please go to the official website to download plsql developer, to avoid downloading an insecure client to cause database ransom if you use the cracked version of plsql developer, please check the installation directory The contents of the Afterconnect.sql and login.sql files, the default installation size of these two files is within 1KB. To fix this, download the 32-bit version of Oracle Instant Client, extract it to a directory such as \instant_client. Despite ORACLE_HOME being set the right values and oci.dll available, PL/SQL Developer could not connect to the database.įurther probing indicated that the Oracle installation was a 64-bit one, and PL/SQL Developer is incapable of loading 64-bit version of oci.dll file. Oracle SQL Developer 64-bit PL/SQL Developer consists of components that provide the tools for developing PL/SQL applications. Quick post: I was trying to connect to a 64-bit Oracle database using PL/SQL Developer.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |