|Subject:||Second request: invalid username/pswd on db-link|
|Posted by:||Ed Stevens (firstname.lastname@example.org)|
|Date:||Fri, 10 Dec 2004|
Please forgive me the re-posting. I first posted this a week ago and
got no bites, so thought I'd try again.
Oracle 126.96.36.199 on Win2k
Recently I started getting a number of OEM alerts from one particular
database. The error is a ORA-01017: invalid username/password; logon
denied. Since this error is showing up in the alert log, it must be
happening when a db_link to a second db is accessed. That ought to be
simple enough, but if I connect with SQL-Plus and issue a SELECT
against the db-link, it works every time. Since the userid/pswd is a
hard-coded part of the db-link definition, I would exect it to work
every time or never.
The app is still under development and the developer has never
reported a problem. If I weren't getting the OEM alerts, we'd never
know there was an issue.