Free installation of oracleclient 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.

And the client is just a tool to interact with the server, like Sqlplus, in Sqlplus

Run SQL statements to the server, and the server runs SQL operations after parsing. and outputs the result of the operation to the client. That's it. A customer

The process of interacting with the server side. Simply put, the client is like a Remote Desktop tool. Only responsible for providing a link to the background server interface, detailed processing

Operations are on the server.

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

Team inside. The server is installed on a machine where you 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 dependencies Oracle the program conflicts.

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

Just need to download instantclient-basic-nt-11.2.0.3.0.zip to be able, the others are based on different needs to expand the package.

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

2.unzip to the local machine

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

I am here: F:\app\wyj\product folder 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 is configured as follows:

4. Install PL/SQL.

5. Open PL/ sql,

When you log in, "Cancel" is OK.

go to "preferences" (Tools - preferences), left side selection Oracle . On the right side, fill in theOracle home folder

name "and OCI The library address can be:

6, again open plsql, input usernamepassword, select the correct database can be.

7, Chinese garbled problem (unified coding can work to reduce the trouble)

    "Computer" -> " System Properties" -> " Advanced system Settings" -> " System Properties / advanced Tab " ->" 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 installation of 1.Oracle

      ORACLESERVICEORCL : Database service ( db instance " Core Services the service. Is the basis for database startup. just the service

service starts. Oracle database competency starts normally. ( must start )

as 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 link methods:

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 is changed in the password management settings when the server side is installed.

4.Oracle Reload .

This is a more headache problem, so the installation process should be cautious. Try to follow the requirements. The system may need to be re-installed as a result of carelessly.

we can to refer to the instructions in the following links to delete,

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

6xgez3hyyfili8njx7fj1hkmphstoxz1btzt9hizxlfj1d69rb4c-fzi-cnztyt9xxrnm5yixn4ffriw .

Summary:

The entire installation process is twists, it is the process. Let yourself have a new understanding of a lot of knowledge, for example: environment variable configuration, monitoring

Listen to the establishment of services, understanding of some services. And the whole process is to constantly solve all kinds of errors, in such a way to find errors and solve the wrong

To learn some new knowledge and summarize their existing problems.

Just do it with your heart. Learning is everywhere.

Free installation of oracleclient and PL/SQL