Re: DBLINKs in critical production system

Ajay,

Depends (as usual).  If the DB Links are FROM the Prod system TO others 
and you're careful about which User you connect to on the other end, then 
you're probably OK, though others might have issues.  You've got to be 
very careful about DB Links from other databases TO Prod.  Those can 
become "back doors" to get at your Prod data.

Also, up through 9i the Password column in the Sys.Link$ table was in 
plain text - not in my 10.2 database, though.  Anyone with Select Any 
Dictionary priv could see the passwords.  Obviously, a gaping security 
hole to make sure you plug.

DB Links can also be a performance bottleneck if you're dragging lots of 
data from other databases back to Prod across a LAN/WAN.  If the other 
database(s) is(are) on the same server as Prod, then having the DB Links 
use IPC greatly reduces the performance hit.

DB Links can be useful, even in Prod, but require great care in 
implementation, IMHO.

Jack C. Applewhite - Database Administrator
Austin (Texas) Independent School District
512.414.9715 (wk)  /  512.935.5929 (pager)

 Same-Day Stump Grinding!  Senior Discounts!
         -- Mike's Tree Service





"Thotangare, Ajay \(GTI\)" <Ajay_Thotangare@xxxxxx> 
Sent by: oracle-l-bounce@xxxxxxxxxxxxx
04/30/2007 10:32 AM
Please respond to
Ajay_Thotangare@xxxxxx


To
<oracle-l@xxxxxxxxxxxxx>
cc

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

Other related posts: