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 »
• 3 October

  What is Index and Why Should We Use Index?

  

  Indexes are used to access data in the table faster.  A book is like a table of contents. When searching for a topic in the book, we can quickly find …

  Read More »
• 1 October

  Oracle Virtual Private Database (VPD) -2

  

  DBMS_RLS Package We use DBMS_RLS to create, modify, or delete security policies with VPD.  The DBMS_RLS.ADD_POLICY procedure allows us to create a VPD security policy. The definition of parameters used in …

  Read More »

September, 2019

• 29 September

  Oracle Virtual Private Database (VPD) – 1

  

  Virtual Private Database allows us to define constraints on tables and views based on row and column security policies. It should not be considered as a separate database because of the …

  Read More »
• 24 September

  Oracle Parameter Files – Spfile Usage

  

  Spfile The parameter file that it used to configure the instance when the database was opened. When the database is created, the spfile <ORACLE_SID> .ora file is created under the …

  Read More »
• 24 September

  Required Parameters For Oracle Database

  

  When the database is first created, there are some basic parameters that are most necessary. We can see these parameters with the following query, SQL> select name from v$parameter where …

  Read More »
• 22 September

  PasswordFile – orapwd utility in Oracle

  

  Hello everyone, in this tutorial we gonna examine PasswordFile – orapwd utility in Oracle. The password file is an optional file. It’s use has some advantages.

  Read More »
• 10 September

  ORA-27048: skgfifi: file header information is invalid ORA-19625: error identifying file in Oracle XTTS Convert Step

  

  Hi, When I use Oracle XTTS for Cross platform migration, I got ” ORA-27048: skgfifi: file header information is invalid ” error.

  Read More »
• 8 September

  Oracle SQL Developer Web

  

  Hi everyone, Today i will show you how to connect SQL Developer Web. Oracle SQL Developer allows database users and administrators to do their database tasks in fewer clicks and …

  Read More »
• 6 September

  What Is In-Memory?

  

  Hi everyone, Today i try to explain Oracle Database 12c In-Memory. In-Memory is a very important subject for Database and DWH. Oracle DB to store data in row format at …

  Read More »

August, 2019

• 16 August

  OCI Error !! – [Errno 12] Timeout on https://www.ksplice.com/yum/uptrack/ol/7Server/x86_64/repodata/repomd.xml:

  

  Hi friends, i want to explain OCI (Oracle Cloud Infrastructure yum problem and solution method. If you currently using Oracle Cloud, you should know basic Cloud Architecture. Oracle takes most …

  Read More »