Getting Started with Oracle (2)--using graphical tools Navicat for Oracle

"This article describes"

This article describes how to use the graphical tools Navicat for Oracle to connect to the local database and the remote access server database.

【】

Http://www.navicat.com.cn/download/navicat-for-oracle

"11G version access to local database"

Install Navicat for oracle--Open connection--pop up new connection--enter, there are several places to be aware of

(1) port : Because it is a local server, it can be filled in loaclhost or 127.0.0.1

(2) Service Name/sid : Here we fill in the SID, corresponding below should choose SID, if forgotten, can be used: Login server-Input command select instance_name from V$instance; View.

(3) User name and password : If it is a new database, has not created a new user, you can log on to the system users, system users are:

User name: System default password: Manager

User name: sys default password: Change_on_install as Sysdba

"10G version access to local database"

10G version (less than 10G version should be, did not try) with Navicat for Oracle when connecting to the database will be error:

Cannot load OCI DLL, 126:instant Client package was required for Baic and TNS connection

For more information:http://wiki.navicat.com/wiki/index.php/instant_client_required

This means that we have 64-bit Oracle installed, but because Navicat only supports 32-bit. Here's how to fix it:

(1) download Instantclient-basic-nt-11.2.0.3.0.zip, Address: http://www.oracle.com/technetwork/topics/winsoft-085727.html

(2) merge the extracted files into the Oracle installation directory under product, such as ... \product\instantclient_11_2

(3) open Navicat for Oracle, Tools--options--Other--oci,

Set up OCI library as: ... \product\instantclient_11_2\oci.dll

Set SQL *plus to: ... \product\11.2.0\dbhome_1\bin\sqlpuls.exe

Press OK.

(4) Repeat the 11G connection method can be.

"Accessing databases on a remote server"

As with 11G local access methods, you need only know the IP and SID and port of the server.

If you forget to log in to the remote server, take the following actions:

(1) IP: Run--cmd--ipconfig, 1

(2) SID : Run--cmd--Login database (based on username and password)--input command select instance_name from V$instance; 2

(3) port : The default port number is 389, the client's default port number is generally 1521. If it is not available, view it in the following ways:

A:listener.ora configuration text, where for example in: C:\app\Administrator\product\11.2.0\dbhome_1\hs\admin\listener.ora, 3

B: After starting the Oracle database service, open Task Manager--service--find oracleoradb11g_home1tnslistener--to see its PID (e.g. 8172)

Run the--cmd--input Netstat-ano to find a process with a PID (such as 8172), view its "local address", and the last few are the port numbers. 4

Figure 1

Figure 2

Figure 3

Figure 4