April, 2021

• 26 April

  ORA-07445: Exception Encountered: Core Dump

  

  I got “ORA-07445: Exception Encountered: Core Dump ” error in Oracle database.

  Read More »
• 26 April

  ORA-01756: Quoted String Not Properly Terminated

  

  I got “ORA-01756: Quoted String Not Properly Terminated ” error in Oracle database.

  Read More »
• 25 April

  ORA-01078: failure in processing system parameters

  

  I got ” ORA-01078: failure in processing system parameters ” error in Oracle database.

  Read More »
• 25 April

  How to Add Node In Oracle RAC

  

  I will explain How to Add Node In Oracle RAC in this post.

  Read More »
• 25 April

  Oracle DBVERIFY ( DBV ) Utility | Restore Validate & Detect Corruption

  

  I will explain Oracle DBVERIFY ( DBV ) Utility in this post which Validate & Detect Corruption and Verify Oracle Files.

  Read More »
• 24 April

  ORA-00997: illegal use of LONG datatype

  

  I got ” ORA-00997: illegal use of LONG datatype ” error in Oracle database during create table as select * from ( CTAS )

  Read More »
• 24 April

  ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT

  

  I got ” ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT ” error in Oracle database during the export ( expdp ).

  Read More »
• 24 April

  ORA-10567: Redo is inconsistent with data block | ORA-00600 ORA-10564 ORA-01110 ORA-10560

  

  I got ” ORA-10567: Redo is inconsistent with data block | ORA-00600 ORA-10564 ORA-01110 ORA-10560 ” error in Oracle database during the MRP process shutdown in Standby Side.

  Read More »
• 24 April

  ORA-31637: cannot create job | ORA-31621

  

  I got ” ORA-31637: cannot create job | ORA-31621 ” error in Oracle database during the export ( expdp ) process.

  Read More »
• 24 April

  ORA-14404: partitioned table contains partitions in a different tablespace

  

  I got ” ORA-14404: partitioned table contains partitions in a different tablespace ” error in Oracle database during the drop tablespace.

  Read More »
• 24 April

  ORA-38884: Cannot shrink data file on standby database due to guaranteed restore points

  

  When you startup Oracle Database, you can get ” ORA-38884: Cannot shrink data file on standby database due to guaranteed restore points ” error.

  Read More »
• 24 April

  ORA-65500: could not modify DB_UNIQUE_NAME, resource exists

  

  I got “ORA-65500: could not modify DB_UNIQUE_NAME, resource exists ” error in Oracle database.

  Read More »
• 23 April

  ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated

  

  I got “ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated ” error in Oracle database.

  Read More »
• 23 April

  ORA-16191: Primary log shipping client not logged on standby

  

  I got ” ORA-16191: Primary log shipping client not logged on standby ” error in Oracle dataguard.

  Read More »
• 23 April

  GEN0 terminating the instance due to ORA error 15082 | ASMB is stuck

  

  I saw ” GEN0 terminating the instance due to ORA error 15082 | ASMB is stuck ” error in Oracle database alertlog during termination of database.

  Read More »
• 23 April

  ORA-19612: datafile not restored due to missing or corrupt data | ORA-19870

  

  I got ” ORA-19612: datafile not restored due to missing or corrupt data | ORA-19870  ” error in Oracle database during the RMAN Incremental backup and Merge into copy backup.

  Read More »

March, 2021

• 11 March

  ORA-27086: unable to lock file – already in use | ORA-31641 ORA-39000

  

  I got ” ORA-27086: unable to lock file – already in use | ORA-31641 ORA-39000  ” error in Oracle database during the expdp running.

  Read More »

February, 2021

• 26 February

  [INS-06006] Passwordless SSH connectivity not set up between the following node

  

  I got ” [INS-06006] Passwordless SSH connectivity not set up between the following node  ” error in Oracle database creation on Exadata.

  Read More »
• 25 February

  ORA-25153: Temporary Tablespace is Empty

  

  I got ” ORA-25153: Temporary Tablespace is Empty  ” error in Oracle database during export operation.

  Read More »
• 25 February

  ORA-16401: archive log rejected by Remote File Server (RFS)

  

  I got ” ORA-16401: archive log rejected by Remote File Server (RFS)  ” error in Oracle database during Dataguard ( Standby installation )

  Read More »
• 19 February

  ORA-16188 terminating the instance due to ORA error 16188 LOG_ARCHIVE_CONFIG

  

  I got ” ORA-16188 terminating the instance due to ORA error 16188 LOG_ARCHIVE_CONFIG  ” error in Oracle database during startup of any instance of RAC Database.

  Read More »
• 19 February

  CRS-2552: There are no available instances of resource

  

  I got ” CRS-2552: There are no available instances of resource ” error in Oracle database during Add instance to RAC Database.

  Read More »
• 19 February

  ORA-02429: cannot drop index used for enforcement of unique/primary key

  

  I got ” ORA-02429: cannot drop index used for enforcement of unique/primary key ” error in Oracle database during drop index.

  Read More »
• 11 February

  ORA-32593: database supplemental logging attributes in flux

  

  I got ” ORA-32593: database supplemental logging attributes in flux ” error in Oracle database during add supplemental log on Oracle database.

  Read More »

January, 2021

• 11 January

  ORA-32018: parameter cannot be modified in memory on another instance

  

  I got ” ORA-32018: parameter cannot be modified in memory on another instance ” error in Oracle database during parameter change on Oracle database.

  Read More »