1. Release Notes
  2. Known Issues with Oracle Database Appliance in This Release

4 Known Issues with Oracle Database Appliance in This Release

The following are known issues deploying, updating, and managing Oracle Database Appliance in this release.

Known Issues When Patching Oracle Database Appliance

Understand the known issues when patching Oracle Database Appliance to this release.

Parent topic: Known Issues with Oracle Database Appliance in This Release

Error in server patching

When patching CX6 controller firmware on Oracle Database Appliance, an error may be encountered.

Problem Description

When patching the server on Oracle Database Appliance, an error message may be displayed.

Failure Message

LNX64-1925-CMT:LOCAL CONTROLLER FIRMWARE NOT UPDATED TO LATEST: 26.41.1000

Command Details

# odacli describe-component

Hardware Models

All Oracle Database Appliance X10 hardware models with CX6 card

Workaround

Follow these steps:
  1. Manually add the missing older firmware (26.37.1014) before patching:
    cat /opt/oracle/oak/pkgrepos/firmwarecontroller/mellanox/0x101f/26.41.1000/componentmetadata.xml
    <OPC_PATCHING_METADATA>
    <name>metadata.xml</name>
    <description>Mellanox Controller Firmware</description>
    <known_versions>26.33.1048,26.35.1012,26.41.1000,26.37.1014</known_versions>
    <firmware_version>26.41.1000</firmware_version>
    </OPC_PATCHING_METADATA>
  2. Run the odacli update-server command.

Bug Number

This issue is tracked with Oracle bug 37194324.

Parent topic: Known Issues When Patching Oracle Database Appliance

Error in updating the operating system when patching the server

When patching the server, the operating system may not be updated.

The following error message is displayed:
DCS-10001:Internal error encountered: Failed to patch OS.
Run the following command:
rpm -q kernel-uek

If the output of this command displays multiple RPM names, then perform the workaround.

Hardware Models

All Oracle Database Appliance hardware models

Workaround

Remove the following RPMs:
# yum remove kernel-uek-4.14.35-1902.11.3.1.el7uek.x86_64
# yum remove kernel-uek-4.14.35-1902.301.1.el7uek.x86_64

This issue is tracked with Oracle bug 34154435.

Parent topic: Known Issues When Patching Oracle Database Appliance

Error in server patching

When patching the Oracle Database Appliance server, an error may be encountered.

Problem Description

When patching the server on Oracle Database Appliance, an error message may be displayed.

Failure Message

When you run the odacli update-server command, the following error message is displayed at the Patch KVM infrastructure task: 

DCS-10033:Service Clusterware on current node is down.

This issue may occur on systems that require update of Oracle ILOM, or operating system, or local storage firmware.

Command Details

# odacli update-server -v version

Hardware Models

All Oracle Database Appliance hardware models

Workaround

Restart Oracle Clusterware as follows:
$GI_HOME/bin/crsctl start crs

Bug Number

This issue is tracked with Oracle bug 36923776.

Parent topic: Known Issues When Patching Oracle Database Appliance

Error in attaching a vdisk after DB system patching

After upgrading a DB system on Oracle Database Appliance, the vdisks attached to the DB system may not continue to be attached.

Problem Description

After DB system upgrade, the existing vdisks are not attached. Only the vdisk metadata associated with the DB system is preserved. The virtual device name may be different from the name before you run the odacli upgrade-dbsystem command.

Command Details

# odacli upgrade-dbsystem

Hardware Models

All Oracle Database Appliance hardware models X9-2, X8-2, and X7-2

Workaround

Detach the vdisk manually with the --force option from the VM to reconcile the metadata. Then, attach the vdisk to the respective VM. Then, manually mount the file system on the device in the DB system.

Bug Number

This issue is tracked with Oracle bug 36885595.

Parent topic: Known Issues When Patching Oracle Database Appliance

Error in server patching

When patching the server on Oracle Database Appliance, an error may be encountered.

Problem Description

When patching the server on Oracle Database Appliance, and the DCS agent loads, the scheduler service may fail to start and an error message may be displayed.

Failure Message

The dcs-agent.log file displays the following error message: 

-----------------------
2024-07-29 14:24:30,351 WARN [backgroundjob-zookeeper-pool-7-thread-2] [] o.j.s.JobZooKeeper: JobRunr encountered a problematic exception. Please create a bug report (if possible, provide the code to reproduce this and the stacktrace) - Processing will continue.
java.lang.NullPointerException: null
        at org.jobrunr.server.zookeeper.tasks.ZooKeeperTask.pollIntervalInSecondsTimeBoxIsAboutToPass(ZooKeeperTask.java:93)
        at org.jobrunr.server.zookeeper.tasks.ZooKeeperTask.getJobsToProcess(ZooKeeperTask.java:84)
        at org.jobrunr.server.zookeeper.tasks.ZooKeeperTask.processJobList(ZooKeeperTask.java:57)
        at org.jobrunr.server.zookeeper.tasks.ProcessOrphanedJobsTask.runTask(ProcessOrphanedJobsTask.java:29)
        at org.jobrunr.server.zookeeper.tasks.ZooKeeperTask.run(ZooKeeperTask.java:47)
        at org.jobrunr.server.JobZooKeeper.lambda$runMasterTasksIfCurrentServerIsMaster$0(JobZooKeeper.java:76)
        at java.util.Arrays$ArrayList.forEach(Arrays.java:3880)
        at org.jobrunr.server.JobZooKeeper.runMasterTasksIfCurrentServerIsMaster(JobZooKeeper.java:76)
        at org.jobrunr.server.JobZooKeeper.run(JobZooKeeper.java:56)
-----------------------

Command Details

# odacli update-server

Hardware Models

All Oracle Database Appliance hardware models

Workaround

  1. Restart the DCS agent:
    systemctl restart initdcsagent
  2. Verify that the DCS agent is running:
    odacli ping-agent
odacli list-jobs
odacli describe-component

Bug Number

This issue is tracked with Oracle bug 36896020.

Parent topic: Known Issues When Patching Oracle Database Appliance

Error in upgrading a database

When upgrading a database, an error may be encountered.

Problem Description

When you create Oracle ASM databases, the RECO directory may not have been created on systems provisioned with the OAK stack. This directory is created when the first RECO record is written. After successfully upgrading these systems using Data Preserving Reprovisioning to Oracle Database Appliance release 19.15 or later, if you attempt to upgrade the database, an error message may be displayed.

Failure Message

When the odacli upgrade-database command is run, the following error message is displayed: 

# odacli upgrade-database -i 16288932-61c6-4a9b-beb0-4eb19d95b2bd -to b969dd9b-f9cb-4e49-8e0d-575a0940d288
DCS-10001:Internal error encountered: dbStorage metadata not in place:
DCS-12013:Metadata validation error encountered: dbStorage metadata missing
Location info for database database_unique_name..

Command Details

# odacli upgrade-database

Hardware Models

All Oracle Database Appliance X6-2HA and X5-2 hardware models

Workaround

  1. Verify that the odacli list-dbstorages command displays null for the redo location for the database that reported the error. For example, the following output displays a null or empty value for the database unique name F.
    # odacli list-dbstorages

ID                                     Type   DBUnique Name  Status     
Destination Location  Total      Used       Available      
---------------------------------------- ------ --------------------
...
...
...
198678d9-c7c7-4e74-9bd6-004485b07c14     ASM    F            CONFIGURED   
DATA    +DATA/F  4.89 TB    1.67 GB    4.89 TB                                                                   
REDO    +REDO/F  183.09 GB  3.05 GB    180.04 GB                                                                                
RECO             8.51 TB              
...
...
...

    In the above output, the RECO record has a null value.

  2. Manually create the RECO directory for this database. If the database unique name is dbuniq, then run the asmcmd command as the grid user.
    asmcmd
  3. Run the mkdir command.
    asmcmd> mkdir +RECO/dbuniq
  4. Verify that the odacli list-dbstorages command output does not display a null or empty value for the database.
  5. Rerun the odacli upgrade-database command.

Bug Number

This issue is tracked with Oracle bug 34923078.

Parent topic: Known Issues When Patching Oracle Database Appliance

Error in database patching

When patching a database on Oracle Database Appliance, an error may be encountered.

Problem Description

When applying the datapatch during patching of database on Oracle Database Appliance, an error message may be displayed.

Failure Message

When the odacli update-database command is run, the following error message is displayed: 

Failed to execute sqlpatch for database …

Command Details

# odacli update-database

Hardware Models

All Oracle Database Appliance hardware models

Workaround

  1. Run the following SQL*Plus command:
    alter system set nls_sort='BINARY' SCOPE=SPFILE;
  2. Restart the database using srvctl command.
  3. Retry applying the datapatch with dbhome/OPatch/datapatch -verbose -db dbUniqueName.

Bug Number

This issue is tracked with Oracle bug 35060742.

Parent topic: Known Issues When Patching Oracle Database Appliance

Component version not updated after patching

After patching the server to Oracle Database Appliance release 19.16, the odacli describe-component command does not display the correct Intel Model 0x1528 Ethernet Controller version, if the current version is 8000047B or 8000047C.

Hardware Models

All Oracle Database Appliance hardware models

Workaround

Manually update the Ethernet controllers to 00005DD or 800005DE using the fwupdate command.

This issue is tracked with Oracle bug 34402352.

Parent topic: Known Issues When Patching Oracle Database Appliance

Error in server patching

When patching Oracle Database Appliance which already has STIG V1R2 deployed, an error may be encountered.

On an Oracle Database Appliance deployment with release earlier than 19.25, if the Security Technical Implementation Guidelines (STIG) V1R2 is already deployed, then when you patch to 19.25 or earlier, and run the command odacli update-server -f version, an error may be displayed.

Hardware Models

All Oracle Database Appliance hardware models

Workaround

The STIG V1R2 rule OL7-00-040420 tries to change the permission of the file /etc/ssh/ssh_host_rsa_key from '640' to '600' which causes the error. During patching, run the command chmod 600 /etc/ssh/ssh_host_rsa_key command on both nodes.

This issue is tracked with Oracle bug 33168598.

Parent topic: Known Issues When Patching Oracle Database Appliance

AHF error in prepatch report for the update-dbhome command

When you patch server to Oracle Database Appliance release 19.25, the odacli update-dbhome command may fail.

The following error message is displayed in the pre-patch report:
Verify the Alternate Archive    Failed    AHF-4940: One or more log archive 
Destination is Configured to              destination and alternate log archive
Prevent Database Hangs                    destination settings are not as recommended

Hardware Models

All Oracle Database Appliance hardware models

Workaround

Follow these steps:
  1. Run the odacli update-dbhome command with the -f option.
    /opt/oracle/dcs/bin/odacli update-dbhome --dbhomeid 7c67c5b4-f585-4ba9-865f-c719c63c0a6e -v 19.25.0.0.0 -f

This issue is tracked with Oracle bug 33144170.

Parent topic: Known Issues When Patching Oracle Database Appliance

Errors when running ORAchk or the odacli create-prepatchreport command

When you run ORAchk or the odacli create-prepatchreport command, an error is encountered.

The following error messages may be seen:
One or more log archive destination and alternate log archive destination settings are not as recommended 
Software home check failed

Hardware Models

Oracle Database Appliance hardware models bare metal deployments

Workaround

Run the odacli update-dbhome, odacli create-prepatchreport, odacli update-server commands with the -sko option. For example:
odacli update-dbhome -j -v 19.25.0.0.0 -i dbhome_id -sko

This issue is tracked with Oracle bugs 30931017, 31631618, and 31921112.

Parent topic: Known Issues When Patching Oracle Database Appliance

Error in patching prechecks report

The patchung prechecks report may display an error.

The following error message may be displayed:
Failure in the pre-patch report caused by “AHF-5190: operating system boot device order is not configured as recommended”

Hardware Models

Oracle Database Appliance X-7 hardware models

Workaround

Run the odacli update-server or odacli update-dbhome command with the -f option.

This issue is tracked with Oracle bug 33631256.

Parent topic: Known Issues When Patching Oracle Database Appliance

Error message displayed even when patching Oracle Database Appliance is successful

Although patching of Oracle Database Appliance was successful, an error message may be displayed.

The following error is seen when running the odacli update-dcscomponents command: 
# time odacli update-dcscomponents -v 19.25.0.0.0 
^[[ADCS-10008:Failed to update DCScomponents: 19.25.0.0.0
Internal error while patching the DCS components : 
DCS-10231:Cannot proceed. Pre-checks for update-dcscomponents failed. Refer  
to /opt/oracle/dcs/log/-dcscomponentsPreCheckReport.log on node 1 for  
details.

Hardware Models

All Oracle Database Appliance hardware models

Workaround

This is a timing issue with setting up the SSH equivalence.

Run the odacli update-dcscomponents command again and the operation completes successfully.

This issue is tracked with Oracle bug 32553519.

Parent topic: Known Issues When Patching Oracle Database Appliance

Server status not set to Normal when patching

When patching Oracle Database Appliance, an error is encountered.

When patching the appliance, the odacli update-server command fails with the following error: 

DCS-10001:Internal error encountered: Server upgrade state is not NORMAL node_name

Hardware Models

All Oracle Database Appliance hardware models

Workaround

  1. Run the command:
    Grid_home/bin/cluvfy stage -post crsinst -collect cluster -gi_upgrade -n all
  2. Ignore the following two warnings:
    Verifying OCR Integrity ...WARNING
PRVG-6017 : OCR backup is located in the same disk group "+DATA" as OCR.

Verifying Single Client Access Name (SCAN) ...WARNING
RVG-11368 : A SCAN is recommended to resolve to "3" or more IP

  3. Run the command again till the output displays only the two warnings above. The status of Oracle Custerware status should be Normal again.

  4. You can verify the status with the command:
    Grid_home/bin/crsctl query crs activeversion -f

This issue is tracked with Oracle bug 30099090.

Parent topic: Known Issues When Patching Oracle Database Appliance

Error when patching to 12.1.0.2.190716 Bundle Patch

When patching Oracle Database release 12.1.0.2 to Oracle Database 12.1.0.2.190716 Bundle Patch, an error is encountered.

The ODACLI job displays the following error:

DCS-10001:Internal error encountered: Failed to run SQL script: datapatch script.

The data patch log contains the entry "Prereq check failed, exiting without installing any patches.".

Hardware Models

All Oracle Database Appliance hardware models bare metal deployments

Workaround

Install the same patch again.

This issue is tracked with Oracle bugs 30026438 and 30155710.

Parent topic: Known Issues When Patching Oracle Database Appliance

Patching of M.2 drives not supported

Patching of M.2 drives (local disks SSDSCKJB48 and SSDSCKJB480G7) is not supported.

These drives are displayed when you run the odacli describe-component command. Patching of neither of the two known versions 0112 and 0121 of the M.2 disk is supported.

Hardware Models

Oracle Database Appliance bare metal deployments

Workaround

None

This issue is tracked with Oracle bug 30249232.

Parent topic: Known Issues When Patching Oracle Database Appliance

Known Issues When Deploying Oracle Database Appliance

Understand the known issues when provisioning or deploying Oracle Database Appliance.

Parent topic: Known Issues with Oracle Database Appliance in This Release

Error in creating Oracle AFD-enabled DB system

When creating a DB system with Oracle ASM Filter Driver (Oracle AFD), an error may be encountered.

Problem Description

When you create a DB system with Oracle AFD on Oracle Database Appliance release 19.22, with Oracle Grid Infrastructure or Oracle Database release 19.21 or earlier, then an error may be encountered at the "Install DB System" step.

Failure Message

The following error message is displayed in the database alert.log: 

WARNING: group 2 (RECO) has missing disks
ORA-15040: diskgroup is incomplete
WARNING: group 2 is being dismounted

Command Details

# odacli create-dbsystem

Hardware Models

All Oracle Database Appliance hardware models running Oracle Grid Infrastructure 19.21

Workaround

This issue is fixed in Oracle Grid Infrastructure 19.22 Release Update (RU). Create the DB system using Oracle Grid Infrastructure and Oracle Database release 19.22.

You can create DB system without enabling Oracle AFD by specifying enableAFD=false in the DB system JSON file during DB system creation.

Do not patch or upgrade the existing Oracle AFD-enabled DB system with Oracle Grid Infrastructure or Oracle Database release 19.21 till the fix for bug 36114443 is available in the Oracle Grid Infrastructure and Oracle Database clone files.

Bug Number

This issue is tracked with Oracle bug 36300713.

Parent topic: Known Issues When Deploying Oracle Database Appliance

Error in provisioning Oracle Database Appliance

When provisioning Oracle Database Appliance, an error may be encountered.

Problem Description

When you provision Oracle Database Appliance, the dnf-makecache.service is in FAILED state because the dnf-makecache.timer is active.

Failure Message

dnf-makecache.service: Failed with result 'exit-code'

Command Details

systemctl status dnf-makecache.service

Hardware Models

All Oracle Database Appliance hardware models

Workaround

Manually disable the dnf-makecache.timer so that the dnf-makecache.service is inactive:
systemctl disable dnf-makecache.timer

Bug Number

This issue is tracked with Oracle bug 37200569.

Parent topic: Known Issues When Deploying Oracle Database Appliance

Error in enabling high-availability on a TDE-enabled database

When enabling high-availability on a TDE-enabled database on Oracle Database Appliance, an error may be encountered.

Problem Description

When you enable high-availability on a TDE-enabled database that uses Oracle Key Vault to store TDE keys, an error message may be displayed.

Failure Message

DCS-12721:OKV command "okv admin endpoint create" failed to run: Failed to create endpoint endpoint_name

Command Details

# odacli modify-database -n dbname -ha

Hardware Models

All Oracle Database Appliance hardware models

Workaround

Instead of enabling high-availability after creating the database, enable high-availability during database creation itself.

Bug Number

This issue is tracked with Oracle bug 37182129.

Parent topic: Known Issues When Deploying Oracle Database Appliance

Error in creating DB system

When creating a DB system, an error may be encountered.

Problem Description

When you create a DB system on Oracle Database Appliance, the following error may be encountered:
DCS-10001:THE CONNECTION IS CLOSED

This error may occur when the bare metal system is provisioned with NTP configured, or there is a time difference between bare metal system and the standard NTP server, or the DB system is created after NTP is configured.

Failure Message

[DB System n1 creation] -  DCS-10001:Internal error encountered: Job 'Provision DB System 'n1'' (f91fd1db-78ec-452d-bcdb-975947849370) failed.

Command Details

odacli create-dbsystem

Hardware Models

All Oracle Database Appliance hardware models

Workaround

Provision the bare metal system without configuring NTP.

If there is a time difference between the bare metal system and the standard NTP server, then add several minutes to the current date.

Enable chrony.

  1. Before enabling chrony, add or update the chrony configuration as follows:
    --------
# cat /etc/chrony.conf
server 10.246.6.36 iburst
driftfile /var/lib/chrony/drift
makestep 1.0 -1
rtcsync
logdir /var/log/chrony
---------
  2. Run the systemctl command to enable and start chronyd service:
    date;
systemctl enable chronyd
systemctl start chronyd
systemctl status chronyd
sleep 10;
date;
  3. Create DB system with NTP configured.

Bug Number

This issue is tracked with Oracle bug 37166091.

Parent topic: Known Issues When Deploying Oracle Database Appliance

Error in creating database in multi-user access environment

When creating a database in a multi-user access environment on Oracle Database Appliance, an error may be encountered.

Problem Description

When creating a database in a 23ai DB system on Oracle Database Appliance in a multi-user access environment or a multi-user access passwordless environment, an error may be encountered when the custom user name is in uppercase.

Failure Message

When you run the odacli create-database command, the following error message is displayed: 

DCS-10001: FAILED TO STORE KEY STORE INTO SSO WALLET

Command Details

# odacli create-database

Hardware Models

All Oracle Database Appliance hardware models

Workaround

When you create the database in a 23ai DB system, create the custom user such that it does not start with a number and all the characters are in lowercase.

Bug Number

This issue is tracked with Oracle bug 37090762.

Parent topic: Known Issues When Deploying Oracle Database Appliance

Unexpected behavior when running odacli modify-dbsystem command

When you run the odacli modify-dbsystem command on Oracle Database Appliance, an error may be encountered.

Problem Description

When you run the odacli modify-dbsystem command to attach a vdisk to a DB system or attach a vdisk to a DB system, and patch the system to Oracle Database Appliance release 19.25, any non-vdisk Oracle Clusterware resource from START and STOP dependency entries are removed.

Command Details

# odacli modify-dbsystem

Hardware Models

All Oracle Database Appliance hardware models

Workaround

If the DB system is altered in Oracle Clusterware dependencies, then rollback any related resource, attach the vdisk, or patch the system and apply the custom configuration again.

Bug Number

This issue is tracked with Oracle bug 37232330.

Parent topic: Known Issues When Deploying Oracle Database Appliance

Error in Oracle Data Guard operation after modifying the Oracle ASM port

When running the odacli modify-asmport command on Oracle Database Appliance configured with Oracle Data Guard, an error may be encountered.

Problem Description

If you run the odacli modify-asmport command on an appliance configured with Oracle Data Guard that uses MAX PROTECTION mode, then this could cause a disruption in primary site due to the standby Oracle Clusterware being restarted as part of the Oracle ASM port change.

Failure Message

The following error message may be displayed in the alert logs for the database on the primary host:

ORA-16072: a minimum of one standby database destination is required
Followed by the message:
terminating the instance due to ORA error 16072

Task Level Failure Message

The job may fail at the Stop CRS on DB System(s) step. The complete details of the error are displayed in the Message section of the command output.

Command Details

# odacli modify-asmport

Hardware Models

All Oracle Database Appliance hardware models

Workaround

Start the database instance on the primary host.

Bug Number

This issue is tracked with Oracle bug 36931905.

Parent topic: Known Issues When Deploying Oracle Database Appliance

Error in database creation on multi-user access enabled system

When creating a database on multi-user access enabled system on Oracle Database Appliance, an error may be encountered.

Problem Description

When you create a database on a multi-user access enabled system, an error message may be displayed.

Failure Message

When the user name of database owner contains both lowercase and uppercase letters, the error message may be as follows:

[jobid-74f31148-ebe0-4507-9296-b9ad4ca7e03b] - [FATAL] Error in Process: /u01/app/KvEl6/product/19.0.0.0/dbhome_2/bin/orapwd
    [jobid-74f31148-ebe0-4507-9296-b9ad4ca7e03b] - Enter password for SYS:
    [jobid-74f31148-ebe0-4507-9296-b9ad4ca7e03b] - OPW-00010: Could not create the password file.
    [jobid-74f31148-ebe0-4507-9296-b9ad4ca7e03b] - ORA-00600: internal error code, arguments: [kfzpCreate02], [0], [], [], [], [], [], [], [], [], [], []
    [jobid-74f31148-ebe0-4507-9296-b9ad4ca7e03b] - ORA-15260: permission denied on ASM disk group
    [jobid-74f31148-ebe0-4507-9296-b9ad4ca7e03b] - ORA-06512: at "SYS.X$DBMS_DISKGROUP", line 679
    [jobid-74f31148-ebe0-4507-9296-b9ad4ca7e03b] - ORA-06512: at line 2
When the user name of database owner begins with number digit, the error message may be as follows:
PRCZ-4001 : failed to execute command "/u01/app/6RXNI/product/19.0.0.0/dbhome_15//bin/dbca" using the privileged execution plugin "odaexec" on nodes "scaoda901c7n1" within 5,000 seconds
PRCZ-2103 : Failed to execute command "/u01/app/6RXNI/product/19.0.0.0/dbhome_15//bin/dbca" on node "scaoda901c7n1" as user "6RXNI". Detailed error:
[FATAL] [DBT-05801] There are no ASM disk groups detected.
  CAUSE: ASM may not be configured, or ASM disk groups are not created yet.
  ACTION: Create ASM disk groups, or change the storage location to File System.
[FATAL] [DBT-05801] There are no ASM disk groups detected.
  CAUSE: ASM may not be configured, or ASM disk groups are not created yet.
  ACTION: Create ASM disk groups, or change the storage location to File System.

Command Details

# odacli create-database

Hardware Models

All Oracle Database Appliance hardware models

Workaround

Do not start custom user name with number digit or have mixed-case letters in the custom user name.

Bug Number

This issue is tracked with Oracle bug 36878796.

Parent topic: Known Issues When Deploying Oracle Database Appliance

Error in configuring Oracle ASR

When configuring Oracle ASR, an error may be encountered when registering Oracle ASR Manager due to an issue while contacting the transport server.

Failure Message

The following error message is displayed:

DCS-10045:Validation error encountered: Registration failed : Please check the agent logs for details.

Command Details

# odacli configure-asr

Hardware Models

All Oracle Database Appliance hardware models

Workaround

Retry configuring Oracle ASR using the odacli configure-asr command.

Bug Number

This issue is tracked with Oracle bug 36363437.

Parent topic: Known Issues When Deploying Oracle Database Appliance

Error in starting the DB System

When starting a DB system on an Oracle Database Appliance, an error may be encountered.

Problem Description

If DBVM is undefined using virsh undefine dbvm_name, then the odacli start-dbsystem command may fail to run.

Failure Message

The following error message may be displayed:
DCS-10001:Internal error encountered: error: failed to get domain 'dbvm_name'

Hardware Models

All Oracle Database Appliance hardware models running Oracle Database Appliance release 19.21

Workaround

Run virsh define /u05/app/sharedrepo/dbsystem/.ACFS/snaps/vm_dbvm_name/dbvm_name.xml to define the VM. Then start the DB system.

Bug Number

This issue is tracked with Oracle bug 36051738.

Parent topic: Known Issues When Deploying Oracle Database Appliance

Error in creating database

When creating a database on Oracle Database Appliance, an error may be encountered.

Problem Description

When creating a database on Oracle Database Appliance, the operation may fail after the createDatabaseByRHP task. However, the odacli list-databases command displays the status as CONFIGURED for the failed database in the job results.

Failure Message

When you run the odacli create-database command, the following error message is displayed: 

DCS-10001:Internal error encountered: Failed to clear all listeners from database

Command Details

# odacli create-database

Hardware Models

All Oracle Database Appliance hardware models

Workaround

Check the job description of the odacli create-database command using the odacli describe-job command. Fix the issue for the task failure in the odacli create-database command. Delete the database with the command odacli delete-database -n db_name and retry the odacli create-database command.

Bug Number

This issue is tracked with Oracle bug 34709091.

Parent topic: Known Issues When Deploying Oracle Database Appliance

Error in creating two DB systems

When creating two DB systems concurrently in two different Oracle ASM disk groups, an error is encountered.

When attempting to start the DB systems, the following error message is displayed:
CRS-2672: Attempting to start 'vm_name.kvm' on 'oda_server'
CRS-5017: The resource action "vm_name.kvm start" encountered the following
error:
CRS-29200: The libvirt virtualization library encountered the following
error:
Timed out during operation: cannot acquire state change lock (held by
monitor=remoteDispatchDomainCreate)
. For details refer to "(:CLSN00107:)" in
"/u01/app/grid/diag/crs/<oda_server>/crs/trace/crsd_orarootagent_root.trc".
CRS-2674: Start of 'vm_name.kvm' on 'oda_server' failed
CRS-2679: Attempting to clean 'vm_name.kvm' on 'oda_server'
CRS-2681: Clean of 'vm_name.kvm' on 'oda_server' succeeded
CRS-4000: Command Start failed, or completed with errors.

Hardware Models

All Oracle Database Appliance hardware models

Workaround

Do not create two DB systems concurrently. Instead, complete the creation of one DB system and then create the other.

This issue is tracked with Oracle bug 33275630.

Parent topic: Known Issues When Deploying Oracle Database Appliance

Error in adding JBOD

When you add a second JBOD to your Oracle Database Appliance deployment on which a DB system is running, an error is encountered.

The following error message is displayed:
ORA-15333: disk is not visible on client instance

Hardware Models

All Oracle Database Appliance hardware models bare metal and dbsystem

Workaround

Shut down dbsystem before adding the second JBOD. 
systemctl restart initdcsagent

This issue is tracked with Oracle bug 32586762.

Parent topic: Known Issues When Deploying Oracle Database Appliance

Error in provisioning appliance after running cleanup.pl

Errors encountered in provisioning applince after running cleanup.pl.

After running cleanup.pl, provisioning the appliance fails because of missing Oracle Grid Infrastructure image (IMGGI191100). The following error message is displayed: 

DCS-10042:User oda-cliadmin cannot be authorized.

Hardware Models

All Oracle Database Appliance hardware models for bare metal deployments

Workaround

After running cleanup.pl, and before provisioning the appliance, update the repository as follows:

# odacli update-repository -f /**gi**

This issue is tracked with Oracle bug 32707387.

Parent topic: Known Issues When Deploying Oracle Database Appliance

Error encountered after running cleanup.pl

Errors encountered in running odacli commands after running cleanup.pl.

After running cleanup.pl, when you try to use odacli commands, the following error is encountered: 

DCS-10042:User oda-cliadmin cannot be authorized.

Hardware Models

All Oracle Database Appliance hardware models for bare metal deployments

Workaround

Run the following commands to set up the credentials for the user oda-cliadmin on the agent wallet: 

# rm -rf /opt/oracle/dcs/conf/.authconfig  
# /opt/oracle/dcs/bin/setupAgentAuth.sh

This issue is tracked with Oracle bug 29038717.

Parent topic: Known Issues When Deploying Oracle Database Appliance

Errors in clone database operation

Clone database operation fails due to errors.

If the source database is single-instance or Oracle RAC One Node, or running on the remote node, the clone database operation fails, because the paths are not created correctly in the control file.

Clone database operation may also fail with errors if the source database creation time stamp is too close to the clone operation (at least within 60 minutes).

Hardware Models

All Oracle Database Appliance high-availability hardware models for bare metal deployments

Workaround

Create the clone database from the source database instance that is running on the same node from which the clone database creation is triggered.

For Oracle Database 12c and later, synchronize the source database before the clone operation, by running the command:
SQL> alter system checkpoint;

This issue is tracked with Oracle bugs 29002563, 29002004, 29001906, 29001855, 29001631, 28995153, 28986643, 30309971, and 30228362.

Parent topic: Known Issues When Deploying Oracle Database Appliance

Known Issues When Managing Oracle Database Appliance

Understand the known issues when managing or administering Oracle Database Appliance.

Parent topic: Known Issues with Oracle Database Appliance in This Release

Error in upgrading Oracle Data Guard

When upgrading Oracle Data Guard, an error may be encountered.

Problem Description

If you configured Oracle Data Guard on a multi-user access enabled Oracle Database Appliance release 19.19 system, as odaadmin user, then this Oracle Data Guard configuration may not display when you run the odacli list-dataguardstatus command. If you upgrade this system to Oracle Database Appliance release 19.23 using Data Preserving Reprovisioning, then the Validate Database Service presence step in the the create-preupgradereport precheck may fail for the Oracle Data Guard database.

The following error message is displayed:
One or more pre-checks failed for [DB]

Command Details

# odacli create-preupgradereport 
# odacli describe-preupgradereport

Task Level Failure message

"The following services [TDG1yn_ro, TDG1yn_rw, Y6Z_ro, Y6Z_rw] created on database 
'TDG1yn' can result in a failure in 'detach-node'

Hardware Models

All Oracle Database Appliance hardware models X9-2, X8-2, and X7-2

Workaround

For each service listed, do the following:
  1. Stop the service reported:
    srvctl stop service -d db_unique_name -service service_name
  2. Remove the service:
    srvctl remove service -d db_unique_name -service service_name

Bug Number

This issue is tracked with Oracle bug 36610040.

Parent topic: Known Issues When Managing Oracle Database Appliance

Error in switchover of Oracle Data Guard

When performing switchover of Oracle Data Guard, an error may be encountered.

Problem Description

The odacli switchover-dataguard command may display an error, but the switchover is actually successful.

The following error message is displayed:
Message: DCS-10001:Internal error encountered: Unable to switchover Dg.
DCS-10001:Internal error encountered: Unable to switchover Dg.

Command Details

# odacli switchover-dataguard

Hardware Models

All Oracle Database Appliance hardware models running Oracle Database 23ai DB system

Workaround

Do the following:
  1. After the odacli switchover-dataguard job fails, run DGMGRL > SHOW CONFIGURATION; to check if the database role switch is complete and Oracle Data Guard shows a SUCCESS status.
  2. If yes, then ignore the error and proceed to run the odacli list-dataguardstatus or odacli describe-dataguardstatus command to update the Oracle Data Guard metadata.

Bug Number

This issue is tracked with Oracle bug 37191228.

Parent topic: Known Issues When Managing Oracle Database Appliance

Error in relocating and re-keying a TDE-enabled database

When relocating and re-keying a TDE-enabled database on Oracle Database Appliance, an error may be encountered.

Problem Description

When you relocate a TDE-enabled database that uses Oracle Key Vault to store TDE keys with the option --target-node,-tn, and re-key with the option --rekey-tde,-rkt, at the same time, an error may be encountered when setting the TDE master encryption key.

Failure Message

DCS-10164:Failed to configure TDE: Failed to set TDE Master Encryption key

Command Details

# odacli modify-database -n dbname -rkt -tn target_node_name

Hardware Models

All Oracle Database Appliance hardware models

Workaround

Perform the relocation and re-key operations separately, one after another.

Bug Number

This issue is tracked with Oracle bug 37155404.

Parent topic: Known Issues When Managing Oracle Database Appliance

Error in restoring TDE-enabled database

When restoring a TDE-enabled database on Oracle Database Appliance, an error may be encountered.

Problem Description

When you restore a TDE-enabled database that uses Oracle Key Vault to store TDE keys, from NFS or Object Store backup destination, and with database type as single-instance database with high-availability enabled, and DB role as PRIMARY, an error message may be displayed during the Relocate database task.

Failure Message

DCS-10001:Internal error encountered: Failed to relocate database.

Command Details

# odacli irestore-database

Hardware Models

All Oracle Database Appliance hardware models

Workaround

None.

Bug Number

This issue is tracked with Oracle bug 37193435.

Parent topic: Known Issues When Managing Oracle Database Appliance

Error in re-keying a TDE-enabled database

When re-keying a TDE-enabled database on Oracle Database Appliance, an error may be encountered.

Problem Description

The status of the database may be set to FAILED when the wrong password TDE password is used to re-key the TDE key.

Failure Message

Modify databaseDCS-10001:Internal error encountered: PL/SQL procedure successfully completed.
 
PL/SQL procedure successfully completed.
 
begin
*
ERROR at line 1:
ORA-28353: failed to open wallet
ORA-06512: at line 3.

Command Details

# odacli modify-database -n dbname -rkt

Hardware Models

All Oracle Database Appliance hardware models

Workaround

Retry the operation with the correct TDE password. The status of the database is set to CONFIGURED.

Bug Number

This issue is tracked with Oracle bug 37079490.

Parent topic: Known Issues When Managing Oracle Database Appliance

Error in deleting a TDE-enabled database

When deleting a TDE-enabled database on Oracle Database Appliance, an error may be encountered.

Problem Description

When you delete an Oracle Key Vault server configuration object created with wrong credentials, then an error message may be displayed.

Failure Message

DCS-12729:Operation on the OKV object failed: /etc/OKV/okvobj88/log/okv0.log.0 (Permission denied)
{
"result" : "Failure",
"message" : "Username does not exist"
}

Command Details

# odacli delete-okvserverconfig -n okv_server_config_name

Hardware Models

All Oracle Database Appliance hardware models

Workaround

Follow these steps:
  1. Delete the existing wallets present in /etc/OKV/okv_server_config_name/client_wallet location as follows:
    rm -f /etc/OKV/okv_server_config_name/client_wallet/*
  2. Switch to the user who owns the Oracle Key Vault server configuration object. In the case of non-multi user access and non-multi user access passwordless environment, switch to the oracle user.
  3. Regenerate Oracle Key Vault client auto-login wallet using the following command. Provide the correct Oracle Key Vault user credentials on prompting. 
    /etc/OKV/okv_server_config_name/bin/okv admin client-wallet add --client-wallet 
/etc/OKV/okv_server_config_name/client_wallet/ --wallet-user okv_user_name
Password:
  4. Retry the deletion of Oracle Key Vault server configuration object as follows: 
    odacli delete-okvserverconfig -n okv_server_config_name

Bug Number

This issue is tracked with Oracle bug 37222709.

Parent topic: Known Issues When Managing Oracle Database Appliance

Error in relocating a TDE-enabled database

When relocating a TDE-enabled database on Oracle Database Appliance, an error may be encountered.

Problem Description

When you relocate a TDE-enabled Oracle Enterprise Edition High-Availability database that uses Oracle Key Vault to store TDE keys, and was created using the okvclient.jar file, an error message may be displayed.

Failure Message

DCS-10001:Internal error encountered: Failed to relocate database.DCS-10001:Internal error encountered: Failed to relocate database.

Command Details

# odacli modify-database -n dbname -rkt -tn target_node_name

Hardware Models

All Oracle Database Appliance hardware models

Workaround

Use the Oracle Key Vault server configuration object to create a TDE-enabled Oracle Enterprise Edition High-Availability database that uses Oracle Key Vault to store TDE keys, so that it can be relocated successfully.

Bug Number

This issue is tracked with Oracle bug 37175219.

Parent topic: Known Issues When Managing Oracle Database Appliance

Error in restoring a TDE-enabled database

When restoring a TDE-enabled database on Oracle Database Appliance, an error may be encountered.

Problem Description

When you restore a TDE-enabled database that uses Oracle Key Vault to store TDE keys, from NFS or Object Store backup destination, and with database type as Oracle RAC One Node database, and DB role as STANDBY, an error message may be displayed during the Setting TDE Master Encryption Key task.

Failure Message

DCS-10001:Internal error encountered: null.DCS-10001:Internal error encountered: null.

Command Details

# odacli irestore-database

Hardware Models

All Oracle Database Appliance hardware models

Workaround

None.

Bug Number

This issue is tracked with Oracle bug 37193436.

Parent topic: Known Issues When Managing Oracle Database Appliance

Error in deleting a TDE-enabled database

When deleting a TDE-enabled database on Oracle Database Appliance, an error may be encountered.

Problem Description

When you delete a TDE-enabled database that uses Oracle Key Vault release 21.8 to store TDE keys, then an error message may be displayed during the OKV delete task.

Failure Message

DCS-10001:Internal error encountered: Failed to delete Wallet <wallet_name> : okv.log.0 (Permission denied)
{
"result" : "Failure",
"message" : "Insufficient privileges on wallet"
}.

Command Details

# odacli delete-database -n db_name

Hardware Models

All Oracle Database Appliance hardware models

Workaround

Follow these steps:
  1. Log into as the Oracle Key Vault administrator to the Oracle Key Vault server where the Oracle Key Vault wallet is present.
  2. Navigate to the Keys & Wallets tab.
  3. Click the edit icon for the wallet that you want to delete.
  4. In the Select Endpoint/User Group section, select the Type as Users from the drop down list.
  5. Select the user that owns the Oracle Key Vault wallet.
  6. In the Select Access Level section, select Read and Modify, and then Manage Wallet.
  7. Click Save.
  8. Delete the database.

Bug Number

This issue is tracked with Oracle bug 36640379.

Parent topic: Known Issues When Managing Oracle Database Appliance

Error in deleting database home

When deleting a database home on Oracle Database Appliance, an error may be encountered.

Problem Description

When you delete a database home, the database home is not deleted completely. The subfolders and files exist in the corresponding database home location and the database home entry exists in the /u01/app/oraInventory/ContentsXML/inventory.xml file.

Failure Message

When the odacli update-database command is run, the following error message is displayed: 

Failed to execute sqlpatch for database …

Command Details

# odacli delete-dbhome

Hardware Models

All Oracle Database Appliance hardware models

Workaround

Before you run the odacli delete-dbhome command, confirm that the wOraDBversion_homeidx exists in the /opt/oracle/rhp/RHPCheckpoints/ location on the same node where you run the command.

Bug Number

This issue is tracked with Oracle bug 36864228.

Parent topic: Known Issues When Managing Oracle Database Appliance

Error in configuring Oracle Data Guard

When configuring Oracle Data Guard on Oracle Database Appliance, an error may be encountered.

Problem Description

When you configure Oracle Data Guard on the second node of the standby system on an Oracle Database Appliance high-availability deployment, the operation may fail at step Configure Standby database (Standby site) in the task Reset Db sizing and hidden parameters for ODA best practice.

Command Details

odacli configure-dataguard

Hardware Models

All Oracle Database Appliance hardware models high-availability deployments

Workaround

Run odacli configure-dataguard on the first node of the standby system in the high-availability deployment

Bug Number

This issue is tracked with Oracle bug 33401667.

Parent topic: Known Issues When Managing Oracle Database Appliance

Error in cleaning up a deployment

When cleaning up a Oracle Database Appliance, an error is encountered.

During cleanup, shutdown of Clusterware fails because the NFS export service uses Oracle ACFS-based clones repository.

Hardware Models

All Oracle Database Appliance hardware models with DB systems

Workaround

Follow these steps:
  1. Stop the NFS service on both nodes:
    service nfs stop
  2. Clean up the bare metal system. See the Oracle Database Appliance Deployment and User's Guide for your hardware model for the steps.

This issue is tracked with Oracle bug 33289742.

Parent topic: Known Issues When Managing Oracle Database Appliance

Error in display of file log path

File log paths are not displayed correctly on the console but all the logs that were generated for a job have actually logged the correct paths.

Hardware Models

All Oracle Database Appliance hardware models with virtualized platform

Workaround

None.

This issue is tracked with Oracle bug 33580574.

Parent topic: Known Issues When Managing Oracle Database Appliance

Error in the enable apply process after upgrading databases

When running the enable apply process after upgrading databases in an Oracle Data Guard deployment, an error is encountered.

The following error message is displayed:
Error: ORA-16664: unable to receive the result from a member

Hardware Models

All Oracle Database Appliance hardware models

Workaround

Follow these steps:
  1. Restart standby database in upgrade mode: 
    srvctl stop database -d <db_unique_name> 
Run PL/SQL command: STARTUP UPGRADE;
  2. Continue the enable apply process and wait for log apply process to refresh.
  3. After some time, check the Data Guard status with the DGMGRL command:
    SHOW CONFIGURATION;

This issue is tracked with Oracle bug 32864100.

Parent topic: Known Issues When Managing Oracle Database Appliance

Error in updating Role after Oracle Data Guard operations

When performing operations with Oracle Data Guard on Oracle Database Appliance, an error is encountered in updating the Role.

The dbRole component described in the output of the odacli describe-database command is not updated after Oracle Data Guard switchover, failover, and reinstate operations on Oracle Database Appliance.

Hardware Models

All Oracle Database Appliance hardware models with Oracle Data Guard configuration

Workaround

Run odacli update-registry -n db --force/-f to update the database metadata. After the job completes, run the odacli describe-database command and verify that dbRole is updated.

This issue is tracked with Oracle bug 31378202.

Parent topic: Known Issues When Managing Oracle Database Appliance

Inconsistency in ORAchk summary and details report page

ORAChk report summary on the Browser User Interface may show different counts of Critical, Failed, and Warning issues than the report detail page.

Hardware Models

Oracle Database Appliance hardware models bare metal deployments

Workaround

Ignore counts of Critical, Failed, and Warning issues in the ORAchk report summary on the Browser User Interface. Check the report detail page.

This issue is tracked with Oracle bug 30676674.

Parent topic: Known Issues When Managing Oracle Database Appliance

The odaeraser tool does not work if oakd is running in non-cluster mode

After cleaning up the deployment, the Secure Eraser tool does not work if oakd is running in non-cluster mode.

Hardware Models

All Oracle Database Appliance Hardware bare metal systems

Workaround

After cleanup of the deployment, oakd is started in the non-cluster mode, and it cannot be stopped using "odaadmcli stop oak" command. In such a case, if the Secure Erase tool is run, then the odaeraser command fails.

Use the command odaadmcli shutdown oak to stop oakd.

This issue is tracked with Oracle bug 28547433.

Parent topic: Known Issues When Managing Oracle Database Appliance