September, 2022

• 22 September

  ORA-27106: system pages not available to allocate memory

  

  I got “ORA-27106: system pages not available to allocate memory” error in Oracle database during startup of instance on Exadata.

  Read More »

June, 2022

• 13 June

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

  

  I got “ORA-02449: unique/primary keys in table referenced by foreign keys During Drop Tablespace ” error in Oracle database.

  Read More »
• 13 June

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

  

  I got “ORA-01136: specified size of file is less than original size of blocks | ORA-01110: data file ” error in Oracle database.

  Read More »
• 2 June

  ORA-30013: undo tablespace ‘UNDOTBS’ is currently in use

  

  I got “ORA-30013: undo tablespace ‘UNDOTBS’ is currently in use ” error in Oracle database.

  Read More »

May, 2022

• 25 May

  ORA-16028: new db_recovery_file_dest causes less destinations than LOG_ARCHIVE_MIN_SUCCEED_DEST requires

  

  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.

  Read More »
• 25 May

  ORA-39078: unable to dequeue message for agent KUPC$ from queue

  

  I got “ORA-39078: unable to dequeue message for agent KUPC$ from queue ” error in Oracle database.

  Read More »
• 24 May

  ORA-04033: Insufficient memory to grow pool

  

  I got ” ORA-02097: parameter cannot be modified because specified value is invalid. ORA-04033: Insufficient memory to grow pool ” error in Oracle database.

  Read More »
• 24 May

  ORA-21780: Maximum number of object durations exceeded

  

  I got ” ORA-21780: Maximum number of object durations exceeded. ” error in Oracle database.

  Read More »
• 24 May

  ORA-38753: Cannot flashback data file; no flashback log data.

  

  I got ” ORA-38753: Cannot flashback data file; no flashback log data. ” error in Oracle database.

  Read More »

April, 2022

• 21 April

  ORA-01668: standby database requires DROP option for offline of data file

  

  I got ” ORA-01668: standby database requires DROP option for offline of data file ” error in Oracle database.

  Read More »
• 21 April

  ORA-14086: a partitioned index may not be rebuilt as a whole

  

  I got ” ORA-14086: a partitioned index may not be rebuilt as a whole ” error in Oracle database.

  Read More »

February, 2022

• 8 February

  ORA-14137: Table in partially dropped state, submit DROP TABLE PURGE

  

  I got ” ORA-14137: Table in partially dropped state, submit DROP TABLE PURGE ” error in Oracle database.

  Read More »
• 8 February

  ORA-56935: existing datapump jobs are using a different version of time zone data file

  

  I got ” ORA-56935: existing datapump jobs are using a different version of time zone data file ” error in Oracle database.

  Read More »
• 8 February

  ORA-24001: cannot create QUEUE_TABLE, SYS.KUPC$DATAPUMP_QUETAB already exists

  

  I got ” ORA-24001: cannot create QUEUE_TABLE, SYS.KUPC$DATAPUMP_QUETAB already exists ” error in Oracle database.

  Read More »
• 8 February

  ORA-10635: Invalid segment or tablespace type

  

  I got ” ORA-10635: Invalid segment or tablespace type ” error in Oracle database.

  Read More »
• 7 February

  CRS-6706: Oracle Clusterware Release patch level (‘X’) does not match Software patch level (‘X’). Oracle Clusterware cannot be started.

  

  I got ” CRS-6706: Oracle Clusterware Release patch level (‘X’) does not match Software patch level (‘X’). Oracle Clusterware cannot be started. ” error When I apply the latest PSU …

  Read More »
• 5 February

  OPATCHAUTO-72043: Patch collection failed , Failed to create bundle patch object, Please verify the patch supplied.

  

  I got ” OPATCHAUTO-72043: Patch collection failed , Failed to create bundle patch object, Please verify the patch supplied. ” error When I apply the latest PSU of Oracle.

  Read More »
• 5 February

  failed to detect Grid Infrastructure setup due to null during Opatchauto apply

  

  I got ” failed to detect Grid Infrastructure setup due to null ” error in the Oracle during Opatchauto apply.

  Read More »
• 5 February

  ORA-10485: Real-Time Query cannot be enabled while applying migration redo

  

  I got ” ORA-10485: Real-Time Query cannot be enabled while applying migration redo ” error in the Oracle dataguard.

  Read More »

January, 2022

• 18 January

  ORA-14100: partition extended table name cannot refer to a remote object

  

  I got ” ORA-14100: partition extended table name cannot refer to a remote object ” error in the Oracle database when Select Partition of table using DBLink (  database link …

  Read More »

December, 2021

• 13 December

  Elements of a Good Developer Portal

  A developer portal can be defined as the interface standing between a set of SDKs, APIs, and other interactive tools and applications. The portal is responsible for helping organizations achieve …

  Read More »

November, 2021

• 30 November

  ORA-10459: cannot start media recovery on standby database; conflicting state detected

  

  I got ” ORA-10459: cannot start media recovery on standby database; conflicting state detected” error in the Oracle dataguard.

  Read More »
• 10 November

  ADR file lock wait event during RMAN L0 And L1 Backup

  

  I will explain ADR file lock wait event during RMAN L0 And L1 Backup in this post.

  Read More »
• 10 November

  The Best Tips for Choosing High-Quality IPTV services

  

  Before choosing the best iptv services for your system, it is essential to know what IPTV is and what it stands for. IPTV is the acronym of Internet Protocol Television. …

  Read More »
• 4 November

  OPATCHAUTO-72050: System instance creation failed | Failed while retrieving system information.

  I got ” OPATCHAUTO-72050: System instance creation failed | Failed while retrieving system information. ” error in the Oracle database.

  Read More »