Configuring Oracle Managed Files for a CDB Using EM Express

This section provides information on configuring Oracle Managed Files for a CDB.

Using Oracle Managed Files simplifies the administration of an Oracle Database. Oracle Managed Files eliminate the need for the DBA to directly manage the operating system files that comprise an Oracle Database. With Oracle Managed Files, you specify file system directories in which the database automatically creates, names, and manages files at the database object level.

Through initialization parameters, you specify the file system directory to be used for a particular type of file. The database then ensures that a unique file, an Oracle managed file, is created and deleted when no longer needed.

This feature does not affect the creation or naming of administrative files such as trace files, audit files, alert logs, and core files.

You can use EM Express to configure Oracle Managed Files for a CDB.

Note:

Before you configure Oracle Managed Files for a CDB:

  • A CDB must exist.

  • EM Express must be configured to manage the CDB.

To configure Oracle Managed Files for a CDB:

  1. In EM Express, navigate to the Containers page for the CDB for which you want to configure Oracle Managed Files.

    For more information, see "Accessing the Containers Page."

  2. Near the top of the Containers page, click the Configure Oracle-Managed Files button.

  3. The Configure Oracle-Managed Files wizard enables you to set a value (a directory location) for the DB_CREATE_FILE_DEST initialization parameter. The directory you specify will be the destination of Oracle Managed Files.

    Specify values for these fields in the Configure Oracle-Managed Files wizard:

    • Scope: Specify Memory to make the change in memory, take effect immediately, and persist until the database is shut down. Choose SPFile to make the change in the server parameter file, so that the change will take place after the database is restarted. Choose both Memory and SPFile to change the value now and to have it remain in effect after the database is restarted.

    • Deferred: If specified, the deferred option allows to modify the value of the parameter only for future sessions that connect to the database. With deferred, current sessions retain the old value. If deferred is not specified, the value is changed immediately.

    • Value: Specify the directory to use for the DB_CREATE_FILE_DEST initialization parameter. This directory will be the destination of Oracle Managed Files.

    • Comment: Optionally, enter a comment regarding the changes you made.

  4. Click OK.

    The Confirmation box advises you that the default directory for Oracle Managed Files has been set to the specified location. In the Status section of the Containers page, the Using Oracle-Managed Files field shows a value of Yes.

    See Also: