March, 2020

• 19 March

  How to Get DDL ( Create Script ) of any Object in Oracle Using DBMS_METADATA.GET_DDL

  

  I will explain How to Get DDL ( Create Script ) of any Object in Oracle Using DBMS_METADATA.GET_DDL in this article. Let’s go to review how to use Get DDL …

  Read More »
• 18 March

  ORA-016340: cannot drop a user that is currently connected

  

  Hi, You can get ” ORA-016340: cannot drop a user that is currently connected ” error during the drop any user.

  Read More »
• 18 March

  ORA-04021: timeout occurred while waiting to lock object during truncate table or alter table

  

  Hi, Sometimes you can get ” ORA-04021: timeout occurred while waiting to lock object  ” during truncate table or alter table.

  Read More »
• 16 March

  How to Drop and Recreate Temp Tablespace in Oracle Database

  

  Hi, I will explain How to Drop and Recreate Temp Tablespace in Oracle Database in this article.

  Read More »
• 16 March

  PRVG-1261 : Required Oracle patch “21255373” in home during Oracle 12c R2 (12.2.0.1.0) Grid Infrastructure Upgrade

  

  Hi, When I upgrade Grid Insfrastructure from Oracle 11g to Oracle 12c R2, I got ” PRVG-1261 : Required Oracle patch “21255373” in home ” error in the Install step.

  Read More »
• 16 March

  How to Upgrade Timezone ( DST ) Manually During Oracle 12c Upgrade

  

  Hi, I will explain How to Upgrade Timezone ( DST ) Manually During Oracle 12c  Upgrade.

  Read More »
• 13 March

  OGG-02028 Failed to attach to logmining server Error code 27144, error message: ORA-27144: attempt to kill process failed

  

  Hi, Goldengate Extract process is abended with ” OGG-02028 Failed to attach to logmining server Error code 27144, error message: ORA-27144: attempt to kill process failed ” error.

  Read More »
• 10 March

  How to Delete or Purge Audit Trail Table and Records ( Purge sys.aud$ table ) in Oracle Database

  

  Hi, I will explain How to Delete or Purge Audit Trail Table and Records in Oracle Database in this article.

  Read More »
• 3 March

  ORA-08103: object no longer exists and ORA-12801: error signaled in parallel query server During Parallel Execution on Exadata

  

  Hi, When I run the SQL as parallel execution using Parallel hint, I got ” ORA-08103: object no longer exists ” error.

  Read More »
• 2 March

  ORA-14508: specified VALIDATE INTO table not found

  

  Hi, When I analyze any table, i got ” ORA-14508: specified VALIDATE INTO table not found” error.

  Read More »

February, 2020

• 28 February

  ORA-00059: maximum no. of DB_FILES exceeded

  

  ORA-00059: maximum number of DB_FILES exceeded   While adding a new datafile to tablespace, I got the ” ORA-00059: maximum no. of DB_FILES exceeded ” error, then I checked db_files …

  Read More »
• 17 February

  ORA-01000 maximum open cursors exceeded

  

  Hi, You can get ” ora-01000 maximum open cursors exceeded ” error during the database operation.

  Read More »
• 12 February

  Determining the Optimal Oracle Undo Retention Period

  

  To determine the optimal value for the UNDO_RETENTION parameter, you must first calculate the actual amount of undo that the database is generating. Once you know approximately how much undo …

  Read More »

January, 2020

• 31 January

  ORA-15032: not all alterations performed ORA-15031 ORA-15025 ORA-27041 ORA-15014 | Add Disks to ASM Disk Group in Oracle

  

  Hi, When you add disks to the ASM Disk group, you can get ” ORA-15032 ORA-15031 ORA-15025 ORA-27041 ” errors.

  Read More »
• 27 January

  ORA-00257: archiver error. connect as sysdba only until resolved

  

  Sometimes you can get ” ora-00257: archiver error. connect as sysdba only until resolved  ” error, while connecting to Oracle database.

  Read More »
• 24 January

  ORA-29913: error in executing ODCIEXTTABLEPOPULATE callout and ORA-31693 ORA-31617 ORA-19505 ORA-27037 Oracle Error Solution

  

  Hi, When you start an export operation, you can get “ORA-31693 ORA-29913 ORA-31617  ORA-19505 ORA-27037 ” errors.

  Read More »
• 24 January

  ORA-01950: no privileges on tablespace | How to Solve ORA-01950 Oracle Error during Insert

  

  Hi, When your new user is created, you can get ” ORA-01950: no privileges on tablespace ” error during Insert operation.

  Read More »
• 10 January

  ORA-56920: a prepare or upgrade window or an on-demand or datapump-job loading of a secondary time zone data file is in an active state

  

  Hi, When you import any dump exported from old version Oracle database, you can get “ORA-56920: a prepare or upgrade window or an on-demand or datapump-job loading of a secondary …

  Read More »
• 6 January

  How to deal with In-database row archiving oracle 12c

  Suppose that we have a table of 10 rows in which only the first 5 rows are used / required by the application team. As a DBA, we can decide …

  Read More »

December, 2019

• 29 December

  How do you connect to an oracle database with os authentication linux

  Let’s say we want to create a database user who logs in with their OS account. To do so, we will use the “external authentication” option offered by oracle. Check the …

  Read More »
• 18 December

  ORA-64307: Exadata Hybrid Columnar Compression is not supported for tablespaces on this storage type

  

  Hi, When you export tables on Exadata and import them on Non Exadata database, you can get ” ORA-64307: Exadata Hybrid Columnar Compression is not supported for tablespaces on this storage …

  Read More »
• 1 December

  Lifetime Support Commitments And Plans

    Oracle Database Versions Databases must be upgraded for oracle support. Oracle Support For Major Version: Oracle Support For Patch Status: Doc:Oracle

  Read More »

October, 2019

• 16 October

  Defining VPD (Virtual Private Database) Policy Groups -3

  

  When a VPD is defined on a table, all VPD definitions are passed to AND.  This means that all VPD definitions apply. Before this article you should look the previously …

  Read More »
• 10 October

  Oracle XTTS Restore Step Failed : Error in executing xttstartupnomount.sql

  

  Hi, When I run Restore step for Oracle XTTS V4, i got ”  Error in executing xttstartupnomount.sql ” absurd error.

  Read More »
• 6 October

  Managing Online Redo Log Files

  

  Online redo log files are files that hold transaction records in the database. Log files to recover the database in case of a problem. For example, if we shut down the …

  Read More »