This discussion is archived
1 Reply Latest reply: Jun 5, 2012 11:44 PM by spajdy RSS

ORA-01017: invalid username/password; logon denied

905665 Newbie
Currently Being Moderated
Folks - Greetings. Here is my setup.

1. One Public DBlink between 2 databases. Lets say the Server 1 has the dblink and Data being fetched from Server 2.
2. One Materialized View using the DBlink in Server 1 to transport Data from Server 2.
3. One Job in Server 1 calling for Refresh the above Materialized View.

When I (using my Userid) call the dbms_mview.refresh manually it successfully refreshes the MV. But when I call the Job I get the ORA-01017: invalid username/password; logon denied ? When I logon as schema itself the Job run successfully. Can anyone have an insight into this ? I know it's about Job authentication issue, but am not sure what can be done to work around this.

Regards

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points