Step by step oracle heterogeneous (HS) configuration

To create db-link with other database from oracle, we will need oracle heterogeneous connection.We will clarify the Step by step oracle heterogeneous (HS)  configuration for oracle 11 G database.

1. Create an odbc from your computer where Oracle Installed. [ Like odbc name is "sqldb"]

2. Change the HS file (inithsodbc.ora (initdg4odbc.ora for 11G database)) from HS location  ( like my location is D:\oracle\product\10.2.0\db_1\hs\admin) and change the parameters as below


HS_FDS_CONNECT_INFO = sqldb
HS_FDS_TRACE_LEVEL = OFF
HS_FDS_SUPPORT_STATISTICS=FALSE

3. Add following lines in listener with existing lines [ Change the location as your settings]

   " (
       SID_DESC=
          (SID_NAME=hsodbc)
          (ORACLE_HOME=D:\oracle\product\10.2.0\db_1)
          (PROGRAM=hsodbc)
          (ENVS=LD_LIBRARY_PATH = D:\oracle\product\10.2.0\db_1)
      )  
  "

example
 SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
      (PROGRAM = extproc)
    )
    (SID_DESC=
      (SID_NAME=hsodbc)
      (ORACLE_HOME=D:\oracle\product\10.2.0\db_1)
      (PROGRAM=hsodbc)
      (ENVS=LD_LIBRARY_PATH = D:\oracle\product\10.2.0\db_1)
    )  
  )


4. Add following TNS in your TNS file :

    hsodbc=
     (DESCRIPTION=
         (ADDRESS=(PROTOCOL=TCP)(HOST=10.11.201.198)(PORT=1521)
      )
      (CONNECT_DATA= (SID=hsodbc)
        )
        (HS=OK)
       )

5. Restart all listener, database and you can use your connected other platform database.