oracle 11g gateway 连接sqlserver 2005 ,ORA-28545解决
来源:互联网 发布:繁体转简体软件 编辑:程序博客网 时间:2024/06/14 05:49
安装好oracle 11g transport gateway,原本机器上已经存在oracle 10g database,同是windows 2003 64bit平台上的。
1.在tg_1\dg4msql\admin新建一个init+[sid].ora文件,命名为initef2kweb.ora,实例名为ef2kweb。编辑文件内容如下:
HS_FDS_CONNECT_INFO=172.19.1.36//ef2kweb
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER
其中172.19.1.36为sqlserver所在的host,ef2kweb为databasename。
2.因为和原先的database为同一台,安装完gateway后,会自动新建一个11g的listener。编辑内容如下:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ks55.dynapack.com.tw)(PORT = 1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = d:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = EF2KWEB)
(ORACLE_HOME = d:\oracle\product\11.2.0\tg_1)
(PROGRAM = dg4msql)
)
)
3.tnsnames.ora 添加如下内容
EF2KWEB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.19.128.55)(PORT = 1521))
)
(CONNECT_DATA =
(SID = ef2kweb)
)
(HS = OK)
)
4建立dblink
create public database link EF2KWEB
connect to SPC indentified by SPC
using 'EF2KWEB';
建立dblink,查询相关语句后报ORA-28545:Error Diagnosed By Net8 When Connecting To An Agent
解决方式如下:
将gateway的listener换个端口号:listener内容编辑如下:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ks55.dynapack.com.tw)(PORT = 1523))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = d:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = EF2KWEB)
(ORACLE_HOME = d:\oracle\product\11.2.0\tg_1)
(PROGRAM = dg4msql)
)
)
tnsnames.ora中的服务端口号也改掉
EF2KWEB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.19.128.55)(PORT = 1523))
)
(CONNECT_DATA =
(SID = ef2kweb)
)
(HS = OK)
)
重启监听后OK,可以查询。
- oracle 11g gateway 连接sqlserver 2005 ,ORA-28545解决
- Oracle 11G gateway 连接MS Sql Server 字符串转换问题ORA-28562,ORA-02063
- plsql连接oracle 11g 报ora-12154解决
- oracle 11g gateway 连接sql server 2000
- 解决连接oracle 11g报ORA-01034和ORA-27101的错误
- 解决连接Oracle 11g报ORA-01034和ORA-27101的错误
- Oracle 11g透明网关连接Sqlserver
- oracle 11g ORA-00845错误解决
- 解决Win7 安装oracle 11g, plsql 连接出现 ora-12154
- Oracle 配置transparent gateway(透明网关)连接sqlserver数据库(gateway安装在sqlserver服务器)
- Oracle 配置transparent gateway连接sqlserver数据库(gateway安装在oracle服务器上)
- oracle 11g不能连接报ORA-12537
- Oracle 11g透明网关连接Sqlserver 2000
- Oracle 11g透明网关连接Sqlserver 2000
- Oracle 11g透明网关连接Sqlserver 2000
- ORA-28002:Oracle 11g密码过期解决
- Navicat for Oracle 11g 解决ORA-28547问题
- oracle 10g 连接 sqlserver---透明网关
- 时间子系统8_动态时钟(NO_HZ)
- 使用ajaxfileupload插件提示Uncaught TypeError:has no method 'handleError'
- android发送短信
- iOS开发-NSDictionary
- cocos2d-X 节点(CCBone.h)API
- oracle 11g gateway 连接sqlserver 2005 ,ORA-28545解决
- Python编码和UTF-8
- [LeetCode]3Sum Closest
- iOS开发-NSData
- 十三周——汉诺塔(2)
- cocos2d-X 节点(CCArmatureAnimation.h)API
- cocos2d-X 节点(CCProcessBase.h)API
- cocos2d-X 节点(CCTween.h)API
- 将软件源加入到/etc/apt/sources.list文件中