1 Reply Latest reply on Jun 6, 2012 6:44 AM by spajdy

    ORA-01017: invalid username/password; logon denied

      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.