Developer Downloads. All software downloads are free, and most come with a Developer License that allows you to use full versions of the products at no charge while developing and prototyping your applications, or for strictly self-educational purposes. Hi, To set up DB environment similar to my Office, I installed Oracle 9i on my Windows 7(64 Bit) in my laptop.But in office we have Windows XP.
On this page
Components included
This Oracle Administrator client installation contains the following components:
- SQL*Net
- ASO (Advanced Security Option)
- Oracle ODBC drivers
- SQL*Plus
- MITAnsSeedGenerator, a Java program that generates a unique random seed for SQLNET.CRYPTO_SEED value. This program is deleted upon completion of the installation.
To add and configure 32-bit ODBC drivers on Windows 7 x64, you have to use the 32-bit version of the ODBC Administrator. To do this, open a command prompt and enter:
Getting Ready
- Back up your system. Before beginning any installation, IS&T recommends you have a current and complete backup of your existing system. While we have tested the install process, there is an infinite number of possible system configurations, and some may cause problems.
- Oracle 11g client is supported for Windows XP, Windows Vista, and Windows 7.
- It is not necessary to uninstall Oracle 9i in order to user Oracle 11g.
Choose Oracle client version
- BrioQuery users on 32-bit or 64-bit machines should choose the 32-bit Oracle 11gR2 client
- The 64-bit installer is available for users who do not need BrioQuery.
Installation Instructions
| Log in as administrator You will need to be logged in as an administrator to complete these instructions. |
- Select the 32-bit or 64-bit Oracle client and download the installer. See: Choose Oracle client version
Result: If you are using Internet Explorer, you may see a download warning - Right click on the warning bar and select Download file.
- When prompted to Open or Save, choose Save.
- IMPORTANT: Right-click on the .zip file and choose Extract All.
Result: Oracle_11.2_32_bit_client_installer folder is created. - Open the folder.
- Double-click Oracle_11.2_32_bit_client_installer.exe to launch the installer.
Result: You may see a User Account Control warning: - Select Yes to allow
Result: A command prompt window opens.
Result: Another command prompt window notifies when the Oracle installer is launched.
Result: Windows Security Alert is displayed. - Press Allow Access to allow Java 2 Platform Standard Edition binary to communicate on the network.
Result: The command window closes and the installation completes.See Also
It is not necessary to uninstall Oracle 9i in order to user Oracle 11g. If you wish to uninstall Oracle 9i, follow the steps here: Oracle 9i or Oracle 11gR2 - Instructions for Uninstall
If the install is not successful
- The MIT Oracle 11gR2 installer is a silent wrapper which
- Creates a sqlnet.ora file, including a dynamically generated crypto seed
- Adds ldap.ora and sqlnet.ora to the machine
- Runs the standard Oracle 11gR2 installer, installing the Administrator client.
- The Oracle installer checks for certain prerequisites before installing, such as operating system version and maximum path length. If these prerequisites are not met, the installer will not complete.
See: Oracle 11g Troubleshooting
Additional Information
Configuration changes accomplished by the MIT Oracle 11g installer
For Service Desk Consultants, installer info (permissions required): [hd:For Service Desk Consultants - Oracle 11gR2 Client for Windows - Installation Instructions]
See Also
So you have Microsoft Office 2010 64 bits a Windows 7 64 bits system, and you are trying to connect to an ODBC data source through Excel. The data source is an Oracle server.
Here’s the solution.
However, the database version or server operating system is arbitrary; it could be an 8i, 9i, 10g, or even an 11g 32-bit or 64-bit database on a UNIX or Windows server. If you’re using Windows 7 64-bit and you want to connect to an ODBC data source through Excel to an Oracle database, you must use Office 2010 64-bit. You cannot use Office 2003 or 2007, for example.
Follow these steps on your Windows 7 64-bit PC to connect to your ODBC data source.
Through Oracle’s web site, go to Instant Client Downloads for Microsoft Windows (x64). Currently, the address to that page is: www.oracle.com/technetwork/database/features/instant-client/
Download the two following files, found under the version 11.1.0.7.0 heading:
Instant Client Package – Basic (instantclient-basic-win-x86-64-11.1.0.7.0.zip)
Instant Client Package – ODBC (instantclient-odbc-win-x86-64-11.1.0.7.0.zip)
Extract both zip files to the same directory (such as c:oracleinstantclient_11_1).
Copy your previous files TNSNAMES.ORA end SQLNET.ORA in this new folder.
Launch the Command Prompt (DOS command window) by running it
as administrator. Go to Start > All Programs > Accessories, then right click Command Prompt and select Run as Administrator.
From within the Command Prompt, navigate to c:oracleinstantclient_11_1, and run odbc_install.exe. You should receive a message saying Oracle ODBC Driver is installed successfully. The name of the new ODBC driver that was just installed is Oracle in instantclient11_1 — use this driver when creating your ODBC connection.
Create a new system environment variable. Set the value of the variable name as TNS_ADMIN, and the value of the variable path as the directory that contains the tnsnames.ora and sqlnet.ora files.
On my PC, I have another Oracle client already installed which has its own tnsnames.ora and sqlnet.ora files. Therefore, I set the value of variable path as c:orantnet80admin (the directory that contains my tnsnames.ora and sqlnet.ora files). If you don’t have another Oracle client installed on your PC, create a new directory such as c:oracleinstantclient_11_1networkadmin, and place the tnsnames.ora and sqlnet.ora files in that directory. Then, set c:oracleinstantclient_11_1networkadmin as the value for the variable path.
To create the ODBC connection, go Start > Control Panel > Administrative Tools > Data Sources (ODBC). Alternatively, you can create the connection right from within Excel.
Then you can have another problem: Your users already have EXCEL files with a driver named for example : « Microsoft ODBC for Oracle ». »ODBC_Connection_in_EXCEL »
Oracle in instantclient10_2 is set by odbc_install.exe and can be altered if you change the registry:
In
, change the name of « Oracle in instantclient10_2 » to whatever you want.
Rename the, « Oracle in instantclient10_2 » key in
Oracle 9i For Windows 7 32 Bit Free
to the same name you used above.
Windows 7 32-bit Amazon
Oracle 9i For Windows 7 32 Bit Download
Now your EXCEL 64Bits should connect well to Oracle.