RE: DBLINKs in critical production system

Yes I agree with your explanation. How different it is accessing data from db link and direct connection without dblink considering I have a very good separate IP/card for dblink  

regards,

Ajay

From: Mitchell, Travis [mailto:Travis.Mitchell_at_vacationclub.com] Sent: Monday, April 30, 2007 11:03 AM
To: Thotangare, Ajay (GTI); oracle-l_at_freelists.org Subject: RE: DBLINKs in critical production system  

Imagine sticking a post-it with username/password information on your monitor... db_links are just about the same, especially pre-10g because the passwords are not encrypted.

I've walked in and found that my database is hung because I did a developer a favor so they could quickly pull some data from a production system. Their sql took forever, backup software tried to shutdown the development database but couldn't because of said sql, ORA-600s and some relationship building with Oracle support ensued. This was pre audit everything requirements, so I would recommend that if you have to use them, make sure your security team and the business has it approved in writing. Technically they can cause problems but from a security standpoint you can be heavily exposed.  

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Thotangare, Ajay (GTI)
Sent: Monday, April 30, 2007 10:43 AM
To: oracle-l_at_freelists.org
Subject: DBLINKs in critical production system  

Hi Group,

I have a question about dblink. I always hear that

• dblinks are not good in production system.
• dblink , ohh!! not in critical production system
• dblink are not safe

Can anybody please let me know the reason for such comments on dblinks.

regards,

Ajay

If you are not an intended recipient of this e-mail, please notify the sender, delete it and do not read, act upon, print, disclose, copy, retain or redistribute it. Click here <http://www.ml.com/email_terms/> for important additional terms relating to this e-mail. http://www.ml.com/email_terms/

--
http://www.freelists.org/webpage/oracle-l