Heterogenous service sql server to oracle

HOW TO CREATE THE HETROGENEOUS SERVICE

=======================================================microfinance==========================================
CREAT TEH INI*.ORA FILE
/u02/app/oracle/product/12.1.0.2/gatewayhome_1/dg4msql/admin   --PWD
[oracle@rcdbdbadm01 admin]$ cat initReliance.ora
HS_FDS_CONNECT_INFO=10.65.7.229:1865//Reliance
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER
[oracle@rcdbdbadm01 admin]$


[oracle@rcdbdbadm01 admin]$ pwd
/u02/app/oracle/product/12.1.0.2/gatewayhome_1/network/admin
[oracle@rcdbdbadm01 admin]$ cat tnsnames.ora
Reliance_conn =
    (DESCRIPTION=
        (ADDRESS=(PROTOCOL=tcp)(HOST=rcdbdbadm01.reliancecapital.com)(PORT=1881))
        (CONNECT_DATA=(SID=Reliance))
        (HS=OK)
     )
       


[oracle@rcdbdbadm01 admin]$ cat listener.ora
# listener.ora Network Configuration File: /u02/app/oracle/product/12.1.0.2/gatewayhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER_Reliance_conn =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1881))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.65.7.152)(PORT = 1881))
    )
  )
SID_LIST_LISTENER_Reliance_conn =
   (SID_LIST =
      (SID_DESC =
      (SID_NAME=Reliance)
      (ORACLE_HOME=/u02/app/oracle/product/12.1.0.2/gatewayhome_1)
      (ENV="LD_LIBRARY_PATH=/u02/app/oracle/product/12.1.0.2/gatewayhome_1/dg4msql/driver/lib:/u02/app/oracle/product/12.1.0.2/gatewayhome_1/lib")
      (PROGRAM=dg4msql)
      )
   )
[oracle@rcdbdbadm01 admin]$

START THE LISTENER

TNSPING CORRECTLY

------------------------------------------------------ORACLE HOME PATH--------------------
[oracle@rcdbdbadm01 admin]$ pwd
/u01/app/oracle/product/11.2.0.3/dbhome_1/network/admin

Reliance_conn =
    (DESCRIPTION=
        (ADDRESS=(PROTOCOL=tcp)(HOST=10.65.7.152)(PORT=1881))   
        (CONNECT_DATA=(SID=Reliance))
        (HS=OK)
     )



CREATE PUBLIC DATABASE LINK MICROFIN_HS_LINK CONNECT TO "orsp_view" IDENTIFIED BY "orsp_view" using 'Reliance_conn';

select * from "mfer_servo_view"@MICFIN_HS_LINK;

SELECT * FROM DUAL@MICFIN_HS_LINK;


Comments

Popular posts from this blog

ORACLE GOLDENGATE

ORACLE RAC QUESTION

CREATING SCHEDULER JOBS