How to Use navicat Lite to connect to an Oracle database

 

I used toad for Oracle 9.0.1, which has powerful functions. Unfortunately, I think the program is too large and the memory consumption is serious.

 

If the program is not disconnected during shutdown, it cannot be shut down successfully. I am using navicat Lite to query mysql. It feels lightweight and I want to use this free software to connect to the Oracle database. It took a lot of time to perform connection tests, so I plan to record the intermediate process and hope to help my friends later.

 

(1) download the free version of navicat Lite in http://www.navicat.com/en/download/download.html.

 

(2) After the installation is successful, click Start. The page is as follows:

 

 

(3) Select the connected database ORACLE:

 

 

A form is automatically displayed for you to enter. Here I encountered several problems when using them. The error prompts are as follows:

 

A. Couldn't init Oracle OCI Environment

 

I didn't know what OCI was at the beginning. After searching, I knew that it was an oracle call interface, that is, an oracle call interface. This is required for connecting to Oracle. However, I have queried my navicat version. In the toolbar, choose --> Option --> OCI-> OCI Library (OCI. DLL) file, it is even more strange, it should be with OCI.

 

 

FindHttp://www.oschina.net/bbs/thread/3508 only to know that my oracle_region and oci.dllare not matched. To http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html

Download,

 

 

 

Instant Client package-basic, which must be filled in with basic information. The size is 49 mb. Download the package and decompress it to any folder. You can see a lot of files, including the OCI. dll file. It is OK to import the file. Then restart the navicat software.

 

An error is fixed.

 

B. ORA-12705: cannot access NLS data files or invalid environment specified, the second error encountered. Reference

Modify-> Regedit. Modify the/HKEY_LOCAL_MACHINE/software/Oracle search key nls_lang in the registry. This key is created by the Oracle standard client and the value is Na. This caused a ORA-12705 error. The solution is to change NA

Simplified chinese_china.zhs16gbk. The error is fixed.

 

C.ORA-01004: default username feature not supported; logon deniedThe third error, indicating that my user name and password are incorrect.

The correct filling method is as follows:

 

 

I compared the value I entered in Toad and found no errors. It was strange. So I was wondering why?

 

I checked some other options, because I checked the items that should not be selected.

 

 

Deselect the two drop check boxes and click connection test. A message is displayed, indicating that the connection is successful! Done!

 

Now you can use navicat to connect to Oracle, Which is lightweight and convenient. I like it very much. Hey, I hope it will help my friends. You do not need to use heavyweight toad, PL/SQL developer.