Environment: the oracle db, SQL server db, oracle gateway respectively in different computers,

enter $GATEWAY_HOME \ tg_1 \ dg4msql \ admin, configuration initdg4msql. Ora

IP HS_FDS_CONNECT_INFO=[used]/MSSQLSERVER JYDB
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER

enter $GATEWAY_HOME \ network \ admin, editor of the listener. Ora

SID_LIST_LISTENER=
(SID_LIST=

(SID_DESC=
(SID_NAME=dg4msql)
(ORACLE_HOME=D: \ product \ 11.2.0 \ tg_1)
(the PROGRAM=dg4msql)
)
)

The LISTENER=
(DESCRIPTION_LIST=
(the DESCRIPTION=
(ADDRESS=(TCP) PROTOCOL=(HOST=gateway IP) (1522) PORT=)
(ADDRESS=(PROTOCOL=IPC) (KEY=EXTPROC1522))
)
)

ADR_BASE_LISTENER=D: \ product \ 11.2.0 \ tg_1


gateway to monitor, LSNRCTL. EXE

create dblink
The create database link mslink
Connect to the "useful" identified by "mm"
Using '(the DESCRIPTION=
(ADDRESS=(TCP) PROTOCOL=(HOST=gateway IP) (1522) PORT=)
(CONNECT_DATA=https://bbs.csdn.net/topics/(SID=dg4msql))
(HS=OK)
) '

CodePudding user response:

I found several tutorials on the Internet, configuration of IP is very chaotic,
(ORACLE_HOME=D: \ product \ 11.2.0 \ tg_1)
(ADDRESS=(TCP) PROTOCOL=(HOST=gateway IP) (1522) PORT=)
(ADDRESS=(TCP) PROTOCOL=(HOST=gateway IP) (1522) PORT=)
Please help the younger brother

CodePudding user response:

And my query SQL server tables, executing SQL statements give me half a minute error ora - 28545, this is how to return a responsibility, how so long to report errors if the failure

CodePudding user response:

Don't have this year red scarf/?

CodePudding user response:

The building Lord problem solved, how to solve, I also met the same problem