ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit

今天kettle采集时报错:ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit.查了下文档:

 

       ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit

Cause: An attempt was made to exceed the maximum number of concurrent sessions allowed by the SESSION_PER_USER clause of the user profile.

Action: End one or more concurrent sessions or ask the database administrator to increase the SESSION_PER_USER limit of the user profile.

 

这个错误是由于超过了用户的profile中定义的SESSIONS_PER_USER(单个用户可以连接的会话数据)限制导致的.

检查用户使用的profile:

SQL> select username,profile from dba_users a where a.username='KDODM';
USERNAME                       PROFILE
------------------------------ ------------------------------
KDODM                          DEFAULT

查看DEFAULT profile的值:

SQL> select * from dba_profiles a where a.resource_name='SESSIONS_PER_USER';
PROFILE                          RESOURCE_NAME                    RESOURCE_TYPELIMIT
------------------------------                -------------------------------- ------------- ----------------------------------------
DEFAULT                            SESSIONS_PER_USER               KERNEL         UNLIMITED
MONITORING_PROFILE             SESSIONS_PER_USER                KERNEL        DEFAULT

发现是UNLIMITED!

问题出在哪里呢?

先不管问题,把各台机上的PL/SQL DEVELOPER关闭,再运行,ok了

 

 

这难道是个BUG?

环境是:

Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi

redhat 5.7  64bit

有谁遇到过这种情况?

续:

上面查的是目标数据库,源数据库同样也ORACLE数据库,联系源数据库DBA,问题杳然出在源数据库上.还是得细心些.