If the host is the host name, remove the domain name after the host name.)ģ. Then determine 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. (ADDRESS = (PROTOCOL = TCP)(HOST = chiclewu-PC)(PORT = 1521)) Then create a new network \ admin directory in the extracted C: \ instantclient ﹣ 11 ﹣ 2 directory, 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 Disk C (note! 64 bit). This is a green version of Oracle client, so as long as you need to decompress it, you can. According to the above error information, it seems that only one 32-bit version of Oracle client should be installed.įirst, download an Oracle 11g client on the Oracle official website, but you need to ap ply for an Oracle account before downloading.Ĭurrent download address: /technetwork/database/features/instant-client/index-097480.html It seems that we can only start with oci.dll.
#Pl sql developer download 64 Bit
However, it is found that PL / SQL deleloper does not distinguish between 64 bit and 32-bit.
#Pl sql developer download install
It seems that we need to install a 64 bit PL / SQL deleloper, so we search the Internet for the 64 bit version of PL / SQL deleloper.
![pl sql developer download pl sql developer download](https://static.filehorse.com/screenshots-mac/developer-tools/mysql-workbench-screenshot-04.jpg)
The installed PL / SQL deleloper can only recognize 32 oci.dll. Or choose not to database TNS, try to login without database to see what error is reported.įinally, the key point of the problem is found.
![pl sql developer download pl sql developer download](https://www.quest.com/images/asset/screenshot/328-235/toad-for-oracle.jpg)
Under the Oracle home option, 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 download pl sql developer download](https://igetintopc.com/wp-content/uploads/2018/05/Allround-Automations-PL-SQL-Developer-12.0.2.1818-Direct-Link-Download-768x280.jpg)
What about it? First, log in to PL / SQL developer in non login mode, and set Oracle home and OCI libaray. When PL / SQL developer is installed, Oracle home and OCI libaray are recognized. Why can’t we choose TNS of database here? I install the database first, then 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.