Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> DB Link, How to created DB Link
churamanidba
post Feb 7 2012, 05:03 AM
Post #1


Advanced Member
***

Group: Members
Posts: 61
Joined: 19-May 10
From: Balijuri
Member No.: 43,147



Hi,

for creating a db link, How to get the encrypted password
here is an example
create public database link "TEST1.UNIX.190.ORG"
connect to "scott" identified by values '053E6879854B7744F64396350297E1D6EF191163AE35216E64'
using '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.30.20.20)(PORT=1521))(CONNECT_D
ATA=(SID=SID1)))';


where or how to get the encrypted password(Pink colored above) to create db link.

Thanks
Churamani


--------------------
Thanks & Regards
Churamani
Go to the top of the page
 
+Quote Post
burleson
post Feb 7 2012, 05:42 AM
Post #2


Advanced Member
***

Group: Members
Posts: 11,498
Joined: 26-January 04
Member No.: 13



Hi Churamani,

>> where or how to get the encrypted password

Good question!

You have to type it in when you create it, but you can then encrypt the table column where the db-link is stored.

The password for the database link is then stored in the data dictionary:

CODE
col link for a30
col username for a10
col host for a20
col owner for a10
select l.name link, l.userid username, l.host, l.ctime created, u.name owner,
l.password
from sys.link$ l, sys.user$ u
where l.OWNER# = u.USER#;

I get

LINK USERNAME HOST OWNER PASSWORD
--------------- ---------- -------------------- -------------------- --------
DHC9_C CDHC DHC_C.WORLD CDHC CDHC2005
DHC9_C CDHC DHC_C.WORLD HR_DDHC CDHC2005
DHC9_C CDHC DHC_C.WORLD HR_TEAM CDHC2005
DHCPRIVATE CDHC DHC.WORLD HIR CDHC2005


See here, how to encrypt the password for a database link:

http://www.dba-oracle.com/t_password_hidin...ion_db_link.htm


--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post
churamanidba
post Feb 7 2012, 11:53 PM
Post #3


Advanced Member
***

Group: Members
Posts: 61
Joined: 19-May 10
From: Balijuri
Member No.: 43,147



Thanks Donald..This Helped me..smile.gif


--------------------
Thanks & Regards
Churamani
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 20th September 2014 - 07:00 PM