-
DB_LINK problem in Oracle 806
HI Guys
Is there any way to know which userid is used to create a DB_LINK?
OWNER DB_LINK USERNAME HOST CREATED
---------- --------------------------------- ---------- ---------- -----------
PUBLIC NCP1_LINK_TK1.WORLD ncp1 11-MAR-1999
Until recently this link was working fine. Dont know what happend, the other day when I run the script to get count of records in the remote table we got this error.
SQL> SELECT COUNT(1) FROM VEFS_RMINDEX;
SELECT COUNT(1) FROM VEFS_RMINDEX
ERROR at line 1:
ORA-01017: invalid username/password; logon denied
ORA-02063: preceding line from NCP1_LINK_TK1
SQL> SELECT COUNT(1) FROM VEFS_RMCA;
SELECT COUNT(1) FROM VEFS_RMCA
*
ERROR at line 1:
ORA-01017: invalid username/password; logon denied
ORA-02063: preceding line from NCP1_LINK_TK1
SQL> SELECT COUNT(1) FROM VEFS_RMORG;
SELECT COUNT(1) FROM VEFS_RMORG
*
ERROR at line 1:
ORA-28000: the account is locked
ORA-02063: preceding line from NCP1_LINK_TK1
Your help is highly appreciated.
Regards
Bhaskara
-
look link$
it is not working because password´s changed huh
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|