oracle解锁账号Oracle11g中recyclebin已经是静态参数,在线不能修改

[oracle@rhel63single ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Mon Apr 20 17:19:32 2015Copyright (c) 1982, 2013, Oracle.  All rights reserved.Connected to an idle instance.SQL> startup ORACLE instance started.Total System Global Area 1068937216 bytesFixed Size                  2260088 bytesVariable Size             612369288 bytesDatabase Buffers          448790528 bytesRedo Buffers                5517312 bytesDatabase mounted.Database opened.SQL> SQL> SQL> SQL> SQL> SQL> SQL> show parameter roracle账号ecycNAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------buffer_pool_recycle                  stringdb_recycle_cache_size                big integer 0recyclebin                           string      onSQL> alter system set recyclebin=off;alter system set recyclebin=off                              *ERROR at line 1:ORA-02096: specified initialization parameter is not modifiable with thisoptionSQL> alter system set recyclebin=off scope=both;alter system set recyclebin=off scope=both                                *ERROR at line 1:ORA-02096: specified initialization parameter is not modifiable with thisoptionSQL> alter system set recyclebin=off scope=spfile;System altered.SQL> 

此条目发表在oracle metalink账号分类目录,贴了标签。将固定链接加入收藏夹。