Tuesday, November 16, 2010

What can you do for ORA-0018 ?

ORA-0018 : Maximum number of session exceeded

If you are facing with above error. Go to ini<SID>.ora file and increase below parameter values.
db_files
processes
sessions

SQL>alter system set processes=250 scope=spfile;
SQL>alter system set sessions=280 scope=spfile;

to activate these parameters database should be restarted.

Related Sap Note : 398927

No comments:

Post a Comment