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;
=======================================================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
Post a Comment