tg4msql_agt_3872.trc内容如下:Heterogeneous Agent Release
9.2.0.1.0
HS Agent diagnosed error on initial communication,
probable cause is an error in network administration
Network error 2: NCR-00002: NCR: Invalid usage
9.2.0.1.0
HS Agent diagnosed error on initial communication,
probable cause is an error in network administration
Network error 2: NCR-00002: NCR: Invalid usage
公司用的是Oracle 11i,有个打印模块可能是用Report-Builder开发的!当打印时,启动打印模块通过本地打印机打印时一般没什么问题,可是通过网络(局域网)打印机打印时却老是出现如下问题而不能打印: REP-1814: 无法格式化报表.对象‘垂直地’永远无法适合于‘B_13‘通过网络打印机能正常打印的机会是比较少的!高手请帮忙了,谢谢!!
先安装:Oracle Transparent Gateway for Microsoft SQL Server 9.2.0.1.0
安装完毕后会在.. oracle\ora92目录下新增一个tg4msql目录,然后编辑
oracle\ora92\tg4msql\admin目录里面的inittg4msql.ora文件:
# This is a sample agent init file that contains the HS parameters that are
# needed for the Transparent Gateway for SQL Server
#
# HS init parameters
#
HS_FDS_CONNECT_INFO="SERVER=10.120.10.139;DATABASE=数据库名"
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER
然后更改。。:\oracle\ora92\network\admin目录下的listener.ora文件 # LISTENER.ORA Network Configuration File: E:\oracle\ora92\network\admin\listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = drpxy01)(PORT = 1521))
)
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME = E:\oracle\ora92)
(SID_NAME = tg4msql)
(PROGRAM=tg4msql)
)
.................然后更改。。\oracle\ora92\network\admin目录下的tnsnames.ora文件,增加一个服务名
SQLSERVER.TEPCO.NCPG=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.120.6.1)(PORT = 1521))
)
(CONNECT_DATA =
(SID = tg4msql)
)
(HS=OK)
)
然后重新启动listener服务;