安装oracle gateways
来源:互联网 发布:ecshop多用户商城源码 编辑:程序博客网 时间:2024/06/08 02:58
安装gate ways 遇到 ora-28545 错误,处理了好几天,今天终于搞定了
处理方法,删除监听,重新配置监听,删除tnsnames配置,netca重新配置监听。
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = E:\app\Administrator\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:E:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
(SID_DESC =
(SID_NAME = dg4msql)
(ORACLE_HOME = E:\app\Administrator\product\11.2.0\dbhome_1)
(PROGRAM = dg4msql)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = L9K1QZN648N2CPB)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
ADR_BASE_LISTENER = E:\app\Administrator
重新配置tnsnames
dg4msql =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = L9K1QZN648N2CPB)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = dg4msql)
)
(HS = OK)
)
重新配置dg4msql
# This is a customized agent init file that contains the HS parameters
# that are needed for the Database Gateway for Microsoft SQL Server
#
# HS init parameters [127.0.0.1]/MSSQLSERVER/test
#
HS_FDS_CONNECT_INFO=192.168.1.1,1433//test
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER
连接成功!
0 0
- 安装oracle gateways
- Oracle gateways连接SqlServer
- oracle gateways 访问 sql server
- Connecting Oracle to PostgreSQL using Oracle Gateways
- Oracle与Sql Serer的链接桥梁之透明网关的部署与配置详解(二)安装GateWays
- ORACLE下载当中的gateways,companion,clusterware都是什么用途?
- 配置gateways从oracle连sql server 2005
- Oracle中使用透明网关[gateways]数据链接到Sqlserver
- ORACLE下载当中的gateways,companion,clusterware都是什么用途?
- 通过Oracle Database Gateways进行数据迁移的解决方案
- 网关;gateways
- Oracle 12c中使用透明网关(gateways) 12.1数据链接到SQL Server 2012
- Cisco Voice Gateways and Gatekeepers
- max no of gateways exceeded
- oracle安装
- Oracle安装
- Oracle安装
- oracle安装
- Android 使用ViewPager实现左右循环滑动图片和显示当前页码
- HDU-4932-Miaomiao's Geometry【暴力枚举】
- DOM和SAX解析器的比较和选择
- Android 仿IOS3D时间选择器城市选择器
- kafka本地存储3-LogSegment
- 安装oracle gateways
- 文章标题
- 单例
- tableViewCell的选中状态的还原
- 123
- HDOJ 2053 Switch Game
- managedQuery 和 getContentResolver().query的区别
- 数字图像处理 调整对比度的几种方法
- 从框架到完整项目搭建,实战项目《约个球》(7)- 将项目迁移到android studio,使用gradle搭建android项目(上)