Still pl/sql developer is not picking up the file. All i want to know is when TNSNAMES.ora and oci.dll are present in C: oracle instantclient11 1. PL/SQL Developer opened, but you can't use. You need to configure the location of OCI.DLL file 32bit. Make sure you have installed the 32bit Oracle Client. PL/SQL Developer Initialization error Occurred This possibly occurs due to incompatibility between OS and Server. There are two possible solutions to your issue, Solution 1: Switch to the 64-bit Operating System (You have to install the whole new OS). More discussions in SQL & PL/SQL. This discussion is archived. 0 Replies Latest reply on Sep 28, 2007 7:39 AM by 569011.
- Could Not Locate Oci Dll Pl Sql Developer Key
- Cannot Load Oci Dll
- Could Not Locate Oci Dll Pl Sql Developer Database
- Oracle Oci Dll
- Could Not Locate Oci Dll Pl Sql Developer Query
Log in PL / SQL
Assume that Oracle 11gr2 database and PL / SQL developer are installed on the local computer.
If it is not installed, you can download and install it at the following address:
Oracle 11gr2 database:https://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html
PL / SQL developer (including registration machine)https://pan.baidu.com/s/1kUfY8GBPassword: 1ky8
First of all, open PL / SQL and you will find that there is no database to choose from. We can log in PL / SQL in a non login mode (just click Cancel).
Start setting: Tools > preferences, click connection under Oracle, and set Oracle home and OCI library.
As I have already set it, it is shown in the following figure:
The paths in the figure may be different. See your Oracle home directory for details. If you don’t know your own Oracle home directory, you can take a look in your own environment variables.
Click Apply > OK, exit PL / SQL developer and log in again.
Could Not Locate Oci Dll Pl Sql Developer Key
Try to log in to the database. The following error occurred:
Make sure you have the 32 bits Oracle client installed
This means that we don’t have a 32-bit Oracle client installed. Although the 64 bit Oracle is installed, we can only identify 32 clients instead of PLSQL. Then we will download and install the 32-bit client.
Installing the 32 bits Oracle client
First determine the specific version of Oracle11g installed on your computer:
You can see that the version is 11.2.0.1.0, then you need to download the corresponding version of the client, but it should be possible to download 11.2. To be on the safe side, we still download version 11.2.0.1.0.
32 bit Oracle client download address:
Official website:https://www.oracle.com/technetwork/topics/winsoft-085727.html
CSDN：http://download.csdn.net/download/ss123sswe/7166681
Baidu cloud:https://pan.baidu.com/s/1kTS1hifPassword: a8zr
The downloaded Oracle client is a decompressed version, so as long as you need to decompress it. Unzip the downloaded Oracle client file instantclient-basic-win32-11.2.0.1.0.zip (this is the client and must be 32-bit) to D: app (it can be unzipped to other places, but the following configuration needs to follow this one). Then, after decompressing the file, you can download the file in_ 11_ Create a new network / Admin directory under directory 2, and create a new directory in the admin directory tnsnames.ora File, add database TNS.
tnsnames.ora The file can also be downloaded from the network / Admin directory of the Oracle database home directory, D: APP / CLG / product / 11.2.0 / dbhome_ 1. Copy the network / Admin, and then sqlnet.ora Copy it. Since it is connected to the local database, write the host as localhost.
I feel thatCopy is betterWhen writing, there must be no space in front of it, otherwise it will not be recognized.
Configuring Oracle home and OCI libaray for PL / SQL
Enter PL / SQL in non login mode, set the path in the same way, and specify the Oracle home path as the Oracle client directory_ 11_ 2) The path of OCI libaray is oci.dll (D:appinstantclient_ 11_ 2 oci.dll )。 The specific configuration is as follows:
After the configuration is complete, save and push out PL / SQL.
Verify that PL / SQL recognizes the new Oracle client
Open PL / SQL and you will find:
The connect as option appears below. You can select normal, SYSDBA, etc.
Enter your user name and password to log in.
After logging in, we can check whether we can query the data:
Cannot Load Oci Dll
The query is successful. There is only one record X in the dual table.
Query is no problem, that is, PL / SQL developer is connected to the local Oracle 11g 64 bit database.
Remember to give me some compliments!
Carefully sorted out the various directions of the computer from the entry, advanced, actual combat video courses and e-books, according to the catalog reasonable classification, you can always find the learning materials you need, what are you waiting for? Pay attention to download now!!!
Never forget, there must be a response, friends help me point out a praise, thank you very much.
I am a professional bright brother, YY Senior Software Engineer, four years of work experience, refused salted fish strive to be the leading slash programmer.
Listen to me, more progress, a shuttle program life
If you are lucky enough to help you, please give me a “like” and give me a concern. If you can give me a comment and an encouragement, I will be very grateful.
List of articles by bright brother in the workplace:More articles
All my articles and answers have cooperation with the copyright protection platform. The copyright belongs to the workplace Liang brother. Without authorization, reprint must be prosecuted!
Symptom
Get the following error message when trying to connect to an Oracle database from PowerBuilder:
'Oracle Library OCI.DLL could not be loaded'
Environment
PowerBuilder
Windows 10 64-bit
Reproducing the Issue
Trying to connect to Oracle from PowerBuilder with the 64-bit Oracle client will cause this error.
Cause
Powerbuilder is a 32-bit application and therefore, can only connect to 32-bit database clients.
To verify whether or not the 32-bit Oracle client is being used run the Oracle SQLPlus program. Then open the
Could Not Locate Oci Dll Pl Sql Developer Database
Windows Task Manager and go to the Processes tab. Sort it by process name and look for sqlplus.exe. It will
look like the following if it is running as a 32-bit application:
sqlplus.exe *32
Oracle Oci Dll
Resolution
Could Not Locate Oci Dll Pl Sql Developer Query
Install the 32-bit Oracle client to resolve this issue.