6/22/2023 0 Comments Download navicat premium 64 bit![]() ![]() It is recommended to use a more concise basic mode, which eliminates complex tnsnames configurations. 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. 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). OCI is a standard database access library and a dynamic link library form retrieval function.īasic mode requires a host name or IP address, port, and service name or SID. 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. In Basic mode, Oracle is connected through the Oracle call Interface (OCI). ![]() There are two types of connection for Oracle in NAVICAT Premium: Basic and TNS. ![]() In navicat Premium configuration database connection Set the OCI library in Navicat Premium to D:\Databases\Oracle\instantclient_12_1_圆4\oci.dll, and then reboot to take effect.ģ. 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. The 32-bit and 64-bit instant clients are extracted and renamed, and the native decompression and renaming paths are as follows:ģ2-bit: D:\Databases\Oracle\instantclient_12_1_x32Ħ4-bit: D:\Databases\Oracle\instantclient_12_1_圆4 Give me the feeling that Navicat premium is more convenient, while the database, Pl\sql developer more professional, Oracle's development management more powerful. The official website is, the download version of this article is 10., the official also provides the Simplified Chinese language pack. PL/SQL developer focuses on ease of use, code quality, and productivity, giving full play to the key benefits of Oracle application development. PL/SQL Developer is an integrated development environment designed specifically for the development of Oracle Database storage program units. The official website is: Http://Since this machine is a 64-bit operating system, download the latest 11.1.10 64-bit version. 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 basic release contains all the files required to run the OCI, OCCI, and JDBC-OCI applications.Īs for why the 32-bit and 64-bit versions of the instant Client are downloaded separately, they are detailed later. The latest version is 12.1.0.2.0, which downloads the 32-bit and 64-bit versions of basic respectively. The Instant client is a streamlined version of the customer's website, launched by Oracle Corporation. ![]() Native: Windows 7 64-bit Software that needs to be preparedġ, Instant Client 12.1.0.2.0 32-bit and 64-bit Server Oracle Version: Oracle 11g R2 64-bit, character set is ZHS16GBK. 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.
0 Comments
Leave a Reply. |