PL/SQL remote connection Oracle 10g Learning Series (6)

Because I do not have Oracle installed locally, using PL/SQL Developer Remote Connection server requires the following configuration:

1. Software Preparation

Oracle Client: Instantclient-basic-win32-11.2.0.1.0.zip

PL/SQL Software: Pl/sql_developer.zip

2.oracle client decompression, placed in the D:\OraclerProgram\instantclient_11_2,

Also new file D:\OraclerProgram\instantclient_11_2\network\admin\tnsnames.ora,

Tnsnames.ora can copy the $oracle_home\network\admin\tnsnames.ora from the server and then simply modify it.

Tnsnames.ora content:

ORCL =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.88.139) (PORT = 1521))

(Connect_data =

(SERVER = dedicated)

(service_name = ORCL)

)

)

)

3.PL/SQL Software installation, open after installation, add Oracle home directory name and OCI library address

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/58/1E/wKioL1Sp9A6TNSIzAAPJPz-ucNA448.jpg "title=" pl Sql.jpg "alt=" Wkiol1sp9a6tnsizaapjpz-ucna448.jpg "/>

4. Once you have identified, restart PL/SQL to connect to the database. Server to start monitoring and Oracle.

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/58/22/wKiom1Sp9JWg0bUkAAGm20j_DQk241.jpg "title=" Login.jpg "alt=" Wkiom1sp9jwg0bukaagm20j_dqk241.jpg "/>

This article is from "Kaka West" blog, please be sure to keep this source http://whnba.blog.51cto.com/1215711/1599198

PL/SQL remote connection Oracle 10g Learning Series (6)