ORACLE11G database installation and use NAVICAT Premium for Oracle Database Connectivity

---restore content starts---

1. Download 11g on the Oracle website first
Oracle Database 11g 2nd edition (11.2.0.1.0) Standard Edition, Standard Edition 1, and Enterprise Edition, Oracle Database 11g 2nd edition for Microsoft Windows (x64) (11.2.0.1.0 ), (sign-in required):
Http://download.oracle.com/otn/nt/oracle11g/112010/win64_11gR2_database_1of2.zip
Http://download.oracle.com/otn/nt/oracle11g/112010/win64_11gR2_database_2of2.zip
Here i download ok can download directly: Link: https://pan.baidu.com/s/1sHRRX2eAo9jF13KjWeerRg Password: u15r

Extract two files together into the same folder under the same directory, do not appear in the path name in the Chinese language, and do not appear spaces and other irregular characters.
When the decompression is complete,

First, the preparatory work

Modify the file Cvu_prereq to enable it to be inspected by Oracle's environment

File Location: DATABASE\STAGE\CVU

File name: Cvu_prereq.xml

See figure I

What to modify:

Insert the following before:

See figure II

2nd step: Under the corresponding path, find "Setup.exe", double-click Run, install Oracle 11g.

Configuration Tutorial: Reference 79752750

Note: You can omit the prerequisites to check for errors here, and if you use Navicat premium to connect to an Oracle database, the installation client steps can be omitted.

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.

Third, 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!

ORACLE11G database installation and use NAVICAT Premium for Oracle Database Connectivity