- \n
- Installation steps are based on Oracle Demantra 12.2.6.2 with Oracle Advanced Planning (APS) 12.2.6 Suite<\/li>\n
- Functional Integration steps of Oracle Demantra and Oracle APS\/ASCP is out of scope of this document. <\/li>\n<\/ul>\n
Installation Steps for Demantra 12.2 with APS\/ASCP 12.2<\/h3>\n
The process to install the Demantra application is a multi-step process.<\/p>\n
\nSteps 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:<\/p>\n
- \n
- Phase 1: Prepare APS\/ASCP database for Demantra<\/li>\n
- Phase 2: Install Oracle Demantra on Windows Machine<\/li>\n
- Phase 3: Configure Oracle Demantra Web Server and Deploy Demantra Application (ear) on Linux<\/li>\n
- Phase 4: Configure and Deploy Oracle Demantra Analytical Engine on Linux<\/li>\n<\/ul>\n
\nI am focusing on Phase 1 and Phase 2 this time<\/p>\n
![\"Demantra](\"\/wp-content\/uploads\/2026\/blog_article_images\/26046-body-Picture1_3.PNG\")
<\/p>\nFollowing are the details related to Phase 1 and 2:<\/strong><\/p>\n
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.<\/p>\n
Prepare APS\/ASCP database for Demantra<\/strong><\/p>\n
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.<\/p>\n
Please complete the following steps in the ASCP Database <\/p>\n
1. <\/strong><\/p>\n
Add below into init ora file<\/p>\n
`db_16K_cache_size=1024M`<\/p>\n
`db_securefile=NEVER`
\n <\/p>\nSQL> `show parameter db_16k_cache_size`<\/p>\n
NAME TYPE VALUE
\n———————————— ———– ——————————
\ndb_16k_cache_size big integer 1G
\nSQL> show parameter db_securefile<\/p>\nNAME TYPE VALUE
\n———————————— ———– ——————————
\ndb_securefile string NEVER
\nSQL><\/p>\n\n2. <\/strong>Create the password file using orapwd ignore if password file already exists.<\/p>\n
`orapwd file=orapw<ORACLE_SID> password=XXXXX entries=10 ignorecase=y`<\/p>\n
3. <\/strong><\/p>\n
Create the Tablespace TS_DMT_DATA and TS_DMT_IDX with blocksize 16k in database by completing the following step. <\/p>\n
SQL> CREATE TABLESPACE TS_DMT_DATA DATAFILE<\/p>\n
\/u01\/oradata\/DTTIC\/d_dmt_data01.dbf’ SIZE 2G AUTOEXTEND ON MAXSIZE 20G,<\/p>\n
\/u01\/oradata\/DTTIC\/d_dmt_data02.dbf’ SIZE 2G AUTOEXTEND ON MAXSIZE 20G<\/p>\n
LOGGING ONLINE PERMANENT BLOCKSIZE 16K<\/p>\n
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K<\/p>\n
SEGMENT SPACE MANAGEMENT AUTO; 2 3 4 5 6`<\/p>\n
Tablespace created.<\/p>\n
SQL> CREATE TABLESPACE TS_DMT_IDX DATAFILE<\/p>\n
‘\/u01\/oradata\/DTTIC\/d_dmt_idx01.dbf’ SIZE 2G AUTOEXTEND ON MAXSIZE 20G,<\/p>\n
\/u01\/oradata\/DTTIC\/d_dmt_idx02.dbf’ SIZE 2G AUTOEXTEND ON MAXSIZE 20G<\/p>\n
LOGGING ONLINE PERMANENT BLOCKSIZE 16K<\/p>\n
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K<\/p>\n
SEGMENT SPACE MANAGEMENT AUTO; 2 3 4 5 6<\/p>\n
Tablespace created.<\/p>\n
Phase 2: Install Oracle Demantra on Windows Machine<\/strong><\/p>\n
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.<\/p>\n
The Demantra Installer on window server creates the database schema (in APS Database) and the administrator tools required to configure the application. <\/p>\n
Pre steps to Installing 12.2.6.2 Demantra in Window 64-bit 2012 Server Machine are<\/strong><\/p>\n
Step1: Right click on My Computer >Properties
\nClick on Advanced system settings >Environment Variables<\/em><\/p>\nStep2: Setup TNS for Planning Database <\/em><\/p>\n
Add below into tnsnames.ora<\/em><\/p>\n
`DTTIC=`
\n `(DESCRIPTION=`
\n `(ADDRESS=(PROTOCOL=tcp)(HOST=ndemdb01 .xx.xxx..net)(PORT=1543))`
\n ` (CONNECT_DATA=`
\n `(SERVICE_NAME=DTTIC)`
\n `(INSTANCE_NAME=DTTIC)`
\n ` )`
\n ` )`<\/em><\/p>\n3. <\/strong> Test SQLPLUS connection from the Oracle client (system\/syssbx@dbSid) <\/p>\n
Steps to Install 12.2.6.2 Demantra in Window 64-bit 2012 Server Machine are:<\/strong><\/p>\n
\n1. 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<\/p>\n
2. Double click on setup.exe<\/p>\n
![\"Demantra](\"\/wp-content\/uploads\/2026\/blog_article_images\/26046-body-Picture2_1.png\")
<\/p>\n- \n<\/ul>\n
- Click on Install Demantra Spectrum.<\/li>\n
- Installer window is showing up.<\/li>\n
- Click Next<\/li>\n
- Choose the options to deploy Demantra and\/ or engine on Linux<\/em> Note: Please select these options to implement demantra Web and Analytical engine on Linux servers for better performance and stability.<\/em>
\n\t![\"demantra](\"\/wp-content\/uploads\/2026\/blog_article_images\/26046-body-Picture2_2.png\")
\n\t<\/li>\n<\/ol>\n2. Click on Install Demantra Spectrum.<\/p>\n
- \n
- Installer window is showing up.<\/li>\n
- Click Next<\/li>\n
- Choose the options to deploy Demantra and\/ or engine on Linux<\/em> Note: Please select these options to implement demantra Web and Analytical engine on Linux servers for better performance and stability.<\/em><\/li>\n<\/ol>\n
![\"Demantra](\"\/wp-content\/uploads\/2026\/blog_article_images\/26046-body-Picture4_2.png\")
<\/p>\n1. Click on Install Demantra Spectrum.
\n2. Installer window is showing up.
\n3. Click Next
\n4. Choose the options to deploy *Demantra and\/ or engine on Linux*
\n*Note: Please select these options to implement demantra Web and Analytical engine on Linux servers for better performance and stability<\/p>\n- \n
- \n\t
![\"Demantra](\"\/wp-content\/uploads\/2026\/blog_article_images\/26046-body-Picture5_0.png\")
\n\t<\/li>\n<\/ol>\n5. Choose the installation folder for Demantra application.
\n6. Choose the location of the shortcuts\/icons for your Demantra application.
\n7. Fill in the DBA user \/ password. <\/p>\n![\"Demantra](\"\/wp-content\/uploads\/2026\/blog_article_images\/26046-body-Picture5_1.png\")
<\/p>\n8. Then click Next on Demantra installer screen.
\n9. Fill in your Demantra schema name and the password.<\/p>\n![\"Demantra](\"\/wp-content\/uploads\/2026\/blog_article_images\/26046-body-Picture6_2.png\")
<\/p>\n(Here Demantra schema : DEM)<\/p>\n
10. Fill in your connection details<\/p>\n
![\"Demantra](\"\/wp-content\/uploads\/2026\/blog_article_images\/26046-body-Picture7_0.png\")
<\/p>\n11. Depending on if your DBA (in this case system user) has SYSDBA privileges, a warning message can popup. Click Next<\/p>\n
![\"Demantra](\"\/wp-content\/uploads\/2026\/blog_article_images\/26046-body-Picture8.png\")
<\/p>\n12. Option to choose the standard or custom application shows up. <\/p>\n
13. Choose tablespaces where Demantra objects will reside. Make sure you have enough free tablespace. <\/p>\n
![\"Demantra](\"\/wp-content\/uploads\/2026\/blog_article_images\/26046-body-Picture8_0.png\")
<\/p>\n
\n14. Choose languages. A default language must be selected.
\n15. Set up the Demantra URL.
\n16. You can set up the email account or it can be set up later.
\n17. Check the summary of the choices and click Install.<\/p>\n![\"Demantra](\"\/wp-content\/uploads\/2026\/blog_article_images\/26046-body-Picture10_0.png\")
<\/p>\n18. Wait for installation to run. <\/p>\n
![\"Demantra](\"\/wp-content\/uploads\/2026\/blog_article_images\/26046-body-Picture12_0.png\")
<\/p>\nIt will ask for java 8 update 51 installation, if not already installed. <\/p>\n
21. Choose Next.
\n22. Choose the folder for java installation.
\n23. Close java setup when the installation is complete
\nAcrobat reader installer will also be launched<\/em><\/p>\n![\"demantra](\"\/wp-content\/uploads\/2026\/blog_article_images\/26046-body-Picture13.png\")
<\/p>\n<\/p>\n
![\"demantra](\"\/wp-content\/uploads\/2026\/blog_article_images\/26046-body-Picture14_0.png\")
<\/p>\n![\"Demantra](\"\/wp-content\/uploads\/2026\/blog_article_images\/26046-body-Picture15.png\")
<\/p>\n
\nClick ok<\/p>\n24. Demantra installation will continue.<\/p>\n
![\"demantra](\"\/wp-content\/uploads\/2026\/blog_article_images\/26046-body-Picture15_0.png\")
<\/p>\n25. Fill in Demantra user passwords.<\/p>\n
![\"Demantra](\"\/wp-content\/uploads\/2026\/blog_article_images\/26046-body-Picture16.png\")
<\/p>\n
\n*All passwords are set to same passwords.* (Note: It is case sensitive)<\/p>\n\n26. Click Done to complete the installation. <\/p>\n
![\"demantra](\"\/wp-content\/uploads\/2026\/blog_article_images\/26046-body-Picture17.png\")
<\/p>\n27. If the DBA user has no SYSDBA privileges, a warning pops up. <\/p>\n
28. Make note of the SQL that must be run after completing the installation.<\/p>\n
29. **Click OK. The installation has completed.**<\/p>\n
30.**Manually execute sys_grants.sql**<\/p>\n
30. Manually execute sys_grants.sql
\n*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*<\/p>\n[oradc@ndemdb01 admin]$ pwd<\/p>\n
\/u01\/app\/oradc\/DTTIC\/patches\/demantra\/admin<\/p>\n
[oradc@ndemdb01 admin]$ ls -lrt<\/p>\n
total 68<\/p>\n
`-rw-rw-r– 1 oradc oradc 234 Mar 30 14:17 UPDATE_PASSWORDS.sql`<\/p>\n
`-rw-rw-r– 1 oradc oradc 2265 Mar 30 14:17 system_revokes.sql`<\/p>\n
`-rw-rw-r– 1 oradc oradc 14568 Mar 30 14:17 sys_grants.sql`<\/p>\n
`-rw-rw-r– 1 oradc oradc 5216 Mar 30 14:17 run_table_reorg.sql`<\/p>\n
`-rw-rw-r– 1 oradc oradc 1298 Mar 30 14:17 revoke_table_reorg.sql`<\/p>\n
`-rw-rw-r– 1 oradc oradc 1000 Mar 30 14:17 grant_table_reorg.sql`<\/p>\n
`-rw-rw-r– 1 oradc oradc 26221 Mar 30 14:17 GRANT_HTTP_TO_DEMANTRA.sql`<\/p>\n
[oradc@ndemdb01 admin]$ sqlplus \/ as sysdba<\/p>\n
`SQL> @sys_grants.sql DEM ACL_DEFAULT ACL_DEFAULT false`<\/p>\n
false
\nUSER is “SYS”<\/p>\n`spool grant_dbms_crypto.log`<\/p>\n
————————-<\/p>\n
— grant_dbms_crypto<\/p>\n
\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026<\/p>\n
— update_passwords
\n <\/p>\n————————————–<\/p>\n
EXECUTE “DEM”.UPDATE_PASSWORDS;<\/p>\n
`spool off`<\/p>\n
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production
\nWith the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
\n[oradc@ndemdb01 admin]$<\/p>\n31. Check the log file for any errors.<\/p>\n
![\"Demantra](\"\/wp-content\/uploads\/2026\/blog_article_images\/26046-body-Picture19.png\")
<\/p>\n32. Keep the log files generated during the installation for further review: D:\\temp\\reInstall<\/p>\n
33. Check the versions.<\/p>\n
![\"Demantra](\"\/wp-content\/uploads\/2026\/blog_article_images\/26046-body-Picture20.png\")
<\/p>\n34. Check if you can log into Business Modeler. Start Business Modeler from modeler.bat <\/p>\n
![\"Demantra](\"\/wp-content\/uploads\/2026\/blog_article_images\/26046-body-Picture20_0.png\")
<\/p>\n<\/p>\n
\n35. Fill in the user and password.<\/p>\n
*Use dm \/ <dm password>* (It is case sensitive) <\/p>\n
\n36. See the Business Modeler Version from Help > About Business Modeler. <\/p>\n
![\"Demantra](\"\/wp-content\/uploads\/2026\/blog_article_images\/26046-body-Picture21.png\")
<\/p>\n37. Check if Tomcat is starting up successfully. Double click on startup.bat<\/p>\n
38. Make sure you can log into demantra anyware.
\nhttp:\/\/localhost:8080\/demantra\/portal\/anywhereLogin.jsp from demantra local server
\nhttp:\/\/nchwdat01.xxx.net:8080\/demantra\/portal\/anywhereLogin.jsp from any machine on internal network <\/p>\n![\"Demantra](\"\/wp-content\/uploads\/2026\/blog_article_images\/26046-body-Picture22.png\")
<\/p>\n<\/p>\n
Detailed steps will be covered in a follow up blog, however high-level steps are :<\/h3>\n
\n1. Install Java JDK 8 64-bit on Linux server (Demenatra Web Server)
\n2. Install Weblogic 12c (12.1.3.0.0 ) on Linux server (Demantra Web Server)
\n3. Configure domain for Demantra Deployment
\n4. Configure JDBC Data Source
\n5. Enable Archived Real Path
\n6. Create Demantra WAR file on Window Machine
\n7. Deploy Demantra ear
\n8. Activate Demantra application<\/strong><\/p>\n<\/p>\n
Phase 4: <\/strong>Configure and Deploy Oracle Demantra Analytical Engine on Linux<\/p>\n
Detailed steps will be covered in the follow up blog, however high-level steps include-<\/p>\n
1. *Install Java JDK 8 64-bit and Oracle Client on Linux Server (Demantra Analytical Engine)*
\n2. Copy the engine tar from windows server to Linux Server*
\n3. Create the Engine Data Source File*
\n4. Configure Demantra Analytical Engine on Analytical Server with a New Oracle Wallet Repository
\n5. Start the Analytical Engine Starter<\/p>\nConclusion<\/h3>\n
The process to install the Demantra application is a multi-step process which span on multi-instances and uses multi component.
\nHowever, by following the above instructions you can easily implement all the steps involving different instances and components to significantly reduce implementation time and achieve the best out of Demantra.
\nDemantra enables planners to sense demand real time, improve forecast accuracy, and shape demand for profitability. <\/p>\nThe result of Integration of these products is a
\n– Enhanced productivity of planners, as it enables them to see an aggregate analytical view with guided analysis.
\n– Informed and faster decisions, as it enables planners to share unified supply chain planning information across the enterprise.
\n– Improves supply chain performance by analyzing all aspects of a supply chain and developing optimal plans across the virtual supply chain. <\/p>\n","protected":false},"excerpt":{"rendered":"Install Oracle Demantra 12.2 & Configure Web Server and Analytical Engine on Linux<\/p>\n","protected":false},"author":2,"featured_media":6992,"menu_order":0,"comment_status":"open","ping_status":"open","template":"","format":"standard","meta":{"content-type":"","nid":"26046","content_type":"blog","created_by":"10130","authored_on":"2023-09-15T13:15:13+00:00","field_article_industries":"","tag_category":"Technical","field_blog_author_text":"by Rackspace Technology Staff","seo_description":"Get step-by-step instructions to install and configure Oracle Demantra 12.2 on a Linux server for better performance and stability.","field_featured_image":"","insights_image":"\/wp-content\/uploads\/2026\/blog_technical_images\/26046-insights_image-oracle-technical-blog-1-insights.jpg","field_partners":"","rxt_platforms":"Oracle E-Business Suite","product":"","publisheddate":"2022-07-18T13:15:13","rxt_solutions":"Enterprise Resource Planning (ERP)","opengraph_tag":"","x_tag":"","teaser_flag":"Technical Blog","seo_titile":"Install and Configure Oracle Demantra 12.2 on Linux","field_topics":"","field_slug":"install-oracle-demantra-12-2-and-configure-web-Server-and-analytical-engine-on-linux","footnotes":""},"categories":[178],"tags":[204],"class_list":["post-6990","blogs","type-blogs","status-publish","format-standard","has-post-thumbnail","hentry","category-blog","tag-technical"],"_links":{"self":[{"href":"https:\/\/www.rackspace.com\/de\/wp-json\/wp\/v2\/blogs\/6990","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rackspace.com\/de\/wp-json\/wp\/v2\/blogs"}],"about":[{"href":"https:\/\/www.rackspace.com\/de\/wp-json\/wp\/v2\/types\/blogs"}],"author":[{"embeddable":true,"href":"https:\/\/www.rackspace.com\/de\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rackspace.com\/de\/wp-json\/wp\/v2\/comments?post=6990"}],"version-history":[{"count":2,"href":"https:\/\/www.rackspace.com\/de\/wp-json\/wp\/v2\/blogs\/6990\/revisions"}],"predecessor-version":[{"id":8683,"href":"https:\/\/www.rackspace.com\/de\/wp-json\/wp\/v2\/blogs\/6990\/revisions\/8683"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rackspace.com\/de\/wp-json\/wp\/v2\/media\/6992"}],"wp:attachment":[{"href":"https:\/\/www.rackspace.com\/de\/wp-json\/wp\/v2\/media?parent=6990"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rackspace.com\/de\/wp-json\/wp\/v2\/categories?post=6990"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rackspace.com\/de\/wp-json\/wp\/v2\/tags?post=6990"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
- \n\t
*Note<\/strong>: Please select these options to implement demantra Web and Analytical engine on Linux servers for better performance and stability. <\/p>\n
1. Click on Install Demantra Spectrum.
\n2. Installer window is showing up.
\n3. Click Next
\n4. Choose the options to deploy *Demantra and\/ or engine on Linux*
\n*Note: Please select these options to implement demantra Web and Analytical engine on Linux servers for better performance and stability.<\/p>\n![\"Demantra](\"\/wp-content\/uploads\/2026\/blog_article_images\/26046-body-Picture3_1.png\")
<\/p>\nFollowing are the details related to Phase 1 and 2<\/strong>:<\/p>\n
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.
\n <\/p>\nPrepare APS\/ASCP database for Demantra<\/strong><\/p>\n
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.<\/p>\n
Please complete the following steps in the ASCP Database <\/p>\n
1. Add below into init ora file<\/p>\n
db_16K_cache_size=1024M`<\/p>\n
`db_securefile=NEVER`
\n <\/p>\nSQL> `show parameter db_16k_cache_size`<\/p>\n
NAME TYPE VALUE
\n———————————— ———– ——————————
\ndb_16k_cache_size big integer 1G
\nSQL> show parameter db_securefile<\/p>\nNAME TYPE VALUE
\n———————————— ———– ——————————
\ndb_securefile string NEVER
\nSQL><\/p>\n2. Create the password file using orapwd ignore if password file already exists.<\/p>\n
`orapwd file=orapw<ORACLE_SID> password=XXXXX entries=10 ignorecase=y`<\/p>\n
3. Create the Tablespace TS_DMT_DATA and TS_DMT_IDX with blocksize 16k in database by completing the following step. <\/p>\n
`SQL> CREATE TABLESPACE TS_DMT_DATA DATAFILE`<\/p>\n
`’\/u01\/oradata\/DTTIC\/d_dmt_data01.dbf’ SIZE 2G AUTOEXTEND ON MAXSIZE 20G,`<\/p>\n
`\/u01\/oradata\/DTTIC\/d_dmt_data02.dbf’ SIZE 2G AUTOEXTEND ON MAXSIZE 20G`<\/p>\n
`LOGGING ONLINE PERMANENT BLOCKSIZE 16K`<\/p>\n
`EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K`<\/p>\n
`SEGMENT SPACE MANAGEMENT AUTO; 2 3 4 5 6`<\/p>\n
Tablespace created.<\/p>\n
Phase 2: Install Oracle Demantra on Windows Machine<\/strong><\/p>\n
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.<\/p>\n
The Demantra Installer on window server creates the database schema (in APS Database) and the administrator tools required to configure the application. <\/p>\n
Pre steps to Installing 12.2.6.2 Demantra in Window 64-bit 2012 Server Machine are:<\/strong><\/p>\n
- \n