Oracle Client Installation + PL/SQL Tools installation Configuration

Oracle Client Installation + PL/SQL Tools installation Configuration

1. Download the Oracle client and install it locally.

11g is:

Http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

10g is:

Http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

Select the appropriate client based on the version of your machine or Oracle server. 10. The 2.0.3 version is specifically designed for Win7.

1. Install the database developer in native SQL Developer (or SQL developer, but it needs to install Java, not the Oracle client).

PL/SQL developer:

Http://www.allroundautomations.com/registered/bodyplsqldev.html

Sql developeR:

Http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html

Specific installation steps:

1, the Oracle client installation process is basically the next step. But there are a few points to pay attention to.

1) Select the installation type. There are 4 installation types available and you can choose the type to install according to your requirements.

2) Remember to specify the home directory details. To remember the path of the tailed bird installation.

3) in the product prerequisites check, it is very likely that the system automatically checks for failure, the first item listed shows an error, and the second item shows no validation passed. At this point, direct click on the next step is not installed. In this page, you can manually select to achieve "user verified". After manual selection, display as.

2, install Pl\sql. The installation process is simple and is basically doing the next steps.

3, configure the Pl\sql tool.

1) pl\sql Start the software, select Toos->preferences. Configure Oracle Home and Ocilibrary. Depending on the Oracle installation path, the selected item is listed in the drop-down box. After the reboot, the completion configuration can be performed.

2) Modify the Tnsname.ora file. Its existence directory is: "%oracle_home%\10.2.0\client_1\network\admin", depending on the installation directory of their own changes, the Oracle folder after the path is generally the same.

Tnsname.ora file in the path under the description requirements and fill specifications.

Specific examples:

Orcl=

(DESCRIPTION =

(Address_list =

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

)

(Connect_data =

(service_name = ORCL)

)

)

In the actual configuration process, you only need to modify several positions on the top of the logo.

A. The database description, which can be defined by the individual itself, is primarily a distinction between individual databases.

B.host the IP of the database server

C.port ports: The port number set by the database server.

D.service_name: The service name set by the database server.

4, Pl\sql connection database.

Start the tool. Enter the user name, password login can.