search

oracle / docker-images

Official source of container configurations, images, and examples for Oracle products and projects
https://developer.oracle.com/use-cases/#containers
Universal Permissive License v1.0
6.56k stars 5.43k forks source link

Instance crashed with ORA 471 #2236

Open TonyKartony opened 2 years ago

TonyKartony commented 2 years ago

Oracle crashes with the following error. What could be the reason? I can't find dirrectory with trace files. Is it possible to look at them?

2022-01-24T15:03:27.201079+00:00
Warning: VKTM detected a forward time drift.
Please see the VKTM trace file for more details:
/opt/oracle/diag/rdbms/orclcdb/ORCLCDB/trace/ORCLCDB_vktm_34.trc
2022-01-24T15:03:28.319031+00:00
PMON (ospid: 28): terminating the instance due to ORA error 471
Cause - 'Instance is being terminated due to fatal process death (pid: 19, ospid: 62, DBW0)'
2022-01-24T15:03:28.429615+00:00
ORCLPDB1(3):opiodr aborting process unknown ospid (29120) as a result of ORA-1092
2022-01-24T15:03:28.429614+00:00
ORCLPDB1(3):opiodr aborting process unknown ospid (30031) as a result of ORA-1092
2022-01-24T15:03:28.436476+00:00
ORCLPDB1(3):opiodr aborting process unknown ospid (29716) as a result of ORA-1092
2022-01-24T15:03:28.458865+00:00
ORCLPDB1(3):opiodr aborting process unknown ospid (28925) as a result of ORA-1092
2022-01-24T15:03:28.463707+00:00
ORCLPDB1(3):opiodr aborting process unknown ospid (29673) as a result of ORA-1092
2022-01-24T15:03:28.464372+00:00
ORCLPDB1(3):opiodr aborting process unknown ospid (29755) as a result of ORA-1092
2022-01-24T15:03:28.473755+00:00
ORCLPDB1(3):opiodr aborting process unknown ospid (29751) as a result of ORA-1092
2022-01-24T15:03:28.479887+00:00
ORCLPDB1(3):opiodr aborting process unknown ospid (29256) as a result of ORA-1092
2022-01-24T15:03:28.485316+00:00
System state dump requested by (instance=1, osid=28 (PMON)), summary=[abnormal instance termination].
System State dumped to trace file /opt/oracle/diag/rdbms/orclcdb/ORCLCDB/trace/ORCLCDB_diag_47_20220124150328.trc
2022-01-24T15:03:28.547559+00:00
ORCLPDB1(3):opiodr aborting process unknown ospid (29260) as a result of ORA-1092
2022-01-24T15:03:28.548001+00:00
ORCLPDB1(3):opiodr aborting process unknown ospid (29087) as a result of ORA-1092
2022-01-24T15:03:28.548172+00:00
ORCLPDB1(3):opiodr aborting process unknown ospid (29800) as a result of ORA-1092
2022-01-24T15:03:28.548853+00:00
ORCLPDB1(3):opiodr aborting process unknown ospid (29495) as a result of ORA-1092
2022-01-24T15:03:28.558503+00:00
ORA-1092 : opitsk aborting process
2022-01-24T15:03:28.558542+00:00
ORA-1092 : opitsk aborting process
2022-01-24T15:03:28.558552+00:00
ORA-1092 : opitsk aborting process
2022-01-24T15:03:28.558560+00:00
ORA-1092 : opitsk aborting process
2022-01-24T15:03:28.558577+00:00
ORA-1092 : opitsk aborting process
2022-01-24T15:03:28.558886+00:00
ORA-1092 : opitsk aborting process
2022-01-24T15:03:34.657332+00:00
Instance terminated by PMON, pid = 28
abhisbyk commented 2 years ago

@TonyKartony On which machine are you running the database container image ? Please provide docker info also.