we replicate some 50 tables from a source database (19.17 on Windows) periodically every 30 Minutes to an other database (19.18 on Windows) using MATERIALIZED VIEWS with a MATERIALIZED VIEW LOG for each table on the source side. Approximately every second or third day for only a few of these tables and not always the same tables we see in the ALERT.LOG on the destination side the message “kkzifr3g: Encountered error ORA-1017” but the next refresh of the same MATERIALIZED VIEW is OK without any change in users or passwords in between. Any idea, what’s happening?
The ALERT.LOG says:
2023-04-15T16:59:02.027846+02:00
….PPDB(3):On demand
….PPDB(3):MV <schemaname>.<mv_name> was not refreshed successfully.
….PPDB(3):Number of MV refresh failures: 1.
….PPDB(3):Encountered error ORA-1017.
….PPDB(3):kkzifr3g: Encountered error ORA-1017.
2023-04-15T16:59:02.033847+02:00
….PPDB(3):Errors in file D:\APP\ORACLE\diag\rdbms\....pcdb\....pcdb\trace\....pcdb_j010_9788.trc:
ORA-12012: Fehler beim autom Ausführen von Job "<schemaname>"."MV_RF$J_0_S_344"
ORA-01017: Benutzername/Kennwort ungültig; Anmeldung abgelehnt
ORA-06512: in "SYS.DBMS_SNAPSHOT_KKXRCA", Zeile 3020
ORA-06512: in "SYS.DBMS_SNAPSHOT_KKXRCA", Zeile 2432
ORA-06512: in Zeile 1
ORA-06512: in "SYS.DBMS_SNAPSHOT_KKXRCA", Zeile 88
ORA-06512: in "SYS.DBMS_SNAPSHOT_KKXRCA", Zeile 253
ORA-06512: in "SYS.DBMS_SNAPSHOT_KKXRCA", Zeile 2413
ORA-06512: in "SYS.DBMS_SNAPSHOT_KKXRCA", Zeile 2976
ORA-06512: in "SYS.DBMS_SNAPSHOT_KKXRCA", Zeile 3263
ORA-06512: in "SYS.DBMS_SNAPSHOT_KKXRCA", Zeile 3322
ORA-06512: in "SYS.DBMS_SNAPSHOT", Zeile 44
ORA-06512: in "SYS.DBMS_IREFRESH", Zeile 1177
ORA-06512: in "SYS.DBMS_REFRESH", Zeile 263
ORA-06512: in Zeile 1
The mentioned Trace-File shows not much more information:
Trace file D:\APP\ORACLE\diag\rdbms\....pcdb\....pcdb\trace\....pcdb_j010_9788.trc
Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production
Version 19.18.0.0.0
Build label: RDBMS_19.18.0.0.0DBRU_WINDOWS.X64_230126
Windows NT Version V6.2
ORACLE_HOME = D:\app\oracle\product\19c\dbhome
Node name : ……….
CPU : 4 - type 86644 physical cores
Process Affinity : 0x0000000000000000
Memory (Avail/Total): Ph:12030M/40959M, Ph+PgF:17436M/46847M
VM name : VMWare Version (6)
Instance name: ….pcdb
Redo thread mounted by this instance: 1
Oracle process number: 110
Windows thread id: 9788, image: ORACLE.EXE (J010)
*** 2023-04-15T16:59:02.032849+02:00 (….PPDB(3))
*** SESSION ID:(291.15704) 2023-04-15T16:59:02.033847+02:00
*** CLIENT ID:() 2023-04-15T16:59:02.033847+02:00
*** SERVICE NAME:(SYS$USERS) 2023-04-15T16:59:02.033847+02:00
*** MODULE NAME:(DBMS_SCHEDULER) 2023-04-15T16:59:02.033847+02:00
*** ACTION NAME:(MV_RF$J_0_S_344) 2023-04-15T16:59:02.033847+02:00
*** CLIENT DRIVER:(SERVER) 2023-04-15T16:59:02.033847+02:00
*** CONTAINER ID:(3) 2023-04-15T16:59:02.033847+02:00
ORA-12012: Fehler beim autom Ausführen von Job "<schemaname>"."MV_RF$J_0_S_344"
<error barrier> at 0x0000002DEB3F8270 placed jslv.c@1927
ORA-01017: Benutzername/Kennwort ungültig; Anmeldung abgelehnt
ORA-06512: in "SYS.DBMS_SNAPSHOT_KKXRCA", Zeile 3020
ORA-06512: in "SYS.DBMS_SNAPSHOT_KKXRCA", Zeile 2432
ORA-06512: in Zeile 1
ORA-06512: in "SYS.DBMS_SNAPSHOT_KKXRCA", Zeile 88
ORA-06512: in "SYS.DBMS_SNAPSHOT_KKXRCA", Zeile 253
ORA-06512: in "SYS.DBMS_SNAPSHOT_KKXRCA", Zeile 2413
ORA-06512: in "SYS.DBMS_SNAPSHOT_KKXRCA", Zeile 2976
ORA-06512: in "SYS.DBMS_SNAPSHOT_KKXRCA", Zeile 3263
ORA-06512: in "SYS.DBMS_SNAPSHOT_KKXRCA", Zeile 3322
ORA-06512: in "SYS.DBMS_SNAPSHOT", Zeile 44
ORA-06512: in "SYS.DBMS_IREFRESH", Zeile 1177
ORA-06512: in "SYS.DBMS_REFRESH", Zeile 263
ORA-06512: in Zeile 1