Creating Database Using Oracle 19c
Create an Oracle database instance (including a pluggable database for TIBCO BPM Enterprise), configure it, and start it.
- Procedure
-
Create an Oracle database instance that is used to hold the TIBCO BPM Enterprise database.
Create a pluggable database (PDB) in your container database (CDB) for TIBCO BPM Enterprise to use. This is because TIBCO BPM Enterprise users have exclusive rights to perform actions. If you install TIBCO BPM Enterprise on the CDB, BPM users have exclusive rights to perform actions on the CDB.
Note: The TIBCO BPM Enterprise database for each BPM system must use separate Oracle database users/schemas. Use of separate tablespaces is also recommended. -
Set the OPEN_CURSORS initialization parameter to a value of 400 or greater.
-
Configure the character sets for the Oracle database instance as follows: NLS_CHARACTERSET must be AL32UTF8 and NLS_NCHAR_CHARACTERSET must be AL16UTF16.
-
Start the Oracle database instance.
After the startup of the CDB, the PDBs do not open automatically. You must make sure that the PDB on which BPM is running is opened after startup. For more information, please refer to the documentation supplied with Oracle19c.
- As the database administrator, run the following script to create the
bpmuser role (user).
TIBCO BPM Enterprise uses this role whenever it connects to the BPM database.
CONFIG_HOME/tibco/cfgmgmt/bpm/database/oracle/createuser.sql
Note: The BPME database tables are generated automatically using the BPME utility.