It would be good idea to limit number of session for DBSNMP user on all monitored hosts. Agent opened 1600+ sessions this morning and as a result `ORA-00020: maximum number of processes XXXX exceeded`.
CREATE PROFILE DBSNMP_PROFILE LIMIT
SESSIONS_PER_USER 50
CPU_PER_SESSION UNLIMITED
CPU_PER_CALL 100000
CONNECT_TIME UNLIMITED
IDLE_TIME UNLIMITED
LOGICAL_READS_PER_SESSION UNLIMITED
LOGICAL_READS_PER_CALL UNLIMITED
COMPOSITE_LIMIT UNLIMITED
PRIVATE_SGA UNLIMITED
FAILED_LOGIN_ATTEMPTS UNLIMITED
PASSWORD_LIFE_TIME UNLIMITED
PASSWORD_REUSE_TIME UNLIMITED
PASSWORD_REUSE_MAX UNLIMITED
PASSWORD_LOCK_TIME UNLIMITED
PASSWORD_GRACE_TIME UNLIMITED
PASSWORD_VERIFY_FUNCTION NULL;
ALTER USER DBSNMP PROFILE DBSNMP_PROFILE;
Hi, did you found some note for this error?
ReplyDeleteDo you how difficult to proof oracle sw error? This happened twice on 1000+ targets and this is the quick work around :(
Delete