Thursday 24 May 2012

Oracle Clound Countrol 12c and runaway agent


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;

2 comments:

  1. Hi, did you found some note for this error?

    ReplyDelete
    Replies
    1. Do you how difficult to proof oracle sw error? This happened twice on 1000+ targets and this is the quick work around :(

      Delete