[oracle@ trace]$ adrci
ADRCI: Release 19.0.0.0.0 - Production on Thu Oct 22 02:44:32 2020
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
ADR base = "/u02/app/oracle"
adrci> show homes
ADR Homes:
diag/rdbms/racdb01/racdb012
adrci> set home diag/rdbms/racdb01/racdb012
adrci> show problem
ADR Home = /u02/app/oracle/diag/rdbms/racdb01/racdb012:
*************************************************************************
PROBLEM_ID PROBLEM_KEY LAST_INCIDENT LASTINC_TIME
------------ ------------------------------------ -------------------- -------------------------
2 ORA 600 [KGL-heap-size-exceeded] 892681 2020-10-22 02:05:02.259000 -07:00
1 row fetched
adrci> show incident
ADR Home = /u02/app/oracle/diag/rdbms/racdb01/racdb012:
*************************************************************************
INCIDENT_ID PROBLEM_KEY CREATE_TIME
------------- ------------------------------------ --------------------------------
898849 ORA 600 [KGL-heap-size-exceeded] 2020-10-22 01:47:17.772000 -07:00
898850 ORA 600 [KGL-heap-size-exceeded] 2020-10-22 01:47:46.487000 -07:00
893321 ORA 600 [KGL-heap-size-exceeded] 2020-10-22 01:48:15.119000 -07:00
895665 ORA 600 [KGL-heap-size-exceeded] 2020-10-22 01:48:48.707000 -07:00
897425 ORA 600 [KGL-heap-size-exceeded] 2020-10-22 01:51:47.065000 -07:00
5 rows fetched
adrci> ips pack incident 898849 in /tmp
Generated package 3 in file /tmp/ORA600KGL_20201022024903_COM_1.zip, mode complete
Additional incremental files:
/tmp/ORA600KGL_20201022024903_INC_2.zip
No comments:
Post a Comment