Free to install Oracle client and PL/SQL

write in front:

Oracle is typical of C/S structure, the server provides instances of Oracle services, mainly for database management, object management and storage, data

Storage, query, database resources monitoring, listening and other services. The client is just a tool that interacts with the server, such as Sqlplus, in Sqlplus

Executes SQL statements to the server, the server performs the operations in SQL after parsing, and outputs the operation results to the client. This is the completion of a customer

The process of interacting with the server side. To put it simply, the client is like a Remote Desktop tool that is only responsible for providing the interface to the backend server, specifically handling

Operations are on the server.

in the previous article, we mainly explained Oracle server-side installation and configuration (Oracle installation and simple configuration), typically in a development team

Inside the team, the server will be installed on a machine where you can connect and manipulate the database by installing the client locally.

Oracle customer user-side configuration.

Here we choose to use the install-free Oracle client. Reason:1. easy to use. 2. not with other dependent Oracle the program conflicts.

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

Just download the Instantclient-basic-nt-11.2.0.3.0.zip, and the rest is a package that expands according to different needs.

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

2.unzip to the local machine

because we now both the client and the server are on the local machine, all I unzip it to Oracle server under the installation directory.

I am here: F:\app\wyj\product directory under

3, configuration Tnsnames.ora

Save with Notepad new Tnsnames.ora file in the : F:\app\wyj\product\instantclient_11_2\NETWORK\ADMIN\ Tnsnames.ora

The content reference is configured below:

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

when you log in, "Cancel" is available. go to Preferences (Tools -preferences), select Oracleon the left, and "Oracle " on the right Home Directory

name "and OCI Library Address:

6, re-open plsql, enter the user name password, select the correct database.

7, Chinese garbled problem (Unified coding can reduce trouble for follow-up work)

/span>

    "Computer" -> " System Properties" -> " advanced system settings -> " System Properties / advanced , " environment variable" -> " system variable " ->" new " ->

Variable Name: Nls_lang

Variable Value: Nls_lang = American_america. Al32utf8

Problem Collation:

to here the whole Oracle installation is basically complete, the following summarizes the installation process needs some problems and solutions:

The following six services are available after the 1.Oracle installation is complete

ORACLESERVICEORCL : Database service ( db instance ) , is Oracle Core Services This service is the basis for database startup, only the service

service starts, Oracle database to start normally. ( must start )

because we use Pl/sqldeveloper is a third-party tool, so Oracleoradb11g_home1tnslistener The service also needs to be opened.

2. The listener is not installed.

( 1 You can refer to the following links to the method:

http://wenku.baidu.com/link?url=doN7uStcQMcfvBmellmGq3hZjoqlx8AJ_C76F6PXlkeeHwIKh4EOQkqE1QppHmxJ_ cad3ikr5zz-

Pqhexhsouqwrhsltmfkb3lb3uinqtyq .

( 2 Use administrator privileges to establish a monitoring service.

3. prompt for password error.

Whether the password was changed in the password management settings when the server side was installed.

4.Oracle Reload .

This is a headache problem, so the installation process should be cautious, as far as possible as required. The system may need to be re-installed because it is accidentally.

we can Follow The instructions in the link below to remove the

http://wenku.baidu.com/link?url=ldf12vqykloyezwm7td4w_obs4-

6xgez3hyyfili8njx7fj1hkmphstoxz1btzt9hizxlfj1d69rb4c-fzi-cnztyt9xxrnm5yixn4ffriw .

Summary:

The entire installation process is twists, it is this process, so that they have a lot of knowledge has a new understanding, such as: environment variable configuration, monitoring

Listen to the establishment of services, understanding of some services. And the whole process is to solve all kinds of errors, in this kind of discovery error and solve the wrong

To learn some new knowledge and summarize their existing problems. As long as the heart, learning everywhere.