components could not be shrunk as they were already at their minimum sizes.
解决： Do not set sga_target to a value below the current value without first shrinking the individual SGA components.
ORA-00828: specified value of shared_pool_reserved_size inconsistent with internal settings 原因： Unable to set shared_pool_reserved_size to specified value if sga_target set, either because the specified value is too small, or because it is too large for the current internal size of shared pool. More details can be found in the alert log.
解决： If possible, do not set shared_pool_reserved_size without setting shared_pool_size if sga_target set. Examine the alert log for information about current internal size of shared pool, and valid range of values for shared_pool_reserved_size.
ORA-00830: cannot set statistics_level to BASIC with auto-tune SGA enabled
原因： The user attempted to set statistics_level to BASIC with auto-tune SGA enabled which cannot be done because auto-tune SGA cannot work with statistics_level set to BASIC. 解决： Disable auto-tune SGA and try setting the statistics_level to BASIC again. ORA-00832: no streams pool created and cannot automatically create one
原因： A database feature which needs STREAMS SGA was being used, however, the streams_pool_size parameter was not defined and the value of db_cache_size was too small to permit an automatic transfer of SGA to the streams pool from the buffer cache. 解决： Please set the parameter streams_pool_size or set sga_target. ORA-00910: specified length too long for its datatype
原因： for datatypes CHAR and RAW, the length specified was > 2000; otherwise, the length specified was > 4000.
解决： use a shorter length or switch to a datatype permitting a longer length such as a VARCHAR2, LONG CHAR, or LONG RAW ORA-00911: invalid character
原因： identifiers may not start with any ASCII character other than letters and numbers. $#_ are also allowed after the first character. Identifiers enclosed by doublequotes may contain any character other than a doublequote. Alternative quotes (q\cannot use spaces, tabs, or carriage returns as delimiters. For all other contexts, consult the SQL Language Reference Manual.
解决： none
ORA-00912: input parameter too long
原因： one of your input strings was too long 解决： shorten the input parameter length ORA-00953: missing or invalid index name
原因： An index name of the form [
ORA-00956: missing or invalid auditing option
原因： AUDIT or NOAUDIT statement contains an invalid auditing option. 解决： Use a valid option.
ORA-00960: ambiguous column naming in select list
原因： A column name in the order-by list matches more than one select list columns. 解决： Remove duplicate column naming in select list.
第36页
ORA-00962: too many group-by / order-by expressions
原因： The group-by or order-by column list contain more than 1000 expressions. 解决： Use 1000 or less expressions in the group-by or order-by list. ORA-00964: table name not in FROM list
原因： The table name referred in the select list is not specified in the from list.
解决： Make sure the name is correctly specified and matches one of the names in the from list. ORA-00965: column aliases not allowed for \
原因： The statement is trying to alias the * expression in the select list which is not legal. 解决： Remove the alias.
ORA-00972: identifier is too long
原因： An identifier with more than 30 characters was specified. 解决： Specify at most 30 characters.
ORA-00976: LEVEL, PRIOR, or ROWNUM not allowed here
原因： LEVEL, PRIOR, or ROWNUM is being specified at illegal location. 解决： Remove LEVEL, PRIOR, or ROWNUM. ORA-00977: duplicate auditing option
原因： AUDIT or NOAUDIT statement specifies an option more than once
解决： Either use ALL with no other auditing options or make sure no option is listed more than once.
ORA-00981: cannot mix table and system auditing options
原因： Table and system-wide auditing options were specified in the same AUDIT or NOAUDIT statement.
解决： You must issue table and system options in separate statements. ORA-00983: cannot audit or noaudit SYS user actions
原因： An attempt was made to AUDIT or NOAUDIT SYS user actions. 解决： Execute the statement again with a valid user.
ORA-00991: only MAC privileges may be granted to procedures
原因： Object privileges or non-MAC system privileges were granted to the procedure. 解决： Only grant MAC privileges using the PROCEDURE clause. ORA-01002: fetch out of sequence
原因： This 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.
解决： 1) 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. ORA-01010: invalid OCI operation
原因： One 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)
第37页
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. 解决： For 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. ORA-01016: This function can be called only after a fetch 原因： Cursor in an invalid state.
解决： Make sure that the oci/upi function is called after fetch. ORA-01019: unable to allocate memory in the user side 原因： The user side memory allocator returned error.
解决： Increase the processes heap size or switch to the old set of calls. ORA-01022: database operation not supported in this configuration
原因： The attempted database operation does not conform to the user programming interface (UPI) for the two communicating ORACLE servers.
解决： You 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. ORA-01023: Cursor context not found (Invalid cursor number) 原因： The cursor number is not a valid open cursor. 解决： Make sure that the cursor is open. ORA-01025: UPI parameter out of range
原因： An integer parameter to a upi function is out of range.
解决： This usually indicates an error in a tool built on top of the oracle dbms. Report the error to your customer support representative.
ORA-01026: multiple buffers of size > 4000 in the bind list 原因： More than one long buffer in the bind list.
解决： Change the buffer size to be less than 4000 for the bind variable bound to a normal column.
ORA-01027: bind variables not allowed for data definition operations
原因： An attempt was made to use a bind variable in a SQL data definition operation. 解决： Such bind variables are not allowed. ORA-01028: internal two task error
原因： Received send long message but don\解决： Report as a bug.
ORA-01029: internal two task error
原因： Received a request to send the long again when there is no long 解决： Report as a bug
ORA-01030: SELECT ... INTO variable does not exist
第38页
原因： The SELECT... INTO specified in the bind call does not correspond to a variable in the SQL statement.
解决： If it is not possible to correct the statement, call customer support. ORA-01031: insufficient privileges
原因： An attempt was made to change the current username or password without the appropriate privilege. This error also occurs if attempting to install a database without the necessary operating system privileges. When Trusted Oracle is configure in DBMS MAC, this error may occur if the user was granted the necessary privilege at a higher label than the current login.
解决： Ask the database administrator to perform the operation or grant the required privileges. For Trusted Oracle users getting this error although granted the the appropriate privilege at a higher label, ask the database administrator to regrant the privilege at the appropriate label. ORA-01032: no such userid
原因： This is an internal error message related to Export/Import. 解决： Contact customer support.
ORA-01033: ORACLE initialization or shutdown in progress
原因： An attempt was made to log on while Oracle is being started up or shutdown. 解决： Wait a few minutes. Then retry the operation. ORA-01034: ORACLE not available
原因： Oracle 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.
解决： Refer 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.
ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilege
原因： Logins are disallowed because an instance started in restricted mode. Only users with RESTRICTED SESSION system privilege can log on.
解决： Request that Oracle be restarted without the restricted option or obtain the RESTRICTED SESSION system privilege.
ORA-01036: illegal variable name/number 原因： Unable to find bind context on user side
解决： Make sure that the variable being bound is in the sql statement. ORA-01037: maximum cursor memory exceeded
原因： Attempting to process a complex sql statement which consumed all available memory of the cursor.
解决： Simplify the complex sql statement.
ORA-01038: cannot write database file version string with ORACLE version string 原因： Attempting 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.
解决： Open 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.
第39页
ORA-01039: insufficient privileges on underlying objects of the view
原因： Attempting to explain plan on other people%underlying objects of the view.
解决： Get necessary privileges or do not perform the offending operation. ORA-01040: invalid character in password; logon denied
原因： There are multibyte characters in the password or some characters in the password are not in US7ASCII range.
解决： Resubmit password with valid characters.
ORA-01041: internal error. hostdef extension doesn\ 原因： Pointer to hstdef extension in hstdef is null. 解决： Report as a bug
ORA-01042: detaching a session with open cursors not allowed
原因： An attempt was made to detach a seesio n which had open cursors. 解决： Close all the cursors before detaching the session.
ORA-01043: user side memory corruption [string], [string], [string], [string] 原因： The application code corrupted some of the usr memory used by oracle 解决： Make sure that the application code is not overwriting memory.
ORA-01044: size string of buffer bound to variable exceeds maximum string
原因： An 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) 解决： Reduce buffer size.
ORA-01045: user string lacks CREATE SESSION privilege; logon denied
原因： A connect was attempted to a userid which does not have create session privilege. 解决： Grant the user CREATE SESSION privilege.
ORA-01048: Couldn\ 原因： The procedure user specified in deferred RPC doesn\
解决： Check to make sure that the procedure exists and is visible to the replication process. ORA-01049: Bind by name is not spupportted in streamed RPC 原因： A newer version of server is talking with this version requesting an operation not supported in this version. 解决： none
ORA-01051: deferred rpc buffer format invalid
原因： The deferred rpc data in sys.def$_call is corrupted. 解决： Contact your customer support representive.
ORA-01052: required destination LOG_ARCHIVE_DUPLEX_DEST is not specified
原因： A valid destination for parameter LOG_ARCHIVE_DUPLEX_DEST was not specified when parameter LOG_ARCHIVE_MIN_SUCCEED_DEST was set to two.
解决： Either specify a value for parameter LOG_ARCHIVE_DUPLEX_DEST, or reduce the value for parameter LOG_ARCHIVE_MIN_SUCCEED_DEST to one. ORA-01058: internal New Upi interface error
原因： Attempt to delete non existant hstdef extension. 解决： Report as a bug.
ORA-01059: parse expected before a bind or execute 原因： The client application attempted to bind a variable or execute a cursor opened in a PL/SQL
第40页