Dear all,
Can db-link to be trigger automatically if the link is not established ?
Regards,
ckwan
Printable View
Dear all,
Can db-link to be trigger automatically if the link is not established ?
Regards,
ckwan
I am not sure I understand your question but the init.ora parameter dblink_encrypt_login set to true will trigger the following: When a connection fails Oracle reattempts the connection using an unencrypted version of the password.
Hi Julian,
Thanks for the reply but what I want is if the db-link connection somehow is disconnected, I am not sure Oracle does able for dba to write a trigger which to detect the connectivity so that it will inform the users immediately thru email or page.
Thank You.
Do you mean that if you open a session, select via a DB link, and if then the DB link connection gets lost somehow, you would receive email notifying you about the problem.
Hi Julian,
Yes you are right. At the moment I am thinking to just to use the 'select dummy from dual@dblink' method to check whether it is successfully connected else I will send the email to administrator about the connectivity is fail.
Any other better method ? Thanks
Regards,
ckwan
I can't think of anything smarter than that :-)Quote:
Originally posted by ckwan
Hi Julian,
Yes you are right. At the moment I am thinking to just to use the 'select dummy from dual@dblink' method to check whether it is successfully connected else I will send the email to administrator about the connectivity is fail.
Any other better method ? Thanks
Regards,
ckwan
Have a look at that about the dual table:
http://www.optimaldba.com/internals/oraint_dual.html