Plsql connecting to Oracle database via instantclient connection timeout

Configuration: Database oracle10.2, server operating system centos5.5, guest operating system Win7 32-bit, plsql version 10.0.5

Configuration must shut down the client and server operating system firewall, or the "Connection timed out" prompt, Plsql unable to connect to the database.

CentOS View firewall status and shutdown Firewall: Service iptables status; service iptables stop;

1, first download instant Client to Oracle website:

Http://www.oracle.com/technology/global/cn/software/tech/oci/instantclient/index.html>

Credential your control system select the Instant client version of the difference

Download back is a compressed file, unzip after the folder called: D:/instantclient_10_2. Put it in the directory you like. For example: d:/instantclient_10_2

2. In the D:/instantclient_10_2 directory under the new directory network, in the network directory and the new Admin directory, in the Admin directory under the new file Tnsnames.ora, using a text editor opened to write the following:

TEST =
(DESCRIPTION =
(Address_list =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.0.100) (PORT = 1522))
)
(Connect_data =
(service_name = test)
)
)

3, gaga a scene variable, named Tns_admin, the value of the Tnsnames.ora file is the path. For example, my machine is: D:\instantclient_11_2

4, set the Oracle speech, Gaga scene variable Nls_lang, the value is simplified Chinese_china. Zhs16gbk

Assuming the oracle of the long-distance database is not clear, SSH can telnet to the long-distance machine, is ordered interface input, with the ordered row adjacent to the database.

SELECT * from Nls_instance_parameters;

View the value of Nls_language

Nls_language

Nls_territory

5, download and demolition PL.SQL.Developer construction applications
Construction Tools->preferences->connection

Oracle Home
D:/instantclient_11_2

OCI Library

D:/instantclient_11_2/oci.dll

The PL/SQL developer in Chinese is

Objects--preferences--contiguous

Oracle Home Directory

D:/instantclient_11_2

OCI Library

D:/instantclient_11_2/oci.dll

6, close PL/SQL Developer, restart Developer.

Host name will appear in the list of PL/SQL developer, enter the user name sparse code, you can log in long-distance Oracle 11g database.

Compensation Instant Client Reputation

Oracle Instant Client is an Oracle-supplied, concise customer with a wide range of platform support. Available for download from the Oracle Web site for
Http://www.oracle.com/technology/global/cn/software/tech/oci/instantclient/index.html>

Contains the following content:

Instant Client package-basic Operation OCI, OCCI, Battle Jdbc-oci apply the full documents required by French.

Instant client Package-basic Lite: contains only English error messages, only supports Unicode, ASCII, Western European character sets.

Instant client Package-jdbc Supplement for JDBC and added XA, international warfare rowset manipulation.

Instant Client package-sql *plus contains the library files required for sqlplus warfare

Instant client PACKAGE-SDK uses Instant client to open up header files and examples for Oracle's application of French makefile

Instant client PACKAGE-ODBC The libraries needed to use ODBC, not all of them. Linux platform contains.

Basic Battle Basic Lite two must be selected, the other packages are optional. I downloaded Basic, JDBC Supplement, SQL *plus, SDK, ODBC. After decompression is placed under a folder, in the folder under the creation of files Tnsnames.ora, set the scene variable Ld_library_path War tns_admin point to the extracted directory, you can use Sqlplus.

I downloaded the instant client version for 10.2.0.2.0 and tested the Oracle 10.2.0.1 that adjoins to Oracle 9.2.0.4.

Instant client does not contain tnsping, Exp/imp, Rman, NETCA and other objects. If you need those objects, you need to remove the Oracle client

Plsql connecting to Oracle database via instantclient connection timeout