My Oracle Support Banner

EM 13c: "Use OMF" Doesn't Show if "db_create_file_dest" Value is not Uppercase (Doc ID 3001372.1)

Last updated on JANUARY 30, 2024

Applies to:

Enterprise Manager for Oracle Database - Version 13.5.0.0.0 and later
Information in this document applies to any platform.

Symptoms

In EM console, trying to add a datafile for a target database doesn't show "Use OMF" option, i.e.

- From Target DB Home page => Administration => Data Files => Create
- Storage Type: Automatic Storage Management
- "Use OMF" Option does not show if db_create_file_dest value is not uppercase, this can be verified by running the following SQL Statement on the target DB:

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.