Importing a Workload External to Enterprise Manager

You can import a workload captured through the PL/SQL interface or through a different Enterprise Manager instance into Enterprise Manager to manage it as you would for a workload originally created within Enterprise Manager. The workload can be in the process of being captured, or the Capture can be completed and the workload stored on a file system. You can also preprocess and replay the workload as you would ordinarily do for a workload created within Enterprise Manager.

This feature is available for Cloud Control Database plug-in 12.1.0.5 and later releases.

To import a database workload external to Enterprise Manager:

  1. From the Database Replay page, click the Captured Workloads tab, then click Import in the toolbar.

    The Import Workload: Source page appears.

  2. Select one of the three choices available to import a captured workload, then click Next:

    • Import a completed captured workload from a directory in the file system

      This option typically applies for a workload created using an API, in which you now want to import it to Enterprise Manager for subsequent processing. In this case, Enterprise Manager may not even be managing the Capture database.

    • Import a completed captured workload from a database target

      In this case, Enterprise Manager is probably already managing the Capture database. The Capture could have been done on this database, or it could have been loaded in as would be the case for the option above.

    • Attach to a Capture running in a database target

      This option is similar to the option above, except this a Capture that is still in progress, rather than one that has already completed.

    The Import Workload: Database page appears.

  3. Click the search icon next to the Database Target field and select a database from the pop-up that appears.

    Note:

    The target version of the database loading the workload must be at least as high as the one you used to capture the workload. For instance, if you captured using Oracle Database 12x, the database you select to read the Capture must be at least version 12x.

    • The system now requests database and host credentials.

    • In the previous step, if you chose to import a completed captured workload from a directory in the file system, the system also requires a workload location.

    • A consolidated Replay has a different directory structure in which there are at least two capture directories. Consequently, if the workload directory contains a consolidated Replay, you need to enable the check box so that Enterprise Manager can be aware of the consolidated Replay during the import operation.

  4. Provide the requisite input for the step above, then click Next.

    The Import Workload: Workload page appears.

    • If you chose "Import a completed captured workload from a directory in the file system" in step 2, this page provides a Load Workload button.

    • If you chose “Import a completed captured workload from a database target" or “Attach to a Capture running in a database target" in step 2, this page provides a Discover Workload button.

  5. Click either Load Workload or Discover Workload, depending on which button is available in accordance with your selection in step 2.

    The system displays workloads, if found, in the Discovered Workloads table.

  6. Either click Next to load the workload, or select one of the workloads, then click Next to continue importing the workload.

    The Import Workload: Replay page appears only under the following conditions:

    • You chose "Import a completed captured workload from a directory in the file system" in step 2.

    • The workload contains one or more Replays.

  7. Optional: Select one or more Replays, if desired, provide a Replay Task Name, then click Next.

    The Import Workload: Review page appears.

  8. If everything appears as you have intended, click Submit.

    The Database Replay page reappears and displays a message stating that the job was submitted successfully. The Status column for your loaded or imported workload in the Captured Workload table will show In Progress.

    Tip:

    You can check on the job's progress by clicking on the captured workload name that you just submitted in the Review step. A Capture Summary page appears, and you can click the Database Replay Import Job link to see the progress of the job execution steps.