Cleaning IBM Business Process Manager 7.5 Process Center database will improve performance.
At first you need to export latest snapshots of process applications and toolkits you want to have after cleaning.
Than do something like described below.
Backup everything: database, profile, ec2 volume, make vm snapshot etc.
1. Stop server:
c:\BPM\75\profiles\ProcCtr01\bin\stopServer.bat server1 -username admin -password admin
2. Drop performance and process center schemas:
sqlplus sys/oracle@orcl as sysdba
drop user perfusr cascade;
drop user procusr cascade;
3. Create new ones and grant privileges:
create user procusr identified by procusr123;
create user perfusr identified by perfusr123;
grant execute on dbms_system to procusr;
grant execute on dbms_system to perfusr;
grant connect,resource,dba to procusr;
grant connect,resource,dba to perfusr;
4. Create tables and procedures for Process Center user from previously generated sql scripts for created at installation profile:
sqlplus procusr/procusr123@orcl
@C:\BPM\75\profiles\ProcCtr01\dbscripts\ProcessServer\Oracle\ORCL\createTable_ProcessServer.sql
@C:\BPM\75\profiles\ProcCtr01\dbscripts\ProcessServer\Oracle\ORCL\createProcedure_ProcessServer.sql
5. Create tables for Performance Server:
sqlplus perfusr/perfusr123@orcl
@C:\BPM\75\profiles\ProcCtr01\dbscripts\PerformanceDW\Oracle\ORCL\createTable_PerformanceDW.sql
6. Load bootstrap data(user attributes, system apps and toolkits, updates etc.):
c:\BPM\75\profiles\ProcCtr01\bin>bootstrapProcessServerData.bat
7. Start server and check logs for errors:
c:\BPM\75\profiles\ProcCtr01\bin\startServer.bat server1
Then import apps and toolkits from Process Center console.
At first you need to export latest snapshots of process applications and toolkits you want to have after cleaning.
Than do something like described below.
Backup everything: database, profile, ec2 volume, make vm snapshot etc.
1. Stop server:
c:\BPM\75\profiles\ProcCtr01\bin\stopServer.bat server1 -username admin -password admin
2. Drop performance and process center schemas:
sqlplus sys/oracle@orcl as sysdba
drop user perfusr cascade;
drop user procusr cascade;
3. Create new ones and grant privileges:
create user procusr identified by procusr123;
create user perfusr identified by perfusr123;
grant execute on dbms_system to procusr;
grant execute on dbms_system to perfusr;
grant connect,resource,dba to procusr;
grant connect,resource,dba to perfusr;
4. Create tables and procedures for Process Center user from previously generated sql scripts for created at installation profile:
sqlplus procusr/procusr123@orcl
@C:\BPM\75\profiles\ProcCtr01\dbscripts\ProcessServer\Oracle\ORCL\createTable_ProcessServer.sql
@C:\BPM\75\profiles\ProcCtr01\dbscripts\ProcessServer\Oracle\ORCL\createProcedure_ProcessServer.sql
5. Create tables for Performance Server:
sqlplus perfusr/perfusr123@orcl
@C:\BPM\75\profiles\ProcCtr01\dbscripts\PerformanceDW\Oracle\ORCL\createTable_PerformanceDW.sql
6. Load bootstrap data(user attributes, system apps and toolkits, updates etc.):
c:\BPM\75\profiles\ProcCtr01\bin>bootstrapProcessServerData.bat
7. Start server and check logs for errors:
c:\BPM\75\profiles\ProcCtr01\bin\startServer.bat server1
Then import apps and toolkits from Process Center console.
Комментариев нет:
Отправить комментарий