2 Replies Latest reply: Sep 17, 2013 4:03 PM by kirkladb RSS

    E-Business R12 Inactive User Issues

    kirkladb

      All:

      I just went live in production with EBS 12.1.3 and we are havinga major issue. I was hoping that someone might have seen this. I log into Apps (32-Bit for both apps and dbtier) and the number of inactive users for Apps steadily increases to reach the max processes for the database). Once this happens no one can get in...:

       

      SQL> l
        1  select s.status, count(1), s.username from v$process p,v$session s where
        2  paddr(+) = addr
        3* group by s.status, s.username order by 1
      SQL> /

      STATUS     COUNT(1) USERNAME
      -------- ---------- ------------------------------
      ACTIVE           28 APPS
      ACTIVE            1 SYS
      ACTIVE           28
      INACTIVE        190 APPS
      INACTIVE          1 DBSNMP
                        1

      There are really no users in now yet the counts are hight. Most of the connections that are inactive are for JDBC Thin Client. Any suggestions?