Use the Oracle 11g adrci ips to package an incident, adrciips

Use the Oracle 11g adrci ips to package an incident, adrciips

[Oracle @ rhel63single ~] $ Which adrci/u02/app/oracle/product/11.2.0.4/db_1/bin/adrci [oracle @ rhel63single ~] $ AdrciADRCI: Release 11.2.0.4.0-Production on Sat May 2 22:32:28 2015 -----> this is OS time Copyright (c) 1982,201 1, Oracle and/or its affiliates. all rights reserved. ADR base = "/u01/app/oracle" adrci> show problemADR Home =/u01/app/oracle/diag/tnslsnr/rhel63single/listener: **************************************** * ******************************** 0 rows fetchedADR Home =/u01 /app/oracle/diag/rdbms/test: **************************************** * ******************************* PROBLEM_ID PROBLEM_KEY LAST_INCIDENT LASTINC_TIME ------------------------------------------------------------ ----------------------- 1 ORA 1578 16961 20:35:35. 310000 + 08: 00 2 ORA 4031 32428 01:00:37. 647000 + 08: 00 3 ORA 600 [qmrcGetRepRC] 32441 02:20:00. 781000 + 08: 00 4 ORA 445 45655 01:51:31. 549000 + 08: 00 4 rows fetchedadrci> show incidentADR Home =/u01/app/oracle/diag/tnslsnr/rhel63single/listener: **************************************** * ******************************** 0 rows fetchedADR Home =/u01 /app/oracle/diag/rdbms/test: **************************************** * ******************************* INCIDENT_ID PROBLEM_KEY CREATE_TIME ---------------- limit 16961 ORA 1578 20:35:35. 310000 + 08: 00 31354 ORA 4031 00:31:36. 018000 + 08: 00 31355 ORA 4031 00:33:17. 268000 + 08: 00 31356 ORA 4031 00:39:46. 038000 + 08: 00 31357 ORA 4031 00:39:58. 767000 + 08: 00 31358 ORA 4031 00:40:07. 251000 + 08: 00 32441 ORA 600 [qmrcGetRepRC] 02:20:00. 781000 + 08: 00 44677 ORA 445 20:46:37. 901000 + 08: 00 44573 ORA 445 20:58:13. 842000 + 08: 00 44574 ORA 445 21:12:58. 866000 + 08: 00 44679 ORA 445 21:15:43. 893000 + 08: 00 44575 ORA 445 01:03:26. 299000 + 08: 00 44683 ORA 445 01:10:24. 094000 + 08: 00 13 rows fetchedadrci> ips create package incident 31358DIA-48448: This command does not support multiple ADR homesadrci> show homesADR Homes: diag/tnslsnr/rhel63single/listenerdiag/rdbms/test/testadrci> set homepath diag/rdbms/test/testadrci> ips create package incident 31358 Created package 1 based on incident id 31358, correlation level typicaladrci> adrci> help HELP [topic] Available Topics: create report echo exit help host ips purge run set base set browser set control set echo set editor set homes | HOME | homepath set termout show alert show base show control show HM_RUN show homes | HOME | homepath show incdir show incident show problem show report show tracefile spool There are other commands intended to be used directly by Oracle, type "help extended" to see the listadrci> show reportDIA-48415: Syntax error found in string [show report] at column [12] adrci> ips helpDIA-48415: syntax error found in string [ips help] at column [8] adrci> help ips help ips [topic] Available Topics: ADD FILE ADD NEW INCIDENTS CHECK REMOTE KEYS COPY IN FILE COPY OUT FILE CREATE PACKAGE DELETE PACKAGE FINALIZE PACKAGE GENERATE PACKAGE GET MANIFEST GET METADATA GET REMOTE KEYS PACK REMOVE FILE SET CONFIGURATION SHOW FILES show incidents show package unpack file unpack package use remote keys adrci> ips show package PACKAGE_ID 1 PACKAGE_NAME certificate -----> This is the OS time PACKAGE_DESCRIPTION DRIVING_PROBLEM 2 minutes ORA 4031 minutes 31358 minutes 00:40:07. 251000 + 08: 00 STATUS New (0) CORRELATION_LEVEL Typical (2) PROBLEMS 1 main problems, 2 correlated problems INCIDENTS 1 main incidents, 5 correlated incidents limit ded_files 14 adrci>

At this point, you can only package one incident. This incident is only packaged and not yet generated on the file system. The steps are as follows:

[Oracle @ rhel63single test] $ adrciADRCI: Release 11.2.0.4.0-Production on Sat May 2 22:53:37 2015 Copyright (c) 1982,201 1, Oracle and/or its affiliates. all rights reserved. ADR base = "/u01/app/oracle" adrci> show homesADR Homes: diag/rdbms/test/testadrci> ips show package PACKAGE_ID 1 PACKAGE_NAME contains PACKAGE_DESCRIPTION DRIVING_PROBLEM 2 DRIVING_PROBLEM_KEY ORA 4031 DRIVING_INCIDENT 31358 00:40:07. 251000 + 08: 00 STATUS New (0) CORRELATION_LEVEL Typical (2) PROBLEMS 1 main problems, 2 correlated problems INCIDENTS 1 main incidents, 5 correlated incidents INCLUDED_FILES 14 adrci> ips create package incident 31358 correlate allCreated package 2 based on incident id 31358, correlation level alladrci> adrci> ips show package PACKAGE_ID 1 PACKAGE_NAME contains PACKAGE_DESCRIPTION DRIVING_PROBLEM 2 DRIVING_PROBLEM_KEY ORA 4031 DRIVING_INCIDENT 31358 00:40:07. 251000 + 08: 00 STATUS New (0) CORRELATION_LEVEL Typical (2) PROBLEMS 1 main problems, 2 correlated problems INCIDENTS 1 main incidents, 5 correlated incidents INCLUDED_FILES 14 PACKAGE_ID 2 PACKAGE_NAME inclupackage_description DRIVING_PROBLEM 2 DRIVING_PROBLEM_KEY ORA 4031 DRIVING_INCIDENT 31358 DRIVING_INCIDENT_TIME 00:40:07. 251000 + 08: 00 STATUS New (0) CORRELATION_LEVEL All (4) PROBLEMS 1 main problems, 2 correlated problems INCIDENTS 1 main incidents, 5 correlated incidents INCLUDED_FILES 14 adrci> ips generate package 1 Generated package 1 in file/u01/app/oracle/diag/rdbms/test/ora4031_201502223521_com_1.zip, mode complete --> GENERATE adrci> ips generate package 2 in/home/oracle/Generated package 2 in file/home/oracle/ORA4031_20150502225909_COM_1.zip, mode complete ---> Generate to the specified position adrci>