Oracle 11gR2 for Win7 Ultimate 64 installation and connection Plsql and Navicat (win64_11gr2_database) (2012-12-31-BD written log migration

Go to Oracle official website http://www.oracle.com/technetwork/cn/database/enterprise-edition/downloads/index.html download the necessary database installation files:

Here to agree to its agreement to download:

Click to accept:

Below we go to download the installation file:

Just right-click on your download tool to download it.

Here's the point: 32-bit clients you can choose no longer because we're going to the next Plsql Developer 9 Chinese Green version (free install oracle,client update to 11G2) can use the database without installing Oracle's client. Why use a 32-bit client because the 64-bit client can not use Plsql I tried as if everyone on the Internet is using 32 of the client, if you want to use 64-bit client may also install to try! The next 32-bit client:

Download it and unzip it directly.

Start the installation below:

Go to database and click Setup.exe to install:

Remove I want to pass my Oracle support ... Front of the small tick click Next:

Click Yes

Select Create and configure a database click Next:

Select the desktop type (my laptop) and click Next:

Enter an easy-to-remember password as a warning, just leave it alone. Click Next:

Choose Yes

Check

Click Finish to start the installation:

Install the main program

To create a database:

Get! If you want some user's password can click password Management:

But it's best not to move it:

The installation is successful!

First Test if you can connect to the database:

Go to the command line test:

Ok! OK

The following changes its auto-start service:

Input Services.msc Enter

Oracle's Services

Change its auto-entry to manual! When it's time to start it, if it doesn't change your chances, it's slow. The database is now ready! Here's how to connect it with Plsql:

First go to the next Plsql Developer 9 Chinese green version of the free version of the I was to go to Sina download (you can choose to download on the Internet)

Log in and click Download Now! However, it is packaged into two files:

Plsql Developer 9 Chinese Green version (free installation oracle,client update to 11G2). Part1.rar

Plsql Developer 9 Chinese Green version (free installation oracle,client update to 11G2). Part2.rar

Must be two files simultaneously extract to a file and just the Oracle database decompression method is the same, here is not

After decompression open that folder is these three files, I put "plsql Developer 9 Chinese Green version (free install oracle,client update to 11G2)" This file name changed to

Plsql Developer 9 is placed in the D-Drive program files below see Plsql Developer 9 is plsql Developer 9 Chinese Green version (free installation oracle,client update to 11G2)

This unzip the file out! Do not open with the need to configure monitoring:

Find the following two files in the path path to install Oracle:

Location of your installation path you know, we need to copy the listener and tnsnames two files into the file.

Overwrite the original two files in the Plsql (you put the path to find it yourself):

You can run Plsql down here.

Run Plsql.exe

Enter the password you set to click OK to enter:

Login Successful!

Here's the Navicat! First go to the next navicat I was in the download bar (you can choose to download on the Internet)

Install it yourself after downloading! Then open it to connect to the Oracle database

Connection test:

Error can not find Oci.dll then we will configure it:

Click Options

Select OCI the path I configured is

D:\Program Files\plsql Developer 9\bin\instantclient_11_2\oci.dll

D:\app\jiangxieyang\product\11.2.0\dbhome_1\BIN\sqlplus.exe

Your path corresponds to finding your last click OK!

The connection is successful!

Finally, the installation of the 32-bit client because some people don't plsql like to use Navicat and that

D:\Program Files\plsql Developer 9\bin\instantclient_11_2\oci.dll

The path is in plsql so you have a 32-bit client!

To the client file, click Setup.exe to install 32-bit clients:

Here if you choose the Administrator (it's full-fledged) on the line! But if you feel too big you can also choose the first instantclient only install this can also connect navicat after all just get

Oci.dll on the line, I just chose the first one click Next:

Next (if you want to change the path to select Browse does not recommend change)

All failed properly! You can ignore all mandatory installations and generally do not affect features

In fact, Oracle performs prerequisite checks that rely on the C $ share, and many system administrators turn this off for security by default, causing the check to pass. The Open method is simple, make sure that the Server service in the service is working properly, and then enter net share c$=c in the cmd command console: But I don't want to share!

Resolute not to share! Tick all ignore next, walk you!

Click Done!

Installation!

Ok! It's done!

And then put in the Navicat:

D:\Program Files\plsql Developer 9\bin\instantclient_11_2\oci.dll

Change to D:\app\jiangxieyang\product\11.2.0\client_1\BIN\oci.dll

Control your own installation path to change! After the test

It's finally done! The END thank you for reading

Oracle 11gR2 for Win7 Ultimate 64 installation and connection Plsql and Navicat (win64_11gr2_database) (2012-12-31-BD written log migration