Most Common Oracle Errors with Solution

Error Code	ORA-00001
Error Message	ORA-00001: unique constraint (constraint_name) violated
Error Reason	An INSERT or UPDATE statement execution which violating the unique key constraint on the Table
Error Resolution	1)Drop The unique Constraint
	2)Allow duplicates by droping the constraint
Error Code	ORA-00054
Error Message	ORA-00054: resource busy and acquire with NOWAIT specified
Error Reason	An insert or update or select command against a LOCK Table
Error Resolution	1)Try to execute the statment after sometime
	2)Execute the command with a NOWAIT commands
Error Code	ORA-00257
Error Message	ORA-00257: archiver is stuck. CONNECT INTERNAL only, until freed
Error Reason	Error occurs at the archival of the redo logs
Error Resolution	1)Check the storage space availabilty
	2)Check the initialization paramter ARCHIVE_LOG_DEST
Error Code	ORA-00600
Error Message	ORA-00600
Error Reason	Internal Error generated by generic kernal code of the Oracle Software
Error Resolution	Should be reported to oracle support
Error Code	ORA-12154
Error Message	ORA-12154: TNS:could not resolve service name
Error Reason	This error occurs due to missing tnsnames.ora file or tnsname.ora file not configured properly .
Error Resolution	Reconfigure the tnsname.ora
Error Code	ORA-03113
Error Description	ORA-03113: end-of-file on communication channel
Error -Reason	An unexpected end of file occured During communication
Error Resolution	1)Check the network may be the network went down
	2)check the server may be the server down
Error Code	ORA-00936
Error Description	ORA-00936: missing expression
Error -Reason	missing sysntax when executing SQL statments
Error Resolution	1) Check your statement sytax properly
Error Code	ORA-01017
Error Description	ORA-01017: invalid username/password; logon denied
Error -Reason	Login activity uisng worng database credentials
Error Resolution	1) Enter the login credentials properly
Error Code	ORA-01555
Error Description	ORA-01555: snapshot too old (rollback segment too small)
Error -Reason	Insufficient Rollback segments
Error Resolution	1) Make larger rollback segments
Error Code	ORA-04031
Error Description	ORA-04031: unable to allocate num bytes of shared memory
Error -Reason	More usage of shared memory than availabe
Error Resolution	1. Reduce the use of shared memory availabe.
	2. Increase the SHARED_POOL_SIZE paramter
Error Code	ORA-01031
Error Description	ORA-01031: insufficient privileges
Error -Reason	Due to the lack of the privileges for the login user to thedatabase objects
Error Resolution	Contact the Oracle DBA for accessing privilages
Error Code	ORA-01000
Error Description	ORA-01000: maximum open cursors exceeded
Error -Reason	Each user is restricted in using the number of cursors at a time . You may get this error when your cursor limit exeeds the set parameter
Error Resolution	shut down Oracle database , increase the OPEN_CURSORS parameter in the initialization file, and restart Oracle database .
Error Code	ORA-12560
Error Description	ORA-12560: TNS:protocol adapter error
Error -Reason	This is an error related to the protocol adaptor
Error Resolution	Check the Protcol specification
Error Code	ORA-27101
Error Description	ORA-27101: shared memory realm does not exist
Error -Reason	Unable to locate the shared memory realm
Error Resolution	Make sure that ORACLE_SID and ORACLE_HOME are correct.
	A tralling slash on the ORACLE_HOME can cause error
	ORACLE_HOME=’/home/oracle/prod’ —- Correct
	ORACLE_HOME=’/home/oracle/prod/’ —-Wrong
Error Code	ORA-04030
Error Description	ORA-04030: out of process memory
Error -Reason	This is a common error while running import . This error is related to RAM settings. If the server having low RAM and memeory parameters are configured with a high configuration causes this error
Error Resolution	The best solution is to increase the RAM of the server if your server running with a low RAM other option is to Increase pga_aggregate_target
Error Code	ORA-00020
Error Description	ORA-00020: maximum number of processes (%s) exceeded
Error -Reason	Maximum number of processes are exceeded than the limit in oracle database
Error Resolution	Login as SYSDBA and kill the unwanted sessions
Error Code	ORA-04030
Error Description	ORA-04030: out of process memory
Error -Reason	This is a common error while running import . This error is related to RAM settings. If the server having low RAM and memeory parameters are configured with a high configuration causes this error
Error Resolution	The best solution is to increase the RAM of the server if your server running with a low RAM other option is to Increase pga_aggregate_target
Error Code	ORA-04030
Error Description	ORA-04030: out of process memory
Error -Reason	This is a common error while running import . This error is related to RAM settings. If the server having low RAM and memeory parameters are configured with a high configuration causes this error
Error Resolution	The best solution is to increase the RAM of the server if your server running with a low RAM other option is to Increase pga_aggregate_target