April, 2020

• 7 April

  ORA-00600: internal error code, arguments: [string], [string], [string], [string], [string], [string], [string], [string], [string], [string], [string], [string]

  

  Hi, The most horrible error is ORA-00600 in the Oracle database.

  Read More »
• 7 April

  ORA-00205: error in identifying control file, check alert log for more info

  

  Sometimes you can get ” ORA-00205: error in identifying control file check alert log for more info ” error.

  Read More »
• 7 April

  ORA-00018: maximum number of sessions exceeded

  

  Hi, Sometimes you can get ” ORA-00018: maximum number of sessions exceeded ” error.

  Read More »
• 7 April

  ORA-00001: unique constraint (string.string) violated

  

  Hi, Sometimes you can get ” ORA-00001: unique constraint (string.string) violated ” error.

  Read More »
• 5 April

  Oracle Database Error Message Codes and Their Description from ORA-00101 to ORA-00130

  

  ORA-00101: invalid specification for system parameter DISPATCHERS Cause: The syntax for the DISPATCHERS parameter is incorrect. Action: Refer to the manual for correct syntax.

  Read More »
• 4 April

  Oracle Database Error Message Codes and Their Description from ORA-00131 to ORA-00160

  

  ORA-00131: network protocol does not support registration ‘string’ Cause: The specified protocol does not support async notification. Action: Refer to the manual for information on supported network protocols.  

  Read More »
• 3 April

  How to Create and Stop Start a Database Service Using DBMS_SERVICE in Oracle Database

  

  Hi, I will explain How to Create and Stop Start a Database Service Using DBMS_SERVICE in Oracle Database in this post.

  Read More »
• 3 April

  ORA-16139: media recovery required

  

  Hi, Sometimes you can get  “ORA-16139: media recovery required  ” error.

  Read More »
• 3 April

  ORA-15221: ASM operation requires compatible.asm of string or higher

  

  Hi, Sometimes you can get  “ORA-15221: ASM operation requires compatible.asm of string or higher  ” error.

  Read More »
• 2 April

  ORA-14004: missing PARTITION keyword

  

  Hi, Sometimes you can get  “ORA-14004: missing PARTITION keyword  ” error.

  Read More »
• 2 April

  ORA-13011: value is out of range During Create a Spatial Index.

  

  Hi, Sometimes you can get  “ORA-13011: value is out of range ” error during create a spatial index.

  Read More »
• 2 April

  How to Change Existing Range Partitioned Table to Interval Partitioned Table and Interval Partitioned to Range Partitioned Table

  

  Hi, I will explain How to Change Existing Range Partitioned Table to Interval Partitioned Table and Interval Partitioned to Range Partitioned Table in this post.  

  Read More »
• 1 April

  Oracle Database Error Message Codes and Their Description from ORA-00071-ORA-00100

  

  ORA-00071: process number must be between 1 and string Cause: An invalid process number was specified. Action: Specify a valid process number.  

  Read More »
• 1 April

  Oracle Database Error Message Codes and Their Description from ORA-00041-ORA-00070

  

  ORA-00041: active time limit exceeded – session terminated Cause: The Resource Manager SWITCH_TIME limit was exceeded. Action: Reduce the complexity of the update or query, or contact your database administrator …

  Read More »
• 1 April

  Oracle Database Error Message Codes and Their Description from ORA-00000 to ORA-00040

  

  ORA-00000: normal, successful completion Cause: Normal exit. Action: None

  Read More »
• 1 April

  How to List and Analyze Partitions of Table Order by High Value Column in Oracle Database

  

  I will explain How to List and Analyze Table Partitions Order by High Value Column in Oracle Database in this post. let’s review the List and Analyze Table Partitions in …

  Read More »

March, 2020

• 29 March

  How to List and Monitor DBMS Jobs and Scheduler Jobs in Oracle Database

  

  I will explain How to List and Monitor DBMS Jobs and Scheduler Jobs in Oracle Database in this post.

  Read More »
• 28 March

  ORA-39511: Start of CRS resource for instance ‘223’ failed with error:[CRS-5702: Resource, ORA-32004 CRS-0223 During Full Exadata Database Startup

  

  Hi, When I startup any instance in the Full exadata, i got ” ORA-39511: Start of CRS resource for instance ‘223’ failed with error:[CRS-5702: Resource, ORA-32004 CRS-0223 ” errors.

  Read More »
• 27 March

  ORA-12842: Cursor invalidated during parallel execution on Exadata

  

  Hi, I got ORA-12842: Cursor invalidated during parallel execution error during parallel execution on Exadata.

  Read More »
• 26 March

  OPatch failed with error code 73 | Prerequisite check “CheckActiveFilesAndExecutables” failed During Opatch apply 30698487

  

  I got OPatch failed with error code 73 | Prerequisite check “CheckActiveFilesAndExecutables” failed During Opatch apply 30698487.

  Read More »
• 25 March

  OPatch failed with error code 73, The Central Inventory is corrupted and The oraInst.loc file specified is not valid Error Solution

  

  When I query the Patch details of Oracle, I got ” OPatch failed with error code 73 The Central Inventory is corrupted and The oraInst.loc file specified is not valid …

  Read More »
• 20 March

  ORA-31693 ORA-02354 ORA-01555 snapshot too old During Export backup via expdp

  

  Hi, I will explain how to solve ORA-31693 ORA-02354 ORA-01555 During Export backup error.

  Read More »
• 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 »