本文记录了在使用SQL*Plus连接Oracle数据库时遇到ORA-02391错误的过程，该错误提示会话数超过了设定的SESSIONS_PER_USER限制。文章详细描述了创建用户、配置会话限制及调整系统设置的具体步骤。
sqlplus / as sysdba
create user test identified by test;
create profile one_session limit sessions_per_user 1;
alter user test profile one_session;
alter system set resource_limit=true;
conn test/test
host sqlplus test/test
SQL*Plus: Release 10.2.0.3.0 - Production on 星期二 8月 11 17:09:05 2009
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
ERROR:
ORA-02391: 超出同时存在的 SESSIONS_PER_USER 限制
create user test identified by test;
create profile one_session limit sessions_per_user 1;
alter user test profile one_session;
alter system set resource_limit=true;
conn test/test
host sqlplus test/test
SQL*Plus: Release 10.2.0.3.0 - Production on 星期二 8月 11 17:09:05 2009
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
ERROR:
ORA-02391: 超出同时存在的 SESSIONS_PER_USER 限制
扫一扫
1248
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
