Oracle 12c R2 Error Codes and Solution Suggestions from ORA-17500 to ORA-18000
- ORA-17500: ODM err:string
Cause: An error returned by ODM library
Action: Look at error message and take appropriate action or contact Oracle Support Services for further assistance
Cause: logical block size for oracle files must be a multiple of the physical block size, and less than the maximum
Action: check INIT.ORA file parameters
Cause: file creation failed due to either insufficient OS permission or the file already exists
Action: check additional error messages
Cause: file open failed due to either insufficient OS permission or the name of file exceeds maximum file name length.
Action: check additional error messages
Cause: The file that was being deleted is still in use or the process has insufficient permission to delete file.
Action: check additional error messages
Cause: There is insufficient space left on the device or the process has insufficient permission to resize file.
Action: check additional error messages
Cause: The I/O request was marked with an error because the I/O error simulation event was turned on.
Action: n/a
Cause: I/O’s were done in a multiple of the logical block size.
Action: Check additional error messages.
Cause: I/O request buffer was not aligned. Check additional information for a buffer pointer value.
Action: Contact Oracle Support Services.
Cause: When a file is identified with logical block size of 0, only I/O’s to block1 is allowed.
Action: Check additional error messages and contact Oracle Support Services.
- ORA-17510: An attempt to do I/O of size string to block string is beyond file size string. Logical block size: string.
Cause: The I/O request pointed to a block beyond the end of the file.
Action: Check additional error messages and contact Oracle Support Services.
Cause: Block Verification after a read operation on a database file failed since the block is media corrupt.
Action: check additional error messages in the trace file and call Oracle Support Services
Cause: An attempt was made to call a Direct NFS (dNFS) package in a non-dNFS environment.
Action: Ensure that dNFS is enabled and the file can be accessed using dNFS.
Cause: Accessing the bitmap block file in clonedb environment has encountered an error
Action: check additional error messages in the trace file and call Oracle Support Services
Cause: Creating a data file in a CloneDB environment failed.
Action: Ensure that the snapshot file passed to CloneDB is not from another CloneDB instance and call Oracle Support Services for further assistance.
Cause: The asynchronous I/O request failed due to storage server reboot.
Action: Ensure that the storage server does not reboot repeatedly during database operations.
Cause: An invocation of the storage clone command was returned with an error.
Action: Ensure that all necessary steps are performed for storage cloning and check the Oracle trace file for additional information.
Cause: Access to the specified backup file was required for Instant Restore.
Action: Ensure that the path and file name are correct for the backup file and the path to the backup file can be accessed from the node of the instance.
Cause: The snapshot layer could not prepare the specified data file.
Action: Ensure that the file does not already exist, is already part of a clone setup, or is being repopulated by an Instant Restore background process. Ensure that the path specified is accessible and writable by the instance.
Cause: Instant Restore could not add the file to the repopulation work queue.
Action: The repopulation process may be working on too many files for the system. Try waiting for some files to complete and try again.
Cause: The initialization parameters for Instant Restore were not set.
Action: Ensure that Instant Restore initialization parameters are set as required for this feature.
Cause: The file was already being repopulated from a previous restore.
Action: Ensure that the file completes restore before you start another restore.
Cause: The instance had too many running processes.
Action: Ensure that the maxmimum number of processes initialization parameter is set properly for this feature.
Cause: The maxmimum processes initialization parameter was not set properly.
Action: Ensure that the maxmimum number of processes initialization parameter is set properly for this feature. Check the alert log for other related errors.
Cause: Cloning a database using storage level snapshot is not supported on the underlying storage.
Action: Use storage product that has snapshot based cloning support for Oracle.
Cause: Files with block sizes smaller than a minimum size cannot be used for clones backed by snapshot file.
Action: Use files with larger block size.
- ORA-17527: Creation of a snapshot failed because the destination string was not a sparse disk group.
Cause: Creating a snapshot failed because the destination disk group was not a sparse disk group.
Action: Ensure that the CREATE_FILE_DEST clause passed to the snapshot copy is in a sparse disk group.
Cause: The file was read-only or was opened read-only and an attempt was made to write to the file, or there was an internal error.
Action: If the file is a parent of a snapshot, then you cannot open read/write, drop or unplug the database. Otherwise, look at the trace file and contact Oracle Support Services.
Cause: An attempt was made to create a compressed file on an instance that was not a CloneDB instance.
Action: Set CLONEDB parameter to TRUE and retry the operation.
Cause: The snapshot referred to by the clone was incompatible with what the clone was created.
Action: Locate the appropriate snapshot and place it in the named location.
- ORA-17531: snapshot (parent)=string modification time string is different from snapshot creation time string recorded in file string
Cause: The clone (child) referred to a snapshot at a specific point in time. The snapshot (parent) currently in that place is at the wrong time.
Action: Locate the appropriate snapshot (parent) and place it in the named location.
- ORA-17532: snapshot (parent)=string checkpoint SCN string is different from snapshot checkpoint SCN string recorded in file string
Cause: The clone (child) referred to an SCN at a specific point in time. The snapshot (parent) currently in that place is at the wrong SCN.
Action: Locate the appropriate snapshot (parent) and place it in the named location.
- ORA-17533: sparse merge copy operation failure because string and string do not share a valid relationship
Cause: Files specified with the ‘sparse_merge_begin’ and ‘sparse_merge_end’ options did not share a valid relationship.
Action: Check additional error messages.
- ORA-17534: sparse merge copy operation failure because request to change file access permissions for string failed
Cause: File access permissions for the file could not be modified.
Action: Check additional error messages.
Cause: The sparse merge copy operation was not successful because it tried to merge to the base parent.
Action: Check additional error messages.
Cause: An attempt to create a file found neither an existing file nor a size for creating the file.
Action: Specify a size for the file.
Cause: An attempt to write to a file which has gone offline/unidentified
Action: Check for other errno in the stack
Cause: Discovery of the odm library by calling odm_discover() failed
Action: Contact your storage vendor who has provided the ODM library or call Oracle Support
Cause: Initialization of the Oracle Disk Manager (ODM) for the thread failed due to insufficient privilege or memory.
Action: Ensure that there is enough system resources available for the Oracle process and that it has access to the ODM library.
Cause: An attempt was made to update block 0 to version 10 format.
Action: Check additional error messages and call Oracle Support Services
Cause: An attempt was made to start large number of processes requiring I/O slaves.
Action: There can be a maximum of 35 processes that can have I/O slaves at any given time in a instance.
Cause: The Oracle Disk Manager (ODM) library returned an error while trying to register the network adapter.
Action: Ensure that the network adapter name specified in the FILEIO_NETWORK_ADAPTERS initialization parameter is a valid name, and that the Oracle user has the correct access privileges.
Cause: The ODM library returned an error while trying to register the memory.
Action: Contact the Oracle Disk Manager Library provider.
Cause: The ODM library returned an error while trying to deregister the memory.
Action: Contact the Oracle Disk Manager Library provider
Cause: The directory that was being deleted is still in use or the process had insufficient permission to delete the directory.
Action: check additional error messages.
Cause: trying to create a database file, but file by that name already exists
Action: verify that name is correct, specify REUSE if necessary
Cause: An error returned by OCI while sending/receiving message from remote instance
Action: Look at error message and take appropriate action or contact Oracle Support Services for further assistance
Cause: Oracle server on the remote instance has returned an error.
Action: Look at remote instance alert log/trace file for more information and take appropriate action or contact Oracle Support Services for further assistance
Cause: Connecting to the remote server specified by database connect string for netowrk file transfer failed.
Action: Check additional error messages
Cause: Cannot communicate with the remote database server as there is a mismatch in the Oracle file protocol version.
Action: Check additional error messages
Cause: The dbname specified by the remote server is not intended for this instance.
Action: Check the dbname specified in the command of the remote instance and look for further error messages.
Cause: An attempt to create a datafile on a device that was formatted for ASM disk failed.
Action: Check that the device specified is not an ASM disk. If you would like to use the disk for datafiles, please clear the disk before you retry the operation.
- ORA-17633: Operation not supported as one of the servers involved is not capable of performing the requested operation
Cause: An attempt was made to perform an operation involving two Oracle servers where both servers did not have the capability required for carrying out the operation. It is likely that one of the servers needs a patch or an upgrade to successfully participate in the operation.
Action: Apply the required fix or update on the lower version server. Contact Oracle Support Services for further assistance.
Cause: An error occurred during network file transfer operation.
Action: Check addtional error messages.
Cause: An error occurred while determining the physical sector size from the underlying storage (ASM/ODM/OSD).
Action: Check additional error messages.
Cause: An error occurred while reading the block on sparse media.
Action: Contact Oracle Support Services.
Cause: An error occurred while changing permission on a database file.
Action: Verify that Oracle user has ownership on the database file.
Cause: An error occurred while accessing a compressed file.
Action: Verify that the Oracle user has permission to access the compressed file.
Cause: An error occurred while opening the snapshot backing file.
Action: Verify that the backing file has not changed since the creation of the snapshot file and set the backing file permissions to read-only.
Cause: The remote SQL statement execution failed on primary database.
Action: Check for the required privileges to run the SQL statement.
Cause: Either the procedure was called on a platform where Oracle File System (OFS) is not supported or an invalid file system type was provided.
Action: Check additional error messages in the trace file.
Cause: Mounting database file system failed with an error.
Action: Check additional error messages in the trace file.
Cause: Unmounting database file system failed with an error.
Action: Check additional error messages in the trace file.
Cause: Mounting of the database file system failed with an error.
Action: Check additional error messages in the trace file.
Cause: Either an invalid file system creation option was specified, the file system already existed, or a failure to create the tables occurred.
Action: Check additional error messages in the trace file.
Cause: Either the database file system was invalid, it was still busy, it did not exist, or some other error has occurred.
Action: Check additional error messages in the trace file.
Cause: An attempt was made to connect to the remote server using a shared server connection. This is not supported.
Action: Verify the connect string and use a dedicated server to connect to remote database.
Cause: The parser detected a missing or invalid outline name
Action: n/a