-
trigger the db-link availability
Dear all,
Can db-link to be trigger automatically if the link is not established ?
Regards,
ckwan
-
Re: trigger the db-link availability
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.
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
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.
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
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
-
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
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|