Install Oracle Demantra 12.2 & Configure Web Server and Analytical Engine on Linux

Narendra Dixit | April 7, 2022

Oracle / Database

Oracle Demantra is a demand management and supply chain management tool provided by Oracle.

It is a best-in-class provider of demand management, sales & operations planning, and trade promotions management solutions. It is integrated with Oracle E-Business Suite / Oracle Advanced Planning (APS) Suite (Oracle Advanced Supply Chain Planning (ASCP)) to leverage Demantra demand management and supply chain management functionality to maximum level. For understanding more architecture related details, refer to my earlier blog.

In this one, I have discussed step by step instructions to Install Oracle Demantra 12.2 with Oracle Advanced Planning (APS) 12.2 Suite and configure of Demantra web server and Analytical engine on Linux server for better performance and stability.

Note

Installation steps are based on Oracle Demantra 12.2.6.2 with Oracle Advanced Planning (APS) 12.2.6 Suite
Functional Integration steps of Oracle Demantra and Oracle APS/ASCP is out of scope of this document.

Installation Steps for Demantra 12.2 with APS/ASCP 12.2

The process to install the Demantra application is a multi-step process.

Steps to Install Oracle Demantra 12.2 with Oracle Advanced Planning (APS) 12.2 Suite and configure of Demantra web server and Analytical engine on Linux server for better performance has been divided into the following four phases:

Phase 1: Prepare APS/ASCP database for Demantra
Phase 2: Install Oracle Demantra on Windows Machine
Phase 3: Configure Oracle Demantra Web Server and Deploy Demantra Application (ear) on Linux
Phase 4: Configure and Deploy Oracle Demantra Analytical Engine on Linux

I am focusing on Phase 1 and Phase 2 this time and in my follow up blog, I will be covering Phase 3 and 4.

Following are the details related to Phase 1 and 2:

This document assumes, ASCP Suite is already provisioned, also build of Window and Linux servers for Demantra is completed along with users/group/networking/security/storage already in place.

Prepare APS/ASCP database for Demantra

The Demantra application must be installed in the same database as ASCP /APS (target Planning instance) for the integration of ASCP and Demantra to work. The EBS source instance can be in a separate database.

Please complete the following steps in the ASCP Database

Add below into init ora file

db_16K_cache_size=1024M

db_securefile=NEVER

SQL> show parameter db_16k_cache_size

NAME TYPE VALUE

db_16k_cache_size big integer 1G SQL> show parameter db_securefile

NAME TYPE VALUE

db_securefile string NEVER SQL>

Create the password file using orapwd ignore if password file already exists.

orapwd file=orapw<ORACLE_SID> password=XXXXX entries=10 ignorecase=y

Create the Tablespace TS_DMT_DATA and TS_DMT_IDX with blocksize 16k in database by completing the following step.

SQL> CREATE TABLESPACE TS_DMT_DATA DATAFILE

'/u01/oradata/DTTIC/d_dmt_data01.dbf' SIZE 2G AUTOEXTEND ON MAXSIZE 20G,

/u01/oradata/DTTIC/d_dmt_data02.dbf' SIZE 2G AUTOEXTEND ON MAXSIZE 20G

LOGGING ONLINE PERMANENT BLOCKSIZE 16K

EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K

SEGMENT SPACE MANAGEMENT AUTO; 2 3 4 5 6

Tablespace created.

SQL> CREATE TABLESPACE TS_DMT_IDX DATAFILE

'/u01/oradata/DTTIC/d_dmt_idx01.dbf' SIZE 2G AUTOEXTEND ON MAXSIZE 20G,

/u01/oradata/DTTIC/d_dmt_idx02.dbf' SIZE 2G AUTOEXTEND ON MAXSIZE 20G

LOGGING ONLINE PERMANENT BLOCKSIZE 16K

EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K

SEGMENT SPACE MANAGEMENT AUTO; 2 3 4 5 6

Tablespace created.

Phase 2: Install Oracle Demantra on Windows Machine

The Demantra application is installed on a Windows server because Oracle Demantra Installer and Oracle Demantra Administrative Utilities (Installer, Business Modeler and Demand Management Tools etc.) are supported only on Windows platforms.

The Demantra Installer on window server creates the database schema (in APS Database) and the administrator tools required to configure the application.

Pre steps to Installing 12.2.6.2 Demantra in Window 64-bit 2012 Server Machine are

Install 64-bit Oracle Database 12c (12.1.0.2) client on Window Server.
Add the Oracle home and Oracle base in you env variables

Step1: Right click on My Computer Properties Click on Advanced system settings Environment Variables

Step2: Setup TNS for Planning Database

Add below into tnsnames.ora

DTTIC= (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=ndemdb01 .xx.xxx..net)(PORT=1543)) (CONNECT_DATA= (SERVICE_NAME=DTTIC) (INSTANCE_NAME=DTTIC) ) )

Test SQLPLUS connection from the Oracle client (system/syssbx@dbSid)

Steps to Install 12.2.6.2 Demantra in Window 64-bit 2012 Server Machine are

Download Patch 25820351: DEMANTRA 12.2.6.2 Release from My Oracle Support and extract p25820351_122620_MSWIN-x86-64.zip at temp location on window server
Double click on setup.exe

Click on Install Demantra Spectrum.
Installer window is showing up.
Click Next
Choose the options to deploy Demantra and/ or engine on Linux Note: Please select these options to implement demantra Web and Analytical engine on Linux servers for better performance and stability.

Choose the installation folder for Demantra application.
Choose the location of the shortcuts/icons for your Demantra application.
Fill in the DBA user / password.

Then click Next on Demantra installer screen.
Fill in your Demantra schema name and the password.

(Here Demantra schema : DEM)

Fill in your connection details

Depending on if your DBA (in this case system user) has SYSDBA privileges, a warning message can popup. Click Next

Option to choose the standard or custom application shows up.
Choose tablespaces where Demantra objects will reside. Make sure you have enough free tablespace.

Choose languages. A default language must be selected.
Set up the Demantra URL.
You can set up the email account or it can be set up later.
Check the summary of the choices and click Install.

Wait for installation to run.

It will ask for java 8 update 51 installation, if not already installed.

Install Java 8 update 51.
Choose Next.
Choose the folder for java installation.
Close java setup when the installation is complete.

Acrobat reader installer will be launched

Click ok

Demantra installation will continue.

Fill in Demantra user passwords.

All passwords are set to same passwords. (Note: It is case sensitive)

Click Done to complete the installation.

If the DBA user has no SYSDBA privileges, a warning pops up.

Make note of the SQL that must be run after completing the installation.
Click OK. The installation has completed.

30.Manually execute sys_grants.sql

Manually execute sys_grants.sql Copy D:\demantra\Demand Planner\Database Objects\Oracle Server\admin to Database server into a temp location e.g. /u01/app/oradc/DTTIC/patches/Demantra

[oradc@ndemdb01 admin]$ pwd

/u01/app/oradc/DTTIC/patches/demantra/admin

[oradc@ndemdb01 admin]$ ls -lrt

total 68

-rw-rw-r-- 1 oradc oradc 234 Mar 30 14:17 UPDATE_PASSWORDS.sql

-rw-rw-r-- 1 oradc oradc 2265 Mar 30 14:17 system_revokes.sql

-rw-rw-r-- 1 oradc oradc 14568 Mar 30 14:17 sys_grants.sql

-rw-rw-r-- 1 oradc oradc 5216 Mar 30 14:17 run_table_reorg.sql

-rw-rw-r-- 1 oradc oradc 1298 Mar 30 14:17 revoke_table_reorg.sql

-rw-rw-r-- 1 oradc oradc 1000 Mar 30 14:17 grant_table_reorg.sql

-rw-rw-r-- 1 oradc oradc 26221 Mar 30 14:17 GRANT_HTTP_TO_DEMANTRA.sql

[oradc@ndemdb01 admin]$ sqlplus / as sysdba

SQL> @sys_grants.sql DEM ACL_DEFAULT ACL_DEFAULT false

false USER is “SYS”

spool grant_dbms_crypto.log

– grant_dbms_crypto

…………………………………

– update_passwords

EXECUTE “DEM”.UPDATE_PASSWORDS;

spool off

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options [oradc@ndemdb01 admin]$

Check the log file for any errors.

Keep the log files generated during the installation for further review: D:\temp\reInstall
Check the versions.

Check if you can log into Business Modeler. Start Business Modeler from modeler.bat

Fill in the user and password.

Use dm / (It is case sensitive)

See the Business Modeler Version from Help > About Business Modeler.

Check if Tomcat is starting up successfully. Double click on startup.bat
Make sure you can log into demantra anyware. http://localhost:8080/demantra/portal/anywhereLogin.jsp from demantra local server http://nchwdat01.xxx.net:8080/demantra/portal/anywhereLogin.jsp from any machine on internal network

Review List of High Priority Patches see My Oracle Support Note 470574.1 and apply the applicable latest patches
Take the backup of and Demantra file system on window machine and Demantra schema.

Phase 3: Configure Oracle Demantra Web Server and Deploy Demantra Application (ear) on Linux

Detailed steps will be covered in the follow up blog, however high-level steps are

Install Java JDK 8 64-bit on Linux server (Demenatra Web Server)
Install Weblogic 12c (12.1.3.0.0 ) on Linux server (Demenatra Web Server)
Configure domain for Demantra Deployment
Configure JDBC Data Source
Enable Archived Real Path
Create Demantra WAR file on Window Machine
Deploy Demantra ear
Activate Demantra application

Phase 4: Configure and Deploy Oracle Demantra Analytical Engine on Linux

Detailed steps will be covered in the follow up blog, however high-level steps include-

Install Java JDK 8 64-bit and Oracle Client on Linux Server (Demantra Analytical Engine)
Copy the engine tar from windows server to Linux Server
Create the Engine Data Source File
Configure Demantra Analytical Engine on Analytical Server with a New Oracle Wallet Repository
Start the Analytical Engine Starter

Conclusion:

The process to install the Demantra application is a multi-step process which span on multi-instances and uses multi component. However, by following the above instructions you can easily implement all the steps involving different instances and components to significantly reduce implementation time and achieve best out of Demantra. Demantra enables planners to sense demand real time, improve forecast accuracy, and shape demand for profitability.

The result of Integration of these products is a

Enhanced productivity of planners, as it enables them to see an aggregate analytical view with guided analysis.
Informed and faster decisions, as it enables planners to share unified supply chain planning information across the enterprise.
Improves supply chain performance by analyzing all aspects of a supply chain and developing optimal plans across the virtual supply chain.

Learn about Rackspace Managed SQL Databases.

Learn about Rackspace Database Services.

Use the Feedback tab to make any comments or ask questions. You can also start a conversation with us.

Narendra Dixit