Thursday, March 17, 2011

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]






57 comments:

  1. Dear Sir. Thank you for the post. It helped very much. Nuvan.

    ReplyDelete
  2. Great help with this post. By using this outline, i was able to install Demantra and launch configuration tools, Business modeler.

    I do have a problem though. i can not launch Collaborator workbench or DP. Whenever I try, I get a "Internet Explorer cannot display the webpage" error. I'm pretty sure Tomcat is running. Any ideas?

    Thanks again for the coherent guideline.

    Mike

    ReplyDelete
  3. Hi Mike.
    Seems that the web server (tomcat) is not running.
    Please try the following:

    1. Stop web server
    2. Go to the Program Files and give the full permissions to the folder and all sub folders of Demantra.
    3. Start web server.
    4. Pay attention to not close the service window.

    ReplyDelete
  4. Hi, in http://localhost:8080/demantra/admin ask me for a password, what password is here?

    ReplyDelete
  5. hi, installed it in linux?

    Regards

    ReplyDelete
  6. Hi, Will it work on windows 7 64 bit?
    Do you have the command to create the tablespace in 11g?

    ReplyDelete
  7. Hi Arty,
    Installed dematra demand planner.After i log in with sop/sop and in collaoborator work bench,once i click any work sheet,it gives error.Can't open worksheet.What may be the cause of error?

    Thank You

    Ram

    ReplyDelete
  8. Hi, i cant see my tablespace in the list when i get to choose. can you pls help?

    ReplyDelete
    Replies
    1. Hi.Did you created them? If yes, are you sure you connected to the same db that the TBS were created?

      Delete
  9. found them i had to restart windows. installing 12.2.1. The installation finished and my pc rebooted. How to I run the apps? thanks for the quick response.

    ReplyDelete
  10. Hi I am not able to start/stop Tomcat server and collaborator WB after installing Demantra. Can you please guide me what is missing ?

    ReplyDelete
  11. For training on Oracle Demantra, Check this site for trainings on emerging IT courses . Go here if you’re looking for training on Oracle Demantra.

    ReplyDelete
  12. Hi ,

    i am unable to start web server.it get close as soon as i opened it.Plz help

    ReplyDelete
    Replies
    1. Hi Renu
      Please try to run the start web server as administrator.

      Delete
    2. Hi Arty,

      I tried to run he start web server as administrator .But i didn't get successful.Same problem is still there for me.Please guide me what is missing ?

      Delete
  13. This comment has been removed by the author.

    ReplyDelete
  14. This comment has been removed by the author.

    ReplyDelete
  15. This comment has been removed by the author.

    ReplyDelete
  16. Thanks for sharing this amazing guidelines. Ihave instIalled demantra on windows server 2003 and used the same database of the existing EBS installation. Tomcat server started .. says INFO: Server startup in 5806ms and then is error in connecting to the database.
    I get database error PLS-00905: object DM.PRE_LOGON is invalid while connecting to demand planner like tools.
    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 !!

    ReplyDelete
  17. Thanks for sharing this amazing guidelines. Ihave instIalled demantra on windows server 2003 and used the same database of the existing EBS installation. Tomcat server started .. says INFO: Server startup in 5806ms and then is error in connecting to the database.
    I get database error PLS-00905: object DM.PRE_LOGON is invalid while connecting to demand planner like tools.
    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 !!

    ReplyDelete
    Replies
    1. Hi Raj,
      Did you tried to recompile the PRE_LOGON ?

      Delete
  18. This comment has been removed by the author.

    ReplyDelete
  19. Hi

    I'm having the following issue:

    Error while running worksheets window liveconnect call for applet ID 5 is not allowed in this JVM instance. Any idea how to fix?
    Server: local host
    system variable is pointing to the correct JDK

    ReplyDelete
    Replies
    1. Hi,

      can you send me more details of the issue (screen shots. error messages, etc)

      Delete
    2. Sure Arty.

      Do you have an email address?

      Delete
    3. This comment has been removed by the author.

      Delete
    4. I've encountered the same issue. Were you able to resolve this?

      Delete
    5. yes so the only way to resolve this is by installing an older java that will allow you to change the security from high to medium (least secure setting). All new java have 2 options only very high, or high. Older versions have medium. I'm using 1.7.0_97.

      Good luck

      Delete
  20. In the machine where the issue is happening.

    Go to control panel -> java -> this open the java control panel. go to security tab
    Set to medium.
    Clear the browser cache and restart the browser. Retest the issue

    As TGF sports already updated, it can be done only with Java lower than 1.8

    ReplyDelete
  21. Hi

    I am getting worksheet window undefined error while opening the worksheet .
    Can anyone help me please

    ReplyDelete
  22. This comment has been removed by the author.

    ReplyDelete
  23. Hi John,

    I'm facing the below error while installing the application,please help!

    Update ds.ini failed. Can't connect to database Oracle library OCI.DLL or ORA803.DLL could not be loaded.

    Note: I'm installing on win 64bit os,so installed oracle 11g 64bit and java as well.



    Regards
    Ram

    ReplyDelete
  24. Hi

    I am getting worksheet window undefined error while opening the worksheet .
    Can anyone help me please..

    Weblogic Administration Training

    ReplyDelete
  25. Clearly And Neatly Explained All the topics in one post.Coming to Our self,We are the leading provider of Restaurant Equipment Parts in US.Really thanks For Posting.Have A Nice Day.Very Useful and Informative Blog.Thanks For Sharing.

    ReplyDelete
  26. This Blog is very helpful and useful, came to know that I should be strong in my basics and this blog helps me to improve it, US Medical Residency in Chicago Services Provided by Us. Thanks For Posting. I Am refereed by my friend to this blog and I also want to refer my other friends to this blog.

    ReplyDelete
  27. It's A Great Pleasure reading your Article, learned a lot of new things, we have to keep on updating it salesforce certification training Thanks for posting.

    ReplyDelete
  28. Really Thanks For Posting Such a Useful and informative article. I would like to share this blog with my friends and Colleagues digital transformation consulting

    ReplyDelete
  29. nice blog thanks for sharing such awonderful information for more details please visit our site
    click here

    ReplyDelete
  30. Thanks For Sharing Such an Useful and Valuable Information....
    plots for sale in vizag

    ReplyDelete
  31. nice blog thanks for sharing such a beautiful data click here

    ReplyDelete
  32. Thanks for sharing this amazing guideline.I really appreciate information shared above. It’s of great help. If someone want to learn Online training courses kindly contact us https://techenoid.com/

    ReplyDelete
  33. nice blog.Thanks for your valuable post.Techebnoid Providing robotic process automation training course in online.https://techenoid.com/rpa-training

    ReplyDelete
  34. He is very good in give the best content on JNTU 99 and information to us. thanks for sharing.

    ReplyDelete
  35. really great informative.we are travel agency visit us online on
    http://quincetravels.com/

    ReplyDelete
  36. SriWebEo is pioneer in providing IT courses and Digital Marketing, Web Designing Courses to Students, Job seekers and working professionals.
    Best Web Design Training

    ReplyDelete
  37. nice article thanks for sharing the post..!
    http://www.kitsonlinetrainings.com/sap-abap-on-hana-online-training.html
    http://www.kitsonlinetrainings.com/sap-grc-online-training.html
    http://www.kitsonlinetrainings.com/sap-mm-online-training.html

    ReplyDelete
  38. This comment has been removed by the author.

    ReplyDelete