Using Sqldevelop to connect Oracle steps in RET Hat 6.2 in Linux

How to connect to Oracle remotely with Plsql on a computer that does not have Oracle installed

1. Load Instantclient, mine is WIN7, download is instantclient-basiclite-nt-11.2

Unzip to a fixed directory such as C:\instantclient_plsql

Create a file in the extracted directory Network\admin\tnsnames.ora

2. Edit the contents of the file, and note that IP and prot are used by remote Oracle

# Tnsnames.ora Network Configuration file:c:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora# Generated by Oracle configuration Tools.

ORCL = (DESCRIPTION = (Address_list = (ADDRESS = (PROTOCOL = TCP) (HOST = 172.16.176.110) (PORT = 1521)) (C Onnect_data = (SERVER = dedicated) (service_name = ORCL)))

Extproc_connection_data = (DESCRIPTION = (Address_list = (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1))) (CO Nnect_data = (SID = plsextproc) (PRESENTATION = RO)))

Note here:

1.

# Tnsnames.ora Network Configuration File:c:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora (if you're not in this directory, Just write your catalogue)

# Generated by Oracle configuration tools.

2. The

One to write well: the IP address of your Linux host, one is you: database name

3. Open, Plsql Develop set Plsql, menu is tools\prefrence

is to say that the directory is copied into the green can be seen, and then click OK, on the line

4. Then click here

OK, that's it.

5. Verify that

That means you're connected to Oracle.

Using Sqldevelop to connect Oracle steps in RET Hat 6.2 in Linux