How to Eliminate Debug Data While Running Ouafdatabasepatch.Sh for Ansible Automation Purpose. (Doc ID 3067326.1)

Last updated on JANUARY 15, 2025

Applies to:

Goal

On : 7.0.0.0.0 version,

Huge debug while running ouafDatabasePatch.sh causing issues.

Huge debug while running ouafDatabasePatch.sh causing issues with the existing automation. Ansible automation kicks off ouafDatabasePatch.sh using expect libraries. The huge debug data is causing issues with expected automation.  This is essentially related to ORMB 7.0 rollup patches application.

Is there a way to disable the below debug statements?

- 2024-12-04 12:38:28,596 [main] DEBUG (database.patch.OUAFPatch) Opening file: CDXPatch.ini
 - 2024-12-04 12:38:28,599 [main] DEBUG (database.patch.OUAFPatch) CDXPatch.ini: 36869149
 - 2024-12-04 12:38:28,600 [main] DEBUG (database.patch.OUAFPatch) CDXPatch.ini: 37089383
 - 2024-12-04 12:38:28,600 [main] DEBUG (database.patch.OUAFPatch) CDXPatch.ini: 36915178
 - 2024-12-04 12:38:28,600 [main] DEBUG (database.patch.OUAFPatch) CDXPatch.ini: 36988446
 - 2024-12-04 12:38:28,603 [main] DEBUG (database.patch.OUAFPatch) opt_s (dev mode): false
 - 2024-12-04 12:38:28,604 [main] INFO (database.patch.OUAFPatch) Enter the target database type (O/M/D) [O]:
 - 2024-12-04 12:38:28,706 [main] DEBUG (database.patch.OUAFPatch)

Connecting to the Target Database ...
 - 2024-12-04 12:38:28,706 [main] DEBUG (database.patch.OUAFPatch)
User Name : C***M
 - 2024-12-04 12:38:28,706 [main] DEBUG (database.patch.OUAFPatch)
Database Name : //x0101vm02:1551/ormbria.healthpartners.com
 - 2024-12-04 12:38:29,113 [main] DEBUG (database.patch.OUAFPatch) target db name : //x******2:1**1/ormbxxx.healthpartners.com
 - 2024-12-04 12:38:29,113 [main] DEBUG (database.patch.OUAFPatch) connection : oracle.jdbc.driver.T4CConnection@4xxxxx0
 - 2024-12-04 12:38:29,261 [main] INFO (database.patch.OUAFPatch)
--Executed Successfully ...

 - 2024-12-04 12:38:29,264 [main] INFO (database.patch.OUAFPatch)

The rollup for ORMB 7.0 fails via automation. Works just fine manually. The automation is not able to handle the amount of debug that is being produced while running rollup roughly 4.5G data in 20 mins.

cd $(dirname /proj/hp/installers/ORMB/7.0.0.0.0_DB/rollup/ORMB-7000-Patch-Set-1/CCB/Database/ouafDatabasePatch.sh);./ouafDatabasePatch.sh -p "-d CISADM,//x0101vm02:1551/ormbria.healthpartners.com"
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.