trigger the db-link availability
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: trigger the db-link availability

Hybrid View

  1. #1
    Join Date
    Oct 2000
    Posts
    250

    trigger the db-link availability

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

    Regards,
    ckwan

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938

    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

  3. #3
    Join Date
    Oct 2000
    Posts
    250
    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.

  4. #4
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    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

  5. #5
    Join Date
    Oct 2000
    Posts
    250
    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

  6. #6
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    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
  •  


Click Here to Expand Forum to Full Width