Oracle Demantra 7.3.1 on Windows7 32bit - Step by Step

Hi All
This is about Oracle Demantra installation on Windows7-32bit. (I did it on my pc).

1. Install  DB 10g/11g on you computer.

2. Be sure that you downloaded Demantra 7.3.1. Only this version is working good with Windows7.
If you will install Demantra 7.3.0 .you will have a lot  of issues with Java on your computer.
Demantra 7.3.1 Install Patch - Patch 10270826

3. Create a needed TBS for Demantra (you will use them during the Demantra installation):


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

4. Install latest Java on your computer: http://java.com/en/download/index.jsp

5. Add the JAVA_HOME  is pointed to your java home directory to environment variable on system level.
The default value for the path is C:/program files/Java/jre

6. Unzip downloaded patch.

7. Run setup.exe as administrator.

Select the language:

If your Demantra will run only on Windows7 without using Linux Apache do not select any checkbox

First Installation is Typical. It will create for you the schema and all tools.

I advice to create an shortcuts on a Startup menu. It will help you in a future.

 DBA User Name: user with dba privileges. I'm using system. May be also be sys.
 Password:  DBA User password.
 TNS Name: Your database SID.

  Demantra Schema user name : DEMO1 (you can choose what you want)
  Demantra schema password

Host Machine: may be localhost or computer name or IP.
Port Number: DB port pool.

If this is the first installation for demo choose Standard Application

Tablespaces:

Default : TS_DP
Temporary :  TEMP
Sales : TS_SALES_DATA
Index : TS_SALES_DATA_X
Simulation : TS_SIM
Simulation Index : TS_SIM_X
Sales_Data_Engine Index : TS_SALES_DATA_INDEX_X
Sales_Data_Engine :TS_SALES_DATA_ENGINE

You can leave the default in Specify Web Address screen

If you don't want to designate mail account, choose to designate later.

Choose the User execution. It will help you in a future and the Demantra processes will not start automatically
every computer restart.

Review the Pre-Installation Summary and press install.

After the installation finished do the following:

1. Go to the Program Files and give the full permissions to the folder and all sub folders of  Demantra.
2. Start --> All Programs --> Start Web Server.
It will open the Tomcat screen. Do not close this window. It will close the Web Server. If the screen was closed - Start Web Server again.

Here the Demantra Links(you can login with default users dm/dm or sop/sop):


Collaborator Workbench
http://localhost:8080/demantra/portal/loginpage.jsp
Web client
http://localhost:8080/demantra/portal/partnerLogin.jsp
Oracle Demantra Anywhere version of Collaborator Workbench http://localhost:8080/demantra/portal/remoteloginpage.jsp
Oracle Demantra Anywhere version of Web client alone http://localhost:8080/demantra/portal/anywhereLogin.jsp
Offline access to Oracle Demantra worksheets
http://localhost:8080/demantra/portal/launchDPWeb.jnlp
Dynamic Open Link (DOL) access for third-party reporting tools http://localhost:8080/demantra/portal/DOLLogin.jsp
User Management
http://localhost:8080/demantra/portal/ userManagement.jsp
Collaborator Workbench Administration
http://localhost:8080/demantra/portal/adminLogin.jsp
Workflow Manager
http://localhost:8080/demantra/workflow/login.jsp
Technical Administration
http://localhost:8080/demantra/admin


Useful Documentation:


Oracle Demantra Release Notes, Release 7.3.1 [ID 1226003.1]
Oracle Demantra Installation Guide, Release 7.3.1 [ID 1226023.1]