环境:oracle db ,sql server db, oracle gateway 分别在不同电脑,进入$GATEWAY_HOME\tg_1\dg4msql\admin,配置 initdg4msql.ora HS_FDS_CONNECT_INFO=[sqlserver ip]/MSSQLSERVER/JYDB
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER进入$GATEWAY_HOME\network\admin下,编辑listener.oraSID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = dg4msql)
(ORACLE_HOME = D:\product\11.2.0\tg_1)
(PROGRAM = dg4msql)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = gateway ip)(PORT = 1522))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))
)
)ADR_BASE_LISTENER = D:\product\11.2.0\tg_1
启动网关监听,LSNRCTL.EXE创建dblink
create database link mslink
connect to “zh” identified by “mm”
using ' (DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=gateway ip)(PORT=1522))
(CONNECT_DATA=(SID=dg4msql))
(HS=OK)
) '
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER进入$GATEWAY_HOME\network\admin下,编辑listener.oraSID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = dg4msql)
(ORACLE_HOME = D:\product\11.2.0\tg_1)
(PROGRAM = dg4msql)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = gateway ip)(PORT = 1522))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))
)
)ADR_BASE_LISTENER = D:\product\11.2.0\tg_1
启动网关监听,LSNRCTL.EXE创建dblink
create database link mslink
connect to “zh” identified by “mm”
using ' (DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=gateway ip)(PORT=1522))
(CONNECT_DATA=(SID=dg4msql))
(HS=OK)
) '
解决方案 »
- windows 下 如何設定oracle 自動啟動時選指定的ora文件
- 求一条SQL语句
- to googogo(googogo): 关于Execution Plan几个问题请教?欢迎高手关注
- 对oracle操作时,对时间类型的字段,能使用substr操作吗?
- 不知道是不是用decode,认为自己是高手的请进来看看!!!!!急!!
- GROUP BY 后的字段要唯一值,取消重复值
- not connected to oracle
- ORACLE 有没有 SQL SERVER 里的 “应用程序角色“,或者相同的解决方法???
- 青蛙软件,哪里有下载?
- 取当前存储过程名
- sqlplus出现某些中文乱码
- 在Windows下使用nodejs安装oracledb
(ORACLE_HOME = D:\product\11.2.0\tg_1)
(ADDRESS = (PROTOCOL = TCP)(HOST = gateway ip)(PORT = 1522))
(ADDRESS=(PROTOCOL=tcp)(HOST=gateway ip)(PORT=1522))
请指点小弟