刷新更改的数据库链接源(到SQL Server的Oracle网关) [英] refreshing changed db link source (oracle gateway to sql server)

问题描述

问题很简单，-当我有机会将Oracle网关中的设置更改为同一台服务器上的另一个数据库的Microsoft sql服务器(dg4msql)配置(HS_FDS_CONNECT_INFO)时，数据库链接并不总是刷新-有时是新选择的使用该数据库链接时，请始终保持旧设置.可能oracle网关以某种方式缓存了连接设置?如何清除缓存?谢谢

the question is pretty straightforward, - when I chance to change setting in oracle gateway to microsoft sql server (dg4msql) configuration (HS_FDS_CONNECT_INFO) to another database on the same server, the database link does not always gets refreshed - sometimes new selects using that database link stay hooked to the old setting. probably oracle gateway caches the connection settings in some way? how do I clear the cache? thanks

推荐答案

数据库链接在会话期间保持打开状态.网关使用数据库链接，因此逻辑上说，如果更改网关配置，则要激活它，您需要重新打开该链接.

Database links are kept open for the duration of a session. The gateway makes use of a database link so it is logical to state that if you change a gateway config, in order for it to be activated, you need to re-open the link.

最简单的方法是停止和启动会话，但这也可以通过发出

Easiest is to stop and start the sessions but this can also be done by issuing an

alter system close database link linkname

请参见关闭数据库链接.文档.

这篇关于刷新更改的数据库链接源(到SQL Server的Oracle网关)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！