DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: DB_LINK problem in Oracle 806

  1. #1
    Join Date
    Jun 2003
    Location
    Singapore
    Posts
    11

    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

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    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
  •  


Click Here to Expand Forum to Full Width