Steps to change Database Password, here Oracle DB
Stop the BPMnode
Change the Database User Password User by i.e.
"ALTER USER user_name IDENTIFIED BY new_password;"
Change Password inside all TIBCO ActiveMatrix® BPM JDBC Resource Templates
repeat for each Template Password
?re-install (sync-state) all Templates
Important Database Settings
NLS_CHARACTERSET must be set at AL32UTF8 (superset of UTF8 => some char can't be store in UTF8 so some things may not work, and you won't be supported)
NLS_NCHAR_CHARACTERSET, there's no clear recommendation/documentation about it, but most customers using here: AL16UTF16.