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.
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:
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.
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
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>
orapwd file=orapw<ORACLE_SID> password=XXXXX entries=10 ignorecase=y
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.
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
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)
)
)
Steps to Install 12.2.6.2 Demantra in Window 64-bit 2012 Server Machine are
(Here Demantra schema : DEM)
Option to choose the standard or custom application shows up.
Choose tablespaces where Demantra objects will reside. Make sure you have enough free tablespace.
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
All passwords are set to same passwords. (Note: It is case sensitive)
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
[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]$
Keep the log files generated during the installation for further review: D:\temp\reInstall
Check the versions.
Use dm /
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.
Detailed steps will be covered in the follow up blog, however high-level steps are
Detailed steps will be covered in the follow up blog, however high-level steps include-
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
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.