ora-02391：exceeded simultaneous sessions_per_user limit

开发人员报告测试环境出错，某个用户不能登陆 ：ra-02391：exceeded simultaneous sessions_per_user limit

 

 

SQL> select *
  2    from dba_profiles
  3   where profile = (select PROFILE from dba_users where username = 'testuser')
  4     AND RESOURCE_NAME = 'SESSIONS_PER_USER';

PROFILE                        RESOURCE_NAME                    RESOURCE_TYPE LIMIT
------------------------------ -------------------------------- ------------- ----------------------------------------
APP_PROFILE                    SESSIONS_PER_USER                KERNEL        100

 

 

SQL> alter profile APP_PROFILE limit sessions_per_user 110;

Profile altered

 

ok ，问题解决。