Ansicht
Dokumentation

audit_trail in init.ora <br />Tip-No.: 93 ( INFO93 )

audit_trail in init.ora
Tip-No.: 93 ( INFO93 )

Addresses (Business Address Services)   BAL Application Log Documentation  
This documentation is copyright by SAP AG.
SAP E-Book

Short text

audit_trail in init.ora
Tip-No.: 93

Symptom

Error ORA-0018 maximum number of sessions exceeded

Cause

Parameter audit_trail was set to TRUE.
The parameter sessions must thus be set to 2.1 * processes.
If this is not done, and sessions = 1.1 * processes (ORACLE
recommendation, you have halved the number of sessions and the above-
named error occurs.

Solution

Either shut off audit_trail again or adapt the sessions (see above).
After chaning the init.ora, you must restart the DB.






General Data in Customer Master   RFUMSV00 - Advance Return for Tax on Sales/Purchases  
This documentation is copyright by SAP AG.

Length: 651 Date: 20240419 Time: 032054     sap01-206 ( 11 ms )