Using the Enterprise Manager for IPS in 11g

In order to view incidents captured by ADR, and to access the Incident Packaging Services through the Enterprise Manager, navigate to the Support Workbench by clicking on the Software and Support tab as shown below. 

Figure 3:  Using the Software and Support tab

From the Support Workbench, problems captured in the ADR are viewed.  There is also a tab for accessing existing packages.  To create a new package, select the checkbox for one or more problems to add to the package and click on the Package button. 

Figure 4 : Viewing Problems on the Support Workbench

This menu offers choices to use the quick packaging or a custom package. 

Figure 5: The Quick Packaging or Custom Packaging Options

Using Quick Packaging

Figure 6:  Quick Packaging with Package Name

From the first step of the quick packaging, it is possible to enter MOSC details to automatically send the zip file to Oracle Support.  A new Service Request based on the package can also be created.  Clicking on the next button generates the logical package and offers a view of the contents of the package.

Figure 7  :  Viewing the Package Contents  

The next step will display the package manifest.  This includes information about the package, included problems and incidents, and a listing of the files that will be included.

Figure  8 : Viewing the Package Manifest

The final step allows the DBA to schedule the generation of the physical package. 

Figure 9 :  Scheduling the Generation of the Physical Package

Clicking the submit button will generate the zip file and display a confirmation and location of the physical file on disk. 

Figure 10:  Physical File on Disk Confirmation and Location

The problem information, incident information, trace files, and dumps associated with the selected problems are automatically added to the zip file.  The zip file can either be uploaded manually on the MOSC service request or uploaded through Oracle's Configuration Manager.  To view all the files in the zip file, navigate to the Packages tab on the Support Workbench and click on the package. 

Custom Package

If the choice is to create a custom package, the option of creating the package based on either an existing package or a new package is offered. 

Figure 11 : Choosing Between an Existing or New Package

From the next screen, it is possible to add or remove problems, incidents, and files.  This gives a simple GUI for customizing the package before generating it. 

Figure 12:  GUI for Package Customization

Once the package is satisfactory, the next step is to click on Finish Contents Preparation and generate the upload file.  If the package is chosen to be built on an existing package, there is the option to do an incremental generation.  Otherwise, the full package will have to be generated. 

Figure 13 : Package Generation

Once the package is created, external files can be added to the package.  In addition, selected files will modify or be removed.  From this view, it is also possible to view an activity log for the package that shows a history of the package's activity.

Figure 14: Activity Log View

The IPS functionality available from the Support Workbench is very similar to the interactive utility ADRCI.  As demonstrated, either ADRCI or OEM can be used to achieve the same objectives.  Regardless of personal preference, IPS provides a means to generate zip files that contain all the information necessary for Oracle to efficiently provide support for Service Requests when database issues arise.