Recently took over a project where the server-side database is Oracle 11g 64-bit. Because the main job is not development, and do not want to install a large Oracle database on their own computers, it is thought that only through the database management tools to connect the database for some common query operations.
The utility will not only download the correct version of oci.dll for absolutely free and suggest the right directory to install it but also resolve other issues related to the oci.dll file. Step 1: Click the “Download App. ” button to get an automatic tool, provided by WikiDll. PL/SQL developer errorCould not initialize oci.dll May 18, 2012 Leave a comment If you have the following error after trying to connect database using PL/SQL Developer It means that you don’t have 32bits client installed.
Operating Environment
Server: Windows Server 2008 64-bit
Server Oracle Version: Oracle 11g R2 64-bit, character set is ZHS16GBK.
Native: Windows 7 64-bit
- When starting Pl/Sql developer you first have to go to the preferences and then the connection part. (menu= tools = preferences). There you have to point Pl/Sql developer to your instant client in a windows way: C: oracle product instantclient102 oci.dll. After doing that, restart Pl/Sql Developer. Then it will load the oci.dll.
- 一直都在用Oracle SQL Developer,看网上对Oracle SQL Developer和PL/SQL Developer两种工具对比的很热,所以下载了PL/SQL Developer来玩玩。 下载安装完毕,打开登录提示Could not locate OCI dll,估计是找不到OCI.dll了,没有登录的进到工具界面,Tools->Preferences ,设置OC.
Software that needs to be prepared
1, Instant Client 12.1.0.2.0 32-bit and 64-bit
The Instant client is a streamlined version of the customer's website, launched by Oracle Corporation.
The latest version is 12.1.0.2.0, which downloads the 32-bit and 64-bit versions of basic respectively. The basic release contains all the files required to run the OCI, OCCI, and JDBC-OCI applications.
As for why the 32-bit and 64-bit versions of the instant Client are downloaded separately, they are detailed later.
2, Navicat Premium 11.1.10 64-bit
Navicat Premium is a set of database management tools that can be easily connected to MySQL, MariaDB, SQL Server, SQLite, Oracle, and PostgreSQL databases in a single program.
The official website is: Http://www.navicat.com.cn/products/navicat-premium.
Since this machine is a 64-bit operating system, download the latest 11.1.10 64-bit version.
3, Plsql Developer 10.0.5.1710
PL/SQL Developer is an integrated development environment designed specifically for the development of Oracle Database storage program units. PL/SQL developer focuses on ease of use, code quality, and productivity, giving full play to the key benefits of Oracle application development. The official website is http://www.allroundautomations.com/plsqldev.html, the download version of this article is 10.0.5.1710, the official also provides the Simplified Chinese language pack.
Give me the feeling that Navicat premium is more convenient, while the database, Plsql developer more professional, Oracle's development management more powerful. So select two software are installed.
Installation configuration
1, decompression instant Client
The 32-bit and 64-bit instant clients are extracted and renamed, and the native decompression and renaming paths are as follows:
32-bit: D:DatabasesOracleinstantclient_12_1_x32
64-bit: D:DatabasesOracleinstantclient_12_1_x64
2. Configuration of Navicat Premium OCI
In fact, Navicat Premium comes with instantclient_10_2, but it is a lite version of Base Lite (Basic Lite:basic, with only English error messages and Unicode, ASCII and Western European character set support), the Chinese character set is not supported, and the server-side Oracle in this article happens to be the Chinese character set, instantclient_10_2 is not appropriate, so you need to download the base version.
Set the OCI library in Navicat Premium to D:DatabasesOracleinstantclient_12_1_x64oci.dll, and then reboot to take effect.
3. In navicat Premium configuration database connection
There are two types of connection for Oracle in NAVICAT Premium: Basic and TNS.
Basic
In Basic mode, Oracle is connected through the Oracle call Interface (OCI). OCI is an application interface that allows program developers to access the Oracle database and control the stages in which all SQL statements run by using the third-generation language legacy process or function call. OCI is a standard database access library and a dynamic link library form retrieval function.
Basic mode requires a host name or IP address, port, and service name or SID.
Tns
In TNS mode, you need to use an alias item in the Tnsnames.ora file to connect to an Oracle server through Oracle call Interface (OCI).
In TNS mode, you need to use an alias item in the Tnsnames.ora file to connect to an Oracle server through Oracle call Interface (OCI).
The TNS mode only needs to select the network service name, but before you need to create a new Tnsnames.ora and configure the database service.
It is recommended to use a more concise basic mode, which eliminates complex tnsnames configurations. The basic model is used in this article.
In the 'New Connection' interface, enter the connection name, connection type, hostname or IP address, port, service name or SID, username and password, and click OK to connect to the database.
4, configure the OCI of plsql Developer
In the Preferences-oracle-connection interface, configure the Oracle home directory name and the OCI library.
Oracle Home directory Name: D:DatabasesOracleinstantclient_12_1_x32
OCI Library: D:DatabasesOracleinstantclient_12_1_x32oci.dll
5. Configure database connection in Plsql developer
The Plsql developer can also be configured with the basic and TNS connection modes.
The main difference between the two is that the database entry, the basic mode needs to enter the 'hostname or ip/service name' format data connection string, TNS mode can be selected in the drop-down box in the configured database.
As with Navicat, it is recommended to use a more concise basic mode, while setting up Plsql developer to keep the login history is much easier.
6, solveplsql developer Query Chinese table appears question mark garbled problem Penurunan rumus venturi dengan manometer.
In Plsql developer, querying a table that contains Chinese characters will become a segment question mark, mainly because the server is not the same as the client's character set.
Execute the following SQL statement to view the server database character set:
SELECT * from V$nls_parameters
The main parameters are:
Nls_laguage:simplified Chinese
Nls_territory:china
Nls_characterset:zhs16gbk
Nls_territory:china
Nls_characterset:zhs16gbk
So in this machine we need to configure the following environment to ensure the consistency of the server and native character sets.
Variable name: Nls_lang
Variable value: Simplified Chinese_china. Zhs16gbk
Check the Chinese table again, we will find that Chinese is normal again.
A picture to outline
At this point, using the client Navicat Premium and Plsql developer through the Instant Client Connection server Oralce the installation configuration process for the database has been completed.
Spit Groove
In fact, the installation of the configuration process is not as easy as expected, but we have to hold the 'nothing to do, things are not afraid of the matter' attitude to solve the problems encountered. The main problems with the spat are the following:
Issue 1:navicat report ora-12737:instant Client light:unsupported server character Set ZHS16GBK The problem is caused by the direct use of Navicat-instantclient_10_2.
Comes with a basic lite version of the instantclient.
Lite version of Basic Lite:basic with only English error messages and Unicode, ASCII, and Western European character set support
Basic: All the files required to run the OCI, OCCI, and JDBC-OCI applications, including the Chinese character set.
The solution is to change the basic version of Instantclient.
You can click Http://wiki.navicat.com/wiki/index.php/Instant_client_required to view the official solution.
But formally looked at the official solution, so that I went around a good big curved to connect the database properly.
Navicat version 10 or below, Navicat only supports 32-bit instant client.
And I ignored the first sentence, understood as Navicat only support 32-bit instant client, download 32-bit instant client, but Navicat version 11, note we use Navicat version 11,navicat version 11 The 64-bit version does not support 32-bit instant client, only supports 64-bit instant client, and most of the articles on the web are NAVICAT version 10 using the 32-bit Instant Client connection database, So I have always suspected that the decompression of the wrong, repeated trial and error, wasted a lot of time to wake up.
Connect Oracle Database Memos with Navicat Premium and plsql developer in 64-bit Win7
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.
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
Could Not Locate Oci Dll Pl Sql Developer Database
CSDN:http://download.csdn.net/download/ss123sswe/7166681
Dt 1 v drums tutor software, free download. 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
Could Not Locate Oci Dll Pl Sql Developer Key
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:
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!