Mir Sayeed Hassan – Oracle Blog

OEM 13.5C Installation stuck at 54% at Repository Configuration due to locked statistics in sysman schema

<OMS_HOME>/cfgtoollogs/cfgfw/CfmLogger.log
INFO: oracle.sysman.top.oms:Still Running...
INFO: oracle.sysman.top.oms:Still Running...

Read more..			

ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

The above error accour while creation of the table in database.

Create table statement

create table MIR.RELATION
(
ID VARCHAR2(255 char) not null primary key,
DESTINATION_ID VARCHAR2(255 char) not null,
SOURCE_ID VARCHAR2(255 char) not null,
);

Error...
Read more..

Cannot open the Pluggable DB due to ORA-65086: cannot open/close the pluggable database

Check the status of database

SQL> select instance_name, open_mode, version from V$database, v$instance;

INSTANCE_NAME    OPEN_MODE      VERSION
-----------------------------------------
ORA19c          READ WRITE    19.0.0.0.0

Perform the Unplug...
Read more..

Error occur while configuration of OEM 13c as installation failed with The referenced database doesn’t contain a valid management Repository.

This error is occur due to the database objects already created earlier which needs proper cleanup of the Repository Database before proceeding for the fresh of OEM installation.

Error occur while dropping tablespace as ORA-23515: materialized views and/or their indices exist in the tablespace

Drop the tablespace

SQL> drop tablespace MGMT_TABLESPACE including contents and datafiles;
drop tablespace MGMT_TABLESPACE including contents and datafiles
*
ERROR at line 1:
ORA-23515: materialized views and/or... 
Read more..			

Apply the latest DB RU Patch_19.19 (35042068) on Oracle Database 19C

Check the status of Database

SQL> select instance_name, version, open_mode from v$database, v$instance;

INSTANCE_NAME         VERSION      OPEN_MODE
---------------- ----------------- --------------------
oemswdb            19.0.0.0.0      READ WRITE

Verify the lastest...
Read more..