Complete process to install oracle 11g

Step 1: First you must find out which Operating system do you have on ur system (32 bit or 64 bit Window).

Step 2: If you 've relevant oracle 11g setup then start installation otherwise click on the below link to install it from Oracle site,

http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

Do the following changes in regedit if your system is 64 bit,

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\MTxOCI     and
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\MSDTC\MTxOCI
are correct:
a. OracleOciLib = oci.dll
b. OracleSqlLib = orasql11.dll   (old: SQLLib80.dll)
c. OracleXaLib = oraclient11.dll  (old: xa80.dll)  

 

Step 3: Update TNSNAMES files according to your system DB config,

By default, TNSNames file is under below location,

C:\app\vinod\product\11.2.0\client_1\Network\Admin\

Settingup Environment variables

you should set the TNS_ADMIN environment variable to point to where ever you store your tnsnames.ora file

Adding DNS name in following tabs in Microsoft DBC Admin wizards

                - USER DSN

                -SYSTEM DSN

Adding editing TNSNAMes files,  then do the ODBC setting and automatically TNS names that you edited in TNSNames file, it populates right under TNS service name dropdown list.

Thats the whole process of installlation. Hope it will work for you ...

Cheers.