Create DB links without password
1)SELECT 'CREATE
'||DECODE(U.NAME,'PUBLIC','public ')||'DATABASE LINK '||CHR(10)
||DECODE(U.NAME,'PUBLIC',Null,
'SYS','',U.NAME||'.')|| L.NAME||chr(10) ||'CONNECT TO '
|| L.USERID || ' IDENTIFIED
BY
"'||L.PASSWORD||'"
USING '''||L.HOST||'''' ||chr(10)||';' TEXT
FROM SYS.LINK$ L, SYS.USER$ U
WHERE L.OWNER# = U.USER#;
CREATE DATABASE LINK
APPS.APPS_TO_APPS.APDBA.RPG.LOCAL
CONNECT TO APPS IDENTIFIED BY
"06928E87ACCA4B558CE34330BD4A2AEB27E11DD1F8AAD84992A88F60BC861672
D56EFAF9BD7849E275AD3BA48F5321AF42C2C21E390299A6BD2C6E5D2B0976280F8A2C
AC1325FE560D0AFC5E104EC21B0F2A16E58BCDB2C19E6C57919DCD30BF7A2006C219C
DE5E58AFE498CC260961DB06FD6193E8FB30393DA9E2ED2DB596"
USING 'DSOLTP12'
;
CREATE DATABASE LINK
APPS.APPS_TO_RGDW.APDBA.RPG.LOCAL
CONNECT TO XXCSI IDENTIFIED BY
"064969080290DC3A26EEEADD714D06A8C6454A20D66CFE25DF23E4D51D61E
DCC4FA8AAE856600A5B91AEA80FAC5629E8E269871D4F7E0A468AC44C813DB3031C1BC
B7BE799351663C9C149986307B1376FD6998971AC19AADF0A5AA44129AA9843D3D3C70D
78199CDC08357FBBD5F7E1ADB380C5E019B70A83067C76FAA20A9"
USING '(DESCRIPTION
= (ADDRESS = (PROTOCOL = T
CP)(HOST = alvdgdw2.APDBA.rpg.local)(PORT
= 1541)) (CONNECT_DATA= (SID=DGD
W2)))'
;
CREATE DATABASE LINK
APPS.EDW_APPS_TO_WH.APDBA.RPG.LOCAL
CONNECT TO APPS IDENTIFIED BY
"06224E8F2B258427D4E7C2C71C3E00B5BBB48018263EC257E73382A5029F9BAC1FE7
C1A212827822E690AD274A774C734AA29C1FDFB0FCBE824B723E95E83D7C94716
2EA37AE0C6154D72FCF8C47382AE58166034C64F5B5FAF75CCE4B381C023B9E3FA
9F3D78BD71BB1856FC22B9B8C08BCDE09D5CCD97E86226152627E1C2"
USING 'DSOLTP12'
;
2)select name,passwordx from
sys.link$ ( we will get Encrypeted Password using this scripts)
NAME
--------------------------------------------------------------------------------
PASSWORDX
--------------------------------------------------------------------------------
APPS_TO_APPS.APDBA.RPG.LOCAL
06928E87ACCA4B558CE34330BD4A2AEB27E11DD1F8AAD84992A88F60BC861672
D56EFAF9BD7849E275AD3BA48F5321AF42C2C21E390299A6BD2C6E5D2B09762
80F8A2CAC1325FE560D0AFC5E104EC21B0F2A16E58BCDB2C19E6C57919D
CD30BF7A2006C219CDE5E58AFE498CC260961DB06FD6193E8FB30393DA9E2ED2DB596
APPS_TO_RGDW.APDBA.RPG.LOCAL
064969080290DC3A26EEEADD714D06A8C6454A20D66CFE25DF23E4D51D61EDC
C4FA8AAE856600A5B91AEA80FAC5629E8E269871D4F7E0A468AC44C813DB30
31C1BCB7BE799351663C9C149986307B1376FD6998971AC19AADF0A5AA44129
AA9843D3D3C70D78199CDC08357FBBD5F7E1ADB380C5E019B70A83067C76FAA20A9
EDW_APPS_TO_WH.APDBA.RPG.LOCAL
06224E8F2B258427D4E7C2C71C3E00B5BBB48018263EC257E73382A5029F9BA
C1FE7C1A212827822E690AD274A774C734AA29C1FDFB0FCBE824B723E95
E83D7C947162EA37AE0C6154D72FCF8C47382AE58166034C64F5B5FAF75
CCE4B381C023B9E3FA9F3D78BD71BB1856FC22B9B8C08BCDE09D5CC
D97E86226152627E1C2
SELECT O.OBJECT_NAME, S.SID,
S.USERNAME, S.MACHINE, S.SERIAL#,
P.SPID,
S.PROGRAM,SQ.SQL_FULLTEXT, S.LOGON_TIME FROM
V$LOCKED_OBJECT L,
DBA_OBJECTS O, V$SESSION S, V$PROCESS P, V$SQL SQ
WHERE L.OBJECT_ID = O.OBJECT_ID
AND L.SESSION_ID = S.SID
AND S.PADDR = P.ADDR AND
S.SQL_ADDRESS = SQ.ADDRESS;
SQL> CREATE DATABASE LINK
RSA.RSA_TO_EBS CONNECT TO APPSRO
IDENTIFIED BY VALUES
'06097F46BF275512A9B017A27645AB41C6FD7926
790F1FCE7069AECAA25
D70C0BCD3C001E4D7B5D783574184F8890973052F79740C7DDC62163289
E33991AB7F93D28C773A78656D41BDA5D198197DE12C3DD5B03F06C62
CC986F0A44219C3350173EAE39A0340FBD71D926079E99A7A21A04AD586ED6C683
D8C0F22A4F22CE' USING 'ebsdcmv'
2 /
Database link created.
|
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment
Note: only a member of this blog may post a comment.