ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit

查看资源限制信息
set pagesize 100;
set linesize 100;
col username for a15;
col profile for a15;
col resource_name for a30;
col limit for a10;

SELECT DISTINCT username,
profile,
resource_name,
limit
FROM dba_profiles
NATURAL JOIN dba_users
WHERE resource_name = 'SESSIONS_PER_USER';

修改limit值
Alter profile 'YourUserProfile' limit SESSIONS_PER_USER 100;