Home / APPS DBA / ERROR ORA-00020 maximum number of processes (%s) exceeded

ERROR ORA-00020 maximum number of processes (%s) exceeded

Syed Saad Ali June 25, 2017 APPS DBA, Errors/Workarounds-Applications, Errors/Workarounds10g, Errors/Workarounds11g, Errors/Workarounds12c, Oracle APPS DBA, Oracle Database Material Leave a comment 598 Views

ERROR

 

ERROR ORA-00020 maximum number of processes (%s) exceeded

SOLUTION

Connect to sqlplus with sysdba

$ sqlplus / ‘ as sysdba’

SQL>ALTER SESSION SET processes = (your desired value);

 

 

About Syed Saad Ali

With 13 years of experience as a certified and skilled Oracle Database Administrator, I possess the expertise to handle various levels of database maintenance tasks and proficiently perform Oracle updates. Throughout my career, I have honed my analytical abilities, enabling me to swiftly diagnose and resolve issues as they arise. I excel in planning and executing special projects within time-sensitive environments, showcasing exceptional organizational and time management skills. My extensive knowledge encompasses directing, coordinating, and exercising authoritative control over all aspects of planning, organization, and successful project completions. Additionally, I have a strong aptitude for resolving customer relations matters by prioritizing understanding and effective communication. I am adept at interacting with customers, vendors, and management, ensuring seamless communication and fostering positive relationships.

Check Also

OracleDBconfig

Manually remove ODA DB HOME

Manually remove OLD DB HOMES if odacli-delete dbhome fails Please follow the instructions below: 1. …

Leave a Reply

Powered by OracleSolutions | Designed by
© Copyright 2024, https://oraclesolutions.pk All Rights Reserved