C Issues with Oracle Database Appliance X6-2S, X6-2M, and X6-2L

The following are known issues deploying, updating, and managing Oracle Database Appliance X6-2S, X6-2M, and X6-2L:

Databases that are not running cannot be upgraded

When a database is not running, the odacli upgrade-database command does not upgrade the database. However, the job shows that the upgrade completed successfully.

Hardware Models

Oracle Database Appliance X6-2S, X6-2M, and X6-2L

Workaround

Start the database and upgrade it. After successful upgrade, the database status changes to Configured. To verify, run the odacli list-databases command to verify the status.

Patch zip files require concatenation

The patch to update Oracle Database Appliance to release 12.1.2.12.0 consists of two zip files. You must concatenate the two zip files before updating the repository.

Hardware Models

Oracle Database Appliance X6-2S, X6-2M, and X6-2L 

Workaround

Perform the following to concatenate the files before updating the repository:

  1. Download both zip files for patch 26433721 from My Oracle Support.

    p26433721_1212120_Linux-x86-64_1of2.zip and p26433721_1212120_Linux-x86-64_2of2.zip

  2. Upload the files to a temporary location in the /u01 directory in Oracle Database Appliance, then unzip the files.

    When inflated, the files are named oda-sm-12.1.2.12.0-170920-server_1of2.zippart and oda-sm-12.1.2.12.0-170920-server_2of2.zippart

  3. Concatenate the two zip files into a single zip file. For example, a file named p26433721_1212120_Linux-x86-64.zip.

    # cat oda-sm-12.1.2.12.0-170920-server_1of2.zippart oda-sm-12.1.2.12.0-170920-server_2of2.zippart > p26433721_1212120_Linux-x86-64.zip

    The file is named p26433721_1212120_Linux-x86-64.zip

    Update the repository.

    # /opt/oracle/dcs/bin/odacli update-repository -f /u01/tmpdir p26433721_1212120_Linux-x86-64.zip

{   
"jobId" : "c5288c4f-4a0e-4977-9aa4-4acbf81b65a1",   
"status" : "Created",   
"message" : "/u01/tmpdir/p26433721_1212120_Linux-x86-64.zip",   
"reports" : [ ],   
"createTimestamp" : "October 7, 2017 06:52:01 AM WSDT",   
"resourceList" : [ ],   
"description" : "Repository Update",   
"updatedTime" : "October 7, 2017 06:52:01 AM WSDT" 
}

  4. Verify that the job completed successfully.

    # odacli describe-job -i c5288c4f-4a0e-4977-9aa4-4acbf81b65a1  
Job details                                                      
----------------------------------------------------------------                      
ID:  c5288c4f-4a0e-4977-9aa4-4acbf81b65a1             
Description:  Repository Update                  
Status:  Success                 
Created:  October 7, 2017 6:52:01 AM WSDT                 
Message:  /u01/tmpdir/121212_patch.zip  
Task Name                        Start Time                                     End Time                                         Status 
-------------------- --------------------------------- ----------------------------------- -------
Unzip patch bundle      October 7, 2017 6:52:01 AM WSDT     October 7, 2017 6:52:31 AM WSDT      Success

  5. Update the agent, server, and database, as described in “Updating Oracle Database Appliance Software”.

 

See Also:

For more information about updating to release 12.1.2.12.0, including how to update the agent, server, and database, see Updating Oracle Database Appliance Software in the Oracle Database Appliance X6-2S/X6-2M/X6-2L Deployment and User’s Guide.

Upgrading an SE database results in an error: Failed to run datapatch

After successfully upgrading an Oracle Database Standard Edition (SE) to 12.1.0.2, the following error appears in the log file: Failed to run datapatch

Datapatch is a tool that enables automation of post-patch SQL actions for RDBMS patches. The error impacts all Standard Edition databases upgrading to release 12.1.0.2.

The following is an excerpt of the log:

...
The following patches will be applied: 25397136
(DATABASE BUNDLE PATCH 12.1.0.2.170418) 

Installing patches...
Patch installation complete.  Total patches installed: 1

Validating logfiles...
Patch 26609798 apply: WITH ERRORS
  logfile:
/u01/app/oracle/cfgtoollogs/sqlpatch/26609798/21481992/26609798_apply_XT_2017S
ep28_06_58_16.log (errors)
    Error at line 1310: Warning: Package altered with compilation errors.

Please refer to MOS Note 1609718.1 and/or the invocation log
/u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_95130_2017_09_28_06_57_51/sqlpat
ch_invocation.log
for information on how to resolve the above errors.

SQL Patching tool complete on Thu Sep 28 06:58:51 2017
2017-09-28 06:58:51,867 ERROR [Running DataPatch] []
c.o.d.a.r.s.d.DbOperations:  run datapatch
2017-09-28 06:58:51,867 WARN [Running DataPatch] [] c.o.d.a.r.s.d.DbActions:
Failed to run datapatch.

Hardware Models

Oracle Database Appliance X7-2S, X7-2M, X7-2-HA, X6-2S, X6-2M, X6-2L

After replacing a disk, the disk is not added to Oracle ASM

When replacing or adding disks to Oracle Database Appliance X6-2S, X6-2M, or X6-2L, the disk is recognized as good, but it is not added to Oracle Automatic Storage Management (ASM).

Use the procedure to add or expand storage and wait the recommended time between tasks, but the new disks are not added to Oracle ASM.

Hardware Models

Oracle Database Appliance X6-2S, X6-2M, and X6-2L

Workaround

After expanding, adding, or replacing disks, restart oakd.