Posted by Mir Sayeed Hassan on 27th August 2023
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…
Posted in OEM (Oracle Enterprise Manager) | Comments Off on OEM 13.5C Installation stuck at 54% at Repository Configuration due to locked statistics in sysman schema
Posted by Mir Sayeed Hassan on 27th August 2023
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..
Posted in ORA-Error | Comments Off on ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
Posted by Mir Sayeed Hassan on 27th August 2023
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..
Posted in DBA Administration | Comments Off on Cannot open the Pluggable Database due to ORA-65086: cannot open/close the pluggable database
Posted by Mir Sayeed Hassan on 10th August 2023
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.
Posted in ORA-Error | Comments Off on Error occur while configuration of OEM 13c as installation failed with the referenced database doesn’t contain a valid management Repository
Posted by Mir Sayeed Hassan on 10th August 2023
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..
Posted in DBA Administration | Comments Off on Error occur while dropping tablespace as ORA-23515: materialized views and/or their indices exist in the tablespace