EM 13c: Patching a Database Oracle Home with Fleet Maintenance in Enterprise Manager 13c Cloud Control Fails With Error: The value for DB_PRODUCT_VERSION is expected but is not set

(Doc ID 2353900.1)

Last updated on FEBRUARY 02, 2018

Applies to:

Enterprise Manager for Oracle Database - Version 13.2.2.0.0 and later
Information in this document applies to any platform.

Symptoms

Enterprise Manager (EM) 13.2 Cloud Control
Oracle Database 12.2.0.1 Fleet Maintenance (patching)



Patching an Oracle Database Oracle Home using Fleet Maintenance fails with error:

 

Navigate: Enterprise > Provisioning and Patching > Procedure Library > Click on the failed Deployment Procedure.

Job Steps Log for Job :Initialize Deployment Procedure

1:Evaluate expression:evaluateExpression


***** PREREQ Provisioning Initialize Compute Step Start *****

Skip Product Prereqs set to
Skip GI Product Prereqs evaluated to false
Skip DB Product Prereqs evaluated to false
Platform name is  : linux_x64

Generic CVU Component : CVU Prerequisite-fixup components/all_platforms/CVU Generic Prerequisite-Fixup component

Platform specific CVU Component : Database Provisioning CVU Downloads/CVU Prerequisite-fixup components/linux_x64/CVU OSD Prerequisite-Fixup component

The platform selected is not windows : true

**** SIDB PREREQ TARGET LIST CREATION START ******

Target Name : <target host name>
Target Type : host
Work Dir : /backup/wordir/260617130688569//260618050554555//MASSDB-e616fa65711a4f3bb131cfe0f4b3863e
User Dir List : /u01/app/oracle /u01/app/oracle/product/12.2.0.1.180116/dbhome_1
Oracle Home Location : /u01/app/oracle/product/12.2.0.1.180116/dbhome_1
Oracle Base Location : /u01/app/oracle
Oracle Home Name :Orasidb11g_home1_2018_01_24_04_25
Validating the credential against <agent target name>

Named Credential for normal users : ORA_PATCH:test : oracle.sysman.core.sec.credstore.EMCredentialReferenceForCredNameImpl@xxxxxxxx

set DB user name as:oracle
set DB user password

Named Credential for root users : SVC_ORAPATCH:test : oracle.sysman.core.sec.credstore.EMCredentialReferenceForCredNameImpl@xxxxxxxx

The data mode handler found is: DEFAULT_CUSTOM_SUDO_PDP

User has selected valid Root Credentials for the given Host. Setting Variable NO_ROOT_ACCESS to false.


**** SIDB REFERENCE HOST TARGET LIST CREATION START ******

HOSTNAME :

**** SIDB DEPLOY TARGET LIST CREATION END ****** ExpressionEvaluationException: Below error message was returned while executing this Computational step.
----------------------------------------------------------
The value for DB_PRODUCT_VERSION is expected but is not set
----------------------------------------------------------



 

 

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms