Open topic with navigation

TIBCO® BPM Enterprise 5.5.0

# Creating Database Using Oracle 19c

Create an Oracle database instance (including a pluggable database for TIBCO BPM Enterprise), configure it, and start it.

Procedure

1. 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.

2. Set the OPEN_CURSORS initialization parameter to a value of 400 or greater.

3. Configure the character sets for the Oracle database instance as follows: NLS_CHARACTERSET must be AL32UTF8 and NLS_NCHAR_CHARACTERSET must be AL16UTF16.

4. 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.

5. 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.

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO® BPM Enterprise

Copyright © 2015-2024. Cloud Software Group, Inc. All Rights Reserved.