Article Series

Get new content delivered directly to your inbox.

Follow My Blog

ORA-27106: system pages not available to allocate memory September 22, 2022

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 Copyrig […]

Mehmet Salih Deveci

4 Common Indicators That Signal Database Performance Issues June 30, 2022

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 Th […]

Kevin Kline

ORA-02449: unique/primary keys in table referenced by foreign keys During Drop Tablespace June 13, 2022

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 CONTENT […]

Mehmet Salih Deveci

ORA-01136: specified size of file is less than original size of blocks | ORA-01110: data file June 13, 2022

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> al […]

Mehmet Salih Deveci

OGG-02039 Failed to set logmining server parameter MAX_SGA_SIZE to value June 3, 2022

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 Fai […]

Mehmet Salih Deveci

Follow My Blog

Share this:

Like this: