Wind Cleaning Yang Zhi Oracle Installation and instructions

Original: Wind Qing Yang Zhi installation and description of Oracle

1.Oracle website and

1. Oracle Chinese official website: http://www.oracle.com/cn/index.html
2. Oracle Chinese official website download: http://www.oracle.com/technetwork/cn/database/enterprise-edition/downloads/index.html
3. Oracle English website: http://www.oracle.com/index.html
4. Oracle English website Download: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html
5. The Oracle version is not specifically described below: Oracle 11g R2

Installation steps for 2.Oracle (Windows System)

1. Oracle installation Nothing to say is the next step. Note: What configuration updates, check updates and so on all skip, even if the installation process to report what error can be ignored

to ignore.

1. If the hand-click Configuration at the end is not the configuration you want, you have two options:
   1. 1. 1. 1. 1. 1. 1. 1. Baidu Google to solve their own.
                        2. Remove the reload.
2. Uninstalling Oracle compares egg pains, unlike SQL Server with a fool-like uninstall. But the great God is ubiquitous, click to view the Oracle 11g full Uninstall chapter.

3. Refusing to be blind and understanding your needs

The company now use Oracle, for small white I can only turn to experienced veteran, he told me to install the Oracle server and client, and then installed PL/SQL Developer, finally help

I configure the next file. For the custom Microsoft Easy-to-operate I, so tedious work I can't stand, I think this is anti-human operation, lasted an afternoon of God

Soul Walk plus Consult, finally according to the way the veteran installed. Look at the old birds configure this configuration that, if a pair of tall on the look, immediately a pair of worship feeling spontaneously, so

Determined to learn this operation, after good to others said: "I am good at AI, Fw, Fl, Br, Ae, Pr, Id, PS and other software installation and uninstallation, proficient in CSS, JavaScript,

Spelling of words such as PHP, ASP, C, C + +, C #, Java, Ruby, Perl, Lisp, Python, objective-c, ActionScript, Pascal, familiar with Windows,

Switching machines for Linux, Mac, Android, IOS, WP8, etc. but you just need to spend half an hour reading about Oracle online, and you'll find these

And then there's no egg to use. When you encounter difficulties, do not expect others there will be the answer you want, every time you choose, your every experience, is your future strong to the non-unremitting

can be The cornerstone of the attack.

3.1 When do you need to install Oracle server?

1. When you need to create a database on this computer or read a database file on this computer, you should install the Oracle server, which is typically an Oracle learner.
2. Oracle Server.

3.2 When do you need to install an Oracle client?

1. 1. When you need to perform CRUD operations on a database's data tables (and, of course, through a program).
   2. Installing OracleClient is easy to manage and operate when you need to connect and operate with multiple Oracle instances or with multiple services.

3.3 Oracle Client

1. 1. I think there are only two types of Oracle clients:

1) Oracle installation package client.

2) Oracle Instant Client.

Note: I personally understand that such as: PL/SQL Developer It's just an integrated development bad environment, it is not possible to connect with Oracle services separately. But why

Do you want to use it? Since it is an integrated development environment, there are certainly the following features:

1. easy to use;

2. Improve developer efficiency.

For example, Microsoft's IDE (Visual studio xxxx) is a cosmic-level integrated development environment.

2. Simple Introduction to install Oracle Instant client +pl/sql Developer

1) First you go to the above address select the product you need to download: Instantclient.

2) Go online to the next PL/SQL Developer (installation is not said).

3) First extract the instantclient to a directory.

4) Install PL/SQL Developer.

5) Start PL/SQL developer-"Tools-" preferences, specific

6) under Oci.dll, create a new folder name: Network (Windows System directory name is case-insensitive), and then in the network file

Create a new folder in the clip name: admin, then you create a new file in it: Tnsnames.ora (suffix. ora), all operations are completed,

Only the configuration of this is called the Tnsnames.ora file content, then I wondered why MD so a bird name, I myself to translate roughly as follows: Transparent

Network substrate names (for me only), that is, by defining the local hostname of the remote service to map the true service address, we want to connect a machine

A program that needs to know at least:

1. IP of the machine (where);

2. Port (the program for this machine);

3. What is the protocol you use to connect?

4. You need to know even the database, the service name, if you have a database.

Then the Tnsnames.ora file format is out,

7) Why do I Need (Tnsnames.ora) This bird thing?

Because PL/SQL developer has no place for you to fill in any IP ports, etc.

8) In fact, you are configured through Oracle's net Manager and will eventually generate this bird-tnsnames.ora, which should be the style of Oracle.

9) So generally in the company only need to use Oracle's instant client + PL/SQL developer, because the company will certainly have a test library and build library.

Configuration under 5 minutes, so there is absolutely no need to go to Ann what server and so on.

4. Summary

1. Don't think someone else will have the answer you want.
2. People must have scientia spirit, refused to take doctrine, others help you fix or at that time taught you to take care of, you do not necessarily learn, more consolidation more thinking.

Wind Cleaning Yang Zhi Oracle Installation and instructions