How to enable Oracle level logging in TIBCO BusinessEvents 4.x and 5.x?

How to enable Oracle level logging in TIBCO BusinessEvents 4.x and 5.x?

book

Article ID: KB0084665

calendar_today

Updated On:

Products Versions
TIBCO BusinessEvents Enterprise Edition -
Not Applicable -

Description

Resolution:
Description:
============
How to enable Oracle level logging in BusinessEvents 4.x and 5.x?

Environment:
==========
Operating system: All
TIBCO BusinessEvents (BE) version: 4.x, 5.x

Resolution:
==========
Prior to BE 4.x, the following two log levels were added to be-engine.tra file to enable Oracle debug level logging: orclLv1Role, orclLv2Role.

From BE 4.x onwards, add the following to CDD(cluster deployment descriptor) file under collections tab -> Log Configurations -> logconfig -> Levels

sql.text:all, sql.vars:all

Issue/Introduction

How to enable Oracle level logging in TIBCO BusinessEvents 4.x and 5.x?