ORA-02095: specified initialization parameter cannot be modified
来源:互联网 发布:sql drop from 编辑:程序博客网 时间:2024/06/05 18:25
ORA-02095: 无法修改指定的初始化参数
SQL> ALTER SYSTEM SET processes=400 SCOPE=BOTH SID='KMIS1';ALTER SYSTEM SET processes=400 SCOPE=BOTH SID='KMIS1' *ERROR at line 1:ORA-02095: specified initialization parameter cannot be modified
参数
alter session set processes = 100;
会报相应的错误, 因为processes属性isses_modifiable的值为false;
有些参数不能动态修改,需要使用ALTER SYSTEM SET parameter = value scope = spfile, 然后重新启动数据库才能生效.
而alter system set parameter = value 使用的默认scope=both, 包括同时修改spfile和当前的设置.
<<database reference>>
v$parameter: isses_modifiable & issys_modifiable
0 0
- ORA-02095: specified initialization parameter cannot be modified
- ORA-02096: specified initialization parameter is not modifiable with this option
- ORA-01261: Parameter db_create_file_dest destination string cannot be
- ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated
- ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated
- ORA-16032: parameter LOG_ARCHIVE_DEST_3 destination string cannot be translated
- ORA-16032: parameter LOG_ARCHIVE_DEST_1 destination string cannot be translated
- field cannot be modified delphi
- ORA-16032: parameter LOG_ARCHIVE_DEST_1 destination string cannot be translated ORA-01264: Unable to
- ORA-29760: instance_number parameter not specified
- Graph is finalized and cannot be modified
- 【Oracle问题集7】ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated
- ORA-16032: parameter LOG_ARCHIVE_DEST_3 destination string cannot be translated问题处理过程
- oralce 报错 ora-16032 parameter log_archive_dest_1 destination string cannot be transtlated
- ORA-32004: obsolete and/or deprecated parameter(s) specified
- ORA-32004: obsolete and/or deprecated parameter(s) specified
- ORA-32004: obsolete and/or deprecated parameter(s) specified
- ora-32004 obsolete and/or deprecated parameter(s) specified
- UI AutoLayer 自动布局-->约束
- Error: Cannot find configuration directory: /etc/hadoop
- MySQL 性能优化
- 初学hibernate笔记
- PAT-1048 数字加密20
- ORA-02095: specified initialization parameter cannot be modified
- Android Studio 使用遇到的各种问题
- 【POJ 3630】Phone List 中文题意&题解&代码(C++)
- Oracle之查看建表语句
- Android shape使用
- mysql-复制表
- 待梳理知识点
- 杂论--二十出头的时间上,你一无所有,你拥有一切
- Java ServletContext 详解