JAVA and SQL Based Batches Have Conflict For ORACLE_HOME Requiring to Have Two Separate Profiles (Doc ID 2121730.1)

Last updated on MARCH 30, 2016

Applies to:

Oracle Retail Price Management - Version 14.0.3 and later
Information in this document applies to any platform.

Goal

Retail Price Management (RPM) batches have conflicts for $ORACLE_HOME between JAVA and SQL Plus profiles.
Batches that utilize the ‘rpmbatch’ user and java, will use Oracle Middleware as $ORACLE_HOME (for example /opt/oracle/middleware).
Whereas batches that use SQL Plus and no java, will use $ORACLE_HOME as Oracle DB Client home (/opt/oracle/product/...)
 
Because of this, it requires switching of $ORACLE_HOME value based on the type of batch to be run.
 

Solution

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