trigger the db-link availability

[ckwan]

Dear all,
Can db-link to be trigger automatically if the link is not established ?

Regards,
ckwan

[julian]

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.

[ckwan]

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.

[julian]

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.

[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

[julian]

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

I can't think of anything smarter than that :-)

Have a look at that about the dual table:

http://www.optimaldba.com/internals/oraint_dual.html