ORA-00020 Error in CMS Database in BO 4.2 SP3

[former_member369090]

The BO Version was upgraded a year ago to 4.2 SP3 Patch 1 and the CMS Database version is 12c with the number of processes value set to 1024. No issues until last week, where the CMS Database had too many connections at a particular hour and had to bring down the database abruptly as it was not able to take any new connections.

The processes were increased to 2048 but the issue repeated after some days again. The error ORA-00020 is found in the logs with too many connections from the user AUDBIUSER which is the user for Audit logs.

All the schedules and publications ran without any failures on the days of the database issues.

The issue does not occur every day but intermittently in the past month. Is any specific recommendations from SAP for Oracle database parameters for CMS database?

Any lead is appreciated. Thanks.

[former_member369090 · Accepted solution]

This issue is found as a known issue with the BI version 4.2 SP3.

Please refer the SAP Note -

https://launchpad.support.sap.com/#/notes/2429436

Thanks everyone who responded.

[denis_konovalov]

You have too many contradictions in your question:
1. You mention upgrade, but it was a year ago and issues started recently - so what possible relation does that has with the issues ?

2. You mention that the errors are for AUDIT DB connection/DB, but then asking for CMS DB on Oracle tuning - Audit DB and CMS DB are 2 different databases, which should be tuned differently.

Your DBA should analyze both DB's performances and usage patterns and tune the Oracle accordingly.

CMS DB behaviour is lots and lots of small reads, occasional large read or write.
Audit DB is - lots of writes, occasional large reads.

[former_member550874]

Hi Priyadharshini,

It would be the time for audit database cleanup.

This usually happens when the audit data goes past the retention days, and BO starts cleaning up the data.

Please cross check the audit data time with CMC -> Auditing -> [Delete Events Older than (days)].

Regards,

Kunal Kharat

[prithvirajr]

Hi,

Please check sapnote

2402362 - ORA-00020 after upgrading to oracle 12c

1888485 - Database Parameter for 12.1.0.2

Hope that helps

Regards,

Prithviraj