invalid username/pswd on db-link

Please forgive me the re-posting. I first posted this a week ago and got no bites, so thought I'd try again.

Oracle 8.1.7.4 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.

Ideas? Received on Fri Dec 10 2004 - 09:51:14 CST