Once the logical package has been
created, it is possible to add diagnostic information or
additional files in ADR to the existing package. To
add an incident to an existing package, the command is ?ips
add incident [incident_number]
package [package_number]?.
To add a file to an existing package, the command is ?ips
add file [file_path]
package [package_number]?,
with file_path as
a fully qualified path and file name. Only files
within the ADR base directory can be added.
You can also view the incidents
contained within the logical package by using ?ips show
incidents package
[package_number]?
such as:
adrci> ips show incidents package 1
**********************************************************
Main INCIDENTS
**********************************************************
----------------------------------------------------------
**********************************************************
INCIDENT RECORD
**********************************************************
----------------------------------------------------------
INCIDENT INFORMATION:
INCIDENT_ID
5138
PROBLEM_ID
2
EXCLUDE
0
----------------------------------------------------------
**********************************************************
Correlated INCIDENTS
**********************************************************
----------------------------------------------------------
**********************************************************
INCIDENT RECORD
**********************************************************
----------------------------------------------------------
INCIDENT INFORMATION:
INCIDENT_ID
5137
PROBLEM_ID
1
EXCLUDE
0
----------------------------------------------------------
adrci>
To view the files included in a package, use the
command ?ips show files package
[package_number]?. The output of this command
will show all the files that will be included in the zip
file when the physical package is generated. Listed
below is the output generated from this command for 2/42
files in package 1.
**********************************************************
----------------------------------------------------------
FILE INFORMATION:
FILE_LOCATION
<ADR_HOME>/incpkg/pkg_1/seq_2/export!c:\oracle\11g\diag\rdbms\ora11gr1\ora11gr1
FILE_NAME
HM_RUN.dmp
LAST_SEQUENCE
2
EXCLUDE
0
----------------------------------------------------------
**********************************************************
FILE RECORD
**********************************************************
----------------------------------------------------------
FILE INFORMATION:
FILE_LOCATION
<ADR_HOME>/incpkg/pkg_1/seq_2/export!c:\oracle\11g\diag\rdbms\ora11gr1\ora11gr1
FILE_NAME
EM_USER_ACTIVITY.dmp
LAST_SEQUENCE
2
EXCLUDE
0
----------------------------------------------------------
Viewing additional IPS commands available from ADRCI is done
by typing ?help ips
[topic]?
from the adrci prompt. Detailed
information for all available commands is available using
the help option. A complete list of possible ADR
operations is also available from Oracle's documentation
library in Oracle Database Utilities ADRCI: ADR Command
Interpreter.
Generating the Physical Incident
Package
If this is the first time creating the
zip file for the logical package, then a complete zip file
will be created. However, if a zip file for the
logical package has already been generated, then an
incremental physical package can be generated to include
only incidents or files that have been added since the last
package generation. Once the logical package is
satisfactory, the DBA can generate the zip file from the
logical package by using the following command:
ips
generate package package_id [output_path] [complete
| incremental]
The output path is the path to the
directory that the zip file will be placed. If this
field is omitted, the package will be generated in the
current working directory. For example, if a DBA wants
to generate the zip file for package 1 in C:\tmp:
adrci> ips generate package 1 in
C:\tmp
Generated package 1 in file C:\tmp\ORA7445qm_20071116141007_COM_1.zip,
mode complete
adrci>
Zip files are named according to the
following nomenclature ,packageName_mode_sequence.zip,
where packageName is the problem key concatenated with a
timestamp, mode is either ?COM? for complete or ?INC? for
incremental, and sequence is an integer.
If a logical package has been modified
and already generated a physical package, the zip file can
be generated using an incremental mode:
adrci> ips generate package 1 in C:\tmp incremental
Generated package 1 in file C:\tmp\ORA7445qm_20071116141007_INC_2.zip,
mode incremental
adrci>
and include the URL for the page.
