Oracle 11g Error Codes and Solution Suggestions from ORA-00701 to ORA-00800 ORA-00701: object necessary for warmstarting database cannot be altered Cause: Attempt to alter or drop a database object (table, cluster, or index) which are needed for warmstarting the database. Action: None ORA-00702: bootstrap verison ‘string’ inconsistent with version ‘string’ Cause: The reading version of…
Tag: Oracle Error Solutions
Oracle 11g Error Codes and Solution Suggestions from ORA-00601 to ORA-00700
Oracle 11g Error Codes and Solution Suggestions from ORA-00601 to ORA-00700 ORA-00601: cleanup lock conflict Cause: PMON process runs into lock conflict trying to recovery processes Action: This is trapped internally, no action necessary ORA-00602: internal programming exception Cause: Internal programming exception Action: Report as bug ORA-00603: ORACLE server session terminated by fatal error Cause:…
Oracle 11g Error Codes and Solution Suggestions from ORA-00501 to ORA-00600
Oracle 11g Error Codes and Solution Suggestions from ORA-00501 to ORA-00600 ORA-00566: cannot request processor group – NUMA not enabled Cause: Cannot start process in a requested processor group when the NUMA feature is disabled. Action: Start the process without requesting a NUMA processor group. ORA-00567: Requested processor group string is too large (maximum string)…
Oracle 11g Error Codes and Solution Suggestions from ORA-00401 to ORA-00500
Oracle 11g Error Codes and Solution Suggestions from ORA-00401 to ORA-00500 ORA-00401: the value for parameter string is not supported by this release Cause: The value specified cannot be supported by this release of the software. Action: Choose an appropriate value, or remove the parameter value to use the default value. ORA-00402: database changes by…
Oracle 11g Error Codes and Solution Suggestions from ORA-00301 to ORA-00400
Oracle 11g Error Codes and Solution Suggestions from ORA-00301 to ORA-00400 ORA-00301: error in adding log file ‘string’ – file cannot be created Cause: The creation of the redo log file failed Action: Check: 1) there is enough storage space on the device 2) the name of the file is valid 3) the device is…
Oracle 11g Error Codes and Solution Suggestions from ORA-00201 to ORA-00300
Oracle 11g Error Codes and Solution Suggestions from ORA-00201 to ORA-00300 ORA-00201: control file version string incompatible with ORACLE version string Cause: The control file was created by incompatible software. Action: Either restart with a compatible software release or use CREATE CONTROLFILE to create a new control file that is compatible with this release. ORA-00202:…
Oracle 11g Error Codes and Solution Suggestions from ORA-00101 to ORA-00200
Oracle 11g Error Codes and Solution Suggestions from ORA-00101 to ORA-00200 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. ORA-00102: network protocol string cannot be used by dispatchers Cause: The network specified in DISPATCHERS does not have the functionality…
Oracle 11g Error Codes and Solution Suggestions from ORA-00000 to ORA-00100
Oracle 11g Error Codes and Solution Suggestions from ORA-00000 to ORA-00100 ORA-00000: normal, successful completion Cause: Normal exit. Action: None ORA-00001: unique constraint (string.string) violated Cause: An UPDATE or INSERT statement attempted to insert a duplicate key. For Trusted Oracle configured in DBMS MAC mode, you may see this message if a duplicate entry exists…
CRS-0184 Cannot Communicate With The Crs Daemon in Oracle
I got an error like CRS-0184 on Oracle 11g RAC system, because of interconnect network is down. After network was up, CRS Daemon did not start. You can take these errors like CRS-0184, CRS-2674, CRS-4534, CRS-4530.. I resolved that problem with below operations. CRS Stop and Start [root@node2 ~] cd $GRID_HOME/bin [root@node2 bin] ./crsctl stop…
ORA-03113: end-of-file on communication channel when startup
If your fra disk or archivelog directory full, your db can not process any transaction. When you increase disk size, database does not recover itself. You have to do some process. Error Solution