Mon Sep 15 03:40:38 2025
Error 1017 received logging on to the standby
------------------------------------------------------------
Check that the primary and standby are using a password file
and remote_login_passwordfile is set to SHARED or EXCLUSIVE,
and that the SYS password is same in the password files.
returning error ORA-16191
两边密码一样的
在备库日志文件中,发现以下错误:
Mon Sep 15 03:34:01 2025
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_6842.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-16000: database open for read-only access
ORA-06512: at line 19
Mon Sep 15 03:42:36 2025
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_7815.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-16000: database open for read-only access
ORA-06512: at line 19
orcl_ora_7815.trc
Error in executing triggers on connect internal
*** 2025-09-15 03:42:36.925
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x0, level=0, mask=0x0)
----- Error Stack Dump -----
ORA-00604: error occurred at recursive SQL level 1
ORA-16000: database open for read-only access
ORA-06512: at line 19
*** 2025-09-15 03:43:11.625
ksukia: Starting kill, flags = 1
ksukia: Attempt 1 to kill process oracle@his1, OS id=4582
ksukia: killed 1 out of 1 processes.
*** 2025-09-15 03:43:12.690
ksukia: Starting kill, flags = 1
ksukia: killed 0 out of 0 processes.
*** 2025-09-15 03:43:14.868
*** 2025-09-15 03:43:14.868 1292 krsv.c
krsv_fg_so_delete: Process state object
175439236: Cleanup shutdown
*** 2025-09-15 03:43:14.868 4343 krsh.c
ARCH: Archival disabled due to shutdown: 1089
*** 2025-09-15 03:43:15.891
*** 2025-09-15 03:43:15.891 4343 krsh.c
ARCH: Archival disabled due to shutdown: 1089
看来有什么东西在执行,
看以前帖子,可能有触发器,
执行:
ALTER SYSTEM SET "_system_trig_enabled"=FALSE;