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
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 tablespaceTS_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
Sales : TS_SALES_DATA
Index : TS_SALES_DATA_X
Simulation Index : TS_SIM_X
Temporary : TEMP
Sales : TS_SALES_DATA
Index : TS_SALES_DATA_X
Simulation Index : TS_SIM_X
Simulation : TS_SIM
Sales_Data_Engine Index : TS_SALES_DATA_INDEX_X
Sales_Data_Engine :TS_SALES_DATA_ENGINE
Sales_Data_Engine Index : TS_SALES_DATA_INDEX_X
Sales_Data_Engine :TS_SALES_DATA_ENGINE
Dont change any thing Click Next
Select Designate administrator account later Click Next
Select User ececution Click Next
Click Install
Click Done
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
http://localhost:8080/demantra/portal/loginpage.jsp
Web client
http://localhost:8080/demantra/portal/partnerLogin.jsp
Oracle Demantra Anywhere version of Web client alone http://localhost:8080/demantra/portal/anywhereLogin.jsp
http://localhost:8080/demantra/portal/loginpage.jsp
Web client
http://localhost:8080/demantra/portal/partnerLogin.jsp
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
http://localhost:8080/demantra/portal/launchDPWeb.jnlp
Dynamic Open Link (DOL) access for third-party reporting tools
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
Collaborator Workbench Administration
http://localhost:8080/demantra/portal/adminLogin.jsp
Collaborator Workbench Administration
http://localhost:8080/demantra/portal/adminLogin.jsp
Technical Administration
http://localhost:8080/demantra/admin
http://localhost:8080/demantra/admin
User Management
http://localhost:8080/demantra/portal/ userManagement.jsp
Workflow Manager
http://localhost:8080/demantra/workflow/login.jsp
http://localhost:8080/demantra/portal/ userManagement.jsp
Workflow Manager
http://localhost:8080/demantra/workflow/login.jsp
Reference :-
Oracle Demantra Installation Guide, Release 7.3.1 [ID 1226023.1]
Oracle Demantra Installation Guide, Release 7.3.1 [ID 1226023.1]
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.
ReplyDeletePlease refer to Metalink doc 873775.1 for the ORA803.DLL error.
ReplyDeleteHi,
ReplyDeleteI 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.
I Have installed all the thing demantra Apps..
ReplyDeletebut i m getting some critical error
Procedure and dba privilage acces
For Windows 7 try Patch 10270826
ReplyDeleteThis comment has been removed by the author.
ReplyDeleteThanks 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 !!
ReplyDeleteI 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?
ReplyDeletePlease let me know the solution.
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
ReplyDeleteMaxMunus 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
MaxMunus
E-mail: nitesh@maxmunus.com
Skype id: nitesh_maxmunus
Ph:(+91) 8553912023
http://www.maxmunus.com/
nice information provided Oracle DBA Training in Deira, Dubai
ReplyDeleteThank you for sharing such a nice and interesting blog with us.
ReplyDeletevisit us:Oracle Demantra Training