Saturday, March 30, 2013

ORA-00215 Must be at Least one Control File

Error Code
ORA-00215

Description
Must be at least one control file.

Cause
Possible cause of this error is, no control file is specified or the control file specified does not exist.

Action
To fix this issue, specify at least one valid control file and retry the operation.

reference

ORA-00214 Control file String Version String Inconsistent

Error Code
ORA-00214

Description
Control file 'string' version string inconsistent with file 'string' version string.

Cause
Possible cause of this error is, an inconsistent set of control files, datafiles/logfiles, and redo files was used.

Action
To fix this issue, use a consistant set of control files, datafiles/logfiles, and redo log files. That is, all the files must be for the same database and from the same time period.

reference

ORA-00213 Cannot Reuse Control File

Error Code
ORA-00213

Description
Cannot reuse control file; old file size string, string required.

Cause
Possible cause of this error is,to reuse a control file, it must be the same size as the one previously used.

Action
To fix this issue, either do not specify REUSE, or specify a matching combination of MAXDATAFILES, MAXLOGFILES, MAXLOGMEMBERS, MAXLOGHISTORY, and MAXINSTANCES clauses in the CREATE DATABASE or CREATE CONTROLFILE statement.

reference

ORA-00212 Block Size String below Minimum Required Size of String Bytes

Error Code
ORA-00212

Description
Block size string below minimum required size of string bytes.

Cause
Possible cause of this error is, the block size specified was too small. Space for the system overhead is required.

Action
To fix this issue, specify a larger block size and retry the operation.

reference

ORA-00211 Control File does not Match Previous Control Files

Error Code
ORA-00211

Description
Control file does not match previous control files.

Cause
Possible cause of this error is, a control file was specified that belongs to another database.

Action
To fix this error, find and install the correct control file.

reference

ORA-00210 Cannot Open the Specified Control File

Error Code
ORA-00210

Description
Cannot open the specified control file.

Cause
Possible cause of this error is, cannot open the control file.

Action
To fix this issue, check to make sure the control file exists and is not locked by some other program.

reference

ORA-00209 Control File Blocksize Mismatch

Error Code
ORA-00209

Description
Control file blocksize mismatch, check alert log for more info.

Cause
Possible cause of this error is, the block size in the control file header does not match the size specified in the DB_BLOCK_SIZE parameter.

Action
To fix this issue, look at the alert log for more information.

reference

ORA-00208 Number of Control File Names Exceeds Limit of String

Error Code
ORA-00208

Description
Number of control file names exceeds limit of string.

Cause
Possible cause of this error is, an attempt was made to use more control files than Oracle supports.

Action
To fix this issue, shut down Oracle. Reduce the number of control files specified in the CONTROL_FILES parameter in the initialization parameter file, and restart Oracle. Delete usused files.

reference

Wednesday, March 27, 2013

ORA-00207 Control Files are not for the Same Database

Error Code
ORA-00207

Description
Control files are not for the same database.

Cause
Possible cause of this error is, the database ID in the control file is not the same as the database ID in the control file used by the first instance to mount this database. Most likely one of the mounts used the wrong control file or there are two databases with the same name.

Action
To fix this error, check that the control file is for the correct database and is not an old version.

reference

ORA-00206 Error in Writing Block String of Control File

Error Code
ORA-00206

Description
Error in writing (block string, # blocks string) of control file.

Cause
Possible cause of this error is, a disk I/O failure was detected on writing the control file.

Action
To fix this error, check if the disk is online, if it is not, bring it online and try a warm start again. If it is online, then you need to recover the disk.

reference

ORA-00205 Error in Identifying Control File

Error Code
ORA-00205

Description
Error in identifying control file, check alert log for more info.

Cause
Possible cause of this error is, the system could not find a control file of the specified name and size.

Action
To fix this issue, check that ALL control files are online and that they are the same files that the system created at cold start time.

reference

ORA-00204 Error in Reading Block String of Control File

Error Code
ORA-00204

Description
Error in reading (block string, # blocks string) of control file.

Cause
Possible cause of this error is, a disk I/O failure was detected on reading the control file.

Action
To fix this issue, check if the disk is online, if it is not, bring it online and try a warm start again. If it is online, then you need to recover the disk.

reference

ORA-00203 Using the Wrong Control Files

Error Code
ORA-00203

Description
Using the wrong control files.

Cause
Possible cause of this error is ,the mount ID in the control file is not the same as the mount ID in the control file used by the first instance to mount this database. The control files are for the same database but they are not the same files. Most likely one instance is using a backup control file.

Action
To fix this issue, check that the correct control files were specified.

reference

ORA-00202 Control File String

Error Code
ORA-00202

Description
Control file: 'string'.

Cause
Possible cause of this error is, this message reports the name file involved in other messages.

Action
To fix this error, see associated error messages for a description of the problem.

reference

ORA-00201 Control File Version String Incompatible with ORACLE Version String

Error Code
ORA-00201

Description
Control file version string incompatible with ORACLE version string.

Cause
Possible cause of this error is, the control file was created by incompatible software.

Action
To fix this error, either restart with a compatible software release or use CREATE CONTROLFILE to create a new control file that is compatible with this release.

reference

ORA-00200 Control File could not be Created

Error Code
ORA-00200

Description
Control file could not be created.

Cause
Possible cause of this error is, it was not possible to create the control file.

Action
To fix this issue, check that there is sufficient disk space and no conflicts in filenames and try to create the control file again.

reference

Monday, March 25, 2013

ORA-00166 Remote or Local Nesting Level is too Deep

Error Code
ORA-00166

Description
Remote/local nesting level is too deep.

Cause:
Possible cause of this error is, too many remote table operations required a reverse trip back to the local site, for example to execute a local function on a remote table.

Action
To fix this error, rearrange the query or co-locate the functions with the tables.

reference

ORA-00165 Migratable Distributed Autonomous Transaction with Remote Operation is not Allowed

Error Code
ORA-00165

Description
Migratable distributed autonomous transaction with remote operation is not allowed.

Cause
Possible cause of this error is, a request was made by the application to start a migratable distributed autonomous transaction with remote operation.

Action
none

reference

ORA-00164 Distributed Autonomous Transaction Disallowed within Migratable Distributed Transaction

Error Code
ORA-00164

Description
Distributed autonomous transaction disallowed within migratable distributed transaction

Cause
Possible cause of this error is, a request was made by the application to start a distributed autonomous transaction when the application was in a migratable distributed transaction.

Action
To fix this error, roll back or commit the current distributed transaction first.

reference

ORA-00163: Internal Database Name Length String is Greater than Maximum

Error Code
ORA-00163

Description
Internal database name length string is greater than maximum (string).

Cause
Possible cause of this error is, an internal database name with a too large length field was passed in.

Action
To fix this error, report the problem to your external transaction coordinator vendor.

reference

Sunday, March 24, 2013

ORA-00162 External dbid Length String is Greater than Maximum

ErrorCode
ORA-00162

Description
External dbid length string is greater than maximum (string).

Cause
Possible cause of this error is, an external database name with too large a length field was passed in.

Action
To fix this error, report the problem to your external transaction coordinator vendor.

reference

ORA-00161 Transaction Branch Length String is Illegal

Error Code
ORA-00161

Description
Transaction branch length string is illegal (maximum allowed string).

Cause
Possible cause of this error is, an external transaction branch ID with a length either too large or 0 was passed in.

Action
To fix this error, report the problem to your external transaction coordinator vendor.

reference

Saturday, March 23, 2013

ORA-00160 Global Transaction Length String is Greater than Maximum

Error Code
ORA-00160

Description
Global transaction length string is greater than maximum (string).

Cause
Possible cause of this error is, an external global transaction ID with a too large length field was passed in.

Action
To fix this error, report the problem to your external transaction coordinator vendor.

reference

ORA-00155 Cannot Perform Work Outside of Global Transaction

Error Code
ORA-00155

Description
Cannot perform work outside of global transaction.

Cause
Possible cause of this error is, the application tried to perform some work on either an Oracle 7.3 server or an Oracle8 server with local transactions disabled while outside of a global transaction.

Action
To fix this error, check if the application is connected to an Oracle 7.3 server. The Transaction monitor must not return a NULL XID on an AX_REG call when the resource manager is Oracle 7.3. If the application is connected to an Oracle8 server, either set nolocal=f in the xa_open string or start a global transaction prior to attempting the work.

reference

Sunday, March 3, 2013

ORA-00154 Protocol Error in Transaction Monitor

Error Code
ORA-00154

Description
Protocol error in transaction monitor.

Cause
Possible cause of this error is, the transaction monitor returned TMJOIN on an AX_REG call but the transaction was locally suspended.

Action
To fix this error, contact the transaction monitor customer support.

reference

ORA-00153 Internal Error in XA Library

Error Code
ORA-00153

Description
Internal error in XA library.

Cause
Possible cause of this error is, the XA library could not access thread-specific pointers.

Action
To fix this error, contact customer support.

reference

ORA-00152 Current Session does not Match Requested Session

Error Code
ORA-00152

Description
Current session does not match requested session.

Cause
Possible cause of this error is, the current session is not the same as the session that was passed into a upixado() call.

Action
To fix this error, check your application.

reference

ORA-00151 Invalid Transaction ID

Error Code
ORA-00151

Description
Invalid transaction ID.

Cause
Possible cause of error is, the specified transaction ID does not correspond to an existing valid transaction.

Action
To fix this error, check your application.

reference

ORA-00150 Duplicate Transaction ID

Error Code
ORA-00150

Description
Duplicate transaction ID.

Cause
Possible cause of this error is, attempted to start a new transaction with an ID already in use by an existing transaction.

Action
To fix this error, check your application.

reference

ORA-00134 Invalid Dispatchers Specification String

Error Code
ORA-00134

Description
Invalid DISPATCHERS specification #string.

Cause
Possible cause of this error is, the syntax for the n-th DISPATCHERS specification was incorrect.

Action
To fix this error, refer to the Oracle Reference Manual for the correct syntax.

reference

ORA-00133 Value of String is too Long

Error Code
ORA-00133

Description
Value of string is too long.

Cause
Possible cause of this error is, the value specified for the attribute was too long.

Action
To fix this error, use shorter names and keywords or remove unneeded blanks.

reference

ORA-00132 Syntax Error or Unresolved Network Name String

Error Code
ORA-00132

Description
Syntax error or unresolved network name 'string'.

Cause
Possible cause of this error is, listener address has syntax error or cannot be resolved.

Action
To fix this error, if a network name is specified, check that it corresponds to an entry in TNSNAMES.ORA or other address repository as configured for your system. Make sure that the entry is syntactically correct.

reference

ORA-00131 Network Protocol does not Support Registration String

Error Code
ORA-00131

Description
Network protocol does not support registration 'string'.

Cause
Possible cause of this error is, the specified protocol does not support async notification.

Action
To fix this error, refer to the manual for information on supported network protocols.

reference

ORA-00130 Invalid Listener Address String

Error Code
ORA-00130

Description
Invalid listener address 'string'

Cause
Possible cause of this error is, the listener address specification is not valid.

Action
To fix this error, make sure that all fields in the listener address (protocol, port, host, key, ...) are correct.

reference

ORA-00129 Listener Address Validation Failed String

Error Code
ORA-00129

Description
Listener address validation failed 'string'.

Cause
Possible cause of this error is, an error was encountered while validating the listener address.

Action
To fix this problem, resolve error or contact your ORACLE representative.

reference

ORA-00128 This Command Requires a Dispatcher Name

Error Code
ORA-00128

Description
This command requires a dispatcher name.

Cause
Possible cause of this error is, wrong syntax for ALTER SYSTEM SHUTDOWN

Action
To fix this error, use correct syntax: ALTER SYSTEM SHUTDOWN [ IMMEDIATE ] 'dispatcher name'.

reference

ORA-00127 Dispatcher string does not exist

Error Code
ORA-00127

Description
Dispatcher string does not exist.

Cause
Possible cause of this error is, there is currently no dispatcher running with the specified name.


Action
To fix this error, retry with a name of the form "D###" denoting an existing dispatcher process.