Scripter World

ORA-06311: IPA: Maximum number of servers reached

2010-01-03T20:47:00.000-08:00

Error : ORA-06311: IPA: Maximum number of servers reached

Cause : Maximum number of servers reached.

Action : Shutdown and restart with an increased maximum number of servers. Note that database links consume one server per link. Be sure to start up enough servers to support database links.

Please leave your valuable comments below :-)

ORA-06309: IPA: No message queue available

2010-01-03T20:46:00.000-08:00

Error : ORA-06309: IPA: No message queue available

Cause : The SQL*Net IPA servers have not been started.

Action : Run ipactl.

Please leave your valuable comments below :-)

ORA-06264: NETNTT: data protocol error

2010-01-03T20:31:00.000-08:00

Error : ORA-06264: NETNTT: data protocol error

Cause : The NTT two-task driver received an unexpected message type."

Action : Contact your customer support representative.

Please leave your valuable comments below :-)

ORA-04011: sequence string must range between string and string

2009-12-29T20:16:00.000-08:00

Error : ORA-04011: sequence string must range between string and string

Cause : the value specified for one of the sequence parameters exceeds limits

Action : specify parameter within these limits

Please leave your valuable comments below :-)

ORA-03292: Table to be truncated is part of a cluster

2009-12-29T19:54:00.000-08:00

Error : ORA-03292: Table to be truncated is part of a cluster

Cause : The table being truncated is a member of a cluster.

Action : Either use TRUNCATE CLUSTER or DROP TABLE

Please leave your valuable comments below :-)

ORA-03249: Uniform size for auto segment space managed tablespace should have atleast blocks

2009-12-29T19:08:00.000-08:00

Error : ORA-03249: Uniform size for auto segment space managed tablespace should have atleast blocks

Cause : For the given blocksize, uniform size specified is insufficient

Action : Specify larger extent size and retry

Please leave your valuable comments below :-)

ORA-03123: operation would block

2009-12-29T08:54:00.000-08:00

Error : ORA-03123: operation would block

Cause : This is a status code that indicates that the operation cannot complete now.

Action : None - this is not an error. The operation should be retried again for completion.

Please leave your valuable comments below :-)

ORA-02882: sou2o: Could not register SGA for protection

2009-12-29T08:41:00.000-08:00

Error : ORA-02882: sou2o: Could not register SGA for protection

Cause : This is an internal error, note error code in errno.

Action : Report to your customer support representative. Restarting your application or your computer may cure the problem.

Please leave your valuable comments below :-)

ORA-02850: File is closed

2009-12-26T05:30:00.000-08:00

Error : ORA-02850: File is closed

Cause : A file upon which an asynchronous I/O operation is to be performed has already been closed by the package.

Action : This is a programming error.

Please leave your valuable comments below :-)

ORA-02836: Unable to create temporary key file

2009-12-25T21:28:00.000-08:00

Error : ORA-02836: Unable to create temporary key file

Cause : Internal error.

Action : Contact ORACLE support.

Please leave your valuable comments below :-)

ORA-02719: osnfop: fork failed

2009-12-15T06:16:00.000-08:00

Error : ORA-02719: osnfop: fork failed

Cause : The fast driver could not fork the oracle shadow process.

Action : Verify that there are enough system resources to support another process. The user or system process limit may have been exceeded, or the amount of free memory or swap space may be temporarily insufficient.

Please leave your valuable comments below :-)

ORA-02713: osnprd: message receive failure

2009-12-15T06:08:00.000-08:00

Error : ORA-02713: osnprd: message receive failure

Cause : The pipe driver failed to read a message from the communications channel.

Action : Contact your customer support representative.

Please leave your valuable comments below :-)

ORA-02710: osnpop: fork failed

2009-12-15T06:06:00.000-08:00

Error : ORA-02710: osnpop: fork failed

Cause : The pipe driver could not fork the oracle shadow process.

Action : Verify that there are enough system resources to support another process. The user or system process limit may have been exceeded, or the amount of free memory or swap space may be temporarily insufficient.

Please leave your valuable comments below :-)

ORA-02709: osnpop: pipe creation failed

2009-12-15T06:05:00.000-08:00

Error : ORA-02709: osnpop: pipe creation failed

Cause : The pipe driver failed to create pipes for two-task communications with the oracle shadow process.

Action : You have probably exceeded the maximum number of open file descriptors per user or the system file table is full. Note the operating system error code and contact your system administrator.

Please leave your valuable comments below :-)

ORA-02701: osnoraenv: error translating oracle image name

2009-12-15T05:59:00.000-08:00

Error : ORA-02701: osnoraenv: error translating oracle image name

Cause : ORACLE_HOME environment variable not set.

Action : Make sure that the ORACLE_HOME environment variable has been properly set and exported.

Please leave your valuable comments below :-)

ORA-02481: Too many processes specified for events (max)

2009-12-14T08:43:00.000-08:00

Error : ORA-02481: Too many processes specified for events (max)

Cause : Too many processes specified than allowed per event.

Action : Enter fewer processes by using ranges or wildcards if possible.

Please leave your valuable comments below :-)

ORA-02423: schema name does not match schema authorization identifier

2009-12-14T07:23:00.000-08:00

Error : ORA-02423: schema name does not match schema authorization identifier

Cause : a table definition with a schema name prepended to the table name does not match the schema name provided in the authorization clause of a create schema statement.

Action : make sure the schema names match.

Please leave your valuable comments below :-)

ORA-02476: can not create index due to parallel direct load on table

2009-12-13T08:40:00.000-08:00

Error : ORA-02476: can not create index due to parallel direct load on table

Cause : A parallel direct load is occurring to the specified table.

Action : Retry statement after load is complete.

Please leave your valuable comments below :-)

ORA-02360: Column not found before end of logical record (use TRAILING NULLCOLS)

2009-12-12T10:17:00.000-08:00

Error : ORA-02360: Column not found before end of logical record (use TRAILING NULLCOLS)

Cause : A column started after the end of the logical record had been reached.

Action : Use the TRAILING NULLCOLS option or supply data for the column.

Please leave your valuable comments below :-)

ORA-02351: Record : Rejected - Error on table , column

2009-12-12T10:07:00.000-08:00

Error : ORA-02351: Record : Rejected - Error on table , column

Cause : The record indicated caused an oracle error on insert.

Action : Determine the oracle error and correct the record.

Please leave your valuable comments below :-)

ORA-02345: cannot create a view with column based on CURSOR operator

2009-12-12T10:01:00.000-08:00

Error : ORA-02345: cannot create a view with column based on CURSOR operator

Cause : A CURSOR operator was used as one of the SELECT elements in the subquery of a CREATE VIEW or CREATE TABLE ... AS SELECT statement.

Action : Remove the CURSOR operator and replace it with the CAST operator.

Please leave your valuable comments below :-)

ORA-02342: replacement type has compilation errors

2009-12-12T09:58:00.000-08:00

Error : ORA-02342: replacement type has compilation errors

Cause : The use of the ALTER...REPLACE statement on a valid type caused a compilation error.

Action : Use the ALTER...REPLACE statement to replace the type with a valid type which does not cause compilation errors.

Please leave your valuable comments below :-)

ORA-02276: default value type incompatible with column type

2009-12-11T07:32:00.000-08:00

Error : ORA-02276: default value type incompatible with column type

Cause : The type of the evaluated default expression is incompatible with the datatype of the column.

Action : Change the type of the column, or modify the default expression.

Please leave your valuable comments below :-)

ORA-02205: only SELECT and ALTER privileges are valid for sequences

2009-12-10T06:28:00.001-08:00

Error : ORA-02205: only SELECT and ALTER privileges are valid for sequences

Cause : An attempt was made to grant or revoke an invalid privilege on a sequence.

Action : Do not attempt to grant or revoke DELETE, INDEX, INSERT, UPDATE, REFERENCES or EXECUTE privilege on sequences.

Please leave your valuable comments below :-)

ORA-02206: duplicate INITRANS option specification

2009-12-10T06:28:00.000-08:00

Error : ORA-02206: duplicate INITRANS option specification

Cause : INITRANS is specified more than once.

Action : Specify INITRANS at most once.

Please leave your valuable comments below :-)

ORA-02202: no more tables permitted in this cluster

2009-12-10T06:26:00.001-08:00

Error : ORA-02202: no more tables permitted in this cluster

Cause : An attempt was made to create a table in a cluster which already contains 32 tables.

Action : Up to 32 tables may be stored per cluster.

Please leave your valuable comments below :-)

ORA-02203: INITIAL storage options not allowed

2009-12-10T06:26:00.000-08:00

Error : ORA-02203: INITIAL storage options not allowed

Cause : The user attempted to alter the INITIAL storage option of a table, cluster, index, or rollback segment. These options may only be specified when the object is created.

Action : Remove these options and retry the statement.

Please leave your valuable comments below :-)

ORA-02199: missing DATAFILE/TEMPFILE clause

2009-12-10T06:06:00.001-08:00

Error : ORA-02199: missing DATAFILE/TEMPFILE clause

Cause : A CREATE TABLESPACE statement has no DATAFILE/TEMPFILE clause.

Action : Specify a DATAFILE/TEMPFILE clause.

Please leave your valuable comments below :-)

ORA-02200: WITH GRANT OPTION not allowed for PUBLIC

2009-12-10T06:06:00.000-08:00

Error : ORA-02200: WITH GRANT OPTION not allowed for PUBLIC

Cause : An attempt was made to GRANT to PUBLIC WITH GRANT OPTION.

Action : Remove the WITH GRANT OPTION clause.

Please leave your valuable comments below :-)

ORA-02195: Attempt to create object in a tablespace

2009-12-10T06:05:00.001-08:00

Error : ORA-02195: Attempt to create object in a tablespace

Cause : The object type is inconsistent with a tablespace contents.

Action : Create an object in a different tablespace, or change the user defaults.

Please leave your valuable comments below :-)

ORA-02198: ONLINE/OFFLINE option already specified

2009-12-10T06:05:00.000-08:00

Error : ORA-02198: ONLINE/OFFLINE option already specified

Cause : In CREATE TABLESPACE, the ONLINE and/or OFFLINE options were specified more than once.

Action : Specify at most one of ONLINE or OFFLINE.

Please leave your valuable comments below :-)

ORA-02194: event specification syntax error (minor error ) near 'string'

2009-12-10T06:04:00.000-08:00

Error : ORA-02194: event specification syntax error (minor error ) near 'string'

Cause : There is a syntax error in an event specification.

Action : Fix the error.

Please leave your valuable comments below :-)

ORA-02191: correct syntax is: SET TRANSACTION USE ROLLBACK SEGMENT

2009-12-10T06:03:00.001-08:00

Error : ORA-02191: correct syntax is: SET TRANSACTION USE ROLLBACK SEGMENT

Cause : There is a syntax error in the user's statement.

Action : Correct the syntax as indicated.

Please leave your valuable comments below :-)

ORA-02192: PCTINCREASE not allowed for rollback segment storage clauses

2009-12-10T06:03:00.000-08:00

Error : ORA-02192: PCTINCREASE not allowed for rollback segment storage clauses

Cause : pctincrease was specified in a create or alter rollback segment

Action : reissue statement without the pctincrease clause

Please leave your valuable comments below :-)

ORA-02187: invalid quota specification

2009-12-10T06:01:00.001-08:00

Error : ORA-02187: invalid quota specification

Cause : In a grant or revoke statement, the user attempted to grant a tablespace quota above the upper limit.

Action : Grant a smaller tablespace quota.

Please leave your valuable comments below :-)

ORA-02189: ON tablespace_name required

2009-12-10T06:01:00.000-08:00

Error : ORA-02189: ON tablespace_name required

Cause : In a grant or revoke statement, the user specified a tablespace quota but did not follow it with the ON clause.

Action : Specify the tablespace on which the quota is to be applied with the ON clause.

Please leave your valuable comments below :-)

ORA-02186: tablespace resource privilege may not appear with other privileges

2009-12-10T06:00:00.000-08:00

Error : ORA-02186: tablespace resource privilege may not appear with other privileges

Cause : An attempt was made to grant or revoke a resource quota in the same statement in which other privileges are granted or revoked.

Action : Use a separate grant or revoke statement for the resource quota privilege.

Please leave your valuable comments below :-)

ORA-02184: resource quotas are not allowed in REVOKE

2009-12-10T05:59:00.000-08:00

Error : ORA-02184: resource quotas are not allowed in REVOKE

Cause : In a revoke statement, a resource quota was specified.

Action : Specify resource privilege without the quota.

Please leave your valuable comments below :-)

ORA-02156: invalid TEMPORARY tablespace identifier

2009-12-10T05:48:00.000-08:00

Error : ORA-02156: invalid TEMPORARY tablespace identifier

Cause : An identifier does not follow TEMPORARY TABLESPACE.

Action : Place a tablespace name after TEMPORARY TABLESPACE.

Please leave your valuable comments below :-)

ORA-02031: no ROWID for fixed tables or for external-organized tables

2009-12-08T06:18:00.000-08:00

Error : ORA-02031: no ROWID for fixed tables or for external-organized tables

Cause : An attempt is being made to access rowid from a fixed table or from a external-organized table.

Action : Do not access ROWID from a fixed table or from a external-organized table.

Please leave your valuable comments below :-)

ORA-01932: ADMIN option not granted for role 'string'

2009-12-07T20:10:00.000-08:00

Error : ORA-01932: ADMIN option not granted for role 'string'

Cause : The operation requires the admin option on the role.

Action : Obtain the grant option and re-try.

Please leave your valuable comments below :-)

ORA-01873: the leading precision of the interval is too small

2009-12-07T18:46:00.000-08:00

Error : ORA-01873: the leading precision of the interval is too small

Cause : The leading precision of the interval is too small to store the specified interval.

Action : Increase the leading precision of the interval or specify an interval with a smaller leading precision.

Please leave your valuable comments below :-)

ORA-01867: the interval is invalid

2009-12-07T18:42:00.000-08:00

Error : ORA-01867: the interval is invalid

Cause : The character string you specified is not a valid interval.

Action : Please specify a valid interval.

Please leave your valuable comments below :-)

ORA-01779: cannot modify a column which maps to a non key-preserved table

2009-12-07T18:29:00.000-08:00

Error : ORA-01779: cannot modify a column which maps to a non key-preserved table

Cause : An attempt was made to insert or update columns of a join view which map to a non-key-preserved table.

Action : Modify the underlying base tables directly.

Please leave your valuable comments below :-)

ORA-01774: Dump undo option specified more than once

2009-12-07T18:28:00.001-08:00

Error : ORA-01774: Dump undo option specified more than once

Cause : The same option for ALTER DUMP UNDO was specified twice.

Action : Remove the redundant options and reissue the command.

Please leave your valuable comments below :-)

ORA-01776: cannot modify more than one base table through a join view

2009-12-07T18:28:00.000-08:00

Error : ORA-01776: cannot modify more than one base table through a join view

Cause : Columns belonging to more than one underlying table were either inserted into or updated.

Action : Phrase the statement as two or more separate statements.

Please leave your valuable comments below :-)

ORA-01771: illegal option for a clustered table

2009-12-07T18:27:00.001-08:00

Error : ORA-01771: illegal option for a clustered table

Cause : During a CREATE or ALTER of a clustered table, the user attempted to enter one or more of the following options: INITRANS, MAXTRANS, PCTFREE, PCTUSED, STORAGE, TABLESPACE. These options may only be specified for the cluster itself.

Action : Remove the illegal option(s).

Please leave your valuable comments below :-)

ORA-01772: Must specify a value for LEVEL

2009-12-07T18:27:00.000-08:00

Error : ORA-01772: Must specify a value for LEVEL

Cause : Expecting the value of LEVEL but something else was specified.

Action : Correct the error and reissue the command.

Please leave your valuable comments below :-)

ORA-01721: USERENV(COMMITSCN) invoked more than once in a transaction

2009-12-07T18:13:00.000-08:00

Error : ORA-01721: USERENV(COMMITSCN) invoked more than once in a transaction

Cause : The USERENV('COMMITSCN') function can only be used once in a transaction.

Action : Re-write the transactioin to use USERENV('COMMITSCN') only once

Please leave your valuable comments below :-)

ORA-01718: BY ACCESS | SESSION clause not allowed for NOAUDIT

2009-12-07T17:58:00.000-08:00

Error : ORA-01718: BY ACCESS SESSION clause not allowed for NOAUDIT

Cause : Attempt to specify BY ACCESS SESSION in a NOAUDIT statement.

Action : Remove BY ACCESS SESSION.

Please leave your valuable comments below :-)

ORA-01704: string literal too long

2009-12-07T06:16:00.000-08:00

Error : ORA-01704: string literal too long

Cause : The string literal is longer than 4000 characters.

Action : Use a string literal of at most 4000 characters. Longer values may only be entered using bind variables.

Please leave your valuable comments below :-)

ORA-01697: controlfile is for a clone database

2009-12-07T06:14:00.000-08:00

Error : ORA-01697: controlfile is for a clone database

Cause : Attempting to mount a clone database without the appropriate command option to designate a clone database.

Action : Use the clone option or appropriate commands, or mount with the primary controlfile.

Please leave your valuable comments below :-)

ORA-01691: unable to extend lob segment string.string by in tablespace

2009-12-07T06:07:00.000-08:00

Error : ORA-01691: unable to extend lob segment string.string by in tablespace

Cause : Failed to allocate an extent for lob segment in tablespace.

Action : Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.

Please leave your valuable comments below :-)

ORA-01684: max # extents (string) reached in table string.string partition

2009-12-07T06:01:00.000-08:00

Error : ORA-01684: max # extents (string) reached in table string.string partition

Cause : A table tried to extend past maxextents

Action : If maxextents is less than the system maximum, raise it. Otherwise, you must recreate with larger initial, next or pctincrease params

Please leave your valuable comments below :-)

ORA-01683: unable to extend index string.string partition by in tablespace

2009-12-07T05:59:00.000-08:00

Error : ORA-01683: unable to extend index string.string partition by in tablespace

Cause : Failed to allocate an extent for index segment in tablespace.

Action : Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.

Please leave your valuable comments below :-)

ORA-01678: parameter must be pairs of pattern and replacement strings

2009-12-07T05:54:00.000-08:00

Error : ORA-01678: parameter must be pairs of pattern and replacement strings

Cause : The initialization parameter does not have even number of strings for its value. The odd numbered strings are patterns to be found in file names. The even numbered strings are used to replace the corresponding patterns when found in file names.

Action :Specify even number of strings for the parameter, or omit the parameter.

Please leave your valuable comments below :-)

ORA-01670: new datafile needed for standby database recovery

2009-12-07T05:48:00.000-08:00

Error : ORA-01670: new datafile needed for standby database recovery

Cause : Standby database recovery noticed that a file was added to the primary database, but is not available on the standby.

Action : Either copy the file from the primary database or do an ALTER DATABASE CREATE DATAFILE command on the standby to create a file to recover.

Please leave your valuable comments below :-)

ORA-01662: tablespace 'string' is non-empty and cannot be made temporary

2009-12-07T05:41:00.000-08:00

Error : ORA-01662: tablespace 'string' is non-empty and cannot be made temporary

Cause : Tried to convert a non-empty tablespace to a temporary tablespace

Action : To drop all the objects in the tablespace.

Please leave your valuable comments below :-)

ORA-01659: unable to allocate MINEXTENTS beyond in tablespace

2009-12-07T05:37:00.000-08:00

Error : ORA-01659: unable to allocate MINEXTENTS beyond in tablespace

Cause : Failed to find sufficient contiguous space to allocate MINEXTENTS for the segment being created.

Action : Use ALTER TABLESPACE ADD DATAFILE to add additional space to the tablespace or retry with smaller value for MINEXTENTS, NEXT or PCTINCREASE

Please leave your valuable comments below :-)

ORA-01650: unable to extend rollback segment by in tablespace

2009-12-07T05:30:00.000-08:00

Error : ORA-01650: unable to extend rollback segment by in tablespace

Cause : Failed to allocate an extent for rollback segment in tablespace.

Action : Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.

Please leave your valuable comments below :-)

ORA-01648: log is the current log of disabled thread

2009-12-07T05:29:00.000-08:00

Error : ORA-01648: log is the current log of disabled thread

Cause : An attempt to enable the thread failed after it was half completed. This log was left as the current log even though the thread is still disabled. Since a log switch cannot be done until the thread is enabled, the log can not be cleared or archived.

Action :Complete the thread enable by issuing the enable command again.

Please leave your valuable comments below :-)

ORA-01645: previous attempt to make read write is half complete

2009-12-07T05:26:00.000-08:00

Error : ORA-01645: previous attempt to make read write is half complete

Cause : A failure while making the tablespace read write left it read only, but the checkpoint was advanced. The tablespace will not be useable after a resetlogs if its files are offline.

Action : Repeat the command to make the tablespace read write.

Please leave your valuable comments below :-)

ORA-01643: system tablespace can not be made read only

2009-12-07T05:25:00.000-08:00

Error : ORA-01643: system tablespace can not be made read only

Cause : Attempting to set the system tablespace to read only. The system tablespace must remain read write for database operation.

Action : Leave system tablespace read write.

Please leave your valuable comments below :-)

ORA-01621: cannot rename member of current log if database is open

2009-12-06T21:16:00.000-08:00

Error : ORA-01621: cannot rename member of current log if database is open

Cause : This is a rename command for a member of the current log for an open thread. If the database is open anywhere, the log may be in use, so the rename cannot be done.

Action : Wait until the log is not current, or mount the database exclusively.

Please leave your valuable comments below :-)

ORA-01604: illegal number range in clause "string" of

2009-12-06T20:55:00.000-08:00

Error : ORA-01604: illegal number range in clause "string" of

Cause : The number range was invalid for this parameter.

Action : Correct the INIT.ORA parameter and restart the instance.

Please leave your valuable comments below :-)

ORA-01755: Must specify an extent number or block number

2009-12-06T18:23:00.000-08:00

Error : ORA-01755: Must specify an extent number or block number

Cause : Expecting an extent or block number but something else was specified.

Action : Correct the error and reissue the command.

Please leave your valuable comments below :-)

ORA-01751: Invalid dump undo option

2009-12-06T18:21:00.001-08:00

Error : ORA-01751: Invalid dump undo option

Cause : An invalid option is specified in the ALTER DUMP UNDO command.

Action : Correct and reissue the command.

Please leave your valuable comments below :-)

ORA-01752: cannot delete from view without exactly one key-preserved table

2009-12-06T18:21:00.000-08:00

Error : ORA-01752: cannot delete from view without exactly one key-preserved table

Cause : The deleted table either had no key perserved tables, had more than one key-preserved table, or the key-preserved table was an unmerged view or a table from a read-only view.

Action : Redefine the view or delete it from the underlying base tables.

Please leave your valuable comments below :-)

ORA-01742: comment not terminated properly

2009-12-06T18:20:00.001-08:00

Error : ORA-01742: comment not terminated properly

Cause : The indicated comment or hint begun with the /* token did not have the terminating */.

Action : Properly terminate the comment or hint with a */.

Please leave your valuable comments below :-)

ORA-01743: only pure functions can be indexed

2009-12-06T18:20:00.000-08:00

Error : ORA-01743: only pure functions can be indexed

Cause : The indexed function uses SYSDATE or the user environment.

Action : PL/SQL functions must be pure (RNDS, RNPS, WNDS, WNPS). SQL expressions must not use SYSDATE, USER, USERENV(), or anything else dependent on the session state. NLS-dependent functions are OK.

Please leave your valuable comments below :-)

ORA-01737: valid modes: [ROW] SHARE, [[SHARE] ROW] EXCLUSIVE, SHARE UPDATE

2009-12-06T18:15:00.000-08:00

Error : ORA-01737: valid modes: [ROW] SHARE, [[SHARE] ROW] EXCLUSIVE, SHARE UPDATE

Cause : The lock mode entered was not recognized

Action : Valid lock modes are SHARE, ROW SHARE, EXCLUSIVE, ROW EXCLUSIVE, SHARE ROW EXCLUSIVE, and SHARE UPDATE.

Please leave your valuable comments below :-)

ORA-01725: USERENV('COMMITSCN') not allowed here

2009-12-06T18:14:00.001-08:00

Error : ORA-01725: USERENV('COMMITSCN') not allowed here

Cause : The function USERNEV('COMMMITSCN') is only allowed as a top-level expression in the VALUES clause of an INSERT statements, and on the right hand side of an assignment in an UPDATE statement.

Action : Correct the use of the function.

Please leave your valuable comments below :-)

ORA-01734: illegal parameters - EXTENT MIN higher than EXTENT MAX

2009-12-06T18:14:00.000-08:00

Error : ORA-01734: illegal parameters - EXTENT MIN higher than EXTENT MAX

Cause : A wrong value is specified for the parameter.

Action : Correct the parameter and reissue the statement.

Please leave your valuable comments below :-)

ORA-01724: floating point precision is out of range (1 to 126)

2009-12-06T18:13:00.000-08:00

Error : ORA-01724: floating point precision is out of range (1 to 126)

Cause : Self-evident.

Action : Self-evident.

Please leave your valuable comments below :-)

ORA-01720: grant option does not exist for 'string.string'

2009-12-06T18:12:00.000-08:00

Error : ORA-01720: grant option does not exist for 'string.string'

Cause : A grant was being performed on a view and the grant option was not present for an underlying object.

Action : Obtain the grant option on all underlying objects of the view.

Please leave your valuable comments below :-)

ORA-01719: outer join operator (+) not allowed in operand of OR or IN

2009-12-06T17:59:00.000-08:00

Error : ORA-01719: outer join operator (+) not allowed in operand of OR or IN

Cause : An outer join appears in an or clause.

Action : If A and B are predicates, to get the effect of (A(+) or B), try (select where (A(+) and not B)) union all (select where (B)).

Please leave your valuable comments below :-)

ORA-01531: a database already open by the instance

2009-12-06T07:38:00.000-08:00

Error : ORA-01531: a database already open by the instance

Cause : During ALTER DATABASE, an attempt was made to open a database on an instance for which there is already an open database.

Action : If you wish to open a new database on the instance, first shutdown the instance and then startup the instance and retry the operation.

Please leave your valuable comments below :-)

ORA-01350: must specify a tablespace name

2009-12-06T06:09:00.000-08:00

Error : ORA-01350: must specify a tablespace name

Cause : Invocation failed to specify either a dictionary tablespace or a spill tablespace.

Action : Reformat invocation of DBMS_LOGMNR_D.SET_TABLESPACE to include the name of one or more tablespaces.

NEW_TABLESPACE - a string naming an existing tablespace. Supply only this parameter to recreate all Logminer tables to employ this tablespace.

DICTIONARY_TABLESPACE - a string naming an existing tablespace. Supply this parameter when it is desired to place Logminer Dictionary data in a tablespace different from that where Logminer spill data is to be written. This parameter overrides the new_tablespace parameter with respect to Logminer Dictionary tables.

SPILL_TABLESPACE - a string naming an existing tablespace. Supply this parameter when it is desired to place Logminer spill data in a tablespace different from that where Logminer Dictionary data is to be written. This parameter overrides the new_tablespace parameter with respect to Logminer spill tables.

Please leave your valuable feedback via comments :-)

ORA-01347: Supplemental log data no longer found

2009-12-06T06:08:00.000-08:00

Error : ORA-01347: Supplemental log data no longer found

Cause : The source database instance producing log files for this LogMiner session was altered to no longer log supplemental data.

Action : Destroy this Logminer session. Re-enable supplemental log data on the source system and create a new LogMiner session.

Please leave your valuable feedback via comments :-)

ORA-01685: max # extents (string) reached in index string.string partition

2009-12-06T06:02:00.000-08:00

Error : ORA-01685: max # extents (string) reached in index string.string partition

Cause : An index tried to extend past maxextents

Action : If maxextents is less than the system max, raise it. Otherwise, you must recreate with larger initial, next or pctincrease params.

Please leave your valuable comments below :-)

ORA-01682: read-only DB cannot allocate temporary space in tablespace

2009-12-06T05:58:00.000-08:00

Error : ORA-01682: read-only DB cannot allocate temporary space in tablespace

Cause : Temporary space (usually for sorting) could not be allocated in either main storage or a tempfile. An attempt was made to allocate the space from the tablespace named, but the database is opened read-only. The database open requires a sort work space.

Action : Either allow sufficient workspace in main storage (SORT_AREA_SIZE initialization parameter), or create a temporary tablespace before making the database read-only. Use ALTER TABLESPACE ADD TEMPFILE statement to add temporary files to the temporary tablespace.

Please leave your valuable comments below :-)

ORA-01679: database must be mounted EXCLUSIVE and not open to activate

2009-12-06T05:55:00.000-08:00

Error : ORA-01679: database must be mounted EXCLUSIVE and not open to activate

Cause : An attempt to activate a standby database was made when the database was not mounted EXCLUSIVE or was already open.

Action : Mount the database EXCLUSIVE and retry the ACTIVATE command.

Please leave your valuable comments below :-)

ORA-01676: standby file name convert of 'string' exceeds maximum length of

2009-12-06T05:53:00.001-08:00

Error : ORA-01676: standby file name convert of 'string' exceeds maximum length of

Cause : When the given file name is converted to the name used for the standby database, the converted name is bigger than the maximum allowed file name.

Action : Change initialization parameter DB_FILE_STANDBY_NAME_CONVERT or LOG_FILE_STANDBY_NAME_CONVERT to convert to a valid file name.

Please leave your valuable comments below :-)

ORA-01677: standby file name convert parameters differ from other instance

2009-12-06T05:53:00.000-08:00

Error : ORA-01677: standby file name convert parameters differ from other instance

Cause : The DB_FILE_STANDBY_NAME_CONVERT or LOG_FILE_STANDBY_NAME_CONVERT initialization parameters are not the same as in other instances that already have the database mounted.

Action : Change initialization parameters DB_FILE_STANDBY_NAME_CONVERT and LOG_FILE_STANDBY_NAME_CONVERT to match other instances.

Please leave your valuable comments below :-)

ORA-01675: max_commit_propagation_delay inconsistent with other instances

2009-12-06T05:52:00.000-08:00

Error : ORA-01675: max_commit_propagation_delay inconsistent with other instances

Cause : The max_commit_propagation_delay INIT.ORA parameter is inconsistent with those in other instances.

Action : Make sure all instances have the same max_commit_propagation_delay.

Please leave your valuable comments below :-)

ORA-01674: data file string is an old incarnation rather than current file

2009-12-06T05:51:00.000-08:00

Error : ORA-01674: data file string is an old incarnation rather than current file

Cause : Recovery encountered redo that indicates this file was dropped from the database and another file was added using the same file number. This implies that a CREATE CONTROLFILE command was given the old file which was dropped rather than the latest file.

Action : Rebuild the controlfile using CREATE CONTROLFILE, and give the correct file.

Please leave your valuable comments below :-)

ORA-01673: data file has not been identified

2009-12-06T05:50:00.000-08:00

Error : ORA-01673: data file has not been identified

Cause : This data file was not in the controlfile after an incomplete recovery or CREATE CONTROLFILE. Since information from its header is needed for standby database recovery, we can not create a standby controlfile.

Action : Find the file and bring it online. If desired it may be taken offline again. If you intend to drop this file, then taking it offline with the DROP option will avoid this error.

Please leave your valuable comments below :-)

ORA-01671: controlfile is a backup, cannot make a standby controlfile

2009-12-06T05:49:00.001-08:00

Error : ORA-01671: controlfile is a backup, cannot make a standby controlfile

Cause : The currently mounted controlfile is a backup controlfile, and attempting to create a controlfile for a standby database.

Action : Complete any needed recovery and open the database with the resetlogs option.

Please leave your valuable comments below :-)

ORA-01672: controlfile may be missing files or have extra ones

2009-12-06T05:49:00.000-08:00

Error : ORA-01672: controlfile may be missing files or have extra ones

Cause : Attempting to create a standby controlfile, but the controlfile was either recently created via CREATE CONTROLFILE or an incomplete recovery has been done. Thus the datafiles in the controlfile and the ones in the data dictionary may not match.

Action : Open the database, then retry the operation.

Please leave your valuable comments below :-)

ORA-01668: standby database requires DROP option for offline of data file

2009-12-06T05:47:00.001-08:00

Error : ORA-01668: standby database requires DROP option for offline of data file

Cause : Attempting to take a datafile offline in a standby database without specifying the DROP option. Files that are offline in a standby database are not recovered, and are likely to be unusable if the standby is activated. Note that specifying DROP does not prevent bringing the file online later.

Action : Specify the DROP option or leave the file online.

Please leave your valuable comments below :-)

ORA-01669: standby database controlfile not consistent

2009-12-06T05:47:00.000-08:00

Error : ORA-01669: standby database controlfile not consistent

Cause : Attempting to activate a standby database with a controlfile that has not been recovered to the same point as the data files. Most likely the controlfile was just copied from the primary database and has not been used for recovery.

Action : Recover the standby database until all the files are consistent.

Please leave your valuable comments below :-)

ORA-01666: controlfile is for a standby database

2009-12-06T05:46:00.001-08:00

Error : ORA-01666: controlfile is for a standby database

Cause : Attempting to mount, recover, or open a standby database without the appropriate command option to designate a standby database.

Action : Use the standby option or appropriate commands, or mount with the primary controlfile.

Please leave your valuable comments below :-)

ORA-01667: cannot add any more tablespaces: limit of exceeded

2009-12-06T05:46:00.000-08:00

Error : ORA-01667: cannot add any more tablespaces: limit of exceeded

Cause : There is no more room in the controlfile for adding tablespaces.

Action : Resize the controlfile or drop other tablespaces.

Please leave your valuable comments below :-)

ORA-01664: Transaction which has expanded the Sort Segment has aborted

2009-12-06T05:43:00.001-08:00

Error : ORA-01664: Transaction which has expanded the Sort Segment has aborted

Cause : Internal Error.

Action : Contact Oracle Support.

Please leave your valuable comments below :-)

ORA-01665: controlfile is not a standby controlfile

2009-12-06T05:43:00.000-08:00

Error : ORA-01665: controlfile is not a standby controlfile

Cause : Attempting to mount, recover or activate a standby database without a standby controlfile.

Action : Create a standby controlfile before attempting to use the database as a standby database.

Please leave your valuable comments below :-)

ORA-01663: the contents of tablespace 'string' is constantly changing

2009-12-06T05:42:00.000-08:00

Error : ORA-01663: the contents of tablespace 'string' is constantly changing

Cause : The contents of the tablespace is always changing between PERMANENT and TEMPORARY.

Action : To decide what the tablespace contents should be and stay with it.

Please leave your valuable comments below :-)

ORA-01661: tablespace 'string' is already temporary

2009-12-06T05:40:00.000-08:00

Error : ORA-01661: tablespace 'string' is already temporary

Cause : Attempting to make tablespace temporary that is already temporary.

Action : Leave tablespace permanent.

Please leave your valuable comments below :-)

ORA-01660: tablespace 'string' is already permanent

2009-12-06T05:37:00.000-08:00

Error : ORA-01660: tablespace 'string' is already permanent

Cause : Attempting to make tablespace permanent that is already permanent.

Action : Leave tablespace permanent.

Please leave your valuable comments below :-)

ORA-01658: unable to create INITIAL extent for segment in tablespace

2009-12-06T05:36:00.000-08:00

Error : ORA-01658: unable to create INITIAL extent for segment in tablespace

Cause : Failed to find sufficient contiguous space to allocate INITIAL extent for segment being created.

Action : Use ALTER TABLESPACE ADD DATAFILE to add additional space to the tablespace or retry with a smaller value for INITIAL

Please leave your valuable comments below :-)

ORA-01656: max # extents (string) reached in cluster

2009-12-06T05:35:00.001-08:00

Error : ORA-01656: max # extents (string) reached in cluster .

Cause : A cluster tried to extend past maxextents

Action : If maxextents is less than the system maximum, raise it. Otherwise, you must recreate with larger initial, next or pctincrease params

Please leave your valuable comments below :-)