Database Administration (MOSC)

MOSC Banner

Mismatch between DBA_DIRECTORIES and DBA_OBJECTS

Seems directories ORACLE_OCM_CONFIG_DIR and ORACLE_OCM_CONFIG_DIR2 appear in dba_directories, but are missing in dba_objects (pdb)....

On Oracle OCI instance:


But also on premise environment running multitenant (oracle 19.x):

alter session set "_EXCLUDE_SEED_CDB_VIEW"=FALSE;

select directory_name, con_id from cdb_directories

minus

select OBJECT_NAME, con_id from cdb_objects where object_type = 'DIRECTORY';


DIRECTORY_NAME                                                            CON_ID

-------------------------------------------------------------------------------------------------------------------------------- ----------

ORACLE_OCM_CONFIG_DIR                                                           2

ORACLE_OCM_CONFIG_DIR2                                                          2


Btw. This does not happen on a single instance !

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center