-
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.
-
Re: db link error
Originally posted by sureshot
ORA-01017: invalid username/password; logon denied
Jeff Hunter
-
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
-
sigh hehehe
-
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.
-
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
-
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?
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|