ADRCI
ADRCI is the command line interface for diagnostic utility used for viewing diagnostics data like listener log , alert log ,incident and cor dump etc and creating incident packages. Below are the the list of useful commands.
1. Get current base location:(Its known as ADR_BASE)
adrci> show base
ADR base is "/u01/app/oracle/"
2. Set new ORACLE_BASE(ADR_BASE)
adrci> set base /u01/app/grid
3. List current ORACLE_HOME
adrci> show home
4. Set new ORACLE_HOME
adrci> set homepath /u02/app/oracle
5. View alert log
adrci> show alert
adrci> show alert -tail 100
6. Purge alerts and trace files
-- This will purge data older than 600 minutes.
adrci> purge -age 600 -type ALERT
adrci> purge -age 600 -type TRACE
adrci> purge -age 600 -type incident
adrci> purge -age 10080 -type cdump
7. Set control policy for auto purge of files
There are two types of policies,
LONGP_POLICY is used to purge below data . Default value is 365 days.
• ALERT
• INCIDENT
• SWEEP
• STAGE
• HM
SHORTP_POLICY is used to purge for below data Default value is 30 days.
• TRACE
• CDUMP
• UTSCDMP
• IPS
— Get existing control policy
adrci> show control
Change default value of control policy details.
-- Set in hours.
adrci> set control (SHORTP_POLICY = 240)
adrci> set control (LONGP_POLICY = 600)
8 . Create incident package:
adrci> show incident
adrci>IPS CREATE PACKAGE INCIDENT
(or)
adrci> ips pack incident in /tmp
Generated package 9 in file /tmp/ORA1578_20090602113045_COM_1.zip, mode complete
We can create empty package and add required incident or problem or alert log files.
-- Create empty package
adrci>IPS CREATE PACKAGE
-- add the necessary incident files. ( package_number will be displayed in the above command)
adrci> IPS ADD INCIDENT incident_number PACKAGE 2
adrci> IPS ADD FILE /u01/app/oracle/alert_db.log PACKAGE 2
-- Now generate the package file.
adrci>IPS GENERATE PACKAGE 2 IN /home/oracle/housekeeping
9. Unpack a ips file
adrci> ips unpack file ORA_98928.zip into /tmp/housekeeping
10. Pack all incident files within a particular time frame
--Generates the package with the incidents occurred between the times '2023-03-01 12:00:00.00' and '2023-03-02 23:00:00.00'
ips pack time '2023-03-01 12:00:00.00' to '2023-03-02 23:00:00.00'
11. View package information
adrci> ips show package
adrci> ips show package 12 detail
12. Remove/delete package information:
-- Delete the complete package:
adrci> ips delete package 2
-- Remove incidents from the packages
adrci > ips remove incident 2 package 7
-- Remove the problem keys from packages
adrci > ips remove problem 4 package 8
Refer more details from oracle site
https://docs.oracle.com/en/database/oracle/oracle-database/19/sutil/oracle-adr-command-interpreter-adrci.html#GUID-DC5744C7-FAC0-436B-99D5-DBD45B66930B
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/sutil/oracle-adr-command-interpreter-adrci.html#GUID-DC5744C7-FAC0-436B-99D5-DBD45B66930B
Logs:
[oracle@oraclelab1 diag]$ adrci
ADRCI: Release 19.0.0.0.0 - Production on Mon Mar 25 23:25:54 2024
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
ADR base = "/u01/app/oracle"
adrci> show homepath
ADR Homes:
diag/rdbms/devdb/DEVDB
diag/rdbms/dev/DEV
diag/rdbms/test/TEST
diag/rdbms/uat/UAT
diag/rdbms/devcdb/DEVCDB
diag/rdbms/testcdb/TESTCDB
diag/rdbms/orclsba/ORCLSBA
diag/clients/user_oracle/host_1462227985_110
diag/tnslsnr/oraclelab1/listener_devdb
diag/tnslsnr/oraclelab1/listener
diag/tnslsnr/oraclelab1/listener_orclsba
adrci> set homepath diag/rdbms/devdb/DEVDB
adrci> show homepath
ADR Homes:
diag/rdbms/devdb/DEVDB
adrci> exit
[oracle@oraclelab1 diag]$
[oracle@oraclelab1 diag]$
[oracle@oraclelab1 diag]$ cd
[oracle@oraclelab1 ~]$ clear
[oracle@oraclelab1 ~]$ ps -ef|grep smon
oracle 16568 1 0 09:02 ? 00:00:00 ora_smon_DEVDB
oracle 24829 20401 0 23:27 pts/0 00:00:00 grep --color=auto smon
[oracle@oraclelab1 ~]$
[oracle@oraclelab1 ~]$
[oracle@oraclelab1 ~]$ env |grep ORA
ORACLE_SID=DEVDB
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/19.0.0.0/dbhome_1
[oracle@oraclelab1 ~]$
[oracle@oraclelab1 ~]$
[oracle@oraclelab1 ~]$ adrci
ADRCI: Release 19.0.0.0.0 - Production on Mon Mar 25 23:28:32 2024
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
ADR base = "/u01/app/oracle"
adrci> show base
ADR base is "/u01/app/oracle"
adrci>
adrci>
adrci> set base /u02/app/oracle
DIA-48447: The input path [/u02/app/oracle] does not contain any ADR homes
adrci>
adrci>
adrci> show hopepath
DIA-48415: Syntax error found in string [show hopepath] at column [13]
adrci> show homepath
ADR Homes:
diag/rdbms/devdb/DEVDB
diag/rdbms/dev/DEV
diag/rdbms/test/TEST
diag/rdbms/uat/UAT
diag/rdbms/devcdb/DEVCDB
diag/rdbms/testcdb/TESTCDB
diag/rdbms/orclsba/ORCLSBA
diag/clients/user_oracle/host_1462227985_110
diag/tnslsnr/oraclelab1/listener_devdb
diag/tnslsnr/oraclelab1/listener
diag/tnslsnr/oraclelab1/listener_orclsba
adrci>
adrci> set homepath diag/rdbms/devdb/DEVDB
adrci>
adrci> show homepath
ADR Homes:
diag/rdbms/devdb/DEVDB
adrci>
adrci>
adrci> show alert
ADR Home = /u01/app/oracle/diag/rdbms/devdb/DEVDB:
*************************************************************************
Output the results to file: /tmp/alert_24890_1396_DEVDB_1.ado
adrci>
adrci>
adrci>
adrci> show alert -tail 10
2024-03-25 22:00:48.429000 +05:30
Private strand flush not complete
Current log# 1 seq# 355 mem# 0: /u01/app/oracle/oradata/DEVDB/onlinelog/o1_mf_1_lcx8xwt5_.log
Current log# 1 seq# 355 mem# 1: /u01/app/oracle/fast_recovery_area/DEVDB/onlinelog/o1_mf_1_lcx8xx9r_.log
2024-03-25 22:00:51.445000 +05:30
Thread 1 advanced to log sequence 356 (LGWR switch), current SCN: 19705879
Current log# 2 seq# 356 mem# 0: /u01/app/oracle/oradata/DEVDB/onlinelog/o1_mf_2_lcx8xwv2_.log
Current log# 2 seq# 356 mem# 1: /u01/app/oracle/fast_recovery_area/DEVDB/onlinelog/o1_mf_2_lcx8xxcn_.log
2024-03-25 22:00:52.498000 +05:30
ARC0 (PID:16626): Archived Log entry 351 added for T-1.S-355 ID 0x3e743412 LAD:1
2024-03-25 22:01:48.114000 +05:30
TABLE SYS.WRP$_REPORTS: ADDED INTERVAL PARTITION SYS_P2225 (5198) VALUES LESS THAN (TO_DATE(' 2024-03-26 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
TABLE SYS.WRP$_REPORTS_DETAILS: ADDED INTERVAL PARTITION SYS_P2226 (5198) VALUES LESS THAN (TO_DATE(' 2024-03-26 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
TABLE SYS.WRP$_REPORTS_TIME_BANDS: ADDED INTERVAL PARTITION SYS_P2229 (5197) VALUES LESS THAN (TO_DATE(' 2024-03-25 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
adrci> :1
DIA-48415: Syntax error found in string [:1] at column [2]
adrci>
adrci> exit
[oracle@oraclelab1 ~]$
[oracle@oraclelab1 ~]$ locate alert_DEVDB.log
/u01/app/oracle/diag/rdbms/devdb/DEVDB/trace/alert_DEVDB.log
/u01/app/oracle/product/19.0.0.0/dbhome_1/rdbms/log/alert_DEVDB.log
[oracle@oraclelab1 ~]$ tail -10f /u01/app/oracle/diag/rdbms/devdb/DEVDB/trace/alert_DEVDB.log
2024-03-25T22:00:51.445813+05:30
Thread 1 advanced to log sequence 356 (LGWR switch), current SCN: 19705879
Current log# 2 seq# 356 mem# 0: /u01/app/oracle/oradata/DEVDB/onlinelog/o1_mf_2_lcx8xwv2_.log
Current log# 2 seq# 356 mem# 1: /u01/app/oracle/fast_recovery_area/DEVDB/onlinelog/o1_mf_2_lcx8xxcn_.log
2024-03-25T22:00:52.498205+05:30
ARC0 (PID:16626): Archived Log entry 351 added for T-1.S-355 ID 0x3e743412 LAD:1
2024-03-25T22:01:48.114691+05:30
TABLE SYS.WRP$_REPORTS: ADDED INTERVAL PARTITION SYS_P2225 (5198) VALUES LESS THAN (TO_DATE(' 2024-03-26 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
TABLE SYS.WRP$_REPORTS_DETAILS: ADDED INTERVAL PARTITION SYS_P2226 (5198) VALUES LESS THAN (TO_DATE(' 2024-03-26 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
TABLE SYS.WRP$_REPORTS_TIME_BANDS: ADDED INTERVAL PARTITION SYS_P2229 (5197) VALUES LESS THAN (TO_DATE(' 2024-03-25 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
^C
[oracle@oraclelab1 ~]$
[oracle@oraclelab1 ~]$
[oracle@oraclelab1 ~]$ adrci
ADRCI: Release 19.0.0.0.0 - Production on Mon Mar 25 23:31:36 2024
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
ADR base = "/u01/app/oracle"
adrci> show base
ADR base is "/u01/app/oracle"
adrci> show homepath
ADR Homes:
diag/rdbms/devdb/DEVDB
diag/rdbms/dev/DEV
diag/rdbms/test/TEST
diag/rdbms/uat/UAT
diag/rdbms/devcdb/DEVCDB
diag/rdbms/testcdb/TESTCDB
diag/rdbms/orclsba/ORCLSBA
diag/clients/user_oracle/host_1462227985_110
diag/tnslsnr/oraclelab1/listener_devdb
diag/tnslsnr/oraclelab1/listener
diag/tnslsnr/oraclelab1/listener_orclsba
adrci> set homepath diag/rdbms/devdb/DEVDB
adrci> show homepath
ADR Homes:
diag/rdbms/devdb/DEVDB
adrci>
adrci>
adrci> purge -age 600 -typr ALERT
DIA-48415: Syntax error found in string [purge -age 600 -typr] at column [20]
adrci> purge -age 600 -type ALERT
adrci> purge -age 600 -type TRACE
adrci> purge -age 600 -type incident
adrci> purge -age 10080 -type cdump
adrci>
adrci>
adrci> show control
ADR Home = /u01/app/oracle/diag/rdbms/devdb/DEVDB:
*************************************************************************
ADRID SHORTP_POLICY LONGP_POLICY LAST_MOD_TIME LAST_AUTOPRG_TIME LAST_MANUPRG_TIME ADRDIR_VERSION ADRSCHM_VERSION ADRSCHMV_SUMMARY ADRALERT_VERSION CREATE_TIME SIZEP_POLICY PURGE_PERIOD FLAGS PURGE_THRESHOLD
-------------------- -------------------- -------------------- ---------------------------------------- ---------------------------------------- ---------------------------------------- -------------------- -------------------- -------------------- -------------------- ---------------------------------------- -------------------- -------------------- -------------------- --------------------
458116003 720 8760 2023-07-24 21:43:56.256053 +05:30 2024-03-25 09:01:41.364048 +05:30 2024-03-25 23:32:44.478668 +05:30 1 2 110 1 2023-07-24 21:43:56.256053 +05:30 18446744073709551615 0 0 95
1 row fetched
adrci> set control (SHORTP_POLICY = 240)
adrci> set control (LONGP_POLICY = 600)
adrci> show control
ADR Home = /u01/app/oracle/diag/rdbms/devdb/DEVDB:
*************************************************************************
ADRID SHORTP_POLICY LONGP_POLICY LAST_MOD_TIME LAST_AUTOPRG_TIME LAST_MANUPRG_TIME ADRDIR_VERSION ADRSCHM_VERSION ADRSCHMV_SUMMARY ADRALERT_VERSION CREATE_TIME SIZEP_POLICY PURGE_PERIOD FLAGS PURGE_THRESHOLD
-------------------- -------------------- -------------------- ---------------------------------------- ---------------------------------------- ---------------------------------------- -------------------- -------------------- -------------------- -------------------- ---------------------------------------- -------------------- -------------------- -------------------- --------------------
458116003 240 600 2024-03-25 23:36:48.915111 +05:30 2024-03-25 09:01:41.364048 +05:30 2024-03-25 23:32:44.478668 +05:30 1 2 110 1 2023-07-24 21:43:56.256053 +05:30 18446744073709551615 0 0 95
1 row fetched
adrci> show incident
ADR Home = /u01/app/oracle/diag/rdbms/devdb/DEVDB:
*************************************************************************
0 rows fetched
adrci> IPS CREATE PACKAGE INCIDENT
DIA-48415: Syntax error found in string [IPS CREATE PACKAGE INCIDENT] at column [27]
adrci> ips pack incident in /tmp
DIA-48415: Syntax error found in string [ips pack incident in] at column [20]
DIA-48438: [in] is not a valid number
adrci> show homepath
ADR Homes:
diag/rdbms/devdb/DEVDB
adrci> set homepath diag/rdbms/uat/UAT
adrci> show incident
ADR Home = /u01/app/oracle/diag/rdbms/uat/UAT:
*************************************************************************
INCIDENT_ID PROBLEM_KEY CREATE_TIME
-------------------- ----------------------------------------------------------- ----------------------------------------
84289 ORA 603 2024-02-21 10:19:58.259000 +05:30
86689 ORA 603 2024-02-21 10:20:24.149000 +05:30
89089 ORA 603 2024-02-21 10:21:29.428000 +05:30
91489 ORA 700 [kdmfsIsSetup-bad-schema-version] 2024-02-21 10:23:04.538000 +05:30
91457 ORA 600 [kewrpwrc_2: Invalid SWRF version] 2024-02-21 10:23:23.219000 +05:30
91458 ORA 600 [kewrpwrc_2: Invalid SWRF version] 2024-02-21 10:23:31.910000 +05:30
91577 ORA 600 [kewrpwrc_2: Invalid SWRF version] 2024-02-21 10:24:32.189000 +05:30
91593 ORA 600 [kewrpwrc_2: Invalid SWRF version] 2024-02-21 10:26:32.676000 +05:30
91594 ORA 600 [kewrpwrc_2: Invalid SWRF version] 2024-02-21 10:30:33.372000 +05:30
91698 ORA 600 [kewrpwrc_2: Invalid SWRF version] 2024-02-22 15:26:49.727000 +05:30
91417 ORA 600 [kewrpwrc_2: Invalid SWRF version] 2024-02-22 15:53:07.903000 +05:30
91433 ORA 600 [kewrpwrc_2: Invalid SWRF version] 2024-02-22 15:56:59.838000 +05:30
91418 ORA 600 [kewrpwrc_2: Invalid SWRF version] 2024-02-23 20:26:54.019000 +05:30
91699 ORA 600 [kewrpwrc_2: Invalid SWRF version] 2024-02-23 20:53:13.024000 +05:30
91419 ORA 600 [kewrpwrc_2: Invalid SWRF version] 2024-02-23 20:57:04.956000 +05:30
91490 ORA 600 [kewrpwrc_2: Invalid SWRF version] 2024-02-24 22:11:16.577000 +05:30
91420 ORA 600 [kewrpwrc_2: Invalid SWRF version] 2024-02-25 01:26:58.048000 +05:30
91700 ORA 600 [kewrpwrc_2: Invalid SWRF version] 2024-02-25 01:53:14.697000 +05:30
91421 ORA 600 [kewrpwrc_2: Invalid SWRF version] 2024-02-25 01:57:06.617000 +05:30
91491 ORA 600 [kewrpwrc_2: Invalid SWRF version] 2024-02-25 08:17:33.231000 +05:30
91492 ORA 600 [kewrpwrc_2: Invalid SWRF version] 2024-02-25 12:47:44.664000 +05:30
21 rows fetched
adrci> IPS CREATE PACKAGE INCIDENT
DIA-48415: Syntax error found in string [IPS CREATE PACKAGE INCIDENT] at column [27]
adrci> ips pack incident in /tmp
DIA-48415: Syntax error found in string [ips pack incident in] at column [20]
DIA-48438: [in] is not a valid number
adrci>
adrci> set homepath diag/rdbms/devdb/DEVDB
adrci> IPS CREATE PACKAGE
Created package 1 without any contents, correlation level typical
adrci> IPS ADD INCIDENT 84289 PACKAGE 1
DIA-49431: No such incident [84289]
adrci>
adrci> exit
[oracle@oraclelab1 ~]$ ls -ltrh
total 3.4M
drwxr-xr-x. 2 oracle oinstall 6 Jul 11 2022 Videos
drwxr-xr-x. 2 oracle oinstall 6 Jul 11 2022 Templates
drwxr-xr-x. 2 oracle oinstall 6 Jul 11 2022 Public
drwxr-xr-x. 2 oracle oinstall 6 Jul 11 2022 Pictures
drwxr-xr-x. 2 oracle oinstall 6 Jul 11 2022 Music
drwxr-xr-x. 2 oracle oinstall 6 Jul 11 2022 Documents
drwxr-xr-x. 2 oracle oinstall 6 Jul 11 2022 Desktop
-rw-r--r--. 1 oracle oinstall 20K Jul 11 2022 db_19.3.0.0.rsp
-rw-r-----. 1 oracle oinstall 26K Jul 11 2022 dbca_DEVDB.rsp
-rw-r-----. 1 oracle oinstall 26K Jul 26 2022 dbca_DEVCDB.rsp
-rw-r-----. 1 oracle oinstall 26K Jul 26 2022 dbca_TESTCDB.rsp
-rwxrwxrwx. 1 oracle oinstall 737 Jul 28 2022 level0.sh
-rw-r-----. 1 oracle oinstall 26K Aug 8 2022 dbca_DEV_12.2.0.1.rsp
-rwxrwxrwx. 1 oracle oinstall 657 Aug 9 2022 level.sh
-rw-r--r--. 1 oracle oinstall 26K Aug 16 2022 mallik_ash.hrml
-rw-r--r--. 1 oracle oinstall 644K Aug 16 2022 mallik_CDB.html
-rw-r--r--. 1 oracle oinstall 23K Aug 23 2022 db_12.2.0.1.rsp
-rw-r--r--. 1 oracle oinstall 26 Oct 4 2022 mallik.sh
-rwxrwxrwx. 1 oracle oinstall 737 Oct 19 2022 level1.sh
-rw-r--r--. 1 oracle oinstall 582K Nov 8 2022 mallik_08_Nov_2022.html
-rw-r--r--. 1 oracle oinstall 105 Dec 8 2022 bash.sh
-rw-r--r--. 1 oracle oinstall 81 Dec 8 2022 query.sql
drwxr-xr-x. 2 oracle oinstall 6 Dec 22 2022 Downloads
drwxr-xr-x. 3 oracle oinstall 4.0K Jan 11 2023 Daily
-rwxr-xr-x. 1 oracle oinstall 751 Feb 16 2023 level_0.sh
-rwxr-xr-x. 1 oracle oinstall 751 Feb 16 2023 level_1.sh
-rw-r--r--. 1 oracle oinstall 353 Feb 18 2023 '
-rwxr-xr-x. 1 oracle oinstall 869 Mar 7 2023 rman_level_0.sh
-rwxr-xr-x. 1 oracle oinstall 870 Mar 7 2023 rman_level_1.sh
-rw-r--r--. 1 oracle oinstall 642K Mar 23 2023 mallik.html
-rw-r--r--. 1 oracle oinstall 32K Mar 27 2023 mallik_ash.html
-rw-r--r--. 1 oracle oinstall 94 Apr 27 2023 mallik1.sh
-rwxrwxrwx. 1 oracle oinstall 734 May 11 2023 rman_DEVDB_level_0.sh
-rwxrwxrwx. 1 oracle oinstall 752 May 11 2023 rman_DEVDB_level_1.sh
-rwxrwxrwx. 1 oracle oinstall 266 Jun 7 2023 DEV.env
-rwxrwxrwx. 1 oracle oinstall 2.7K Jun 7 2023 instance_select_on_logon.sh
-rw-r--r--. 1 oracle oinstall 47 Jul 23 2023 mallik.txt
-rw-r--r--. 1 oracle oinstall 52 Jul 28 2023 script.sql
-rwxrwxrwx. 1 oracle oinstall 147 Jul 28 2023 batch_sqlplus.sh
-rw-------. 1 oracle oinstall 2.3K Jul 28 2023 nohup.out
-rwxrwxr-x. 1 oracle oinstall 801 Aug 11 2023 RMAN_L0_DEVDB_Sun.sh
-rwxrwxr-x. 1 oracle oinstall 801 Aug 11 2023 RMAN_L1_DEVDB_Mon_Sat.sh
-rw-r--r--. 1 oracle oinstall 72 Aug 12 2023 afiedt.buf
-rw-r--r--. 1 oracle oinstall 614K Sep 1 2023 mallik_awr.html
-rw-r--r--. 1 oracle oinstall 891 Nov 13 08:26 DEVDB_Sun_Level_0.sh
-rw-r--r--. 1 oracle oinstall 890 Nov 13 08:26 DEVDB_Mon_Sat_Level_1.sh
drwxrwxrwx. 3 root root 4.0K Feb 26 08:52 script
-rw-r--r--. 1 oracle oinstall 643K Mar 5 08:20 awr_DEVDB_05032024.html
[oracle@oraclelab1 ~]$ pwd
/home/oracle
[oracle@oraclelab1 ~]$ adrci
ADRCI: Release 19.0.0.0.0 - Production on Mon Mar 25 23:41:53 2024
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
ADR base = "/u01/app/oracle"
adrci> set homepath diag/rdbms/devdb/DEVDB
adrci> sow homepath
DIA-48415: Syntax error found in string [sow homepath] at column [12]
adrci> show homepath
ADR Homes:
diag/rdbms/devdb/DEVDB
adrci> IPS ADD FILE /home/oracle/script.sql PACKAGE 1
DIA-49424: Directory outside ADR not allowed
adrci>
adrci> exit
[oracle@oraclelab1 ~]$ cd //u01/app/oracle/diag//rdbms/devdb/DEVDB
[oracle@oraclelab1 DEVDB]$ ll
total 28
drwxr-x---. 2 oracle oinstall 21 Mar 25 23:32 alert
drwxr-x---. 2 oracle oinstall 6 Jul 24 2023 cdump
drwxr-x---. 2 oracle oinstall 6 Jul 24 2023 hm
drwxr-x---. 2 oracle oinstall 6 Mar 25 23:32 incident
drwxr-x---. 3 oracle oinstall 19 Mar 25 23:39 incpkg
drwxr-x---. 2 oracle oinstall 34 Sep 30 08:38 ir
drwxr-x---. 2 oracle oinstall 4096 Oct 26 08:37 lck
drwxr-x---. 8 oracle oinstall 4096 Oct 26 07:49 log
drwxr-x---. 2 oracle oinstall 4096 Jul 24 2023 metadata
drwxr-x---. 2 oracle oinstall 6 Jul 24 2023 metadata_dgif
drwxr-x---. 2 oracle oinstall 6 Jul 24 2023 metadata_pv
drwxr-x---. 2 oracle oinstall 87 Mar 25 23:32 stage
drwxr-x---. 2 oracle oinstall 6 Oct 26 08:37 sweep
drwxr-x---. 3 oracle oinstall 581632 Mar 25 23:32 trace
[oracle@oraclelab1 DEVDB]$ cd alert
[oracle@oraclelab1 alert]$ ll
total 40
-rw-r-----. 1 oracle oinstall 38207 Mar 25 22:01 log.xml
[oracle@oraclelab1 alert]$ ls -ltrh
total 40K
-rw-r-----. 1 oracle oinstall 38K Mar 25 22:01 log.xml
[oracle@oraclelab1 alert]$
[oracle@oraclelab1 alert]$ pwd
//u01/app/oracle/diag/rdbms/devdb/DEVDB/alert
[oracle@oraclelab1 alert]$ adrci
ADRCI: Release 19.0.0.0.0 - Production on Mon Mar 25 23:43:45 2024
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
ADR base = "/u01/app/oracle"
adrci> set homepath diag/rdbms/devdb/DEVDB
adrci> show homepath
ADR Homes:
diag/rdbms/devdb/DEVDB
adrci> IPS ADD FILE /u01/app/oracle/diag/rdbms/devdb/DEVDB/alert/log.xml PACKAGE 1
Added file /u01/app/oracle/diag/rdbms/devdb/DEVDB/alert/log.xml to package 1
adrci> IPS GENERATE PACKAGE 1 IN /home/oracle/
Generated package 1 in file /home/oracle/IPSPKG_20240325233912_COM_1.zip, mode complete
adrci> adrci>
adrci>
adrci> IPS unpack file /home/oracle/IPSPKG_20240325233912_COM_1.zip /tmp
Unpacking file /home/oracle/IPSPKG_20240325233912_COM_1.zip into target /tmp
adrci> exit
[oracle@oraclelab1 alert]$ cd /tmp
[oracle@oraclelab1 tmp]$ ls -ltrh
total 368K
drwx------. 2 root root 41 Apr 14 2023 mozilla_root0
drwx------. 3 root root 17 Dec 1 10:33 systemd-private-4309e12c255c45eebbe06424143737d8-rtkit-daemon.service-KgloC1
drwx------. 3 root root 17 Dec 1 10:33 systemd-private-4309e12c255c45eebbe06424143737d8-cups.service-emjPFx
drwx------. 3 root root 17 Dec 1 10:33 systemd-private-4309e12c255c45eebbe06424143737d8-bolt.service-iUBex2
drwx------. 3 root root 17 Dec 1 10:33 systemd-private-4309e12c255c45eebbe06424143737d8-colord.service-8chJlP
drwx------. 2 root root 25 Feb 2 15:11 ssh-levLy1ZfyOAl
drwx------. 3 root root 17 Feb 2 15:11 systemd-private-4309e12c255c45eebbe06424143737d8-fwupd.service-Wm3PL9
drwx------. 2 oracle oinstall 25 Feb 8 07:14 ssh-h8xcYGEJ7JnH
-rw-------. 1 root root 365K Mar 25 09:14 yum_save_tx.2024-03-25.09-14.BqYSVj.yumtx
drwxr-xr-x. 2 oracle oinstall 19 Mar 25 23:45 hsperfdata_oracle
drwxrwxr-x. 3 oracle oinstall 19 Mar 25 23:45 diag
[oracle@oraclelab1 tmp]$ cd diag
[oracle@oraclelab1 diag]$ ll
total 0
drwxr-xr-x. 3 oracle oinstall 19 Mar 25 23:45 rdbms
[oracle@oraclelab1 diag]$ cd rdbms/
[oracle@oraclelab1 rdbms]$ ll
total 0
drwxr-xr-x. 3 oracle oinstall 19 Mar 25 23:45 devdb
[oracle@oraclelab1 rdbms]$ cd devdb/
[oracle@oraclelab1 devdb]$ ll
total 4
drwxr-xr-x. 16 oracle oinstall 4096 Mar 25 23:45 DEVDB
[oracle@oraclelab1 devdb]$ cd DEVDB/
[oracle@oraclelab1 DEVDB]$ ll
total 8
drwxr-xr-x. 2 oracle oinstall 21 Mar 25 23:45 alert
drwxr-xr-x. 2 oracle oinstall 6 Mar 25 23:45 cdump
drwxr-xr-x. 2 oracle oinstall 6 Mar 25 23:45 hm
drwxr-xr-x. 2 oracle oinstall 6 Mar 25 23:45 incident
drwxr-xr-x. 3 oracle oinstall 19 Mar 25 23:45 incpkg
drwxr-xr-x. 2 oracle oinstall 6 Mar 25 23:45 ir
drwxr-xr-x. 2 oracle oinstall 4096 Mar 25 23:45 lck
drwxr-xr-x. 5 oracle oinstall 48 Mar 25 23:45 log
drwxr-xr-x. 2 oracle oinstall 4096 Mar 25 23:45 metadata
drwxr-xr-x. 2 oracle oinstall 6 Mar 25 23:45 metadata_dgif
drwxr-xr-x. 2 oracle oinstall 6 Mar 25 23:45 metadata_pv
drwxr-xr-x. 2 oracle oinstall 6 Mar 25 23:45 stage
drwxr-xr-x. 2 oracle oinstall 6 Mar 25 23:45 sweep
drwxr-xr-x. 2 oracle oinstall 29 Mar 25 23:45 trace
[oracle@oraclelab1 DEVDB]$ pwd
/tmp/diag/rdbms/devdb/DEVDB
[oracle@oraclelab1 DEVDB]$ date
Mon Mar 25 23:46:20 IST 2024
[oracle@oraclelab1 DEVDB]$
[oracle@oraclelab1 DEVDB]$
[oracle@oraclelab1 DEVDB]$ adrci
ADRCI: Release 19.0.0.0.0 - Production on Mon Mar 25 23:46:27 2024
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
ADR base = "/tmp"
adrci> set homepath diag/rdbms/devdb/DEVDB
adrci>
adrci> ips pack time '2024-03-25 12:00:00' to '2024-03-25 13:00:00'
Generated package 2 in file /tmp/IPSPKG_20240325234807_COM_1.zip, mode complete
adrci> ips show paches
DIA-49406: Undefined configuration parameter specified [paches]
adrci> ips show package
PACKAGE_ID 1
PACKAGE_NAME IPSPKG_20240325233912
PACKAGE_DESCRIPTION
DRIVING_PROBLEM N/A
DRIVING_PROBLEM_KEY N/A
DRIVING_INCIDENT N/A
DRIVING_INCIDENT_TIME N/A
STATUS New (0)
CORRELATION_LEVEL Typical (2)
PROBLEMS 0 main problems, 0 correlated problems
INCIDENTS 0 main incidents, 0 correlated incidents
INCLUDED_FILES 24
PACKAGE_ID 2
PACKAGE_NAME IPSPKG_20240325234807
PACKAGE_DESCRIPTION
DRIVING_PROBLEM N/A
DRIVING_PROBLEM_KEY N/A
DRIVING_INCIDENT N/A
DRIVING_INCIDENT_TIME N/A
STATUS Generated (4)
CORRELATION_LEVEL Typical (2)
PROBLEMS 0 main problems, 0 correlated problems
INCIDENTS 0 main incidents, 0 correlated incidents
INCLUDED_FILES 28
adrci> ips show package 1 details
DIA-48415: Syntax error found in string [ips show package 1 details] at column [26]
adrci> ips show package 1 detail
DETAILS FOR PACKAGE 1:
PACKAGE_ID 1
PACKAGE_NAME IPSPKG_20240325233912
PACKAGE_DESCRIPTION
DRIVING_PROBLEM N/A
DRIVING_PROBLEM_KEY N/A
DRIVING_INCIDENT N/A
DRIVING_INCIDENT_TIME N/A
STATUS New (0)
CORRELATION_LEVEL Typical (2)
PROBLEMS 0 main problems, 0 correlated problems
INCIDENTS 0 main incidents, 0 correlated incidents
INCLUDED_FILES 24
SEQUENCES Last 0, last full 0, last base 0
UNPACKED TRUE
CREATE_TIME 2024-03-25 23:39:12.913644 +05:30
UPDATE_TIME N/A
BEGIN_TIME N/A
END_TIME N/A
FLAGS 0
HISTORY FOR PACKAGE 1:
SEQUENCE 1
BASE_SEQUENCE 1
MODE Complete (0)
STATUS Finalizing (1)
FILENAME
ARCHIVE_TIME 2024-03-25 23:45:00.626797 +05:30
UPLOAD_TIME N/A
UNPACK_TIME 2024-03-25 23:45:57.408539 +05:30
FORCE FALSE
GENERATE_FLAGS 0
UNPACK_FLAGS 0
MAIN INCIDENTS FOR PACKAGE 1:
CORRELATED INCIDENTS FOR PACKAGE 1:
FILES FOR PACKAGE 1:
FILE_ID 1
FILE_LOCATION <ADR_HOME>/alert
FILE_NAME log.xml
LAST_SEQUENCE 0
EXCLUDE Included
FILE_ID 2
FILE_LOCATION <ADR_HOME>/trace
FILE_NAME alert_DEVDB.log
LAST_SEQUENCE 0
EXCLUDE Included
FILE_ID 3
FILE_LOCATION <ADR_HOME>/incpkg/pkg_1/seq_1/export
FILE_NAME IPS_CONFIGURATION.dmp
LAST_SEQUENCE 0
EXCLUDE Included
FILE_ID 4
FILE_LOCATION <ADR_HOME>/incpkg/pkg_1/seq_1/export
FILE_NAME IPS_PACKAGE.dmp
LAST_SEQUENCE 0
EXCLUDE Included
FILE_ID 5
FILE_LOCATION <ADR_HOME>/incpkg/pkg_1/seq_1/export
FILE_NAME IPS_PACKAGE_INCIDENT.dmp
LAST_SEQUENCE 0
EXCLUDE Included
FILE_ID 6
FILE_LOCATION <ADR_HOME>/incpkg/pkg_1/seq_1/export
FILE_NAME IPS_PACKAGE_FILE.dmp
LAST_SEQUENCE 0
EXCLUDE Included
FILE_ID 7
FILE_LOCATION <ADR_HOME>/incpkg/pkg_1/seq_1/export
FILE_NAME IPS_PACKAGE_HISTORY.dmp
LAST_SEQUENCE 0
EXCLUDE Included
FILE_ID 8
FILE_LOCATION <ADR_HOME>/incpkg/pkg_1/seq_1/export
FILE_NAME IPS_FILE_METADATA.dmp
LAST_SEQUENCE 0
EXCLUDE Included
FILE_ID 9
FILE_LOCATION <ADR_HOME>/incpkg/pkg_1/seq_1/export
FILE_NAME IPS_FILE_COPY_LOG.dmp
LAST_SEQUENCE 0
EXCLUDE Included
FILE_ID 10
FILE_LOCATION <ADR_HOME>/incpkg/pkg_1/seq_1/export
FILE_NAME DDE_USER_ACTION_DEF.dmp
LAST_SEQUENCE 0
EXCLUDE Included
FILE_ID 11
FILE_LOCATION <ADR_HOME>/incpkg/pkg_1/seq_1/export
FILE_NAME DDE_USER_ACTION_PARAMETER_DEF.dmp
LAST_SEQUENCE 0
EXCLUDE Included
FILE_ID 12
FILE_LOCATION <ADR_HOME>/incpkg/pkg_1/seq_1/export
FILE_NAME DDE_USER_ACTION.dmp
LAST_SEQUENCE 0
EXCLUDE Included
FILE_ID 13
FILE_LOCATION <ADR_HOME>/incpkg/pkg_1/seq_1/export
FILE_NAME DDE_USER_ACTION_PARAMETER.dmp
LAST_SEQUENCE 0
EXCLUDE Included
FILE_ID 14
FILE_LOCATION <ADR_HOME>/incpkg/pkg_1/seq_1/export
FILE_NAME DDE_USER_INCIDENT_TYPE.dmp
LAST_SEQUENCE 0
EXCLUDE Included
FILE_ID 15
FILE_LOCATION <ADR_HOME>/incpkg/pkg_1/seq_1/export
FILE_NAME DDE_USER_INCIDENT_ACTION_MAP.dmp
LAST_SEQUENCE 0
EXCLUDE Included
FILE_ID 16
FILE_LOCATION <ADR_HOME>/incpkg/pkg_1/seq_1/export
FILE_NAME INCIDENT.dmp
LAST_SEQUENCE 0
EXCLUDE Included
FILE_ID 17
FILE_LOCATION <ADR_HOME>/incpkg/pkg_1/seq_1/export
FILE_NAME INCCKEY.dmp
LAST_SEQUENCE 0
EXCLUDE Included
FILE_ID 18
FILE_LOCATION <ADR_HOME>/incpkg/pkg_1/seq_1/export
FILE_NAME INCIDENT_FILE.dmp
LAST_SEQUENCE 0
EXCLUDE Included
FILE_ID 19
FILE_LOCATION <ADR_HOME>/incpkg/pkg_1/seq_1/export
FILE_NAME PROBLEM.dmp
LAST_SEQUENCE 0
EXCLUDE Included
FILE_ID 20
FILE_LOCATION <ADR_HOME>/incpkg/pkg_1/seq_1/export
FILE_NAME HM_RUN.dmp
LAST_SEQUENCE 0
EXCLUDE Included
FILE_ID 21
FILE_LOCATION <ADR_HOME>/incpkg/pkg_1/seq_1/export
FILE_NAME EM_USER_ACTIVITY.dmp
LAST_SEQUENCE 0
EXCLUDE Included
FILE_ID 22
FILE_LOCATION <ADR_HOME>/incpkg/pkg_1/seq_1
FILE_NAME config.xml
LAST_SEQUENCE 0
EXCLUDE Included
FILE_ID 23
FILE_LOCATION <ADR_HOME>/incpkg/pkg_1/seq_1/opatch
FILE_NAME opatch.log
LAST_SEQUENCE 0
EXCLUDE Included
FILE_ID 24
FILE_LOCATION <ADR_HOME>/incpkg/pkg_1/seq_1/opatch
FILE_NAME opatch.xml
LAST_SEQUENCE 0
EXCLUDE Included
adrci> ips delete package 1
Deleted package 1
adrci> ips show package
PACKAGE_ID 2
PACKAGE_NAME IPSPKG_20240325234807
PACKAGE_DESCRIPTION
DRIVING_PROBLEM N/A
DRIVING_PROBLEM_KEY N/A
DRIVING_INCIDENT N/A
DRIVING_INCIDENT_TIME N/A
STATUS Generated (4)
CORRELATION_LEVEL Typical (2)
PROBLEMS 0 main problems, 0 correlated problems
INCIDENTS 0 main incidents, 0 correlated incidents
INCLUDED_FILES 28
adrci> ips show package 2 detail;s
DETAILS FOR PACKAGE 2:
PACKAGE_ID 2
PACKAGE_NAME IPSPKG_20240325234807
PACKAGE_DESCRIPTION
DRIVING_PROBLEM N/A
DRIVING_PROBLEM_KEY N/A
DRIVING_INCIDENT N/A
DRIVING_INCIDENT_TIME N/A
STATUS Generated (4)
CORRELATION_LEVEL Typical (2)
PROBLEMS 0 main problems, 0 correlated problems
INCIDENTS 0 main incidents, 0 correlated incidents
INCLUDED_FILES 28
SEQUENCES Last 1, last full 1, last base 0
UNPACKED FALSE
CREATE_TIME 2024-03-25 23:48:07.755342 +05:30
UPDATE_TIME N/A
BEGIN_TIME 2024-03-25 12:00:00.000000 +05:30
END_TIME 2024-03-25 13:00:00.000000 +05:30
FLAGS 0
HISTORY FOR PACKAGE 2:
SEQUENCE 1
BASE_SEQUENCE 1
MODE Complete (0)
STATUS Generated (4)
FILENAME /tmp/IPSPKG_20240325234807_COM_1.zip
ARCHIVE_TIME 2024-03-25 23:48:15.265451 +05:30
UPLOAD_TIME N/A
UNPACK_TIME N/A
FORCE FALSE
GENERATE_FLAGS 0
UNPACK_FLAGS 0
MAIN INCIDENTS FOR PACKAGE 2:
CORRELATED INCIDENTS FOR PACKAGE 2:
FILES FOR PACKAGE 2:
FILE_ID 1
FILE_LOCATION <ADR_HOME>/alert
FILE_NAME log.xml
LAST_SEQUENCE 1
EXCLUDE Included
FILE_ID 2
FILE_LOCATION <ADR_HOME>/trace
FILE_NAME alert_DEVDB.log
LAST_SEQUENCE 1
EXCLUDE Included
FILE_ID 25
FILE_LOCATION <ADR_HOME>/incpkg/pkg_2/seq_1/export
FILE_NAME IPS_CONFIGURATION.dmp
LAST_SEQUENCE 1
EXCLUDE Included
FILE_ID 26
FILE_LOCATION <ADR_HOME>/incpkg/pkg_2/seq_1/export
FILE_NAME IPS_PACKAGE.dmp
LAST_SEQUENCE 1
EXCLUDE Included
FILE_ID 27
FILE_LOCATION <ADR_HOME>/incpkg/pkg_2/seq_1/export
FILE_NAME IPS_PACKAGE_INCIDENT.dmp
LAST_SEQUENCE 1
EXCLUDE Included
FILE_ID 28
FILE_LOCATION <ADR_HOME>/incpkg/pkg_2/seq_1/export
FILE_NAME IPS_PACKAGE_FILE.dmp
LAST_SEQUENCE 1
EXCLUDE Included
FILE_ID 29
FILE_LOCATION <ADR_HOME>/incpkg/pkg_2/seq_1/export
FILE_NAME IPS_PACKAGE_HISTORY.dmp
LAST_SEQUENCE 1
EXCLUDE Included
FILE_ID 30
FILE_LOCATION <ADR_HOME>/incpkg/pkg_2/seq_1/export
FILE_NAME IPS_FILE_METADATA.dmp
LAST_SEQUENCE 1
EXCLUDE Included
FILE_ID 31
FILE_LOCATION <ADR_HOME>/incpkg/pkg_2/seq_1/export
FILE_NAME IPS_FILE_COPY_LOG.dmp
LAST_SEQUENCE 1
EXCLUDE Included
FILE_ID 32
FILE_LOCATION <ADR_HOME>/incpkg/pkg_2/seq_1/export
FILE_NAME DDE_USER_ACTION_DEF.dmp
LAST_SEQUENCE 1
EXCLUDE Included
FILE_ID 33
FILE_LOCATION <ADR_HOME>/incpkg/pkg_2/seq_1/export
FILE_NAME DDE_USER_ACTION_PARAMETER_DEF.dmp
LAST_SEQUENCE 1
EXCLUDE Included
FILE_ID 34
FILE_LOCATION <ADR_HOME>/incpkg/pkg_2/seq_1/export
FILE_NAME DDE_USER_ACTION.dmp
LAST_SEQUENCE 1
EXCLUDE Included
FILE_ID 35
FILE_LOCATION <ADR_HOME>/incpkg/pkg_2/seq_1/export
FILE_NAME DDE_USER_ACTION_PARAMETER.dmp
LAST_SEQUENCE 1
EXCLUDE Included
FILE_ID 36
FILE_LOCATION <ADR_HOME>/incpkg/pkg_2/seq_1/export
FILE_NAME DDE_USER_INCIDENT_TYPE.dmp
LAST_SEQUENCE 1
EXCLUDE Included
FILE_ID 37
FILE_LOCATION <ADR_HOME>/incpkg/pkg_2/seq_1/export
FILE_NAME DDE_USER_INCIDENT_ACTION_MAP.dmp
LAST_SEQUENCE 1
EXCLUDE Included
FILE_ID 38
FILE_LOCATION <ADR_HOME>/incpkg/pkg_2/seq_1/export
FILE_NAME INCIDENT.dmp
LAST_SEQUENCE 1
EXCLUDE Included
FILE_ID 39
FILE_LOCATION <ADR_HOME>/incpkg/pkg_2/seq_1/export
FILE_NAME INCCKEY.dmp
LAST_SEQUENCE 1
EXCLUDE Included
FILE_ID 40
FILE_LOCATION <ADR_HOME>/incpkg/pkg_2/seq_1/export
FILE_NAME INCIDENT_FILE.dmp
LAST_SEQUENCE 1
EXCLUDE Included
FILE_ID 41
FILE_LOCATION <ADR_HOME>/incpkg/pkg_2/seq_1/export
FILE_NAME PROBLEM.dmp
LAST_SEQUENCE 1
EXCLUDE Included
FILE_ID 42
FILE_LOCATION <ADR_HOME>/incpkg/pkg_2/seq_1/export
FILE_NAME HM_RUN.dmp
LAST_SEQUENCE 1
EXCLUDE Included
FILE_ID 43
FILE_LOCATION <ADR_HOME>/incpkg/pkg_2/seq_1/export
FILE_NAME EM_USER_ACTIVITY.dmp
LAST_SEQUENCE 1
EXCLUDE Included
FILE_ID 44
FILE_LOCATION <ADR_HOME>/incpkg/pkg_2/seq_1
FILE_NAME config.xml
LAST_SEQUENCE 1
EXCLUDE Included
FILE_ID 45
FILE_LOCATION <ADR_HOME>/incpkg/pkg_2/seq_1/opatch
FILE_NAME opatch.log
LAST_SEQUENCE 1
EXCLUDE Included
FILE_ID 46
FILE_LOCATION <ADR_HOME>/incpkg/pkg_2/seq_1/opatch
FILE_NAME opatch.xml
LAST_SEQUENCE 1
EXCLUDE Included
FILE_ID 47
FILE_LOCATION <ADR_HOME>/incpkg/pkg_2/seq_1
FILE_NAME metadata.xml
LAST_SEQUENCE 1
EXCLUDE Included
FILE_ID 48
FILE_LOCATION <ADR_HOME>/incpkg/pkg_2/seq_1
FILE_NAME manifest_2_1.xml
LAST_SEQUENCE 1
EXCLUDE Included
FILE_ID 49
FILE_LOCATION <ADR_HOME>/incpkg/pkg_2/seq_1
FILE_NAME manifest_2_1.html
LAST_SEQUENCE 1
EXCLUDE Included
FILE_ID 50
FILE_LOCATION <ADR_HOME>/incpkg/pkg_2/seq_1
FILE_NAME manifest_2_1.txt
LAST_SEQUENCE 1
EXCLUDE Included
DIA-48415: Syntax error found in string [s] at column [1]
adrci> ips remove incident 2 package 2
DIA-49433: Incident not part of package [2]
adrci>
adrci> ips remove file 50 package 2
DIA-49427: No such file or file not accessible [50]
adrci>
adrci> ips remove FILE_ID 50 package 2
DIA-48415: Syntax error found in string [ips remove FILE_ID] at column [18]
adrci>
adrci> ips delete package 2;
Deleted package 2
adrci> ips show package
adrci>
adrci>
adrci>
adrci> exit
[oracle@oraclelab1 DEVDB]$
Regards,
Mallikarjun