0

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

hello_earth
  • 1,442
  • 1
  • 25
  • 39
  • Are the sessions stopped when the change is made? –  Jul 10 '14 at 09:58
  • do you mean the sessions connected to Oracle at that time? i guess not. what you are saying is that the db link settings are pulled from the configuration file at the time of the opening of each session and not as a result of polling the config file at specific times? i guess it's very logical, but it didn't quite occur to me :) please can you write it as an answer so that I can accept it? – hello_earth Jul 10 '14 at 11:24

1 Answers1

1

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

See Closing Database Links in the docu.

  • +1 for alternative way to close dblink - another very very crude way i was using was killing running oracle gateway processes on the server (...) – hello_earth Jul 18 '14 at 15:58