Oracle BPA Suite tips: #2. Installation of the server

Time for the next tip on the BPA Suite. The first step usually involves playing around with the standalone version. This works fine. If you want to share your models with your team, you need to install the server seperately. The documentation for the installation is scattered around and it is not immediately clear what steps you need to take. So here is an overview:

1. install the database part
2. install the business repository. This name is confusing; it is not a repository, but an application server that connects the client with the database
3. test the installation

Install the database

• create a database (e.g. with SID ARIS) with characterset AL32UTF8
• create two tablespaces ARISDATA en ARISINDEX both with size 2GB
• execute in sqlplus the following: alter system set query_rewrite_integrity=trusted scope=both
• open a command prompt and set two environment variables:
  SET ORACHE_HOME=[path to oracle home]
SET ORACLE_SID=[SID of db. eg. ARIS]
• if you used a different SID, change the entry in the aris70.bat file
• run the script: aris70.bat system [pwd] .
• open sql*plus and create a new schema by calling
  slq> exec schema_aris_70.new_schema('ARIS70', 'ARIS70ADM', 'ARIS70ADM', 'ARISDATA', 'ARISINDEX');
• Remove the comments in front of the grant statements in the automgr.sql and run it:
  
sql>@automgr.sql
• create 10 (or less) aris schema’s by running: sql>exec autocreate70('aris', 10);

Installing the application server (aka business repository server aka business server)
There are two options: you can install it on the same machine, or install it on a different machine. As a rule of thumb you need to install it on a separate server if you expect to have more than 200 users.

• Run de setup.exe of business server repository
  Check all options, except the web client components (unless you want to use the webclient)
  Install the service as a windows service
  Enter the name of the SID you picked for the database (ARIS)
• If you picked a different SID, change the lockservice.cfg file

Test the installation
Now we are ready to test the installation. There are two ways to do this: using the Oracle BPA Admin tool (command line) or using the Oracle BPA Site Administrator. Both connect to the business repository, not to the database.
We will use the Oracle BPA Admin tool:

• Open the tool from the programs menu
• Enter the command: server [name of the business repository server machine]
• Enter the password (default SITEADMIN)
• query the status: status

If everything is up and running you can connect the client (Oracle Business Process Architect) to the business server. This can be done by opening the administrator. Click “Add Server” and enter the name of the Business Process Repository server. You are ready to start, by adding databases and start modeling.