block before the statement was parsed.
解决： Ensure the statement is parsed before a bind or execute. ORA-01060: array binds or executes not allowed
原因： The 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. 解决： Bind a single cursor or execute the PL/SQL block once.
ORA-01061: cannot start up a V8 server using a V7 client application
原因： You are using an Oracle client application linked with version 7 (or lower) libraries and you attempted to start up a V8 (or higher) server.
解决： Use a client application linked with V8 (or higher) libraries.60 ORA-01062: unable to allocate memory for define buffer
原因： Exceeded the maximum buffer size for current plaform 解决： Use piecewise fetch with a smaller buffer size ORA-01070: Using an old version of Oracle for the server 原因： Using pre 7.0.10.1 version of oracle for server 解决： Upgrade server to post 7.0.10.1 version
ORA-01071: cannot perform operation without starting up ORACLE 原因： Obvious 解决： none
ORA-01072: cannot stop ORACLE; ORACLE not running 原因： Obvious 解决： none
ORA-01073: fatal connection error: unrecognized call type 原因： An illegal internal operation was attempted. 解决： Contact your customer support representative.
ORA-01074: cannot shut down ORACLE; inside a login session - log off first 原因： Obvious 解决： none
ORA-01075: you are currently logged on 原因： Attempt to login while logged in. 解决： none
ORA-01076: multiple logons per process not yet supported 原因： Obvious 解决： none
ORA-01077: background process initialization failure
原因： Failure during initialization of ORACLE background processes.
解决： Further diagnostic information should be in the error stack or in the trace file. ORA-01078: failure in processing system parameters
原因： Failure during processing of INIT.ORA parameters during system startup. 解决： Further diagnostic information should be in the error stack.
ORA-01079: ORACLE database was not properly created, operation aborted 原因： There was an error when the database or control file was created. 解决： s to recreate the database or a new control file. ORA-01080: error in shutting down ORACLE
第41页
原因： Failure during system shutdown.
解决： Further diagnostic information should be in the error stack. ORA-01081: cannot start already-running ORACLE - shut it down first 原因： Obvious 解决： none
ORA-01082: \
原因： \ORACLE without the transaction processing option.
解决： Remove it from INIT.ORA file or set it to \
ORA-01083: value of parameter \
原因： The 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. 解决： Change the value of the parameter in INIT.ORA file to match that of other cluster database instances.
ORA-01084: invalid argument in OCI call
原因： The failing OCI call contains an argument with an invalid value.
解决： Use valid argument values. For more information, see the Programmer\Guide to the Oracle Call Interfaces and the appropriate programming language supplement. ORA-01085: preceding errors in deferred rpc to \
原因： Errors were encountered when the named procedure was executed as a deferred remoted procedure call.
解决： Correct the cause of the preceding errors. ORA-01086: savepoint \
原因： Trying to roll back to a save point that was never established. 解决： none
ORA-01088: cannot shut down ORACLE while active processes exist 原因： Users are still logged into the instance.
解决： Either wait for all users to logoff or use SHUTDOWN IMMEDIATE. ORA-01089: immediate shutdown in progress - no operations are permitted
原因： The SHUTDOWN IMMEDIATE command was used to shut down a running ORACLE instance, so your operations have been terminated.
解决： Wait for the instance to be restarted, or contact your DBA. ORA-01090: shutdown in progress - connection is not permitted
原因： The SHUTDOWN command was used to shut down a running ORACLE instance, so you cannot connect to ORACLE.
解决： Wait for the instance to be restarted, or contact your DBA. ORA-01091: failure during startup force 原因： Unable to destroy the old SGA.
解决： Manually remove the old SGA and reissue the STARTUP command ORA-01092: ORACLE instance terminated. Disconnection forced
原因： The instance this process was connected to was terminated abnormally, probably via a shutdown abort. This process was forced to disconnect from the instance.
解决： Examine the alert log for more details. When the instance has been restarted, retry action. ORA-01093: ALTER DATABASE CLOSE only permitted with no sessions connected
第42页
原因： There is at least one more session other than the current one logged into the instance. ALTER DATABASE CLOSE is not permitted.
解决： Find the other sessions and log them out and resubmit the command ORA-01095: DML statement processed zero rows
原因： During 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. 解决： none
ORA-01096: program version (string) incompatible with instance (string)
原因： A program is trying to connect to an instance using a different version of code than the database was started with. This is not allowed.
解决： Either relink the program with the same version as the database or restart the database using the old version of code.
ORA-01097: cannot shutdown while in a transaction - commit or rollback first 原因： Obvious 解决： none
ORA-01099: cannot mount database in SHARED mode if started in single process mode 原因： Obvious 解决： none
ORA-01100: database already mounted
原因： A database is already mounted in this instance. 解决： none
ORA-01101: database being created currently mounted by some other instance
原因： Some other instance has the database of same name currently mounted and you are trying to create it.
解决： Either change the database name or shutdown the other instance. ORA-01102: cannot mount database in EXCLUSIVE mode
原因： Some other instance has the database mounted exclusive or shared. 解决： Shutdown other instance or mount in a compatible mode. ORA-01103: database name \
原因： The database name in the control file does not match your database name. 解决： Either find the correct control file or change your database name. ORA-01104: number of control files (string) does not equal string 原因： The number of control files used by this instance disagrees with the number of control files in an existing instance.
解决： Check to make sure that all control files are listed.
ORA-01105: mount is incompatible with mounts by other instances
原因： An attempt to mount the database discovered that another instance mounted a database by the same name, but the mount is not compatible. Additional errors are reported explaining why. 解决： See accompanying errors.
ORA-01106: database must be closed before dismounting 原因： Obvious 解决： none
ORA-01107: database must be mounted for media recovery
原因： An attempt to perform media recovery was made but the database is not mounted.
第43页
解决： Mount the database.
ORA-01108: file string is in backup or media recovery
原因： Either media recovery is actively being applied to the file, or it is being backed up while the database is in NOARCHIVELOG mode. It cannot be used for normal database access or crash recovery.
解决： Complete or cancel the media recovery session or backup. ORA-01109: database not open
原因： A command was attempted that requires the database to be open. 解决： Open the database and try the command again ORA-01110: data file string: \
原因： Reporting file name for details of another error 解决： See associated error message
ORA-01111: name for data file string is unknown - rename to correct file
原因： The data file was missing from a CREATE CONTROLFILE command or backup control file recovery was done with a control file that was saved before the file was created. 解决： Rename the MISSING file to the name of the real file. ORA-01112: media recovery not started
原因： An attempt to continue media recovery is being made but media recovery was not started. 解决： None.
ORA-01113: file string needs media recovery
原因： An attempt was made to online or open a database with a file that is in need of media recovery.
解决： First apply media recovery to the file.
ORA-01114: IO error writing block to file string (block # string)
原因： The device on which the file resides is probably offline. If the file is a temporary file, then it is also possible that the device has run out of space. This could happen because disk space of temporary files is not necessarily allocated at file creation time.
解决： Restore access to the device or remove unnecessary files to free up space. ORA-01115: IO error reading block from file string (block # string) 原因： Device on which the file resides is probably offline 解决： Restore access to the device
ORA-01116: error in opening database file string 原因： Usually the file is not accessible. 解决： Restore the database file.
ORA-01117: adding file \
原因： An attempt was made to add a database file with a block size that is greater than the maximum block size allowed.
解决： Retry the DDL command with a smaller block size.
ORA-01118: cannot add any more database files: limit of string exceeded 原因： There is no more room in the control file for adding database files. 解决： Resize the control file or drop other tablespaces. ORA-01119: error in creating database file \
原因： Usually due to not having enough space on the device. 解决： none
第44页
ORA-01120: cannot remove online database file string 原因： Attempting to drop a datafile when it is online 解决： Take file offline before dropping.
ORA-01121: cannot rename database file string - file is in use or recovery
原因： Attempted to use ALTER DATABASE RENAME to rename a datafile that is online in an open instance or is being recovered.
解决： Close database in all instances and end all recovery sessions. ORA-01122: database file string failed verification check
原因： The information in this file is inconsistent with information from the control file. See accompanying message for reason.
解决： Make certain that the db files and control files are the correct files for this database. ORA-01123: cannot start online backup; media recovery not enabled
原因： An attempt to start backup of an on-line tablespace failed because media recovery is not enabled.
解决： Enable media recovery and retry this operation.
ORA-01124: cannot recover data file string - file is in use or recovery
原因： An attempt to do media recovery found that the file was not available for recovery. Either it is online and the database is open in some instance, or another process is curently doing media recovery on the file.
解决： Do not do media recovery.
ORA-01125: cannot disable media recovery - file string has online backup set
原因： An attempt to disable media recovery found that an online backup is still in progress. 解决： End the backup of the offending tablespace and retry this command.
ORA-01126: database must be mounted in this instance and not open in any instance 原因： Obvious 解决： none
ORA-01127: database name \ 原因： Obvious 解决： none
ORA-01128: cannot start online backup - file string is offline
原因： An attempt to start an online backup found that one of the files is offline. 解决： Bring the offending files online and retry this command or do a cold backup. ORA-01129: user\ 原因： The user\解决： Reassign the default or temporary tablespace.
ORA-01135: file string accessed for DML/query is offline 原因： Attempted to access a data file that is offline 解决： Bring the data file back online
ORA-01136: specified size of file string (string blocks) is less than original size of string blocks 原因： A file size was specified in the AS clause of ALTER DATABASE CREATE DATAFILE, and the size was smaller the the size needed 解决： Create the file with a larger size.
ORA-01137: data file string is still in the middle of going offline
原因： It was not possible to get the lock for a file that is offline when attempting to bring it
第45页