Oracle7 Server Messages
01000-01099: User Program Interface
This section lists messages generated when using the UPI to the Oracle Server. Precompilers and SQL*Forms are examples of products that use the UPI.
ORA-01000 maximum open cursors exceeded
Cause: | A host language program attempted to open too many cursors. The initialization parameter OPEN_CURSORS determines the maximum number of cursors per user. | |
Action: | Modify the program to use fewer cursors. If this error occurs often, shut down Oracle, increase the value of OPEN_CURSORS, and then restart Oracle. | |
ORA-01001 invalid cursor
Cause: | Either a host language program call specified an invalid cursor or the values of the AREASIZE and MAXOPENCURSORS options in the precompiler command were too small. All cursors must be opened using the OOPEN call before being referenced in any of the following calls: SQL, DESCRIBE, NAME, DEFINE, BIND, EXEC, FETCH, and CLOSE. The Logon Data Area (LDA)
must be defined by using OLON or OLOGON. If the LDA is not defined,
this message is issued for the following calls: OPEN, COM, CON, ROL,
and LOGOFF. | |
Action: | Check the erroneous call statement. Specify a correct LDA area or open the cursor as required. If there is no problem with the cursor, it may be
necessary to increase the AREASIZE and MAXOPENCURSORS options
before precompiling. | |
ORA-01002 fetch out of sequence
Cause: | In a host language program, a FETCH call was issued out of sequence. A successful parse-and-execute call must be issued before a fetch. This can occur if an attempt was made to FETCH from an active set after all records have been fetched. This may be caused by fetching from a SELECT FOR UPDATE cursor after a commit. A PL/SQL cursor loop implicitly does fetches and may also cause this error. | |
Action: | Parse and execute a SQL statement before attempting to fetch the data. | |
ORA-01003 no statement parsed
Cause: | A host language program call referenced a cursor with no associated parsed SQL statement. A SQL call (for example, OSQL3) must be used to pass a SQL statement to Oracle and to associate the statement with an open cursor. A cursor must already have an associated SQL statement if referenced in any of the following calls: DESCRIBE, NAME, DEFINE, BIND, EXECUTE,
and FETCH. | |
Action: | Do the SQL call, for example, OSQL, to pass the required SQL statement before referencing the cursor. | |
ORA-01004 default username feature not supported; logon denied
Cause: | An attempt was made to use automatic logon on a system not supporting
this feature. | |
Action: | Provide the complete username and password to log on to Oracle. | |
ORA-01005 null password given; logon denied
Cause: | An invalid password was given when logging on. | |
Action: | Provide a valid password. | |
ORA-01006 bind variable does not exist
Cause: | A program issued a BIND call for a variable not listed in the associated SQL statement. Only those variables prefixed by either a colon (:) or ampersand (&) in the SQL statement may be referenced in a BIND call, OBIND or OBINDN. This error may also be caused by a mismatch between a Precompiler program and the related library, SQLLIB. | |
Action: | Modify the BIND call to reference one of the substitute variables specified in the associated SQL statement. | |
ORA-01007 variable not in select list
Cause: | A reference was made to a variable not listed in the SELECT clause. In OCI, this can occur if the number passed for the position parameter is less than one or greater than the number of variables in the SELECT clause in any of the following calls: DESCRIBE, NAME, or DEFINE. In SQL*Forms or SQL*Report, specifying more variables in an INTO clause than in the SELECT clause also causes this error. | |
Action: | In OCI, specify a position number between 1 and the number of variables in the SELECT clause. In SQL*Forms or SQL*Report, specify an equal number of variables in the SELECT and INTO clauses. | |
ORA-01008 not all variables bound
Cause: | A SQL statement containing substitution variables was executed without all variables bound. All substitution variables must have a substituted value before the SQL statement is executed. | |
Action: | In OCI, use an OBIND or OBINDN call to substitute the required values. | |
ORA-01009 missing mandatory parameter
Action: | Check the syntax for the call and enter all required parameters. | |
ORA-01010 invalid OCI operation
Cause: | One of the following: | |
- You attempted an invalid OCI operation.
- You are using an Oracle client application linked version 7.1, or higher libraries, the environment ORA_ENCRYPT_LOGIN is set to TRUE, and you attempted to connect to a version 7.0, or lower, Oracle Server.
- 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.
Action: | For the above causes: | |
- Do not use the invalid OCI operation.
- 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.
- 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.
ORA-01011 cannot use V7 compatibility mode when talking to V6 server
Cause: | An attempt was made to use Oracle7 compatibility mode when accessing Oracle Version 6. | |
Action: | Use V6 SQL language type. You may need to use the SET COMPATIBILITY V6 command. | |
ORA-01012 not logged on
Cause: | A host language program issued an Oracle call, other than OLON or OLOGON, without being logged on to Oracle. This can occur when a user process attempts to access the database after the instance it is connected to terminates, forcing the process to disconnect. | |
Action: | Log on to Oracle, by calling OLON or OLOGON, before issuing any Oracle calls. When the instance has been restarted, retry the action. | |
ORA-01013 user requested cancel of current operation
Cause: | The user interrupted an Oracle operation by entering CTRL-C, Control-C, or another canceling operation. This forces the current operation to end. This is an informational message only. | |
Action: | Continue with the next operation. | |
ORA-01014 Oracle shutdown in progress
Cause: | A user tried to log on to Oracle while an instance shutdown was in progress. Oracle logons are disabled while Oracle is being shut down. | |
Action: | Wait until Oracle is brought back up before attempting to log on. | |
ORA-01015 logon called recursively
Cause: | This is an internal error message not usually issued. | |
Action: | Contact customer support. | |
ORA-01016 this function can be called only after a fetch
Cause: | The cursor is in an invalid state. | |
Action: | Ensure the appropriate OCI/UPI function is called after the fetch and before the offending function. | |
ORA-01017 invalid username/password; logon denied
Cause: | An invalid username or password was entered in an attempt to log on to Oracle. The username and password must be the same as was specified in a GRANT CONNECT statement. If the username and password are entered together, the format is: username/password. | |
When Trusted Oracle7 is configured in OS MAC mode, this error may occur if attempting to query a table/view in a secondary database when the username was not created or not granted the CREATE SESSION privilege in the secondary database.
When Trusted Oracle7 is configured in DBMS MAC mode, this error may occur if granted the CREATE SESSION system privilege at a higher label than that attempted at login.
Action: | Enter a valid username and password combination in the correct format. | |
For Trusted Oracle7 users, if the cause of this error is that the username was either not created or not granted the CREATE SESSION system privilege in a secondary database, ask the database administrator to authorize the username to access the secondary database. Alternatively, if the cause of this error is that the username is granted the CREATE SESSION system privilege at a higher label than that of the attempted login, either login at that higher label or ask the database administrator to regrant the privilege at the appropriate label.
ORA-01018 column does not have a LONG datatype
Cause: | An attempt was made to fetch data using the LONG fetch option, but the specified column was not LONG. | |
Action: | Re-execute the fetch without the LONG fetch option or create the table with a LONG column. | |
ORA-01019 unable to allocate memory in the user side
Cause: | The user side memory allocator returned an error. | |
Action: | Increase the size of the process heap or switch to the old set of calls. | |
ORA-01020 unknown context state
Cause: | This is an internal error message not usually issued. | |
Action: | Contact customer support. | |
ORA-01022 database operation not supported in this configuration
Cause: | The attempted database operation does not conform to the user programming interface (UPI) for the two communicating Oracle servers. | |
This problem occurs when you use a 7.0.13 server and try to use PL/SQL or remote procedure calls on a 7.0.12 server.
Action: | You may need to upgrade one or more of your Oracle servers or relink your user-side application with new libraries. | |
ORA-01023 cursor context not found (invalid cursor number)
Cause: | The cursor number is not a valid open cursor. | |
Action: | Make sure that the cursor is open. | |
ORA-01024 invalid datatype in OCI call
Action: | Check the datatype description and enter the correct number for the datatype. | |
ORA-01025 UPI parameter out of range
Cause: | An integer parameter to a UPI function is out of range. This is an internal error message not usually issued. | |
Action: | Contact customer support. | |
ORA-01026 multiple buffers of size > 2000 in the bind list
Cause: | There is more than one long buffer in the bind list. | |
Action: | Change the buffer size to be less than 255 for the bind variable bound to a normal column. | |
ORA-01027 bind variables not allowed for data definition operations
Cause: | An attempt was made to use a bind variable in a SQL data definition statement; for example, a CREATE TABLE AS SELECT statement in which the SELECT's WHERE clause refers to a variable. | |
Action: | Remove the bind variable. Then retry the SQL statement. | |
ORA-01030 SELECT ... INTO variable does not exist
Cause: | The SELECT... INTO specified in the bind call does not correspond to a variable in the SQL statement. | |
Action: | If it is not possible to correct the statement, call customer support. | |
ORA-01031 insufficient privileges
Cause: | An attempt was made to change the current username or password without the appropriate privilege. This error also occurs if attempting to UPDATE a table with only SELECT privileges, if attempting to CONNECT INTERNAL, or if attempting to install a database without the necessary operating-system privileges. | |
When Trusted Oracle7 is configured in DBMS MAC, this error may occur if
the user was granted the necessary privilege at a higher label than the
current login.
Action: | Ask the database administrator to perform the operation or grant the
required privileges. | |
For Trusted Oracle7 users getting this error although granted the appropriate privilege at a higher label, ask the database administrator to regrant the privilege at the appropriate label.
ORA-01032 no such userid
Cause: | This is an internal error message related to Export/Import. | |
Action: | Contact customer support. | |
ORA-01033 Oracle startup or shutdown in progress
Cause: | An attempt was made to log on while Oracle is being started up or shut down. | |
Action: | Wait a few minutes. Then retry the operation. | |
ORA-01034 Oracle not available
Cause: | 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 was
improperly defined.
Action: | Refer to accompanying messages for possible causes and correct the problem mentioned in the other messages. Retry after Oracle has been initialized. | |
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
Cause: | Logins were disallowed because an instance started in restricted mode. Only users with the RESTRICTED SESSION system privilege can log on. | |
Action: | Request that Oracle be restarted without the restricted option or obtain the RESTRICTED SESSION system privilege. | |
ORA-01036 illegal variable name/num
Cause: | Unable to find bind context on user side. | |
Action: | Make sure that the variable being bound is in the SQL statement. | |
ORA-01037 maximum cursor memory exceeded
Cause: | An attempt was made to process a complex SQL statement that consumed all available memory of the cursor. | |
Action: | Simplify the complex SQL statement. | |
ORA-01038 cannot write datafile version num with Oracle Version num
Cause: | An attempt was made to write datafile headers in an old format. The new format cannot be used until after the database has been verified as being compatible with this software version. | |
Action: | 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, use the previous software release to do the operation. | |
ORA-01039 insufficient privileges on underlying objects of the view
Cause: | An attempt was made to use another user's view without the necessary privileges on the underlying objects of the view. | |
Action: | Obtain the necessary privileges or do not perform the offending operation. | |
ORA-01040 invalid character in password; logon denied
Cause: | There are multi-byte characters in the password or some characters in the password are not in the US7ASCII range. | |
Action: | Retry password with valid characters. | |
ORA-01041 internal error. HOSTDEF extension does not exist
Cause: | The pointer to the HOSTDEF extension in HOSTDEF is null. | |
Action: | Report as a bug to customer support. | |
ORA-01042 detaching a session with open cursors not allowed
Cause: | An attempt was made to detach a session that has open cursors. | |
Action: | Close all the cursors before detaching the session. | |
ORA-01043 user side memory corruption [num], [num], [num], [num]
Cause: | The application code corrupted some of the user memory. | |
Action: | Make certain that the application code is not overwriting memory. Contact customer support. | |
ORA-01044 size num of buffer bound to variable name exceeds maximum num
Cause: | An attempt was made to bind a buffer whose total size would exceed the maximum size allowed. The total array size for arrays is calculated as (element_size) * (number of elements) | |
Action: | Reduce the buffer size. | |
ORA-01045 user name lacks CREATE SESSION privilege; logon denied
Cause: | An attempt was made to connect to a userid that does not have create
session privilege. | |
Action: | If required, GRANT the user the CREATE SESSION privilege. | |
ORA-01046 cannot acquire space to extend context area
Cause: | Oracle could not extend the current area any further because the operating system would not supply any more space. A system-specific message should appear following this message. | |
ORA-01047 the above error occurred in schema=name, package=name, procedure=name
Cause: | This message is displayed after a previous message to provide more
specific information. | |
Action: | See the cause and action for the previous message. | |
ORA-01048 couldn't find the specified procedure in the given context
Cause: | The user of the procedure specified a deferred RPC that does not exist. | |
Action: | Ensure that the procedure was specified correctly and that the replication process can locate the procedure. | |
ORA-01049 bind by name is not supported in streamed RPC
Cause: | This error occurs when a newer server version requests from an older server version an operation that is not supported. | |
Action: | You may need to upgrade one or more of your Oracle servers or relink your user application with new libraries. | |
ORA-01050 cannot acquire space to open context area
Cause: | Oracle could not open a new context area because the operating system would not supply any more space. A system-specific message should appear following this message. | |
ORA-01051 deferred RPC buffer format invalid
Cause: | The deferred RPC data in SYS.DEF$_CALL is corrupted. | |
Action: | Contact customer support. | |
ORA-01053 user storage address cannot be read
Cause: | A bind variable or other user area could not be read by Oracle. | |
Action: | Check that binds are done correctly on valid user buffers, then retry
the operation. | |
ORA-01054 user storage address cannot be written
Cause: | A define, FETCH... INTO or SELECT... INTO, variable or other user area could not be written to by Oracle. | |
Action: | Check that INTO variables and indicators are correctly specified. Then retry
the operation. | |
ORA-01057 invalid or ambiguous block.field reference in user exit
Cause: | The reference to a block.field identifier in a user exit is incorrect or ambiguous, probably because it is misspelled or incomplete. | |
Action: | Check syntax and identifier spelling. Then correct the reference. | |
ORA-01058 internal New Upi interface error
Cause: | An attempt was made to delete a non-existent HSTDEF extension. | |
Action: | Contact customer support. | |
ORA-01059 parse expected before a bind or execute
Cause: | The client application attempted to bind a variable or execute a cursor opened in a PL/SQL block before the statement was parsed. | |
Action: | Ensure the statement is parsed before a bind or execute. | |
ORA-01060 array binds or executes not allowed
Cause: | 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. | |
Action: | Bind a single cursor or execute the PL/SQL block one. | |
ORA-01070 using an old version of Oracle for the server
Cause: | An attempt was made to run an older, obsolete Oracle7 Server. | |
Action: | Upgrade the server. | |
ORA-01071 cannot perform operation without starting up Oracle
Cause: | An attempt was made to perform an operation before Oracle was started. | |
Action: | Start up Oracle. Then retry the operation. | |
ORA-01072 cannot stop Oracle; Oracle not running
Cause: | An attempt was made to stop Oracle, but Oracle was not running. | |
Action: | No action required. | |
ORA-01073 fatal connection error: unrecognized call type
Cause: | An illegal internal operation was attempted. This is an internal error message not usually issued. | |
Action: | Contact customer support. | |
ORA-01074 cannot shut down Oracle; inside a logon session - log off first
Cause: | An attempt was made to shut down Oracle inside a logon session. | |
Action: | Log off before shutting down Oracle. | |
ORA-01075 currently logged on
Cause: | An attempt was made to log on while already logged on. | |
Action: | No action required. | |
ORA-01076 multiple logons per process not yet supported
Cause: | Oracle does not support multiple logons per process. | |
Action: | No action required. | |
ORA-01077 background process initialization failure
Cause: | A failure occurred during initialization of the background processes. | |
Action: | Refer to the diagnostic information in the accompanying message stack or in the trace file and take appropriate action. | |
ORA-01078 failure in processing initialization parameters
Cause: | A failure occurred during processing of the initialization parameters during system startup. | |
Action: | Refer to the diagnostic information in the accompanying message stack and take appropriate action. | |
ORA-01079 Oracle database was not properly created, operation aborted
Cause: | There was an error when the database or control file was created. | |
Action: | Check the message signaled when the database was first created or when the control file was re-created. Take appropriate actions to re-create the database or a new control file. | |
ORA-01080 error in shutting down Oracle
Cause: | A failure occurred during system shutdown. | |
Action: | Refer to the diagnostic information in the accompanying message stack and take appropriate action. | |
ORA-01081 cannot start already-running Oracle - shut it down first
Cause: | An attempt was made to start Oracle while it was already running. | |
Action: | Shut down Oracle first, if you want to restart it. | |
ORA-01083 value of parameter name is inconsistent with that of other servers
Cause: | The value of the given initialization parameter is required to be the same for all servers in the parallel configuration. | |
Action: | Change the value in the initialization parameter file to match that of the other control files. | |
ORA-01084 invalid argument in OCI call
Cause: | The failing OCI call contains an argument with an invalid value. | |
ORA-01085 preceding errors in deferred RPC to name.name.name
Cause: | Errors were encountered when the named procedure was executed as a deferred, remote procedure call. | |
Action: | Correct the cause of the preceding errors. | |
ORA-01086 savepoint name never established
Cause: | An attempt was made to roll back to a savepoint that was never established. | |
Action: | No action required. | |
ORA-01087 cannot start up Oracle - currently logged on
Cause: | An attempt was made to start up Oracle by a user who is currently logged on. | |
Action: | Log off. Then issue the STARTUP command. | |
ORA-01088 cannot shut down Oracle while active processes exist
Cause: | Users are still logged on to the instance. | |
Action: | Either wait for all users to log off or issue the SHUTDOWN IMMEDIATE command to force the users off the system. Alternatively, issue the SHUTDOWN ABORT command to shut down the database without waiting for users to be forced off. | |
ORA-01089 immediate shutdown in progress - no operations are permitted
Cause: | The SHUTDOWN IMMEDIATE command was used to shut down a running Oracle instance, terminating any active operations. | |
Action: | Wait for the instance to be restarted or contact the database administrator. | |
ORA-01090 shutdown in progress - connection is not permitted
Cause: | The SHUTDOWN command was used to shut down a running Oracle instance, disallowing any connects to Oracle. | |
Action: | Wait for the instance to restart or contact the database administrator. | |
ORA-01091 failure during startup force
Cause: | Unable to destroy the old SGA. | |
Action: | Manually remove the old SGA. See your operating system-specific Oracle documentation for instructions. Then retry the STARTUP command. | |
ORA-01092 Oracle instance terminated. Disconnection forced
Cause: | The instance connected to was terminated abnormally, probably due to a SHUTDOWN ABORT. The current process was forced to disconnect from
the instance. | |
Action: | Contact the database administrator to determine when the instance is restarted. Attempt to reconnect after the instance is running again. | |
ORA-01093 ALTER DATABASE CLOSE only permitted with no sessions connected
Cause: | There is at lease one more session, other than the current one, logged in to the instance. ALTER DATABASE CLOSE is not permitted when other sessions
are active. | |
Action: | Find the other sessions and disconnect them. Then retry the ALTER DATABASE CLOSE command. Also, issue the SHUTDOWN IMMEDIATE command to force users off the system, or issue the SHUTDOWN ABORT command to shut down the database without waiting for users to be forced off. | |
ORA-01094 ALTER DATABASE CLOSE in progress. Connections not permitted
Cause: | An attempt was made to connect while the database is being closed with the ALTER DATABASE CLOSE command. | |
Action: | Attempt to connect again when the database is open. Contact the database administrator to find out when the database will be open. | |
ORA-01095 DML statement processed zero rows
Cause: | A DML cursor from the OTEX() call processed 0 rows when executed. | |
Action: | Caller can either do a rollback or ignore the message and execute the rest of the cursors in the cursor array. | |
ORA-01096 program version num incompatible with instance num
Cause: | The program was linked with a different version of the server than the instance to which it is attempting to connect. | |
Action: | Relink the program against the same version of Oracle as the instance or restart (startup force) the database using the program's version of the SERVER. | |
ORA-01097 cannot shutdown while in a transaction - commit or rollback
Cause: | An attempt was made to shut down the database while a transaction was
in progress. | |
Action: | Either commit or rollback the current transaction and then attempt to
shut down the database. | |
ORA-01098 program interface error during LONG insert
Cause: | The application program interface could not insert or update a LONG column because of an internal error when a TTCGETV call fails. For example, a network read error or one of the parameters passed to the call is invalid. | |
Action: | Retry the insert or update. | |
ORA-01099 cannot mount database in SHARED mode if started in single process mode
Cause: | An attempt was made to mount a database in parallel mode with the initialization parameter SINGLE_PROCESS set to TRUE. | |
Action: | Either mount the database in EXCLUSIVE mode or set the initialization parameter SINGLE_PROCESS to FALSE before starting the instance in parallel (shared) mode. | |