64-bit Win7 system installation 64-bit ORACLE11G experience sharing __oracle

Environment: 64bit Win 7 flagship SP1 patch

Win64 oracle11g----Win64_11gr1_database_1013.zip

1, the installation process occurs in a problem: The System Self-Test Upgrade system environment does not meet the requirements

Solution:

First find the path:

"E:/oracle enterprise_standard edition_11.1.0.6/database/stage/prereq/db/refhost.xml".

After you find the "refhost.xml" file, if you don't have the XML software installed, open the file in Notepad, and after you open it, we find the following node:

{

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

}

Replace the above nodes with the following nodes:

{

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

}

2, after the installation of the completion of the access problem, Plsql can not access the native 64-bit Oracle

Problem Description: Unable to find oci.dll error

Problem Reason: Oracle is 64-bit, oci.dll naturally, and Plsql_developer is 32-bit, unable to load 64-bit DLLs.

Workaround:

1. Download 32-bit Oracle instantclient, and expand to a directory, such as D:/oracleclient/instantclient_11_2;

2. Copy the Tnsnames.ora of the system to the directory; 3. Set the Oracle_home and OCI Library in Plsql developer, as shown in the following illustration: 4. Edit the following bat file under the Plsql Developer Directory, replace the shortcut, and start the Plsql Developer:

@echo off
Set Path=c:/oracle/instantclient_10_2
Set Oracle_home=c:/oracle/instantclient_10_2
Set Tns_admin=c:/oracle/instantclient_10_2s
Set Nls_lang=american_america. Zhs16gbk
Start Plsqldev.exe

3, in the subsequent ASP.net development, in the database access, error occurred.

To call a partial 32-bit DLL for publishing, configure-general-enable 32-bit applications in the IIS application process pool-true

Error description: "A badimageformatexception is raised when attempting to load an Oracle client library. This problem occurs if you are running in 64-bit mode with 32-bit Oracle client components installed. "

The workaround is as follows:

In fact, System.Data.OracleClient is pointing to the oci.dll under the PATH environment variable. So we just have to get the program to find the 64-bit oci.dll. The method is as follows:

1. Download Instantclient-basic-win-x86-64-11.1.0.6.0.zip, and unpack, such as c:/instantclient-basic-win-x86-64-11.1.

2. Add the above path in the system's environment variable path.

After restarting the operating system, the program looks for Oci.dll in accordance with the path path, and if a 32-bit oci.dll is automatically skipped, a 64-bit oci.dll will be able to connect to the database.