- #Oracle pl sql developer install
- #Oracle pl sql developer 64 Bit
- #Oracle pl sql developer professional
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.
#Oracle pl sql developer 64 Bit
However, it is found that PL / SQL deleloper does not distinguish between 64 bit and 32-bit.
#Oracle pl sql developer 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.
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. 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. 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. Our premium Oracle 1Z0-149 certification practice exam will boost your confidence as well as your actual Oracle Database Program with PL/SQL exam result.The installation steps of Oracle database and PL / SQL developer are omitted here. Our team of Oracle Database experts has designed Questions-Answers for this premium practice exam by collecting inputs from recently certified candidates.
#Oracle pl sql developer professional
If you want to test your Oracle 1Z0-149 knowledge to identify your areas of improvement and get familiar with the actual exam format, we suggest you prepare with the Premium Oracle Database PL/SQL Developer Certified Professional (OCP) Certification Practice Exam.
This Oracle Database Program with PL/SQL certification sample practice test and sample question set are designed for evaluation purposes only. To become familiar with the actual Oracle Certification exam environment, we suggest you try our Sample Oracle 1Z0-149 Certification Practice Exam. The Oracle Database Program with PL/SQL (1Z0-149) Sample Question Set is designed to help you prepare for the Oracle Database PL/SQL Developer Certified Professional (OCP) certification exam.