Error opening the PDB db as MAX_STRING_SIZE migration is incomplete for pluggable database PDB$SEED in Oracle 19C DB Check the database version SQL> select name, open_mode, version from v$database, v$instance; NAME OPEN_MODE VERSION ————————————– PEPTEST READ WRITE 19.0.0.0.0 Check the CDB & PDBS SQL>… 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..

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.

ORA-30032: The Suspended (Resumable) Statement has Timed Out in Oracle Database 11gR2(11.2.0.4) Issue: This issue was occur while doing a transaction in real-time database & it’s was hung for few seconds & get the error SQL> select instance_name, version, status, open_mode from V$database, v$instance; INSTANCE_NAME VERSION STATUS OPEN_MODE —————-… Read more..

ORA 01665 control file is not a standby control file This error occour while starting the recovery process on standby database. Check the status of database SQL> select instance_name,open_mode,status from V$instance, v$database; INSTANCE_NAME OPEN_MODE STATUS —————- ——————– ———— testdb-std1 MOUNTED MOUNTED SQL>… Read more..

ORA-04031: unable to allocate ** bytes of shared memory and could not startup the database This ORA error occur due the less shared memory allocated in shared pool. Start up database failed SQL> startup ORA-01012: not logged on Process ID: 0 Session ID: 0 Serial number: 0 Check the current available memory assign to this Read More