I cannot make a linked server

I cannot make a linked server

Follow the process below to make a linked server between the SQL server 64-bit & oracle 32-bit. Probably when you tried, it is going to missed something.

Run setup.exe of Oracle 11g Client in 64-bit SQL Server running machine.
You have to install 32-bit first.

Select “Custom” for OLEDB component installation in “Select Installation Type” step.

Select Oracle Base and Path.

You must select “Oracle Windows Interfaces 11.x.x” component for OLEDB in “Available Product Components” step.

Additionally select “Oracle NET 11.1″ and “SQL*PLUS 11.1″, etc optionally.

After installation, restore TNSNAMES.ORA backup file under the new location of %ORACLE_HOME%/network/admin folder.

Repeat above step #4-#7 with 64bit Oracle 11g Client setup.
Oracle “Base directory” is same as the 32bit, but Path is supposed to be different from the previous one in above step #5.

You will see an error message “OracleMTSRecoveryService already exists” as below screenshot during the 64-bit client installation. You can “Ignore” it.   

Modify the system registry settings as follows. And then reboot server!HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSDTCMTxOCI     and
HKEY_LOCAL_MACHINESOFTWAREWow6432NodeMicrosoftMSDTCMTxOCI
are correct:
a. OracleOciLib = oci.dll
b. OracleSqlLib = orasql11.dll   (old: SQLLib80.dll)
c. OracleXaLib = oraclient11.dll  (old: xa80.dll)

After this all process, you will must be able to make a linked server connection between the SQL server 64 bit & oracle 32 bit.

Thanks.