Oracle初始参数中三个关于License的设置

核心提示： 接下来新开一个窗口，连接另外一个用户： C:Documents and Settingschent>sqlplus /nologSQL*Plus: Release 9.2.0.6.0 - Production on Thu Mar 23 10:51:04 2006Copyright

接下来新开一个窗口，连接另外一个用户：

C:Documents and Settingschent>sqlplus /nolog
SQL*Plus: Release 9.2.0.6.0 - Production on Thu Mar 23 10:51:04 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> conn sky/forever
Connected.
SQL> select * from v$license;
SESSIONS_MAX SESSIONS_WARNING SESSIONS_CURRENT SESSIONS_HIGHWATER USERS_MAX
------------ ---------------- ---------------- ------------------ ----------
3 0 3 3 0

再开一个用户试试看：

C:Documents and Settingschent>sqlplus /nolog
SQL*Plus: Release 9.2.0.6.0 - Production on Thu Mar 23 10:52:45 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> conn vivian/forever
ERROR:
ORA-00019: maximum number of session licenses exceeded

可以发现，提示超出限制，无法连接了，不过，具有 RESTRICTED SESSION 权限的用户是可以连接的：

SQL> conn sky/forever
Connected.
SQL> select * from v$license;
SESSIONS_MAX SESSIONS_WARNING SESSIONS_CURRENT SESSIONS_HIGHWATER USERS_MAX
------------ ---------------- ---------------- ------------------ ----------
3 0 4 4 0

最后，我们可以观察alert文件中的记录：

Thu Mar 23 10:47:30 2006
ALTER SYSTEM SET license_max_sessions=3 SCOPE=BOTH;
Thu Mar 23 10:52:51 2006
Non-DBA logon denied; current logons equal maximum (3)
License maximum (3) exceeded, DBA logon allowed