29 November 2011

Step by Step Oracle Demantra 7.3.1 Installation on Windows 64bit

Step One Install Oracle Database 10g or 11
 I installed 11.2.0
prerequisites :-
Install Latest JDK also
Set JAVA_HOME  is pointed to your java home directory to environment variable on system level.
I Installed the below path  C:\Java\jre7
Install Acropat Reader

Step Two Create below Table space:-

create tablespace TS_DP datafile 'C:\VIS\oradata\TEST\ts_dp01.dbf' size 1000M;
create tablespace TS_SALES_DATA datafile 'C:\VIS\oradata\TEST\ts_sales_data01.dbf' size 500m;
create tablespace TS_SALES_DATA_X datafile 'C:\VIS\oradata\TEST \ts_sales_data_x01.dbf' size 100m;
create tablespace TS_SIM datafile 'C:\VIS\oradata\TEST\ts_sim01.dbf' size 500m;
create tablespace TS_SIM_X datafile 'C:\VIS\oradata\TEST\ts_sim_x01.dbf' size 100m;
create tablespace TS_SALES_DATA_ENGINE datafile 'C:\VIS\oradata\TEST\ts_sales_data_engine01.dbf' size 500m;
create tablespace TS_SALES_DATA_ENGINE_X datafile 'C:\VIS\oradata\TEST\ts_sales_data_engine_x01.dbf' size 100m;

Click Install Demantra Spectrum
 Click Next
Click Next

Don't select any thing Click Next
 Select Typical  Click Next
 Select your Installation path Click Next

Select In the Start menu   Click Next
 Enter Database sys or system passwor and SID  i user SYS only Click Next
 Give any one New user name What ever you want you give I user MUTHU01 Click Next
 Enter Database detail Click Next
 Select Standard Application Click Next
 Select  below Table space :-

Default : TS_DP
Temporary :  TEMP
Simulation Index : TS_SIM_X
Simulation : TS_SIM
Sales_Data_Engine Index : TS_SALES_DATA_INDEX_X

 Dont change any thing Click Next
Select Designate administrator account later  Click Next
 Select User ececution  Click Next
 Click Install
 Click Done

Once installation finished follow below steps 
 Click Start --> All Programs --> Start Web Server 
It will open one Tomcat screen. Don't close that screen. If you closed It will close the Web Server.  Then you need to Start Web Server again
 default users and password           dm/dm or sop/sop

Collaborator Workbench
Web client
Oracle Demantra Anywhere version of Web client alone http://localhost:8080/demantra/portal/anywhereLogin.jsp

Oracle Demantra Anywhere version of Collaborator Workbench http://localhost:8080/demantra/portal/remoteloginpage.jsp
Offline access to Oracle Demantra worksheets
Dynamic Open Link (DOL) access for third-party reporting tools 
Collaborator Workbench Administration

Technical Administration

User Management
http://localhost:8080/demantra/portal/ userManagement.jsp
Workflow Manager

Reference :-
Oracle Demantra Installation Guide, Release 7.3.1 [ID 1226023.1]


Anonymous said...

I installed the 64 bit version of both oracle database and demantra and when i try to open demand planner and the other demantra programs it says 'can't connect to database Oracle library OCI.DLL or ORA803.DLL'. Please help.

Abu said...

Please refer to Metalink doc 873775.1 for the ORA803.DLL error.

NAREN said...


I have 10g client installed on my Windows7 laptop, I am trying to install Demantra 7.3.1 but after 'Choose shortcut location'
option when it goes to next screen 'database configuration' it shows a error message saying a critical utility is missing in
'C:\apps\oracle\client\10.2.0\BIN' and only shows 2 option EXIT or BACK. Please suggest what I am missing.

prabhu kumaran falcons said...

I Have installed all the thing demantra Apps..
but i m getting some critical error

Procedure and dba privilage acces

Anonymous said...

For Windows 7 try Patch 10270826

Raj A said...
This comment has been removed by the author.
Raj A said...

Thanks for sharing this amazing guidelines. In my case it seems the tomcat server started .. says INFO: Server startup in 5806ms . When i try to login to http://localhost:8080/demantra/portal/loginpage.jsp however it says 'the page or file is not allowed to be viewed' . Please help me !!

Kiran said...

I have upgraded demantra in windows from 7.3.1 to 12.2.6 lastest version of demantra. After that i am getting this error at Business modular?

Please let me know the solution.

Nitesh Kumar said...

I really appreciate information shared above. It’s of great help. If someone want to learn Online (Virtual) instructor lead live training in Oracle Demantra, kindly contact us http://www.maxmunus.com/contact
MaxMunus Offer World Class Virtual Instructor led training on Oracle Demantra. We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 100000+ trainings in India, USA, UK, Australlia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain and UAE etc.
For Demo Contact us.
Nitesh Kumar
E-mail: nitesh@maxmunus.com
Skype id: nitesh_maxmunus
Ph:(+91) 8553912023