ORA-00385: | cannot enable Very Large Memory with new buffer cache parameters |
Cause: | User specified one or more of { db_cache_size , db_recycle_cache_size, db_keep_cache_size, db_nk_cache_size (where n is one of 2,4,8,16,32) } AND use_indirect_data_buffers is set to TRUE. This is illegal. |
Action: | Very Large Memory can only be enabled with the old (pre-Oracle_8.2) parameters. |
Conexoes de Rede - Blog oracle error ,net work, ora code, pl sql for, security it, firebird, mysql,router and switch cisco, linux,windows server, wireless, how to, open source, performance oracle, tunning, switching, realtek, certification, ccna
oracle error- ORA-00385: cannot enable Very Large Memory with new buffer cache parameters
Marcadores:
banco de dados,
database,
error oracle,
ora,
oracle,
oracle error,
oracode
ORA-00384: Insufficient memory to grow cache
ORA-00384: | Insufficient memory to grow cache |
Cause: | The system could not allocate sufficient memory to grow the cache to the specified size. |
Action: | Attempt a smaller increase in the value of the parameter. |
Marcadores:
banco de dados,
database,
error oracle,
ora,
oracle,
oracle error,
oracode
oracle error- ORA-00383: DEFAULT cache for blocksize string cannot be reduced to zero
ORA-00383: | DEFAULT cache for blocksize string cannot be reduced to zero |
Cause: | User attempted to reduce db_cache_size to zero, or attempted to to reduce db_<n>K_cache_size to zero while there were still online tablespaces with blocksize <n>K. Note that since the SYSTEM tablespace cannot be taken offline, it is always illegal to set db_cache_size to zero. |
Action: | Offline any tablespaces with the corresponding blocksize and then perform the operation again. |
Marcadores:
banco de dados,
database,
error oracle,
ora,
oracle,
oracle error,
oracode
oracle error- ORA-00382: %s not a valid block size, valid range [string..string]
ORA-00382: | %s not a valid block size, valid range [string..string] |
Cause: | User specified a value for db_nk_cache_size where n is one of {2, 4, 8, 16, 32}, but nk is not a valid block size for this platform. |
Action: | Remove corresponding parameter from the "init.ora" file and restart the instance. |
Marcadores:
banco de dados,
database,
error oracle,
ora,
oracle,
oracle error,
oracode
oracle error- ORA-00381: cannot use both new and old parameters for buffer cache size specification
ORA-00381: | cannot use both new and old parameters for buffer cache size specification |
Cause: | User specified one or more of { db_cache_size , db_recycle_cache_size, db_keep_cache_size, db_nk_cache_size (where n is one of 2,4,8,16,32), db_cache_advice } AND one or more of { db_block_buffers, buffer_pool_keep , buffer_pool_recycle }. This is illegal. |
Action: | Use EITHER the old (pre-Oracle_8.2) parameters OR the new ones. Don't specify both. If old size parameters are specified in the parameter file, you may want to replace them with new parameters since the new parameters can be modified dynamically and allow you to configure additional caches for additional block sizes. Cache advisory can only be enabled with the new cache parameters. |
Marcadores:
banco de dados,
database,
error oracle,
ora,
oracle,
oracle error,
oracode
oracle error- ORA-00380: cannot specify db_stringk_cache_size since stringK is the standard block size
ORA-00380: | cannot specify db_stringk_cache_size since stringK is the standard block size |
Cause: | User specified the parameter db_nk_cache_size (where n is one of 2,4,8,16,32), while the standard block size for this database is equal to n Kbytes. This is illegal. |
Action: | Specify the standard block size cache using db_cache_size (DEFAULT pool) (and db_recycle_cache_size, db_keep_cache_size if additional buffer pools are required). Do NOT use the corresponding db_nk_cache_size parameter for the standard block size. |
Marcadores:
banco de dados,
database,
error oracle,
ora,
oracle,
oracle error,
oracode
oracle error- ORA-00379: no free buffers available in buffer pool string for block size stringK
ORA-00379: | no free buffers available in buffer pool string for block size stringK |
Cause: | All buffers in the specified buffer pool for the specified block size are in use and no free buffers are available. |
Action: | Increase the number of buffers in the specified pool for the specified block size |
Marcadores:
banco de dados,
database,
error oracle,
ora,
oracle,
oracle error,
oracode
oracle error- ORA-00378: buffer pools cannot be created as specified
ORA-00378: | buffer pools cannot be created as specified |
Cause: | Either the number of buffers or the number of lru latches is too small to satisfy the specified buffer pool configuration. |
Action: | Either increase the number of buffers and/or number of lru latches or configure smaller buffer pools. |
Marcadores:
banco de dados,
database,
error oracle,
ora,
oracle,
oracle error,
oracode
oracle error- ORA-00377: Frequent backups of file string causing write operation to stall
ORA-00377: | Frequent backups of file string causing write operation to stall |
Cause: | Backups are occurring too frequently on this file. Each time a new backup is started for a file, any writes which have been previously issued (but not completed) have to be re-issued. If hot backups are started very, very frequently, it is possible that some writes will be re-issued repeatedly and never complete. |
Action: | Increase the interval between begin hot-backup commands for this file. |
Marcadores:
banco de dados,
database,
error oracle,
ora,
oracle,
oracle error,
oracode
oracle error- ORA-00376: file string cannot be read at this time
ORA-00376: | file string cannot be read at this time |
Cause: | attempting to read from a file that is not readable. Most likely the file is offline. |
Action: | Check the state of the file. Bring it online |
Marcadores:
banco de dados,
database,
error oracle,
ora,
oracle,
oracle error,
oracode
oracle error- ORA-00375: unable to get default db_block_size
ORA-00375: | unable to get default db_block_size |
Cause: | the system was unable to determine the default db_block_size |
Action: | see accompanying system specific error. As a workaround, specify the blocksize in the INIT.ORA file. |
Marcadores:
banco de dados,
database,
error oracle,
ora,
oracle,
oracle error,
oracode
oracle error- ORA-00373: online log version string incompatible with ORACLE version string
ORA-00373: | online log version string incompatible with ORACLE version string |
Cause: | The online log was written by incompatible version of Oracle. Can occur when the log file was created by either a new or older version of Oracle. |
Action: | Recover the database with the compatible software, shut it down cleanly, then restart with current software. |
Marcadores:
banco de dados,
database,
error oracle,
ora,
oracle,
oracle error,
oracode
oracle error- ORA-00372: file string cannot be modified at this time
ORA-00372: | file string cannot be modified at this time |
Cause: | attempting to modify the contents of a file that cannot be modified. The file is most likely part of a read only tablespace but may be in the process of going offline, or the database may be in the process of closing. |
Action: | check the status of the file and its tablespace |
Marcadores:
banco de dados,
database,
error oracle,
ora,
oracle,
oracle error,
oracode
oracle error- ORA-00371: not enough shared pool memory, should be atleast string bytes
ORA-00371: | not enough shared pool memory, should be atleast string bytes |
Cause: | Init.ora parameter shared_pool_size is too small |
Action: | Increase the parameter value |
Marcadores:
banco de dados,
database,
error oracle,
ora,
oracle,
oracle error,
oracode
oracle error- ORA-00370: potential deadlock during kcbchange operation
ORA-00370: | potential deadlock during kcbchange operation |
Cause: | Error code used internally by software. Should never be reported |
Action: | Treat as internal error. See error 600. |
Marcadores:
banco de dados,
database,
error oracle,
ora,
oracle,
oracle error,
oracode
oracle error- ORA-00369: Current log of thread string not useable and other log being cleared
ORA-00369: | Current log of thread string not useable and other log being cleared |
Cause: | Attempt to open thread failed because it is necessary to switch redo generation to another online log, but all the other logs are being cleared or need to be archived before they can be used. |
Action: | If the ALTER DATABASE CLEAR LOGFILE command is still active then wait for it to complete. Otherwise reissue the CLEAR command. If there are other online logs for the thread, that are not being cleared, then archive the logs. |
Marcadores:
banco de dados,
database,
error oracle,
ora,
oracle,
oracle error,
oracode
oracle error- ORA-00368: checksum error in redo log block
ORA-00368: | checksum error in redo log block |
Cause: | The redo block indicated by the accompanying error, is not vaild. It has a checksum that does not match the block contents. |
Action: | Restore correct file or reset logs. |
Marcadores:
banco de dados,
database,
error oracle,
ora,
oracle,
oracle error,
oracode
oracle error- ORA-00366: log string of thread string, checksum error in the file header
ORA-00366: | log string of thread string, checksum error in the file header |
Cause: | The file header for the redo log contains a checksum that does not match the value calculated from the file header as read from disk. This means the file header is corrupted |
Action: | Find and install correct version of log or reset logs. |
Marcadores:
banco de dados,
database,
error oracle,
ora,
oracle,
oracle error,
oracode
oracle error- ORA-00365: the specified log is not the correct next log
ORA-00365: | the specified log is not the correct next log |
Cause: | The specified log failed to pass checks to ensure it corresponds to the log that was just applied. This is probably the result of using a log that was generated against a cold backup image of the database. |
Action: | Find the log that was generated by this copy of the database and give that filename to recovery. |
Marcadores:
banco de dados,
database,
error oracle,
oracle,
oracle error
oracle error- ORA-00364: cannot write header to new log member
ORA-00364: | cannot write header to new log member |
Cause: | An i/o error occurred when attempting to write the header to a log member that is being added to an existing group. |
Action: | See accompanying errors. Fix problem or use another file. |
Marcadores:
banco de dados,
database,
error oracle,
oracle,
oracle error
oracle error- ORA-00363: log is not the archived version
ORA-00363: | log is not the archived version |
Cause: | d by failing to list the current log of an enabled thread in a CREATE CONTROLFILE command. |
Action: | Find the archived version of the log and supply its name. If this is media recovery immediately following a CREATE CONTROLFILE, be sure the current log for this thread was included. |
Marcadores:
banco de dados,
database,
error oracle,
oracle,
oracle error
oracle error- ORA-00362: member is required to form a valid logfile in group string
ORA-00362: | member is required to form a valid logfile in group string |
Cause: | A request to drop a logfile member was denied because it would remove data required to form a complete logfile. |
Action: | If desired, delete the entire log (after archiving if required), by using DROP LOGFILE; |
Marcadores:
banco de dados,
database,
error oracle,
oracle,
oracle error
oracle error- ORA-00361: cannot remove last log member string for group string
ORA-00361: | cannot remove last log member string for group string |
Cause: | An attempt has been made to remove the last member of a log file group. |
Action: | If desired, delete the entire log, by using DROP LOGFILE. |
Marcadores:
banco de dados,
database,
error oracle,
oracle,
oracle error
oracle error- ORA-00360: not a logfile member: string
ORA-00360: | not a logfile member: string |
Cause: | A filename was given to drop logfile member that is not a part of the database, or which is a data file. |
Action: | Supply a valid logfile member name. |
Marcadores:
banco de dados,
database,
error oracle,
oracle,
oracle error
oracle error- ORA-00359: logfile group string does not exist
ORA-00359: | logfile group string does not exist |
Cause: | An add logfile member or drop logfile request specified a logfile group number that does not exist. |
Action: | Check the configuration of the log files and reissue the command. |
Marcadores:
banco de dados,
database,
error oracle,
oracle,
oracle error
oracle error- ORA-00358: Too many file members specified, the maximum is string
ORA-00358: | Too many file members specified, the maximum is string |
Cause: | A create or alter statement specified too many members in a parenthesised file list. |
Action: | Specify a number of file members that is within the port-defined limit. |
Marcadores:
banco de dados,
database,
error oracle,
oracle,
oracle error
oracle error- ORA-00357: too many members specified for log file, the maximum is string
ORA-00357: | too many members specified for log file, the maximum is string |
Cause: | An add logfile or add logfile member command would result in a log with too many members. The number of members is set when the database is created. |
Action: | Use fewer log file members. |
Marcadores:
banco de dados,
database,
error oracle,
oracle,
oracle error
oracle error- ORA-00356: inconsistent lengths in change description
ORA-00356: inconsistent lengths in change description
Cause:A change record in the redo log contains lengths that do not add up to a consistent value. The log is corrupted in some way.
Action:Do recovery with a good version of the log or do time based recovery up to the indicated time.
Marcadores:
banco de dados,
database,
error oracle,
oracle,
oracle error
oracle error- ORA-00355: change numbers out of order
ORA-00355: | change numbers out of order |
Cause: | A change number found in the redo log is lower than a previously encountered change number. The log is corrupted in some way. The corruption may be at the earlier change or at this one. |
Action: | Do recovery with a good version of the log or do time based recovery up to the indicated time. |
Marcadores:
banco de dados,
database,
error oracle,
oracle,
oracle error
oracle error- ORA-00354: corrupt redo log block header
ORA-00354: | corrupt redo log block header |
Cause: | The block header on the redo block indicated by the accompanying error, is not reasonable. |
Action: | Do recovery with a good version of the log or do time based recovery up to the indicated time. If this happens when archiving, archiving of the problem log can be skipped by clearing the log with the UNARCHIVED option. This must be followed by a backup of every datafile to insure recoverability of the database. |
Marcadores:
banco de dados,
database,
error oracle,
oracle,
oracle error
oracle error- ORA-00353: log corruption near block string change string time string
ORA-00353: | log corruption near block string change string time string |
Cause: | Some type of redo log corruption has been discovered. This error describes the location of the corruption. Accompanying errors describe the type of corruption. |
Action: | Do recovery with a good version of the log or do incomplete recovery up to the indicated change or time. |
Marcadores:
banco de dados,
database,
error oracle,
oracle,
oracle error
oracle error- ORA-00352: all logs for thread string need to be archived - cannot enable
ORA-00352: | all logs for thread string need to be archived - cannot enable |
Cause: | Attempting to enable a thread with all logs needing to be archived, and media recovery has been enabled. There is no log that can be made the new current log for the thread. |
Action: | Archive a log for the thread or disable media recovery. |
Marcadores:
banco de dados,
database,
error oracle,
oracle,
oracle error
oracle error- ORA-00351: recover-to time invalid
ORA-00351: | recover-to time invalid |
Cause: | The time specified in a recover-until statement must be after January 1st 1988. |
Action: | Specify a time after January 1st 1988. |
Marcadores:
banco de dados,
database,
error oracle,
oracle,
oracle error
oracle error- ORA-00350: log string of instance string (thread string) needs to be archived
ORA-00350: | log string of instance string (thread string) needs to be archived |
Cause: | The command cannot be done because the log has not been archived, and media recovery has been enabled. |
Action: | Archive the log or disable media recovery. If the command supports an UNARCHIVED option then it can be used. However this may result in making backups unuseable, and forcing the drop of some offline files. |
Marcadores:
banco de dados,
database,
error oracle,
oracle,
oracle error
oracle error- ORA-00349: failure obtaining block size for 'string'
ORA-00349: failure obtaining block size for 'string'
Cause:The operating system was unable to determine the blocksize for the given filename.
Action:Consult the accompanying error message, and correct the device or specify another filename.
Marcadores:
banco de dados,
database,
error oracle,
oracle,
oracle error
oracle error- ORA-00348: single-process redo failure. Must abort instance
ORA-00348: single-process redo failure. Must abort instance
Cause:A failure occurred during a critical portion of the log code during single process operation. This error does not occur during normal multi-process operation.
Action:Shutdown abort and warmstart the database.
Marcadores:
banco de dados,
database,
error oracle,
oracle,
oracle error
oracle error-ORA-00374: parameter db_block_size = string invalid ; must be a multiple of string in the range [string..string]
ORA-00374: | parameter db_block_size = string invalid ; must be a multiple of string in the range [string..string] |
Cause: | invalid value for db_block_size parameter |
Action: | adjust parameter and restart |
Marcadores:
banco de dados,
database,
error oracle,
ora,
oracle,
oracle error,
oracode
oracle error- ORA-00367: checksum error in log file header
ORA-00367: | checksum error in log file header |
Cause: | The file header for the redo log contains a checksum that does not match the value calculated from the file header as read from disk. This means the file header is corrupted |
Action: | Find the correct file and try again. |
Marcadores:
banco de dados,
database,
error oracle,
ora,
oracle,
oracle error,
oracode
oracle error- ORA-00347: log string of thread string, expected block size string doesn't match string
ORA-00347: | log string of thread string, expected block size string doesn't match string |
Cause: | On header read the blocksize indicated in the control file did not match the blocksize contained in the log file. |
Action: | Restore correct file or reset logs. |
Marcadores:
banco de dados,
database,
error oracle,
oracle,
oracle error
oracle error- ORA-00346: log member marked as STALE
ORA-00346: | log member marked as STALE |
Cause: | A log file member no longer is complete. |
Action: | Correct the underlying problem by referring to the other error messages found with this one. |
Marcadores:
banco de dados,
database,
error oracle,
oracle,
oracle error
oracle error- ORA-00345: redo log write error block string count string
ORA-00345: | redo log write error block string count string |
Cause: | An IO error has occurred while writing the log |
Action: | Correct the cause of the error, and then restart the system. If the log is lost, apply media/incomplete recovery. |
Marcadores:
banco de dados,
database,
error oracle,
oracle,
oracle error
oracle error- ORA-00344: unable to re-create online log 'string'
ORA-00344: | unable to re-create online log 'string' |
Cause: | An I/O failure occurred when attempting to re-create an online as part of either ALTER DATABASE OPEN RESETLOGS or ALTER DATABASE CLEAR LOGFILE command. |
Action: | Correct the file/device as indicated by accompanying errors. |
Marcadores:
banco de dados,
database,
error oracle,
oracle,
oracle error
oracle error- ORA-00343: too many errors, log member closed
ORA-00343: | too many errors, log member closed |
Cause: | The maximum number of errors on this log member has been exceeded. |
Action: | Correct the underlying problem by referring to the other error messages found with this one. |
Marcadores:
banco de dados,
database,
error oracle,
oracle,
oracle error
oracle error- ORA-06502: PL/SQL: numeric or value error string
ORA-06502: PL/SQL: numeric or value error string
Cause: An arithmetic, numeric, string, conversion, or constraint error occurred. For example, this error occurs if an attempt is made to assign the value NULL to a variable declared NOT NULL, or if an attempt is made to assign an integer larger than 99 to a variable declared NUMBER(2).
Action: Change the data, how it is manipulated, or how it is declared so that values do not violate constraints.
Marcadores:
banco de dados,
database,
error oracle,
ora-06502,
oracle,
oracle error
oracle error- ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
ORA-12514: | TNS:listener does not currently know of service requested in connect descriptor |
Cause: | The listener received a request to establish a connection to a database or other service. The connect descriptor received by the listener specified a service name for a service (usually a database service) that either has not yet dynamically registered with the listener or has not been statically configured for the listener. This may be a temporary condition such as after the listener has started, but before the database instance has registered with the listener. |
Action: | - Wait a moment and try to connect a second time. - Check which services are currently known by the listener by executing: lsnrctl services <listener name> - Check that the SERVICE_NAME parameter in the connect descriptor of the net service name used specifies a service known by the listener. - If an easy connect naming connect identifier was used, check that the service name specified is a service known by the listener. - Check for an event in the listener.log file. |
Marcadores:
banco de dados,
database,
error oracle,
ora-12514,
oracle,
oracle error
oracle error- ORA-00342: archived log does not have expected resetlogs SCN string
ORA-00342: | archived log does not have expected resetlogs SCN string |
Cause: | Recovery was given a log that does not belong to current incarnation or one of the parent incarnation. There should be another log that contains the correct redo. |
Action: | Supply the correct log file. |
Marcadores:
banco de dados,
database,
error oracle,
oracle,
oracle error
oracle error- ORA-00338: log string of thread string is more recent than control file
ORA-00338: | log string of thread string is more recent than control file |
Cause: | The control file change sequence number in the log file is greater than the number in the control file. This implies that the wrong control file is being used. Note that repeatedly causing this error can make it stop happening without correcting the real problem. Every attempt to open the database will advance the control file change sequence number until it is great enough. |
Action: | Use the current control file or do backup control file recovery to make the control file current. Be sure to follow all restrictions on doing a backup control file recovery. |
Marcadores:
banco de dados,
database,
error oracle,
oracle,
oracle error
oracle error- ORA-00339: archived log does not contain any redo
ORA-00339: | archived log does not contain any redo |
Cause: | The archived log is not the correct log. It is a copy of a log file that has never been used for redo generation, or was an online log being prepared to be the current log. |
Action: | Restore the correct log file. |
Marcadores:
banco de dados,
database,
error oracle,
oracle,
oracle error
oracle error- ORA-00340: IO error processing online log string of thread string
ORA-00340: | IO error processing online log string of thread string |
Cause: | An IO error occurred on the named online log. |
Action: | Restore accessibility to file, or restore file from backup. |
Marcadores:
banco de dados,
database,
error oracle,
oracle,
oracle error
oracle error- ORA-00341: log string of thread string, wrong log # string in header
ORA-00341: | log string of thread string, wrong log # string in header |
Cause: | The internal information in an online log file does not match the control file. |
Action: | Restore correct file or reset logs. |
Marcadores:
banco de dados,
database,
error oracle,
oracle,
oracle error
oracle error- ORA-00337: log file 'string' does not exist and no size specified
ORA-00337: | log file 'string' does not exist and no size specified |
Cause: | An attempt to add a log found neither an existing file nor a size for creating the file. |
Action: | Specify a size for the log file. |
Marcadores:
banco de dados,
database,
error oracle,
oracle,
oracle error
oracle error- ORA-00336: log file size string blocks is less than minimum string blocks
ORA-00336: | log file size string blocks is less than minimum string blocks |
Cause: | The log file size as specified in create database is too small. |
Action: | Increase the log file size. |
Marcadores:
banco de dados,
database,
error oracle,
oracle,
oracle error
Subscribe to:
Posts (Atom)