Oracle 12c R2 Error Codes and Solution Suggestions from ORA-15400 to ORA-15600
- ORA-15400: not running on supported ASM appliance
Cause: An attempt was made to initialize the server code as an appliance when it was not running a supported appliance configuration.
Action: Check the appliance configuration and retry the operation.
Cause: An attempt was made to run an operation that is not supported by the specified appliance.
Action: Check the documentation to see which operations are allowed or disallowed for the specified appliance.
Cause: An attempt was made to do an operation that resulted in insufficient number of disks required for the specified appliance.
Action: Check the appliance configuration and retry the operation after inserting disks in the appropriate slots.
Cause: Oracle ASM was unable to read an appliance configuration file.
Action: Check the operating system error messages to determine the identity of the configuration file. Then, fix the configuration file.
Cause: There were too many dropping or offline disks in the specified disk group.
Action: Wait for the drop and rebalance operations to complete, or online the offline disks and wait for the online to complete. Then, retry the operation.
Cause: An attempt was made to add a disk to a slot in the ASM appliance that already had a disk (possibly OFFLINE) associated with it.
Action: Use FORCE to drop the disk that exists in the specified slot. Then, retry the operation.
Cause: An attempt was made to either online or replace a disk that was already being replaced, probably by another instance.
Action: Change the ONLINE statement to exclude the disk.
Cause: More than one disk is discovered matching the specified disk string.
Action: Change the disk string to specify one and only one disk.
Cause: The replacement disk must be at least of the same size of the old disk.
Action: Use a larger physical disk to replace.
Cause: An attempt was made to add disks of a different type to the disk group under appliance mode.
Action: Check if all the disks in the disk group are of the same type. Do not add flash and hard disks to the same disk group.
Cause: The disks in the disk group were not of equal size.
Action: Ensure that all disks in the disk group are of equal size. If adding new disks to the disk group, their size must be equal to the size of the existing disks in the disk group. If resizing, all disks in the disk group must be resized to the same size.
Cause: An attempt was made to enable appliance mode with a different number of disks in each failure group.
Action: Check if all failure groups have an equal number of disks and try again.
Cause: An attempt was made to do an operation that resulted in dropping all disks in a failure group or creating a new failure group.
Action: Disable appliance mode, perform the operation and reenable appliance mode. WARNING: To reenable appliance mode, ensure the following constraints are met: * There are a sufficient number of disks in each failure group. * All failure groups have an equal number of disks. * There are no offline disks in the disk group. * Every disk in the disk group is of the same type (flash or hard disk). * All disks in the disk group have an equal size.
Cause: Appliance mode could not be set because it was explicitly disabled.
Action: Enable appliance mode and appliance partnering parameters.
- ORA-15414: Appliance mode requires at least string failure groups and either string or string disks in all failure groups.
Cause: Appliance mode could not be enabled because it did not meet the minimum requirements.
Action: Check if there are sufficient failure groups and a sufficient number of disks in each failure group.
Cause: Some of the appliance properties were invalid. This could be due to a cell software downgrade after setting the ‘appliance.mode’ attribute.
Action: Check the cell software on all of the cells or disable appliance mode.
Cause: An offline disk prevented the current ADD or DROP operation.
Action: Drop the offline disk or online the offline disk or disable appliance mode.
Cause: Appliance mode could not be enabled for the current value of the compatible.asm attribute.
Action: Disable appliance mode if it is enabled or advance compatible.asm to a version that supports appliance mode.
Cause: The specified disk group was not mounted in restricted mode prohibiting the requested operation.
Action: Dismount the disk group, remount it in restricted mode and retry the operation.
Cause: The current operation could not be completed because the disk group is in the middle of an appliance migration.
Action: Wait for the migration to complete and then retry the command.
Cause: The disk group was mounted for recovery preventing the requested operation.
Action: Dismount the disk group, remount it in normal mode and retry the operation.
- ORA-15422: Disks ‘string‘ and ‘string‘, in failure group ‘string‘ of disk group ‘string‘, do not belong to the same cell
Cause: It was detected that disks from different cells belong to the same failure group.
Action: Make the necessary disk swaps so only disks from the same cell belong to the same failure group.
- ORA-15423: Disk ‘string‘ in failure group ‘string‘ and disk ‘string‘ in failure group ‘string‘ of disk group ‘string‘ belong to the same cell
Cause: It was detected that disks from the same cell belong to different failure groups.
Action: Make the necessary disk swaps so disks from the same cell are not shared between different failure groups.
Cause: The command did not specify a valid quota group name.
Action: Specify a valid quota group name.
Cause: The command did not specify a valid quota group property.
Action: Specify a valid quota group property.
Cause: The command did not specify a valid quota limit for the quota group.
Action: Specify a valid quota limit.
Cause: The command did not specify a valid file group name.
Action: Specify a valid file group name.
Cause: The specified quota group already existed in the disk group.
Action: Specify a different quota group name.
Cause: The specified quota group did not exist in the disk group.
Action: Specify a valid quota group name.
Cause: The specified operation was not permitted on the quota group.
Action: Check the quota group specified in the command.
Cause: The specified quota group did not have sufficient quota available to permit the operation.
Action: Specify a quota group with sufficient available quota or increase the quota limit of the specified quota group.
Cause: One or more file groups were associated with the specified quota group and, therefore, the operation was not permitted.
Action: Drop the file groups or move the file groups to a different quota group.
Cause: A volume IO background process terminated with error.
Action: Wait for the process to restart.
Cause: The specified ASM rebalance phase did not exist.
Action: Specify a valid rebalance phase.
Cause: The specified ASM rebalance phase cannot be skipped.
Action: Specify a valid rebalance phase to skip.
Cause: The operation could not be completed with the volume offline or dismounted.
Action: Online or mount the volume and retry the operation.
Cause: Sector size migration was not allowed because Oracle ACFS accelerator volumes, volumes associated with an Oracle ACFS accelerator, or non Oracle ACFS volumes exist in the disk group.
Action: Move the volume to a different disk group and retry the operation. 15446 available 15447 available 15448 available 15449 available
Cause: The volume name specified was invalid
Action: Specify a valid volume name.
Cause: The volume size specified was invalid.
Action: Specify a valid volume size.
Cause: The volume stripe width specified was invalid.
Action: Specify a valid volume stripe width.
Cause: An ADD VOLUME command did not specify a valid number of stripe columns.
Action: Specify a valid number of stripe columns.
Cause: An ALTER DISKGROUP ALL command specified a single volume or a list of volumes
Action: Use the ALL keyword when specifying volumes on multiple diskgroups.
Cause: The FORCE option was used to disable ALL volumes.
Action: Use FORCE option to disable one volume at a time.
Cause: The command did not specify a valid volume usage string.
Action: Specify a valid volume usage string with alphanumeric characters.
Cause: A volume name was specified with a nonalphabetic first character.
Action: Set the first character of the volume name to be alphabetic.
Cause: A volume name was specified with an invalid character.
Action: Use a volume name with only alphanumeric characters.
Cause: An ADD VOLUME command specified a STRIPE_WIDTH that was not a power of two.
Action: Select a STRIPE_WIDTH that is a power of two; for example, 4K, 8K, etc.
Cause: An ADD VOLUME command specified a volume name that was already used by another volume.
Action: Select a different name for the volume.
Cause: An ADD VOLUME command specified a STRIPE_WIDTH that was too small.
Action: Select a larger STRIPE_WIDTH.
Cause: An ADD VOLUME command specified a STRIPE_WIDTH that was too large.
Action: Select a smaller STRIPE_WIDTH.
Cause: The volume size specified was too small.
Action: Select a larger volume size.
Cause: An ADD VOLUME command specified a STRIPE_COLUMNS that was that was too large.
Action: Select a smaller STRIPE_COLUMNS value.
Cause: An ADD VOLUME command specified a STRIPE_COLUMNS that was too small.
Action: Select a larger STRIPE_COLUMNS value.
Cause: The command specified a volume name that does not exist.
Action: Ensure a valid volume name is used.
Cause: Another command was currently operating on a volume.
Action: Wait a short time before retrying the command.
Cause: An attempt was made to communicate with the volume driver. The volume was being accessed by another application and, therefore, could not be changed.
Action: Shut down all applications that might be accessing this volume and then retry the command.
Cause: A volume background process terminated with error.
Action: Wait for process to restart.
Cause: The volume driver background process terminated with error.
Action: Warm start instance.
Cause: An ADD VOLUME command specified a volume redundancy that was incompatible with the redundancy of the disk group.
Action: Specify a valid volume redundancy. An unprotected redundancy volume cannot be added to a normal or high redundancy disk group, and a mirror or high redundancy volume cannot be added to an external redundancy disk group.
Cause: The volume library could not be loaded. Either the platform does not support volume operations, or there is a problem with the library.
Action: Ensure that the platform supports volumes. If the platform does support volumes, check the alert log for library loading failure information.
Cause: An attempt was made to access or modify a volume’s storage through an unsupported interface.
Action: Use supported interfaces for access to volume devices.
Cause: An ADD VOLUME command specified a volume name that was too long.
Action: Select a smaller volume name.
Cause: The usage string specified was too long.
Action: Select a smaller usage string.
Cause: An attempt was made using SQL to resize an ADVM volume that contains an ACFS file system.
Action: Use the ‘acfsutil size’ operating system command to resize the volume.
Cause: An attempt was made to communicate with the volume driver.
Action: Check that the ASM volume driver is loaded. If so, check the alert log to identify the reason for failure and take necessary action to prevent such failures in the future.
Cause: The ACFS background process terminated with error
Action: Wait for process restart
Cause: Volumes were not supported. A common example is having disks, such as NFS, in the diskgroup that are not supported by volumes.
Action: Remove unsupported disks in the diskgroup.
Cause: An error was reported in the ASM volume driver.
Action: Check the operating system log files to identify the reason for the failure and take necessary action to prevent such failures in the future.
Cause: A invalid volume mountpath string was specified.
Action: Specify a valid volume mountpath string with alphanumeric characters.
Cause: Improper driver installation.
Action: Check the alert log for device file creation failure information. Reload the driver using the supported installation method.
Cause: The version of the ASM volume driver was not supported by ASM.
Action: Update the volume driver or the ASM instance.
Cause: Errors were returned by the ALTER DISKGROUP CHECK VOLUME command.
Action: See the alert log for details of the errors.
Cause: A volume was added on a diskgroup that already contained the maximum number allowed.
Action: Remove volumes on the diskgroup.
Cause: An internal ASM error occurred while altering a volume.
Action: See the alert log for details of the error.
Cause: One or more ASM volumes were found to be open during shutdown.
Action: Close the ASM volume and retry the shutdown.
Cause: ASM volume was not closed prior to instance termination on node specified.
Action: Close the ASM volume either via unmount or node restart and retry the operation
Cause: An ASM volume was not closed prior to instance shutdown on node specified. It is conflicting with the volume that is to be enabled.
Action: Close the ASM volume either via unmount or node restart and retry the operation.
Cause: The ASM volume cannot be added/dropped on all instances.
Action: See the alert log for the reason the volume could not be added/droped.
Cause: Non-mirrored volumes erroneously contained the MIRRORHOT or MIRRORCOLD keyword.
Action: Remove the MIRRORHOT or MIRRORCOLD keywords from non-mirrored volumes.
Cause: An attempt was made to use a feature which is not compatible with existing ASM volumes. A common example is adding a disk to the diskgroup that is unsupported by ASM volumes.
Action: Omit the option from the command.
Cause: An attempt was made to advance ADVM compatibility beyond the disk group’s ASM compatibility.
Action: Advance ASM compatibility before advancing ADVM compatibility.
Cause: An attempt was made to set the ADVM compatibility to a version that was lower than the minimum supported.
Action: Set ADVM compatibility to at least the minimum supported version.
Cause: The ASM operation specified required a higher disk group attribute value for compatible.advm.
Action: Set the disk group attribute compatible.advm to or above the requested version.
Cause: The volume size specified was too large.
Action: Select a smaller volume size.
- ORA-15497: Volume string uses a metadata block size (string) smaller than the specified sector size (string).
Cause: The Oracle ACFS volume had a metadata block size incompatible with the specified sector size.
Action: Migrate Oracle ACFS to a larger metadata block size before changing the sector size.
Cause: A volume name was specified that would conflict with existing volume device(s). A volume ‘<vol_name>-<dg_num>’ is the name of the block device. Additionally, a raw device named ‘r<vol_name>-<dg_num>’ is also created. Since that name already existed, a name collision occurred.
Action: Choose another name for the volume (no leading ‘r’ is recommended).
Cause: The volume driver background process terminated with error.
Action: Warm start the instance.
Cause: Given instance encountered unexpected errors while trying to start the workload capture.
Action: Check the alert log and other diagnostics in the given instance to diagnose the problem.
Cause: Given instance encountered unexpected errors while trying to stop the workload capture.
Action: Check the alert log and other diagnostics in the given instance to diagnose the problem.
- ORA-15503: cannot startup instance when procedures in “DBMS_WORKLOAD_CAPTURE” or “DBMS_WORKLOAD_REPLAY” are in the middle of their execution
Cause: The new instance could not be started because the database was executing a procedure in either the DBMS_WORKLOAD_CAPTURE or DBMS_WORKLOAD_REPLAY package.
Action: Start the new instance after such procedures in the given packages have finished execution.
- ORA-15504: cannot start workload capture because instance string not present in RESTRICTED SESSION mode
Cause: The NO_RESTART_MODE option in DBMS_WORKLOAD_CAPTURE.START_CAPTURE was FALSE, therefore all the active instances were expected to be in the RESTRICTED SESSION mode.
Action: Start all instances using STARTUP RESTRICT or execute ALTER SYSTEM ENABLE RESTRICTED SESSION on all active instances before issuing DBMS_WORKLOAD_CAPTURE.START_CAPTURE.
- ORA-15505: cannot start workload capture because instance string encountered errors while accessing directory “string“
Cause: Given instance could not access the specified CAPTURE directory or the specified CAPTURE directory already had a workload capture in it.
Action: Provide a directory object that is valid, empty and accessible from all the instances in the database cluster.
Cause: Given instance encountered unexpected errors while trying to prepare for a workload replay.
Action: Check the alert log and other diagnostics in the given instance to diagnose the problem.
Cause: Given instance encountered unexpected errors while trying to start a workload replay.
Action: Check the alert log and other diagnostics in the given instance to diagnose the problem.
Cause: Given instance encountered unexpected errors while trying to cancel a workload replay.
Action: Check the alert log and other diagnostics in the given instance to diagnose the problem.
Cause: Workload replay was cancelled.
Action: Restart the workload replay.
Cause: The STATISTICS_LEVEL initialization parameter was set to BASIC.
Action: Change the STATISTICS_LEVEL initialization parameter setting to either TYPICAL or ALL.
Cause: No user sessions were recorded in the given workload capture. Processing this capture failed because no user workload was captured.
Action: Capture a workload in which at least one user session connects and performs some operations.
Cause: One or more files created by DBMS_WORKLOAD_REPLAY.PROCESS_CAPTURE were missing.
Action: Process the workload capture using DBMS_WORKLOAD_REPLAY.PROCESS_CAPTURE and then retry the command.
Cause: Given input directory is either invalid or inaccessible.
Action: Verify that the input directory is valid and accessible and then retry the command.
Cause: The corresponding PL/SQL program was either dropped or modified.
Action: Verify that the corresponding PL/SQL program is defined the same way during replay as it was defined during workload capture.
Cause: Error encountered during the replay of a remote procedure call.
Action: Correct the cause of the preceding error and restart workload replay.
Cause: One of the parallel preprocessing workers died unexpectedly while processing the workload.
Action: Find the root cause or simply preprocess the workload using only one process.
Cause: One of the parallel preprocessing workers could not be started.
Action: Find the root cause or simply preprocess the workload using only one process.
Cause: An unexpected error occurred during parallel preprocessing.
Action: Find the root cause or simply preprocess the workload using only one process.
Cause: For security considerations, access to external databases via database links were disabled during workload replay.
Action: Use advanced parameter for Database Replay to enable database links during workload replay.
Cause: Two WMD files were found in the directory.
Action: Check that the WMD files in capture directory were not modified, moved, duplicated or deleted.
Cause: An attempt was made to create a file during workload processing without the proper file permissions.
Action: Correct the file permissions and try again.
Cause: An attempt to generate a workload capture subset failed. Possible reasons are included in the error message.
Action: Correct the issue and try again.
Cause: Either the path does not exist or is inaccessible or the subpath specification is invalid.
Action: Verify that the path exists and is accessible, the subpath specification is valid, and retry the command.
- ORA-15525: a user call cannot be replayed because not enough information was captured; extra details: string
Cause: An attempt to replay a user call failed because the workload was captured with an old version of Oracle. The information needed for replay was not recorded.
Action: Capture the workload using a newer version of Oracle or use the replay filters to skip the user call.
Cause: The server connection identifier was invalid.
Action: Restart the client with correct server connection identifier.
Cause: 1) the replay client used an invalid username or password; 2) the replay user does not have the privilege to switch user; 3) the recorded username does not exist in the replay database.
Action: 1) restart replay client with correct username and password 2) grant user switching prvilege to the replay user 3) verify whether the replay database was restored properly
Cause: Workload Replay Client’s replay user did not have EXECUTE permission on the DBMS_WORKLOAD_REPLAY package.
Action: Grant execute permission on the DBMS_WORKLOAD_REPLAY package to replay user and restart the Workload Replay Client.
Cause: The Workload Replay Client could not connect to the database server because the database server was not in the PREPARE mode.
Action: Put the database in PREPARE mode by using DBMS_WORKLOAD_REPLAY.PREPARE_REPLAY, and restart the Workload Replay Client.
Cause: Workload Replay Client encountered an unexpected error.
Action: Check the Workload Replay Client’s log files and the database server alert log to diagnose the problem.
Cause: Invalid input was specified.
Action: Use the Workload Replay Client’s HELP=Y option to know more about valid input options.
- ORA-15557: workload replay client cannot access the replay directory or the database version do not match the preprocessing one
Cause: The Workload Replay Client could not access the directory that contained the workload to be replayed, or the workload was preprocessed by a different version of the database.
Action: Restart the workload replay after specifying the correct replay directory, or preprocess it with the correct database.
Cause: A single replay thread got disconnected from the server due to an unexpected error.
Action: Check the Workload Replay Client’s log files and the database server alert log to diagnose the problem.
Cause: The Workload Replay Client could not access one or more workload capture files from the replay directory.
Action: Restart the workload replay after copying all the workload capture files to the replay directory.
Cause: The Workload Replay Client could not access the work directory to write log files for debug information.
Action: Restart the Workload Replay Client after specifying the correct work directory.
Cause: The specified connection is invalid or the specified host is inaccessible.
Action: Test the specified connection using other methods and redefine the connection remapping, if necessary. Consult the view DBA_WORKLOAD_CONNECTION_MAP to inspect connection remappings.
Cause: The DBA_WORKLOAD_CONNECTION_MAP view did not exist or was not accessible.
Action: Re-create the workload capture and replay views. For additional information, see the documentation.
Cause: The Workload Replay Client does not have enough resource (CPU or memory) to spawn new threads.
Action: Restart the workload replay after allocating more resource (CPU and memory) to the Workload Replay Client or use more hosts as replay clients to drive the workload.
- ORA-15564: contents of the replay directory provided to the workload replay client do not match with the replay directory provided to the database server
Cause: The processed workload capture files given to the workload replay client directory did not match the contents of the replay directory given as input to DBMS_WORKLOAD_REPLAY.INITIALIZE_REPLAY.
Action: Provide the same processed workload capture files to both the database server and all the workload replay clients and restart the replay. If the same workload capture files were processed more than once, provide a copy of the latest processed workload capture files to all the workload replay clients and the database server.
Cause: The workload replay client encountered a user call in the captured workload that was not supported for replay in the current version.
Action: Look in the DBA_WORKLOAD_REPLAY_DIVERGENCE view for details about the call that encountered this error. Refer to the documentation for more details on the types of workload that are not supported in the current version.
Cause: The replay user encountered an error when accessing internal objects for Database Replay or switching user.
Action: Set up the replay user appropriately at the replay database. Ensure that the replay user can access SYS-owned objects and has been granted the BECOME USER privilege.
Cause: The recorded user did not exist in the replay database or encountered other problems during log in.
Action: Check the returned error number and set up the recorded user appropriately at the replay database.
Cause: The replay of a recorded user call was terminated since it was significantly slower than the workload capture.
Action: Find the root cause for the performance issue. Or, use DBMS_WORKLOAD_REPLAY API to disable the timeout check if the replay is expected to be slower.
Cause: The captured workload contained one or more incomplete recording files. This can happen when the original workload capture’s FINISH_CAPTURE command timed out while waiting for all the active sessions to close their workload capture files.
Action: Incomplete capture files will not interfere with the processing and replaying of the captured workload. This is simply a warning message to point out that some database calls might not have been recorded due to FINISH_CAPTURE command timing out. For a list of the incomplete files, check the alert log for lines containing DBMS_WORKLOAD_REPLAY.PROCESS_CAPTURE after capture processing.
Cause: The captured workload contained one or more corrupt recording files.
Action: For a list of the incomplete files, check the alert log for lines containing DBMS_WORKLOAD_REPLAY.PROCESS_CAPTURE after capture processing. The corrupt files will be replayed up to the point of the corruption. Alternatively, it is possible to remove the corrupt files and run DBMS_WORKLOAD_REPLAY.PROCESS_CAPTURE again. In this case, no workload from the corrupt files will be replayed.