Como modificar el formato de la fecha en la sessión actual.
alter session set nls_date_format ='dd/mm/yyyy hh24:mi:ss';
Alter session set nls_date_format='dd/mm/yy hh:mi:ss';
martes, 1 de noviembre de 2016
ORA Error . Listado Errores Oracle. ORA-19922 a ORA-21604
ORA-19922: there is no parent row with id string
and level string
Cause:
RMAN tried to add a new V$RMAN_STATUS row, but the parent row did not exist.
Action:
This is an internal error. Contact Oracle Support.
ORA-19923: the session for row with id string
is not active
Cause:
RMAN tried to update an V$RMAN_STATUS row but the process which owns this row
died.
Action:
This is an internal error. Contact Oracle Support.
ORA-19924: there are no row with id string
Cause:
RMAN tried to update an V$RMAN_STATUS row, but the row don't exist.
Action:
This is an internal error. Contact Oracle Support.
ORA-19926: Database cannot be converted at this
time
Cause:
Another CONVERT DATABASE operation is already in progress.
Action:
Retry CONVERT DATABASE command later.
ORA-19927: CONVERT DATABASE operation cannot
proceed
Cause:
An error occurred earlier during CONVERT DATABASE operation.
Action:
Retry CONVERT DATABASE command.
ORA-19930: file string has invalid
checkpoint SCN string
Cause:
When opening the file to be placed in a copy or backup set, to be inspected,
the file header was not recognized as a valid header because it contained a
invalid checkpoint SCN. The indicated file cannot be processed.
Action:
Ensure that the correct files are being specified for the catalog or backup
operation.
ORA-19931: file string has invalid creation
SCN string
Cause:
When opening the file to be placed in a copy or backup set, to be inspected,
the file header was not recognized as a valid header because it contained a
invalid creation SCN. The indicated file cannot be processed.
Action:
Ensure that the correct files are being specified for the catalog or backup
operation.
ORA-19932: control file is not clone or standby
Cause:
The operation failed because the control file was not mounted as standby or
clone.
Action:
Mount the database as standby or clone and retry.
ORA-19941: invalid blocksize in cross platform
datafile string
Cause:
Blocksize in header of datafile copy being converted at target was invalid.
Either datafile has not been made read/write with compatibility 10.0 or greater
at source database or datafile copy is corrupted.
Action:
Make a new datafile copy taken after tablespace has been made read/write with
compatibility 10.0 at source database and retry conversion.
ORA-19942: datafile copy string not created
with compatibility 10.0 or greater
Cause:
The specified datafile copy to be converted at the target was not produced
after making the tablespace in read/write mode with compatibility 10.0 or
greater at the source database.
Action:
Make a new datafile copy taken after tablespace has been made read/write with
compatibility 10.0 at source database and retry conversion.
ORA-19943: The current database incarnation changed
during backup
Cause:
The backup failed because the current database incarnation was changed during
the backup. One of the following events caused this incarnation change:
- The database
was opened using ALTER DATABASE OPEN RESETLOGS statement.
- RMAN command
RESET DATABASE TO INCARNATION was issued.
- If this
happened on physical standby database, then redo apply has applied redo data
from a new database incarnation.
Action:
Re-try the backup.
ORA-19951: cannot modify control file until DBNEWID
is completed
Cause:
An operation requiring to modify the control file was attempted, but a NID
change is in progress.
Action:
Wait until NID completes before attempting the operation.
ORA-19952: database should be mounted exclusively
Cause:
The database was started in parallel mode. To change the DBID, the database
must be mounted exclusively.
Action:
Shut down the database and start it in exclusive mode.
ORA-19953: database should not be open
Cause:
The database was open. To change the DBID, the database must be mounted
exclusively.
Action:
Shut down the database and mount it in exclusive mode.
ORA-19954: control file is not current
Cause:
The operation failed because a non-current, non-standby control file was
mounted.
Action:
Make the control file current and retry.
ORA-19955: only one open thread is allowed to
change the DBID
Cause:
The operation failed because there were active threads in the database. The
most likely cause is that the database crashed the last time it was shut down.
Action:
Ensure that all threads are closed before retrying the operation. Start and
open the database to perform crash recovery, then shut down with the NORMAL or
IMMEDIATE options to close it cleanly. Finally, try running the utility again.
ORA-19956: database should have no offline
immediate datafiles
Cause:
The operation failed because the database had one or more datafiles that were
in OFFLINE IMMEDIATE mode.
Action:
Drop the datafiles or recover them and bring them online.
ORA-19957: database should have no datafiles in
unknown state
Cause:
The operation failed because the database had one or more datafiles that were
in an unknown state.
Action:
Drop the datafiles or recover them and bring them online.
ORA-19958: potential deadlock involving DIAG
process
Cause:
DIAG requested a control file operation that may lead to a deadlock
Action:
Try last operation later when the control file is released
ORA-19960: Internal use only
Cause:
NID usage
Action:
None
ORA-19999: skip_row procedure was called
Cause:
The skip_row procedure was called which raises this error
Action:
Skip_row should only be called within a trigger or a procedure called by a
trigger.
ORA-20000: string
Cause:
The stored procedure 'raise_application_error' was called which causes this
error to be generated.
Action:
Correct the problem as described in the error message or contact the
application administrator or DBA for more information.
ORA-21300: objects option not installed
Cause:
The objects option is not installed at this site. object types and other object
features are, therefore, unavailable.
Action:
Install the objects option. The objects option is not part of the Oracle Server
product and must be purchased separately. Contact an Oracle sales
representative if the objects option needs to be purchased.
ORA-21301: not initialized in object mode
Cause:
This function requires the OCI process to be initialized in object mode.
Action:
Specify OCI_OBJECT mode when calling OCIInitialize().
ORA-21500: internal error code, arguments: [string],
[string], [string], [string], [string], [string],
[string], [string]
Cause:
This is the generic error number for the OCI environment (client-side) internal
errors. This indicates that the OCI environment has encountered an exceptional
condition.
Action:
Report as a bug - the first argument is the internal error number.
ORA-21501: program could not allocate memory
Cause:
The operating system has run out of memory.
Action:
Take action to make more memory available to the program.
ORA-21503: program terminated by fatal error
Cause:
A program is in an unrecoverable error state.
Action:
Report as a bug.
ORA-21520: database server driver not installed
Cause:
User attempted to access a database server through an object-mode OCI
environment but the necessary driver for supporting such access to the database
server is not installed or linked in.
Action:
Check if the driver corresponding to the database server has been
installed/linked in and entered in the server driver table.
ORA-21521: exceeded maximum number of connections
in OCI (object mode only)
Cause:
User exceeded the maximum number of connections (255) that can be supported by
an OCI environment in object mode.
Action:
Close some of existing and unused connections before opening more connections.
ORA-21522: attempted to use an invalid connection
in OCI (object mode only)
Cause:
User attempted to use an invalid connection or a connection that has been
terminated in an OCI environment (object mode), or user attempted to
dereference a REF obtained from a connection which has been terminated.
Action:
Ensure that the connection exists and is still valid.
ORA-21523: functionality not supported by the
server (object mode only)
Cause:
User attempted to use a functionality that the server does not support.
Action:
Upgrade the server
ORA-21524: object type mismatch
Cause:
The object type of the object is different from what is specified.
Action:
Check the type of the object and correct it.
ORA-21525: attribute number or (collection element
at index) string violated its constraints
Cause:
Attribute value or collection element value violated its constraint.
Action:
Change the value of the attribute or collection element such that it meets its
constraints. The constraints are specified as part of the attribute or
collection element's schema information.
ORA-21526: initialization failed
Cause:
The initialization sequence failed. This can happen, for example, if an
environment variable such as NLS_DATE_FORMAT is set to an invalid value.
Action:
Check that all NLS environment variables are well-formed.
ORA-21527: internal OMS driver error
Cause:
A process has encountered an exceptional condition. This is the generic
internal error number for Oracle object management services exceptions.
Action:
Report this as a bug to Oracle Support Services.
ORA-21560: argument string is null, invalid,
or out of range
Cause:
The argument is expecting a non-null, valid value but the argument value passed
in is null, invalid, or out of range. Examples include when the LOB/FILE
positional or size argument has a value outside the range 1 through (4GB - 1),
or when an invalid open mode is used to open a file, etc.
Action:
Check your program and correct the caller of the routine to not pass a null,
invalid or out-of-range argument value.
ORA-21561: OID generation failed
Cause:
The handles passed in may not be valid
Action:
Check the validity of the env, svc handles
ORA-21600: path expression too long
Cause:
The path expression that is supplied by the user is too long. The path
expression is used to specify the position of an attribute in an object. This
error occurs when one of the intermediate elements in the path expression
refers to an attribute of a built-in type. Thus, the OCI function cannot
proceed on to process the rest of the elements in the path expression.
Action:
User should pass in the correct path expression to locate the attribute.
ORA-21601: attribute is not an object
Cause:
The user attempts to perform an operation (that is valid only for an object) to
an attribute of a built-in type. An example of such an illegal operation is to
dynamically set a null structure to an attribute of a built-in type.
Action:
User should avoid performing such operation to an attribute of built-in type.
ORA-21602: operation does not support the specified
typecode
Cause:
The user attempts to perform an operation that does not support the specified
typecode.
Action:
User should use the range of valid typecodes that are supported by this
operation.
ORA-21603: property id [string] is invalid
Cause:
The specified property id is invalid.
Action:
User should specify a valid property id. Valid property ids are enumerated by
OCIObjectPropId.
ORA-21604: property [string] is not a
property of transient or value instances
Cause:
Trying to get a property which applies only to persistent objects.
ORA Error . Listado Errores Oracle. ORA-19851 a ORA-19921
ORA-19851: OS error while managing auxiliary
database string
Cause:
An OS error was received while managing the automatic auxiliary instance.
Action:
Check the accompanying errors.
ORA-19852: error creating services for auxiliary
instance string (error string)
Cause:
An error was received while managing the services of the auxiliary instance.
Action:
Check the accompanying errors.
ORA-19853: error preparing auxiliary instance string
(error string)
Cause:
An error was received while managing the automatic auxiliary instance.
Action:
Check the accompanying errors.
ORA-19854: error obtaining connect string from
target
Cause:
Could not obtain the connect string from the target database
Action:
Check the accompanying errors.
ORA-19860: piece validation cannot be performed
more than once
Cause:
The user attempted to validate a list of backup pieces more than once.
Validation may only be performed once for a given validation conversation.
Action:
Do not attempt to validate the pieces more than once.
ORA-19861: additional backup pieces cannot be
validated in this conversation
Cause:
The user tried to add new pieces to the list of files being validated after the
validation had already been performed. In a validation conversation, the list
can only be validated once.
Action:
Add all the backup pieces to the list before validating, or start a new
validation conversation for the remaining pieces.
ORA-19862: backup pieces must be validated before
accessing results
Cause:
The user tried to get validation results for backup pieces before the pieces
were actually validated.
Action:
Validate the pieces before trying to access the results.
ORA-19863: device block size string is
larger than max allowed: string
Cause:
The user specified a device BLKSIZE that is larger than the device BLKSIZE
specified during compressed backup.
Action:
Change the device BLKSIZE to be smaller than the maximum allowed.
ORA-19865: Backup piece string has no data
Cause:
No data was returned for the specified backup piece.
Action:
This normally indicates a problem with the media management software which is
linked with Oracle to provide backup and restore services. Contact the media
management software vendor.
ORA-19866: error writing file header for datafile string
Cause:
During a block recovery, the header of the datafile could not be updated.
Action:
Contact Oracle Support Services.
ORA-19870: error while restoring backup piece string
Cause:
This error should be followed by other errors indicating the cause of the
problem.
Action:
See other errors actions.
ORA-19873: cannot apply this backup section to file
string
Cause:
RMAN cannot restore a multi-section backup to the indicated file, because this
section is not a backup of this file, or the file was not prepared correctly
for this restore.
Action:
If this error occurs while running RMAN, then it is an internal error and you
should contact Oracle support.
ORA-19874: cannot finish multi-section restore to
file string
Cause:
During a multi-section restore, the file being restored is not a file in which
a multi-section restore is in progress.
Action:
If this error occurs while running RMAN, then it is an internal error and you
should contact Oracle support.
ORA-19875: multi-section restore not complete for
file string
Cause:
While completing a multi-section restore, it was found that all required
sections for this file were not correctly applied.
Action:
If this error occurs while running RMAN, then it is an internal error and you
should contact Oracle support.
ORA-19880: Corrupted space header for datafile string,
block string
Cause:
When reading the space header block to use Unused Block Optimization for the
backup of the datafile, the space header block had corrupted information.
Action:
The corrupt space header must be fixed before Unused Block Optimization can be
used for this file. Note that you should fix the corruption in any case because
it will affect the availability of the data in the file, beyond just taking
backups.
ORA-19881: Corrupted space bitmap for datafile string,
block string
Cause:
When reading a space bitmap block to use Unused Block Optimization for the
backup of the datafile, the space bitmap block had corrupted information.
Action:
The corrupt space bitmap must be fixed before Unused Block Optimization can be
used for this file. Note that you should fix the corruption in any case because
it will affect the availability of the data in the file, beyond just taking
backups.
ORA-19882: datafile string checkpoint string
is ahead of space bitmap datafile string checkpoint string
Cause:
When checkpointing the datafile containing the space bitmaps for the datafile
being backed up in order to use Unused Block Optimization, the checkpoint of
the datafile containing the space bitmaps did not advance.
Action:
Examine the trace and alert files for possible causes. Fix underlying problem
to use Unused Block Optimization for datafile's backup.
ORA-19883: Unused Block Optimization stopped for
datafile string
Cause:
Accompanying errors detail the problem that prevented Unused Block Optimization
from being used.
Action:
See accompanying errors for appropiate action.
ORA-19900: RESETLOGS must be specified after
recovery to new incarnation
Cause:
Recovery was done to an incarnation after changing the destination incarnation
using RMAN's RESET DATABASE command.
Action:
Open the database with the RESETLOGS option.
ORA-19901: database needs more recovery to create
new incarnation
Cause:
Recovery was done to an incarnation after changing the destination incarnation
using RMAN's RESET DATABASE command, but one or more of the recovered datafiles
still belongs to the parent incarnation. This usually happens when recovery is
ended before any logs from the desired incarnation have been applied.
Action:
Continue recovery.
ORA-19902: incarnation key string not found
Cause:
The specified incarnation was not found in the control file.
Action:
Resubmit request with known incarnation key. To see which incarnations are
available for this target database, query V$DATABASE_INCARNATION or use RMAN's
LIST INCARNATION command.
ORA-19903: test recovery not allowed when
recovering to new incarnation
Cause:
Either a new incarnation was set using RMAN's RESET DATABASE command for a
control file that was CURRENT, or the control file is from a prior incarnation.
As recovery to a new incarnation requires changing the control file, test
recovery is not allowed.
Action:
Perform actual recovery or RESET DATABASE to incarnation that was last opened
using the control file to do test recovery.
ORA-19904: test recovery not allowed for datafile string
Cause:
The specified datafile has been restored from a backup that was taken before
the last RESETLOGS. Recovering this datafile will require a file header update
that is incompatible with test recovery.
Action:
Perform actual recovery.
ORA-19905: log_archive_format must contain %s, %t
and %r
Cause:
log_archive_format is missing a mandatory format element. Starting with Oracle
10i, archived log file names must contain each of the elements %s(sequence),
%t(thread), and %r(RESETLOGS ID) to ensure that all archived log file names are
unique.
Action:
Add the missing format elements to log_archive_format.
ORA-19906: recovery target incarnation changed
during recovery
Cause:
While a media recovery was active, a new incarnation was detected by the server
due to inspection or cataloging of archived logs or backup files.
Action:
If you want recovery to use the new incarnation, restart recovery. This is the
most common action on a standby database when RESETLOGS is done in primary. If
you do not want recovery to use the new incarnation, change the recovery
destination using RMAN's RESET DATABASE TO INCARNATION <incarnation#>
command. To see which incarnations are available for this target database,
query V$DATABASE_INCARNATION or use RMAN's LIST INCARNATION command.
ORA-19907: recovery time or SCN does not belong to
recovered incarnation
Cause:
A point-in-time recovery to an SCN or time stamp prior to the last RESETLOGS
was requested.
Action:
Either change the specified recovery time/SCN, or change the recovery
destination using RMAN's RESET DATABASE command.
ORA-19908: datafile string has invalid
checkpoint
Cause:
The specified datafile has an invalid checkpoint.
Action:
Restore the datafile from a backup.
ORA-19909: datafile string belongs to an
orphan incarnation
Cause:
Either the specified datafile was restored from a backup that was taken during
a period of time that has already been discarded by a RESETLOGS operation, or
Oracle cannot identify which database incarnation the file belongs to. The
alert log contains more information.
Action:
Restore a backup of this file that belongs to either the current or a prior
incarnation of the database. If you are using RMAN to restore, RMAN will
automatically select a correct backup.
ORA-19910: can not change recovery target
incarnation in control file
Cause:
The RESET DATABASE TO INCARNATION command was used while the database is open.
This is not allowed.
Action:
Close the database then re-issue the command.
ORA-19911: datafile string contains future
changes at the incarnation boundary
Cause:
The file did not hit end backup marker redo during recovery at the incarnation
boundary, hence may contain changes discarded by new incarnation.
Action:
Use older backup of the file and then re-issue the command.
ORA-19912: cannot recover to target incarnation string
Cause:
The control file is not in the recovery path of the target incarnation, and
does not contain enough information as to how to recover to the target
incarnation.
Action:
Restore the latest control file from the target incarnation and retry.
ORA-19913: unable to decrypt backup
Cause:
A backup piece could not be decrypted. This message is accompanied with another
message that indicates the name of the encrypted backup that could not be
restored. The reason could be either that an invalid password was entered, or
that, when using transparent decryption, the database external security device
is not open.
Action:
If password-based restore was enabled for this backup, then supply the correct
password using the RMAN SET DECRYPTION command. If transparent restore was
enabled for this backup, then ensure that the database external security device
is open.
ORA-19914: unable to encrypt backup
Cause:
RMAN could not create an encrypted backup. This message will be accompanied by
other messages that give more details about why the encrypted backup could not
be created. The most common reason for this message is that you are trying to
create a backup that can be transparently decrypted, and the database external
security device is not open.
Action:
If the external security device is not open, then open it. If the external
security device is not configured, then the only type of encrypted backup that
you can create is a password-based backup.
ORA-19915: unable to encrypt pre-10.2 files
Cause:
An RMAN encrypted backup was requested, but this backup includes one or more
archived logs that were generated by an older release of Oracle. These archived
logs cannot be encrypted.
Action:
Back up the older logs without encryption. Logs created with Oracle release
10.2 and greater can be encrypted.
ORA-19916: string
Cause:
An error occurred when processing user request.
Action:
Do not use message 19917; it is used internally for testing purpose. Do not use
message 19918; it is an internal event used by encryption.
ORA-19919: encrypted backups to tertiary storage
require Oracle Secure Backup
Cause:
RMAN was configured to create encrypted backups, but the channel is neither a
DISK channel nor an Oracle Secure Backup channel.
Action:
Allocate a DISK channel or an Oracle Secure Backup channel to use backup
encryption.
ORA-19921: maximum number of string rows
exceeded
Cause:
The maximum number of rows in the V$RMAN_STATUS or V$RMAN_OUTPUT table has been
exceeded.
Action:
Close some of existing and unused RMAN connections and sessions.
Suscribirse a:
Entradas (Atom)