db link error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: db link error

  1. #1
    Join Date
    Feb 2003
    Posts
    67

    db link error

    I have a database TSTAFF that has a schema EDIT_REPORTS which has a synonym to I_TBLMAINT.EDIT_ERR_LOC table on TODS database. I have a public database link for TSTAFF to TODS and I am getting this error when I try to connect:

    ORA-04052: error occurred when looking up remote object I_TBLMAINT.EDIT_ERR_LOC@TODS.WORLD
    ORA-00604: error occurred at recursive SQL level 1
    ORA-01017: invalid username/password; logon denied
    ORA-02063: preceding line from TODS

    What could be the problem. Thanks.

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092

    Re: db link error

    Originally posted by sureshot
    ORA-01017: invalid username/password; logon denied
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    Probably just a Unix thing.

  4. #4
    Join Date
    Jul 2001
    Location
    Slovenia
    Posts
    422
    Originally posted by JMac
    Probably just a Unix thing.
    Tomaž
    "A common mistake that people make when trying to design something completely
    foolproof is to underestimate the ingenuity of complete fools" - Douglas Adams

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    sigh hehehe

  6. #6
    Join Date
    Feb 2003
    Posts
    67
    I appreciate your response. My question is:

    I have a public database link with no fixed user. What the username the database is trying to connect to tods?

    edit_reports?
    i_tblmaint?

    Please, I need to know the inner workings of what db_link is doing to understand the problem.

    Thanks.

  7. #7
    Join Date
    Feb 2001
    Posts
    295
    It will look in the remote database for the same user used on the local database.

    That user should exist on both databases.
    An ounce of action is worth a ton of theory.
    —Friedrich Engels

  8. #8
    Join Date
    Feb 2003
    Posts
    67
    Assuming that I have a public database link with no fixed user and the current username does not exist or not allowed in the other database, how do I access the tables?

  9. #9
    Join Date
    Jul 2001
    Location
    Slovenia
    Posts
    422
    You can't.
    Either create dblink with fixed user
    or create all users that are possible to use dblink also on remote database.
    Tomaž
    "A common mistake that people make when trying to design something completely
    foolproof is to underestimate the ingenuity of complete fools" - Douglas Adams

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