Description:

Installing AMX BPM on Oracle 12c requires some manual changes in order to work in a plugable scenario.

1), Tablespace access is no longer enabled by default. This can result in ORA-01950: no privileges on tablespace in SystemNode.log.

2). Plugable databases have new requirements for user creation. If you do not prefix the user with c## then it will not create, throwing a ORA-65096: invalid common user or role name error.

Work around:

1). grant unlimited tablespace to <username>; This is done in the example script below.

2). There are two or more places that you will need to create users. There may be more than this. The same user creation steps will need to be used for each.
 a). AMX Administrator database.
 b). BPM Database.
 c). BDS Database.

For all of these you need an extra step before the create user command in each SQL session.

alter session set "_ORACLE_SCRIPT"=true;

For a) above, the following script suffices (customize values, locations as needed in your environment):

 

alter system set processes=320 scope=spfile;

alter system set open_cursors=10000 scope=spfile;

alter session set "_ORACLE_SCRIPT"=true;
drop user amxuser cascade;
drop user bpmuser cascade;
create tablespace amx_tablespace datafile 'amx.dbf' size 100M AUTOEXTEND ON NEXT 50M MAXSIZE 2000M ;
create user amxuser identified by MyPassWord123 default tablespace amx_tablespace;
grant connect, resource,unlimited tablespace to amxuser;

For b) and c) above, you have to manually create the database, so save the scripts in the second database page then go back and uncheck the automatic creation option.

In %SHARED_CONFIG HOME%\amx.bpm.app\database\admin , if you have not specified a different area, this would be %CONFIG_HOM%\bpm\amx.bpm.app\database\admin

- edit createdb-admin.sql and insert this at the top of the file. Do not put any extra blank lines in 

alter session set "_ORACLE_SCRIPT"=true;

- edit createdb-admin-bds.sql and insert this at the top of the file. Do not put any extra blank lines in

alter session set "_ORACLE_SCRIPT"=true;

Once this is done, go through and run the relevant scripts in the following order. Commented out items only apply for separate bds schemas.

@admin/setup-admin.sql
--@admin/setup-admin-bds.sql
@admin/createdb-admin.sql
--@admin/createdb-admin-bds.sql
@ProcessManagerCreate.sql
@WorkManagerCreate.sql

How to install AMX BPM on Oracle 12c with pluggable databases.

TIBCO AMX BPM Installation 3.1 > I - Installation and Upgrade Scenarios > Performing Required Pre-Installation Tasks > 4. Create the External ActiveMatrix Administrator Database pages 70-71
TIBCO AMX BPM Installation 3.1 > II - Installation and Upgrade Procedures > Configuring ActiveMatrix BPM Runtime Objects (TIBCO Configuration Tool) > Manually Creating the BPM Database pages 94-97