I. Connection to Oracle
The following is a tutorial on Navicat Premium Connection to Oracle database
first, need to prepare the software (download the software suitable for your own system)
1.Navicat Premium
Official: Http://www.navicat.com.cn/products/navicat-premium
2.Instant Client
Link: Https://pan.baidu.com/s/1kMWBuskD5sN942nf9zBLPQ Password: WUJW
Second, installation configuration
1. Extract the two compressed packages from the instant client to the same folder .
2. Configure the OCI for Navicat Premium (click Tools---> Options---->oci)
Set the OCI library in Navicat Premium to the Oci.dll in the folder you just unzipped, setting Sql*plus to Sqlplus.exe
Such as:
then the restart takes effect.
3. Connect Oracle
1. Open Navicat Premium, click Connect to select Oracle
2. Fill in the connection information
There are two types of connection for Oracle in NAVICAT Premium: Basic and TNS.
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.
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.
Click on the connection test to test success and prove the connection is successful!
Second, the basic operation of Oracle:
Basic Operations Reference Tutorial: (in Oracle, a user represents a different database, so you can manage multiple databases by creating different users)
52254101
Enable Oracle connectivity and basic operations with Navicat Premium