Demantra User Refresh

Refresh Demantra USER :

 

1. Export the source data.
    
   expdp schemas=DEMANTRA directory=DM_DIR dumpfile=demantra.dmp logfile=demantra.log compression=all
    
2. Drop the demantra user in the destination.
3. Import the demantra schema .

impdp directory=DM_DIR dumpfile=demantra.dmp logfile=imp_demantra.log schemas=DEMANTRA PARALLEL=5

1. Change the demantra password to same as old one.
2. Run gather stats.
3.  
   exec dbms_stats.gather_schema_stats(ownname => 'DEMANTRA' , estimate_percent =>dbms_stats.auto_sample_size, cascade =>tr
   ue,degree =>6);
    
4. Update the Adminurl in the sys_parames table from BM.
    C:\Program Files (x86)\Oracle Demantra Spectrum1224\Demand Planner\DeskTop\modular
    Pass the dm user and passowrd.
    Under parameters à system parametersàchange AppServerURL and save.
    
    
    
    
5. Run sys_grants.sql
   C:\Program Files (x86)\Oracle Demantra Spectrum1224\Demand Planner\Database Objects\Oracle Server\admin\sys_grants.sql
    
   Sqlplus  sys@tnsname as sysdba
   Sql> @sys_grants.sql DEMANTRA /sys/acls/demantra.xml  /sys/acls/demantra.xml
    
6. Recreate the war file
   C:\Program Files (x86)\Oracle Demantra Spectrum1224\Collaborator\DEMTST\create_war.bat
    
   File create under  location :
   C:\Program Files (x86)\Oracle Demantra Spectrum1224\Collaborator
    
7. Copy new war file to the applciation server
    
8. Restart the Demantra applciation.
    

NOTE : If the windows server is new  one and already not install demantra on  it then you need to install the demantra all versions according to the demantra.version_details_history table. Please refer NOTEID : 1354934.1

Install Demantra on a new machine - with a new standard / dummy db schema that will be droped next point/ - matching the exact version in version_details_history - last release

-- apply any patches as in main instance

 Drop dummy schema and import the actual schema.

 

ISSUE 1 :

 

 

After refresh the schema dm user password  not working for the  Business moduler  but working the collaborator workbench password ,then do below sterps.

 

1. From collaborator change the db password  right side screen ,Administrationà Change password  and change the DM passowrd .
2. Run sys_grants.sql
3.  And connect to BM and check.
4. IF want same as old password do step1 again.

Change the password after refresh the DEMANTRA SCHMA :