Upgraded Simphony 18.2 to 19.1 and R&A 8.5.1 Patch 3/6 to EBO 9.1
Posted by Mohammed Yaqoob Qureshi on 12 July 2021 05:04 PM
Upgraded Simphony 18.2 to 19.1 and R&A 8.5.1 to 9.1 . Steps as below|
following below steps can be considered.
Refer Doc: R&A 9.1 installation doc
>>Page no 13
Uninstall Enterprise Back Office version 8.5.1,
To create a backup of the configurations, copy the myMicros folder to a backup location.
You cannot restore the configurations from older versions. You can only use the backup as a configuration reference.
Make sure the current Microsoft Windows user has Change permissions for the myMicros folder.
Navigate to the installation path\myMicros\Uninstall_
Follow the instructions, and then click Next to uninstall the Enterprise Back Office components on the current server. You cannot stop or cancel the uninstallation process.
Delete the myMicros folder to remove all files that were not removed by the uninstallation wizard.
Uninstall Java version 1.6.
>Command to uninstall any java on server:
wmic product where "name like 'Java%'" call uninstall
Restart the server.
1) dism /online /add-package /packagepath:"C:\Windows\
2) netsh advfirewall firewall add rule name="Simphony Port 80" dir=in action=allow protocol=TCP localport=80
3) fsutil behavior set disable8dot3 0
4)netsh int isatap set state disable
netsh int teredo set state disable
5)JDK 1.7 update 80 Java x64 SE7 install (D:\Javaroot)
Install Java version 1.7.
6)ALTER SYSTEM SET processes = 2000 SCOPE = SPFILE;
ALTER SYSTEM set open_cursors = 30000 scope=both;
Upgrade the Enterprise Back Office 8.5.1 database with the Enterprise Back Office 9.1 database installer.(upgrade existing DB)
7) Look for expired & Locked users created on the date on DBinstaller.exe (9.1) was run. The Other users , usually related to oracle has a creation date of 2013 as i noticed.
SELECT username, account_status, created, lock_date, expiry_date
WHERE account_status != 'OPEN';
Below scipts to unlock them:
alter user LABOR identified by Ses_4766876 account unlock;
alter user ADMN identified by Ses_4766876 account unlock;
alter user FRCST identified by Ses_4766876 account unlock;
alter user SCHED identified by Ses_4766876 account unlock;
alter user POST identified by Ses_4766876 account unlock;
alter user OLAP identified by Ses_4766876 account unlock;
alter user MMSQL identified by Ses_4766876 account unlock;
Grant create session to LABOR;
Grant create session to ADMN;
Grant create session to FRCST;
Grant create session to SCHED;
Grant create session to POST;
Grant create session to OLAP;
Grant create session to MMSQL;
Stop All Simphony services,DTS,DPS etc
Run the Enterprise Back Office 9.1 installer.(Follow steps as of fresh installation)
Keep all the services related of BOE and simphony to delayed start.
Restart the server.
login R&A with m organization user ie.
Go to system>Oragnaization>MICROS>
Simphony DB username:transdb
Simphony DB Password:Ses_4766876