How to install the oracle10g_64-bit version in a win7_64 environment

Shortly after contacting Oracle, there were a lot of problems when installing a deployment link to Oracle, and SQL Server was just so friendly.

There may be errors in the article, please identify.

the important steps of the article are marked with a yellow background . (at the bottom of the summary version )

recommended first look at the yellow font marked area , the number of hearts, and then open other Help links (other blogs are better than bloggers, afraid you see the escape)

Reproduced please indicate the source, although not well written, but the code from the word, indeed very tired.

If you have previously installed Oracle software, it is recommended to completely uninstall (there is no need _ I do not know _)

Reference Baidu Experience: http://jingyan.baidu.com/article/64d05a02655d10de54f73b67.html (do not know how to insert hyperlinks, irritability)

After cleaning up an older version of Oracle, start installing the oracle10g server side, first with an installation package

Try searching for this keyword:10204_vista_w2k8_x64_production_db

There is no problem with installing this version.

For example, Huawei Network disk this address: HTTP://DL.DBANK.COM/C0Y3GVFQPJ (if not coincidentally, resources are gone, trouble yourself to find it)

After the server-side download is complete, then install it, install the diagram, Baidu can be handy, such as this:

Http://jingyan.baidu.com/article/c1a3101e9118e4de656deb92.html

(because the version is different, the above download version is not modified compatibility and other operations, this is not the right thing)

If you can't follow the tutorial above, then there is a console window:

Then search for Oraparamin the installation package and find one of the rows windows=5.0,5.1,5.2,6.0

Obviously you should know how to change it, like windows=5.0,5.1,5.2,6.0,6.1.

You will find that the above failure has become, through. So it can be installed.

The middle step, just a little bit, because there are a lot of other tutorials, there is not much to say.

After entering the installation interface, also point the next step, in the detection of the error reported this, directly fried well.

Checking operating system requirements ...
Required result: one of the 5.0,5.1,5.2,6.0
Actual results: 6.1

Slightly adjust the mood, the same in the installation package search refhost.xml , search for two files, are modified according to the following method

<!--Microsoft Windows 7-->
<OPERATING_SYSTEM>
<version value= "6.0"/>
</OPERATING_SYSTEM>

Change this 6.0 to 6.1 (at the moment you do not change, add a 6.1 there is no problem)

OK, there should be no other problems, the default is good, let the password input, and remember, no harm.

However, in the creation of the database, it is likely to be stuck in the location of the 85% (for a long time), how to do, do nothing, quiet away, after a while.

Without an accident, the database is already installed.

But sometimes we need tools such as PL/SQL to link the Oracle server.

At this time, you will probably need the help of this link: http://blog.csdn.net/cselmu9/article/details/8070728

Under the 32-bit version of the client tool, I downloaded the name: instantclient-basic-win32-10.2.0.4

After you open the download link, pay attention to find the correct version, whether there is any problem with other version links, I have not tried, you can tell lazy bloggers after the trial.

The above link, the second step is to modify the Tnsnames.ora, directly in the Oracle installation directory, search for tnsnames , and then copied to the client unzipped folder

(Do not have to manually copy which letters, lazy, and will not be wrong)

Note that the above client (about 100M left), do not need to install, you can not install, decompression is good, remember where it is good.

Still, it's important to note that it's a good thing to change TNS. This file indicates how your client links the database.

In this way, it is also important to bind Plsql with the client. (Remember to download the sqlplus8.*) series.

No user login (that is, after the click Cancel, go directly into the)

Click Functions (Tools), modify Preferences (Preference)

That's how it's changed:

Yes, the above two addresses, is the address of your client, you unzip where, you click where. (where not to point)

Reboot the Plsql and connect it.

This time, whether using plsql or SQL plus link to the Oracle server is not a problem, you can use the Scott users, test, such as the DMP table query.

However, the link to the remote server is still a problem, such as the server in a machine, and you are in C.

Then set the Netmanager (for other versions of the client) above the client I did not find Netmanager, so I have to manually modify the above, the TNS file

IP set for the server's IP, how to change, and so I return to the company to study it. (In fact, the purpose of setting up Netmanager and modifying TNS is the same, let the client confirm:

How to link a database, which database (network name) to connect to

Is the database ORCL this thing, this thing is actually stored in the TNS file, for example, you set with Netmanager, set the network name when the input SHARPL,

(You can enter any name you want), then the database that drop-down box should be selected, SHARPL.

Write it first, find other questions, and then update it.

Summarized as follows:

Three installation packages are required:

First 64-bit Oracle, then 32-bit client, then Plsql

1, first encountered the first problem:

The server side is not able to control the console:

Find Oraparam, add 6.1 in two places, and the console can be

2. A problem occurred during the installation of the database:

Find Refhost.xml, and change 6.0 of them to 6.1;

3, in the installation process to 85% error, skip directly, no tube, but have to wait a while.

4, error linking Oracle with Plsql:

Solution: Search for Tnsnames.ora in the Oracle installation package and overwrite the files in the network/admin in the Plsql installation package.

5, do not log into the Plsql, modify the preferences, modify the Oracle home directory named client address, and modify the OCI library for the client's OCI, restart PL/SQL.

How to install the oracle10g_64-bit version in a win7_64 environment