Free installation of Oracle client and PL/SQL

Preface:

Oracle is a typical C/S structure. The server provides oracle service instances, which are mainly used for database management, object management and storage, and data

Storage, query, database resource monitoring, monitoring, and other services. The client is just a tool for interacting with the server, such as sqlplus, in sqlplus

Run the SQL statement on the server. The server parses the statement and then executes the operation in the SQL statement, and outputs the operation result to the client. This completes a customer

The process of interaction between the client and the server. To put it simply, the client is like a remote desktop tool. It is only responsible for providing the interface that links to the background server.

All operations are performed on the server.

In the previous article, we mainly explained the installation and configuration of the Oracle server (Oracle Installation and simple configuration ).

The server is installed on a machine. You can connect to and operate the database by installing the client locally.

Configure the Oracle client.

Here we choose to use the Oracle client without installation. Reason: 1. Easy to use. 2. It will not conflict with other Oracle-dependent programs.

 

1. Download instantclient-basic-nt-11.2.0.3.0.zip

You only need to download instantclient-basic-nt-11.2.0.3.0.zip. Other packages are extended according to different requirements.

: Http://www.oracle.com/technetwork/topics/winsoft-085727.html

 

2. decompress the package to the local machine.

Because the client and server are both on the local machine, I will decompress it to the installation directory of the Oracle server.

Here I am: F: \ app \ wyj \ product directory

3. Configure tnsnames. ora

Create a new tnsnames. ora file in notepad and save it to: F: \ app \ wyj \ product \ instantclient_11_2 \ NETWORK \ ADMIN \ tnsnames. ora.

For details, refer to the following Configuration:

4. Install PL/SQL.
5. Open PL/SQL,

When logging on, click "cancel. Go to "Preferences" (tools-> preferences), select Oracle on the left, and enter "Oracle main directory" on the right.

Name and OCI library address:

 

 

6. Open PLSQL again, enter the user name and password, and select the correct database.

7. Chinese Garbled text (Unified encoding can reduce the trouble for subsequent work)

"Computer"-> "System Properties"-> "Advanced System settings"-> "system properties/Advanced tab"-> "environment variables"-> "system variables"->" new "->

Variable name: NLS_LANG

Variable value: NLS_LANG = AMERICAN_AMERICA.AL32UTF8

Troubleshooting:

Here, the entire Oracle installation is basically completed. The following describes the problems and solutions required during the installation process:

1. After Oracle is installed, the following six services are available:

OracleServiceORCL: Database Service (database instance), which is the core service of Oracle and the basis for database startup.

To enable the Oracle database. (Must be started)

Because PL/SQLDeveloper is a third-party tool, OracleOraDb11g_home1TNSListener must be enabled.

2. The Listener cannot be installed.

 

(1) You can refer to the following link:

Http://wenku.baidu.com/link? Url = response-

PqhexhsoUQwrhsltmFkb3LB3UInQtyq.

 

(2) Use the administrator privilege to establish the listening service.

3. A Password error is prompted.

Whether the password is changed in the password management settings when installing the server.

4. reinstall Oracle.

This is a headache, so you should be cautious about the installation process, as far as possible according to the requirements. Because the system may need to be reinstalled accidentally.

You can refer to the instructions in the following link to delete the file,

Http://wenku.baidu.com/link? Url = ldf12vQYKLoyEZWm7Td4w_OBs4-

.

Summary:

The entire installation process is a wave of twists and turns, which gives you a new understanding of a lot of knowledge, such as environment variable configuration, monitoring

The establishment of listener service and understanding of some services. In addition, the whole process is constantly solving various errors.

Learn new knowledge and summarize your existing problems. Learning is everywhere.