December, 2020

• 16 December

  RMAN-06169: could not read file header | RMAN-06056: could not access datafile

  

  I got ” RMAN-06169: could not read file header | RMAN-06056: could not access datafile ” error in Oracle database.

  Read More »
• 16 December

  ORA-12906: cannot drop default temporary tablespace

  

  I got ” ORA-12906: cannot drop default temporary tablespace ” error in Oracle database.

  Read More »
• 16 December

  ORA-15001: diskgroup “DATA” does not exist or is not mounted | ORA-15018 ORA-15001 RMAN-06956

  

  I got ” ORA-15001: diskgroup “DATA” does not exist or is not mounted | ORA-15018 ORA-15001 RMAN-06956 ” error in Oracle database.

  Read More »
• 16 December

  dbms_lock.sleep Grant Execute Privilege in Oracle

  

  I will explain dbms_lock.sleep Grant Execute Privilege in Oracle in this post.

  Read More »
• 16 December

  MRP0: Background Media Recovery terminated with error 1274 | ORA-01274: cannot add data file

  

  I got ” MRP0: Background Media Recovery terminated with error 1274 after adding a Datafile ” error in Oracle dataguard ( Standby Site ).

  Read More »
• 15 December

  RMAN-06571: datafile 1 does not have recoverable copy

  

  I got ” RMAN-06571: datafile 1 does not have recoverable copy ” error in Oracle database during restore database.

  Read More »
• 15 December

  ORA-01167: two files are the same file | ORA-01503: CREATE CONTROLFILE failed

  

  I got ” ORA-01167: two files are the same file | ORA-01503: CREATE CONTROLFILE failed ” error in Oracle database during controlfile creation.

  Read More »
• 15 December

  ORA-01678: parameter db_file_name_convert must be pairs of pattern and replacement strings

  

  I got ” ORA-01678: parameter db_file_name_convert must be pairs of pattern and replacement strings ” error in Oracle database.

  Read More »
• 15 December

  ORA-07217: sltln: environment variable cannot be evaluated

  

  I got ” ORA-07217: sltln: environment variable cannot be evaluated ” error in Oracle database during catalog files.

  Read More »
• 15 December

  ORA-14060: data type or length of a table partitioning column may not be changed

  

  I got ” ORA-14060: data type or length of a table partitioning column may not be changed ” error in Oracle database during startup 2 nodes Oracle RAC.

  Read More »
• 15 December

  ORA-39046: Metadata remap REMAP_TABLESPACE has already been specified.

  

  I got ” ORA-39046: Metadata remap REMAP_TABLESPACE has already been specified ” error in Oracle database during startup 2 nodes Oracle RAC.

  Read More »
• 13 December

  ORA-01617: cannot mount: 2 is not a valid thread number

  

  I got ” ORA-01617: cannot mount: 2 is not a valid thread number ” error in Oracle database during startup 2 nodes Oracle RAC.

  Read More »
• 12 December

  Oracle 21c is Available and Oracle 21c New Features

  

  I will explain Oracle 21c is Available and Oracle 21c New Features in this post. Let’s review the Oracle 21c New Features .  

  Read More »

November, 2020

• 30 November

  DDL_LOCK_TIMEOUT Parameter Usage to Avoid ORA-00054: resource busy error

  

  I will explain the DDL_LOCK_TIMEOUT Parameter Usage to Avoid ORA-00054: resource busy error in this post. let’s review the DDL_LOCK_TIMEOUT Parameter | ORA-00054: resource busy error.

  Read More »
• 30 November

  ORA-12990: duplicate option specified

  

  I got ” ORA-12990: duplicate option specified ” error in Oracle database during import ( impdp ).

  Read More »
• 30 November

  ORA-14639: SUBPARTITIONS clause can be specfied only for Hash Composite Range Hash table/partition

  

  I got ” ORA-14639: SUBPARTITIONS clause can be specfied only for Hash Composite Range Hash table/partition ” error in Oracle database during table creation.

  Read More »
• 30 November

  ORA-19511: non RMAN but media manager or vendor specific failure error text | ORA-27029 | ORA-19507

  

  I got ” ORA-19511: non RMAN but media manager or vendor specific failure error text | ORA-27029 | ORA-19507 ” error in Oracle database during Database Restore.

  Read More »
• 30 November

  ORA-64308: hybrid columnar compressed table cannot have column with LONG data type

  

  I got ” ORA-64308: hybrid columnar compressed table cannot have column with LONG data type” error in Oracle database during table creation.

  Read More »
• 30 November

  ORA-01466: unable to read data – table definition has changed

  

  I got ” ORA-01466: unable to read data – table definition has changed ” error in Oracle database during impdp.

  Read More »
• 20 November

  ORA-13841: SQL profile named already exists for a different signature/category pair

  

  I got ” ORA-13841: SQL profile named already exists for a different signature/category pair” error in Oracle database.

  Read More »
• 20 November

  ORA-14511: cannot perform operation on a partitioned object

  

  I got ” ORA-14511: cannot perform operation on a partitioned object” error in Oracle database.

  Read More »
• 13 November

  ORA-12516 TNS:listener could not find available handler with matching protocol stack

  

  Sometimes You can get ” ORA-12516 TNS:listener could not find available handler with matching protocol stack  ” error.

  Read More »
• 10 November

  ORA-01427: Subquery returns more than one row

  

  When you run a SQL Statement with Subquery, you can get ” ORA-01427: Subquery returns more than one row ” error.

  Read More »
• 6 November

  Benefits of having a tool to monitor your SQL server

  

  Effective, persistent monitoring of your SQL server is essential, but unless you understand the reasons behind this, you might not be adequately concerned with fulfilling your maintenance duties. To remedy …

  Read More »
• 5 November

  ORA-12899: value too large for column, KUP-11007: conversion error loading table

  

  When you start an import operation, you can get ” ORA-12899: value too large for column, KUP-11007: conversion error loading table ” errors.

  Read More »