Second request: invalid username/pswd on db-link

Giganews Newsgroups
Subject: Second request: invalid username/pswd on db-link
Posted by:  Ed Stevens (nospam@noway.nohow)
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 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?

Replies