Category: Oracle

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-01900 to ORA-02100 ORA-01900: LOGFILE keyword expected Cause: keyword missing Action: supply missing keyword ORA-01901: ROLLBACK keyword expected Cause: keyword missing Action: supply missing keyword ORA-01902: SEGMENT keyword expected Cause: keyword missing Action: supply missing keyword ORA-01903: EVENTS keyword expected Cause: keyword missing Action: supply missing keyword ORA-01904: DATAFILE keyword expected Cause: keyword missing Action: supply…

Oracle 12c R2 Error Codes and Solution Suggestions from INS-35000 to INS-35500 INS-35011: E-mail address cannot be empty. Cause: E-mail address for database management using e-mail notifications was empty. Action: Specify an e-mail address for notification functions. INS-35012: Outgoing main (SMTP) server cannot be empty. Cause: The value for the outgoing main (SMTP) server is empty. You must…

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-01700 to ORA-01900 ORA-01702: a view is not appropriate here Cause: Among other possible causes, this message will be produced if an attempt was made to define an Editioning View over a view. Action: An Editioning View may only be created over a base table. ORA-01703: missing SYNONYM…

Oracle 12c R2 Error Codes and Solution Suggestions from INS-30001 to INS-32167 INS-30001: The string password is empty. Cause: The string password should not be empty. Action: Provide a non-empty password. INS-30002: The string password and string confirm password are not same. Cause: The string password and string confirm password should be the same. Action: Ensure that string password and string confirm password are the same. INS-30003: The string password length is too long. Cause: The string password length cannot…

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-01600 to ORA-01700 ORA-01600: at most one “string” in clause “string” of string Cause: The INIT.ORA parameter was mis-specified. Action: Correct the INIT.ORA parameter and restart the instance. ORA-01601: illegal bucket size in clause “string” of string Cause: The bucket size was invalid for this parameter. Action: Correct the INIT.ORA parameter and…

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-01500 to ORA-01600 ORA-01500: failure in getting date/time Cause: During create database or alter tablespace, there was a failure in getting the date and time. Action: Contact your customer support representative. ORA-01501: CREATE DATABASE failed Cause: An error occurred during create database Action: See accompanying errors. ORA-01502: index ‘string.string‘ or…

Oracle 12c R2 Error Codes and Solution Suggestions from INS-00001 to INS-21003 INS-00001: Unknown irrecoverable error Cause: No additional information available. Action: Refer to the logs or contact Oracle Support Services INS-00002: Unhandled exception Cause: No additional information available. Action: Refer to the logs or contact Oracle Support Services INS-00003: Application startup failed Cause: An unexpected error occured while loading…

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-01400 to ORA-01500 ORA-01400: cannot insert NULL into (string) Cause: An attempt was made to insert NULL into previously listed objects. Action: These objects cannot accept NULL values. ORA-01401: inserted value too large for column Cause: The value inserted was too large for the given column. Action: Do not insert…

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-01300 to ORA-01400 ORA-01300: writable database required for specified LogMiner options Cause: Options were specified which required the database to be writable. Action: Specify different options or open the database for write access. ORA-01301: error writing to file during flat file build Cause: Error writing to file during flat…

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-01200 to ORA-01300 ORA-01200: actual file size of string is smaller than correct size of string blocks Cause: The size of the file as returned by the operating system is smaller than the size of the file as indicated in the file header and the control file. Somehow the file has…