Hello together,

yesterday i had the ora-00018 Error in my Baan installation. When i look on my DB server I can see that more than 500 sessions are open. Is it normal that baan open so many DB-Session because we have only 120 Users. Maybe Oracle have problems when a user make not a normal logout?

Nows someone a feature which I can cancel old Baan-Oracle sessions?
Thanks,

Hello together,

yesterday i had the ora-00018 Error for my Baan installation. When look on my DB server I cqan see that more than 500 sessions ar open. Is it normal that baan open so many DB-Session because we have only 120 Users. Maybe Oracle have problems when a user make not a normal logout?

Now someone a feature which I can cancel old Baan-Oracle sessions?
Thanks,


Hello,

maybe in ****init_ora set open_cursors to a higher value.

Regards

It's common for Baan to have multiple sessions open in Oracle for one Baan process.

Regards,
Han

Refer to the BaanERP Oracle Database Driver Technical Reference Manual.
Document Information
Code: U7076C US
Group: User Documentation
Edition: C
Date: May, 2000

Chapter 6 Database driver configuration and tuning
Cursor management
The BaanERP Oracle database driver has two resource variables that influence the cursor handling, max_free_cursors and retained_cursors.

Check for the similar manual for Baan-4 versions.

From Oracle DB perspective-

ORA-00018: maximum number of sessions exceeded
Cause: All session state objects are in use.
Action: Increase the value of the SESSIONS initialization parameter.