April, 2020

• 10 April

  ORA-00472: PMON process terminated with error

  

  Hi, Sometimes you can get ” ORA-00472: PMON process terminated with error ” error.

  Read More »
• 10 April

  ORA-00474: SMON process terminated with error

  

  Hi, Sometimes you can get ” ORA-00474: SMON process terminated with error ” error.

  Read More »
• 10 April

  ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

  

  Sometimes you can get ” ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired ” error.

  Read More »
• 8 April

  Oracle Database Error Message Codes and Their Description from ORA-00221 to ORA-00250

  

  ORA-00221: error on write to control file Cause: An error occurred when writing to one or more of the control files. Action: See accompanying messages.  

  Read More »
• 8 April

  CRS-4535 Cannot communicate with Cluster Ready Services with CRS-4530: Communications failure contacting Cluster Synchronization Services daemon and CRS-4534

  

  Hi, Sometimes you can get  “CRS-4535 Cannot communicate with Cluster Ready Services  ” error.

  Read More »
• 7 April

  Oracle Database Error Message Codes and Their Description from ORA-00161 to ORA-00220

  

  ORA-00161: transaction branch length string is illegal (maximum allowed string) Cause: An external transaction branch ID with a length either too large or 0 was passed in. Action: Report the …

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