{"id":2052,"date":"2016-08-06T13:30:42","date_gmt":"2016-08-06T10:30:42","guid":{"rendered":"http:\/\/www.fatihacar.com\/blog\/?p=2052"},"modified":"2016-12-12T09:23:21","modified_gmt":"2016-12-12T06:23:21","slug":"oracle-12c-r2-error-codes-and-solution-suggestions-from-ora-00900-to-ora-01100","status":"publish","type":"post","link":"http:\/\/www.fatihacar.com\/blog\/oracle-12c-r2-error-codes-and-solution-suggestions-from-ora-00900-to-ora-01100\/","title":{"rendered":"Oracle 12c R2 Error Codes and Solution Suggestions from ORA-00900 to ORA-01100"},"content":{"rendered":"

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-00900 to ORA-01100<\/strong><\/p>\n

\n
<\/a> ORA-00910: specified length too long for its datatype<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0for datatypes CHAR and RAW, the length specified was > 2000; otherwise, the length specified was > 4000.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0use a shorter length or switch to a datatype permitting a longer length such as a VARCHAR2, LONG CHAR, or LONG RAW<\/span><\/span><\/p>\n

\n
<\/a> ORA-00911: invalid character<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The identifier name started with an ASCII character other than a letter or a number. After the first character of the identifier name, ASCII characters are allowed including “$”, “#” and “_”. Identifiers enclosed in double quotation marks may contain any character other than a double quotation. Alternate quotation marks (q’#…#’) cannot use spaces, tabs, or carriage returns as delimiters. For all other contexts, consult the SQL Language Reference Manual.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the Oracle identifier naming convention. If you are attempting to provide a password in the IDENTIFIED BY clause of a CREATE USER or ALTER USER statement, then it is recommended to always enclose the password in double quotation marks because characters other than the double quotation are then allowed.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00912: input parameter too long<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0one of your input strings was too long<\/span><\/span><\/p>\n

Action:<\/b>\u00a0shorten the input parameter length<\/span><\/span><\/p>\n

\n
<\/a> ORA-00956: missing or invalid auditing option<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0AUDIT or NOAUDIT statement contains an invalid auditing option.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use a valid option.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00957: duplicate column name<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-00958: missing CHECK keyword<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-00959: tablespace ‘string<\/i>‘ does not exist<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-00960: ambiguous column naming in select list<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A column name in the order-by list matches more than one select list columns.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove duplicate column naming in select list.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00961: bad datetime\/interval value<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-00962: too many group-by \/ order-by expressions<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The group-by or order-by column list contain more than 1000 expressions.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use 1000 or less expressions in the group-by or order-by list.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00963: unsupported interval type<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-00964: table name not in FROM list<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The table name referred in the select list is not specified in the from list.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Make sure the name is correctly specified and matches one of the names in the from list.<\/span><\/span>
\n<\/p>\n

\n
<\/a> ORA-00965: column aliases not allowed for ‘*’<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The statement is trying to alias the * expression in the select list which is not legal.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove the alias.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00966: missing TABLE keyword<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-00967: missing WHERE keyword<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-00968: missing INDEX keyword<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-00969: missing ON keyword<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-00970: missing WITH keyword<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-00971: missing SET keyword<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-00972: identifier is too long<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An identifier with more than 128 bytes was specified, or a password identifier longer than 30 bytes was specified.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify at most 128 bytes for identifiers, and at most 30 bytes for password identifiers.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00973: invalid row count estimate<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-00974: invalid PCTFREE value (percentage)<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-00975: date + date not allowed<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-00976: Specified pseudocolumn or operator not allowed here.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0LEVEL, PRIOR, ROWNUM, CONNECT_BY_ROOT, CONNECT_BY_ISLEAF or CONNECT_BY_ISCYCLE was specified at an illegal location.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove LEVEL, PRIOR, ROWNUM, CONNECT_BY_ROOT, CONNECT_BY_ISLEAF or CONNECT_BY_ISCYCLE.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00977: duplicate auditing option<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0AUDIT or NOAUDIT statement specifies an option more than once<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Either use ALL with no other auditing options or make sure no option is listed more than once.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00978: nested group function without GROUP BY<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-00979: not a GROUP BY expression<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-00980: synonym translation is no longer valid<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A synonym did not translate to a legal target object. This could happen for one of the following reasons: 1. The target schema does not exist. 2. The target object does not exist. 3. The synonym specifies an incorrect database link. 4. The synonym is not versioned but specifies a versioned target object.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Change the synonym definition so that the synonym points at a legal target object.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00981: cannot mix table and system auditing options<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Table and system-wide auditing options were specified in the same AUDIT or NOAUDIT statement.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0You must issue table and system options in separate statements.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00982: missing plus sign<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-00983: cannot audit or noaudit SYS user actions<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to AUDIT or NOAUDIT SYS user actions.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Execute the statement again with a valid user.<\/span><\/span><\/p>\n

\n
<\/a> ORA-00984: column not allowed here<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-00985: invalid program name<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-00986: missing or invalid group name(s)<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-00987: missing or invalid username(s)<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-00988: missing or invalid password(s)<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-00989: too many passwords for usernames given<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-00990: missing or invalid privilege<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-00991: only MAC privileges may be granted to procedures<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Object privileges or non-MAC system privileges were granted to the procedure.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Only grant MAC privileges using the PROCEDURE clause.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01002: fetch out of sequence<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0This error means that a fetch has been attempted from a cursor which is no longer valid. Note that a PL\/SQL cursor loop implicitly does fetches, and thus may also cause this error. There are a number of possible causes for this error, including: 1) Fetching from a cursor after the last row has been retrieved and the ORA-1403 error returned. 2) If the cursor has been opened with the FOR UPDATE clause, fetching after a COMMIT has been issued will return the error. 3) Rebinding any placeholders in the SQL statement, then issuing a fetch before reexecuting the statement.<\/span><\/span><\/p>\n

Action:<\/b>\u00a01) Do not issue a fetch statement after the last row has been retrieved – there are no more rows to fetch. 2) Do not issue a COMMIT inside a fetch loop for a cursor that has been opened FOR UPDATE. 3) Reexecute the statement after rebinding, then attempt to fetch again.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01003: no statement parsed<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01004: default username feature not supported; logon denied<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01005: null password given; logon denied<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01006: bind variable does not exist<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01007: variable not in select list<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01008: not all variables bound<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01009: missing mandatory parameter<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01010: invalid OCI operation<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0One of the following: 1) You attempted an invalid OCI operation. 2) You are using an Oracle client application linked with version 7.1 (or higher) libraries, the environment variable ORA_ENCRYPT_LOGIN is set to TRUE, and you attempted to connect to a version 7.0 (or lower) Oracle Server. 3) You are connected to a version 7.1 (or higher) Oracle Server, the initialization parameter DBLINK_ENCRYPT_LOGIN is set to TRUE, and you attempted to use a database link pointing to a version 7.0 (or lower) Oracle Server. 4) You are connected to a version 9.0.2(or higher) Oracle Server and you attempted to use a database link pointing to a version 9.0.1(or lower) Oracle Server for distributed autonomous transaction.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0For the above causes: 1) Do not use the invalid OCI operation. 2) If you do not wish to use encrypted connect passwords in your distributed database, set ORA_ENCRYPT_LOGIN to FALSE. If you wish to use encrypted connect passwords, you must upgrade all Oracle Servers to version 7.1 (or higher). 3) If you do not wish to use encrypted database links in your distributed database, set DBLINK_ENCRYPT_LOGIN to FALSE. If you wish to use encrypted database links, you must upgrade all Oracle Servers to version 7.1 (or higher). 4) Do not attempt distributed autonomous transaction on version 9.0.1(or lower) Oracle Server.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01016: This function can be called only after a fetch<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Cursor in an invalid state.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Make sure that the oci\/upi function is called after fetch.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01017: invalid username\/password; logon denied<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01018: column does not have a LONG datatype<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01019: unable to allocate memory in the user side<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The user side memory allocator returned error.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Increase the processes heap size or switch to the old set of calls.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01020: unknown context state<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01021: invalid context size specified<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01022: database operation not supported in this configuration<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The attempted database operation does not conform to the user programming interface (UPI) for the two communicating ORACLE servers.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0You may need to upgrade one or more of your ORACLE servers or re-link your user side application with new libraries. Report the problem to Worldwide Customer Support.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01023: Cursor context not found (Invalid cursor number)<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The cursor number is not a valid open cursor.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Make sure that the cursor is open.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01024: invalid datatype in OCI call<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01025: UPI parameter out of range<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An integer parameter to a upi function is out of range.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0This usually indicates an error in a tool built on top of the oracle dbms. Report the error to your customer support representative.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01026: multiple buffers of size > 4000 in the bind list<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0More than one long buffer in the bind list.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Change the buffer size to be less than 4000 for the bind variable bound to a normal column.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01027: bind variables not allowed for data definition operations<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to use a bind variable in a SQL data definition operation.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Such bind variables are not allowed.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01028: internal two task error<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Received send long message but don’t have the cursor context.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Report as a bug.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01029: internal two task error<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Received a request to send the long again when there is no long<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Report as a bug<\/span><\/span><\/p>\n

\n
<\/a> ORA-01030: SELECT … INTO variable does not exist<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The SELECT… INTO specified in the bind call does not correspond to a variable in the SQL statement.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0If it is not possible to correct the statement, call customer support.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01031: insufficient privileges<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to perform a database operation without the necessary privileges.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ask your database administrator or designated security administrator to grant you the necessary privileges<\/span><\/span><\/p>\n

\n
<\/a> ORA-01032: no such userid<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0This is an internal error message related to Export\/Import.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact customer support.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01033: ORACLE initialization or shutdown in progress<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to log on while Oracle is being started up or shutdown.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Wait a few minutes. Then retry the operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01034: ORACLE not available<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Oracle was not started up. Possible causes include the following: – The SGA requires more space than was allocated for it. – The operating-system variable pointing to the instance is improperly defined.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Refer to accompanying messages for possible causes and correct the problem mentioned in the other messages. If Oracle has been initialized, then on some operating systems, verify that Oracle was linked correctly. See the platform specific Oracle documentation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilege<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Logins are disallowed because an instance started in restricted mode. Only users with RESTRICTED SESSION system privilege can log on.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Request that Oracle be restarted without the restricted option or obtain the RESTRICTED SESSION system privilege.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01036: illegal variable name\/number<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Unable to find bind context on user side<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Make sure that the variable being bound is in the sql statement.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01037: maximum cursor memory exceeded<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Attempting to process a complex sql statement which consumed all available memory of the cursor.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Simplify the complex sql statement.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01038: cannot write database file version\u00a0string<\/i>\u00a0with ORACLE version\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Attempting to write datafile headers in an old format. The new format can not be used until after the database has been verified as being compatible with this software version.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Open the database to advance to the new file formats, then repeat the operation. If the operation is required before the database can be opened, then use the previous software release to do the operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01039: insufficient privileges on underlying objects of the view<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Attempting to explain plan on other people’s view without the necessary privileges on the underlying objects of the view.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Get necessary privileges or do not perform the offending operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01040: invalid character in password; logon denied<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0There are multibyte characters in the password or some characters in the password are not in US7ASCII range.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Resubmit password with valid characters.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01041: internal error. hostdef extension doesn’t exist<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Pointer to hstdef extension in hstdef is null.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Report as a bug<\/span><\/span><\/p>\n

\n
<\/a> ORA-01042: detaching a session with open cursors not allowed<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to detach a seesio n which had open cursors.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Close all the cursors before detaching the session.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01043: user side memory corruption [string<\/i>], [string<\/i>], [string<\/i>], [string<\/i>]<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The application code corrupted some of the usr memory used by oracle<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Make sure that the application code is not overwriting memory.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01044: size\u00a0string<\/i>\u00a0of buffer bound to variable exceeds maximum\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to bind a buffer whose total size would exceed the maximum size allowed. Total array size for arrays is calculated as: (element_size)*(number of elements)<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Reduce buffer size.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01045: user\u00a0string<\/i>\u00a0lacks CREATE SESSION privilege; logon denied<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A connect was attempted to a userid which does not have create session privilege.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Grant the user CREATE SESSION privilege.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01046: cannot acquire space to extend context area<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01047: The above error occurred in schema=string<\/i>, package=string<\/i>, procedure=string<\/i><\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01048: Couldn’t find the specified procedure in the given context<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The procedure user specified in deferred RPC doesn’t exist.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check to make sure that the procedure exists and is visible to the replication process.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01049: Bind by name is not spupportted in streamed RPC<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A newer version of server is talking with this version requesting an operation not supported in this version.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0n\/a<\/span><\/span><\/p>\n

\n
<\/a> ORA-01050: cannot acquire space to open context area<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01051: deferred rpc buffer format invalid<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The deferred rpc data in sys.def$_call is corrupted.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact your customer support representive.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01052: required destination LOG_ARCHIVE_DUPLEX_DEST is not specified<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A valid destination for parameter LOG_ARCHIVE_DUPLEX_DEST was not specified when parameter LOG_ARCHIVE_MIN_SUCCEED_DEST was set to two.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Either specify a value for parameter LOG_ARCHIVE_DUPLEX_DEST, or reduce the value for parameter LOG_ARCHIVE_MIN_SUCCEED_DEST to one.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01053: user storage address cannot be read<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01054: user storage address cannot be written<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01055: Object datatypes not supported for bind or define in this mode<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Bind or Define used for objects with an invalid mode<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Change the mode.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01057: invalid or ambiguous block.field reference in user exit<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01058: internal New Upi interface error<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Attempt to delete non existant hstdef extension.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Report as a bug.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01059: parse expected before a bind or execute<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The client application attempted to bind a variable or execute a cursor opened in a PL\/SQL block before the statement was parsed.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure the statement is parsed before a bind or execute.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01060: array binds or executes not allowed<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The client application attempted to bind an array of cursors or attempted to repeatedly execute against a PL\/SQL block with a bind variable of type cursor.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Bind a single cursor or execute the PL\/SQL block once.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01061: cannot start up a V8 server using a V7 client application<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0You are using an Oracle client application linked with version 7 (or lower) libraries and you attempted to start up a V8 (or higher) server.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use a client application linked with V8 (or higher) libraries.60<\/span><\/span><\/p>\n

\n
<\/a> ORA-01062: unable to allocate memory for define buffer<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Exceeded the maximum buffer size for current plaform<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use piecewise fetch with a smaller buffer size<\/span><\/span><\/p>\n

\n
<\/a> ORA-01063: fetch row count exceeds MINSWORDMAXVAL<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The total number of rows requested from the server exceeded the maximum specified in MINSWORDMAXVAL.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Fix the number of rows to fetch or prefetch for the fetch interface call.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01070: Using an old version of Oracle for the server<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Using pre 7.0.10.1 version of oracle for server<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Upgrade server to post 7.0.10.1 version<\/span><\/span><\/p>\n

\n
<\/a> ORA-01071: cannot perform operation without starting up ORACLE<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Obvious<\/span><\/span><\/p>\n

Action:<\/b>\u00a0n\/a<\/span><\/span><\/p>\n

\n
<\/a> ORA-01072: cannot stop ORACLE; ORACLE not running<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Obvious<\/span><\/span><\/p>\n

Action:<\/b>\u00a0n\/a<\/span><\/span><\/p>\n

\n
<\/a> ORA-01073: fatal connection error: unrecognized call type<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An illegal internal operation was attempted.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01074: cannot shut down ORACLE; inside a login session – log off first<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Obvious<\/span><\/span><\/p>\n

Action:<\/b>\u00a0n\/a<\/span><\/span><\/p>\n

\n
<\/a> ORA-01075: you are currently logged on<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Attempt to login while logged in.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0n\/a<\/span><\/span><\/p>\n

\n
<\/a> ORA-01076: multiple logons per process not yet supported<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Obvious<\/span><\/span><\/p>\n

Action:<\/b>\u00a0n\/a<\/span><\/span><\/p>\n

\n
<\/a> ORA-01077: background process initialization failure<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Failure during initialization of ORACLE background processes.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Further diagnostic information should be in the error stack or in the trace file.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01078: failure in processing system parameters<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Failure during processing of INIT.ORA parameters during system startup.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Further diagnostic information should be in the error stack.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01079: ORACLE database was not properly created, operation aborted<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0There was an error when the database or control file was created.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check what error was signaled when the database was first created or when the control file was recreated. Take appropriate actions to recreate the database or a new control file.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01080: error in shutting down ORACLE<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Failure during system shutdown.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Further diagnostic information should be in the error stack.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01081: cannot start already-running ORACLE – shut it down first<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Obvious<\/span><\/span><\/p>\n

Action:<\/b>\u00a0n\/a<\/span><\/span><\/p>\n

\n
<\/a> ORA-01082: ‘row_locking = always’ requires the transaction processing option<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0“row_locking = always” is specified in INIT.ORA file. This feature is not supported by ORACLE without the transaction processing option.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove it from INIT.ORA file or set it to “default” or “intent”.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01083: value of parameter “string<\/i>” is inconsistent with that of other instances<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The value of the given parameter is required to be the same for all instances in the cluster database configuration. ROW_LOCKING and SERIALIZABLE are 2 examples.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Change the value of the parameter in INIT.ORA file to match that of other cluster database instances.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01084: invalid argument in OCI call<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The failing OCI call contains an argument with an invalid value.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use valid argument values. For more information, see the Programmer’s Guide to the Oracle Call Interfaces and the appropriate programming language supplement.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01085: preceding errors in deferred rpc to “string<\/i>.string<\/i>.string<\/i>“<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Errors were encountered when the named procedure was executed as a deferred remoted procedure call.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the cause of the preceding errors.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01086: savepoint ‘string<\/i>‘ never established in this session or is invalid<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to roll back to a savepoint that was never established in this session, or was invalid.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Try rolling back to the savepoint from the session where it is established.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01087: cannot start up ORACLE – currently logged on<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01088: shutdown in progress – operation not permitted until restart<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The SHUTDOWN command was used to shut down a running Oracle instance but the shutdown operation was not complete.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Wait for the instance to be restarted or contact your database administrator.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01089: immediate shutdown or close in progress – no operations are permitted<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The SHUTDOWN IMMEDIATE command was used to shut down a running Oracle instance, or CLOSE IMMEDIATE was used to shut down a pluggable database, so your operations have been terminated.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Wait for the instance to be restarted, or contact your DBA.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01090: shutdown in progress – connection is not permitted<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The SHUTDOWN command was used to shut down a running ORACLE instance, so you cannot connect to ORACLE.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Wait for the instance to be restarted, or contact your DBA.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01091: failure during startup force<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Unable to destroy the old SGA.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Manually remove the old SGA and reissue the STARTUP command<\/span><\/span><\/p>\n

\n
<\/a> ORA-01092: ORACLE instance terminated. Disconnection forced<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The instance this process was connected to was terminated abnormally, probably via a shutdown abort. This process was forced to disconnect from the instance.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Examine the alert log for more details. When the instance has been restarted, retry action.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01093: ALTER DATABASE CLOSE only permitted with no sessions connected<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0There is at least one more session other than the current one logged into the instance. ALTER DATABASE CLOSE is not permitted.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Find the other sessions and log them out and resubmit the command<\/span><\/span><\/p>\n

\n
<\/a> ORA-01094: ALTER DATABASE or ALTER PLUGGABLE DATABASE CLOSE in progress. Connections not permitted<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01095: DML statement processed zero rows<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0During a call to OTEX, an update, delete, or insert statement being executed processed zero rows. The execution of statements by OTEX was halted at this point.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0n\/a<\/span><\/span><\/p>\n

\n
<\/a> ORA-01096: program version (string<\/i>) incompatible with instance (string<\/i>)<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A program is trying to connect to an instance using a different version of code than the database was started with. This is not allowed.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Either relink the program with the same version as the database or restart the database using the old version of code.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01097: cannot shutdown while in a transaction – commit or rollback first<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Obvious<\/span><\/span><\/p>\n

Action:<\/b>\u00a0n\/a<\/span><\/span><\/p>\n

\n
<\/a> ORA-01098: program Interface error during Long Insert<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01099: cannot mount database in SHARED mode if started in single process mode<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Obvious<\/span><\/span><\/p>\n

Action:<\/b>\u00a0n\/a<\/span><\/span><\/p>\n

\n
<\/a> ORA-01100: database already mounted<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A database is already mounted in this instance.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0n\/a<\/span><\/span><\/p>\n

\n
<\/dd>\n<\/dl>\n","protected":false},"excerpt":{"rendered":"

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-00900 to ORA-01100 ORA-00910: specified length too long for its datatype Cause:\u00a0for datatypes CHAR and RAW, the length specified was > 2000; otherwise, the length specified was > 4000. Action:\u00a0use a shorter length or switch to a datatype permitting a longer length such as a VARCHAR2,…<\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":true,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[53],"tags":[54],"class_list":["post-2052","post","type-post","status-publish","format-standard","hentry","category-oracle-errors-and-solutions","tag-oracle-error-solutions"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p39NFI-x6","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2052","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/comments?post=2052"}],"version-history":[{"count":2,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2052\/revisions"}],"predecessor-version":[{"id":2109,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2052\/revisions\/2109"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=2052"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=2052"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=2052"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}