I got “ORA-27106: system pages not available to allocate memory” error in Oracle database during startup of instance on Exadata.   ORA-27106: system pages not available to allocate memory Details of error are as follows. [MSDB4]/home/oracle $ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Thu Sep 22 13:23:26 2022 Version 19.14.0.0.0 Copyright … The post ORA-27106: system pages not available to allocate memory appeared first on IT Tutorial ..read more

Dealing with database performance issues has to be a priority, regardless of the scope or scale of your server infrastructure. Of course, if you don’t know what to look for, you might not appreciate that performance is suboptimal in the first place. To avoid this scenario persists, here are some thoughts on how your database … The post 4 Common Indicators That Signal Database Performance Issues appeared first on IT Tutorial ..read more

I got “ORA-02449: unique/primary keys in table referenced by foreign keys During Drop Tablespace ” error in Oracle database.   ORA-02449: unique/primary keys in table referenced by foreign keys During Drop Tablespace Details of error are as follows. SQL> DROP TABLESPACE TBS_USERS INCLUDING CONTENTS AND DATAFILES DROP TABLESPACE TBS_USERS INCLUDING CONTENTS AND DATAFILES * ERROR … The post ORA-02449: unique/primary keys in table referenced by foreign keys During Drop Tablespace appeared first on IT Tutorial ..read more

I got “ORA-01136: specified size of file is less than original size of blocks | ORA-01110: data file ” error in Oracle database.   ORA-01136: specified size of file is less than original size of blocks | ORA-01110: data  Details of error are as follows. SQL> alter system set standby_file_management='MANUAL' scope=both; System altered. SQL> alter … The post ORA-01136: specified size of file is less than original size of blocks | ORA-01110: data file appeared first on IT Tutorial ..read more

I got ” OGG-02039 Failed to set logmining server parameter MAX_SGA_SIZE to value ” error in Oracle database.   OGG-02039 Failed to set logmining server parameter MAX_SGA_SIZE to value Details of error are as follows. OGG-02039 Failed to set logmining server parameter MAX_SGA_SIZE to value 1000       When starting the Extracts for the … The post OGG-02039 Failed to set logmining server parameter MAX_SGA_SIZE to value appeared first on IT Tutorial ..read more

I got “ORA-30013: undo tablespace ‘UNDOTBS’ is currently in use ” error in Oracle database.   ORA-30013: undo tablespace ‘UNDOTBS’ is currently in use Details of error are as follows. SQL> drop tablespace undotbs8 including contents and datafiles; drop tablespace undotbs1 including contents and datafiles * ERROR at line 1: ORA-30013: undo tablespace 'UNDOTBS8' is … The post ORA-30013: undo tablespace ‘UNDOTBS’ is currently in use appeared first on IT Tutorial ..read more

I got “ORA-16028: new db_recovery_file_dest causes less destinations than LOG_ARCHIVE_MIN_SUCCEED_DEST requires  | ORA-02097: parameter cannot be modified because specified value is invalid ” error in Oracle database.   ORA-16028: new db_recovery_file_dest causes less destinations than LOG_ARCHIVE_MIN_SUCCEED_DEST requires You are performing a Data Pump export (expdp), and it fails with the following errors. Details of error … The post ORA-16028: new db_recovery_file_dest causes less destinations than LOG_ARCHIVE_MIN_SUCCEED_DEST requires appeared first on IT Tutorial ..read more

I got “ORA-39078: unable to dequeue message for agent KUPC$ from queue ” error in Oracle database.   ORA-39078: unable to dequeue message for agent KUPC$ from queue You are performing a Data Pump export (expdp), and it fails with the following errors. Details of error are as follows. ORA-39029: worker 86 with process name … The post ORA-39078: unable to dequeue message for agent KUPC$ from queue appeared first on IT Tutorial ..read more

I got ” ORA-02097: parameter cannot be modified because specified value is invalid. ORA-04033: Insufficient memory to grow pool ” error in Oracle database.   ORA-21780: Maximum number of object durations exceeded Details of error are as follows. SQL> show parameter streams_pool_size NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ streams_pool_size big integer 15G SQL> SQL> alter … The post ORA-04033: Insufficient memory to grow pool appeared first on IT Tutorial ..read more

I got ” ORA-21780: Maximum number of object durations exceeded. ” error in Oracle database.   ORA-21780: Maximum number of object durations exceeded Details of error are as follows. 2022-03-27 20:21:25 ERROR OGG-00664 OCI Error ORA (status = 21780-ORA-21780: Maximum number of object durations exceeded. ORA-06512: at "SYS.DBMS_APPLY_ERROR", line 168 ORA-06512: at "SYS.DBMS_APPLY_ERROR", line 237 … The post ORA-21780: Maximum number of object durations exceeded appeared first on IT Tutorial ..read more