ORA-02095: specified initialization parameter cannot be modified
Cannot be specified Parameter initialization ORA modified
2023-09-14 08:59:39 时间
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
开始以为是 Fork 来的没有修改权限,但之前没有遇到这样的情况,提示信息说的也不是这个意思。
alter session set processes = 100;
会报相应的错误, 因为processes属性isses_modifiable的值为false;
有些参数不能动态修改,需要使用ALTER SYSTEM SET parameter = value scope = spfile, 然后重新启动数据库才能生效.
而alter system set parameter = value 使用的默认scope=both, 包括同时修改spfile和当前的设置.
开始以为是 Fork 来的没有修改权限,但之前没有遇到这样的情况,提示信息说的也不是这个意思。
相关文章
- The type javax.swing.JComponent cannot be resolved. It is indirectly referenced from required .class files
- 记一个mvn奇怪错误: Archive for required library: 'D:/mvn/repos/junit/junit/3.8.1/junit-3.8.1.jar' in project 'xxx' cannot be read or is not a valid ZIP file
- The type java.lang.CharSequence cannot be resolved. It is indirectly referenced from required .class files.
- java.lang.ClassCastException: net.sf.ezmorph.bean.MorphDynaBean cannot be cast to
- java.lang.ClassCastException: org.apache.hadoop.io.Text cannot be cast to org.apache.h...
- Error:Cannot build Artifact ':war exploded' because it is included into a circul
- ESX启动故障排除一“Cannot open the disk ‘XXXXXX.vmdk’ or one of the snapshot disks it depends on.”
- vscode go: cannot find main module
- Json解析异常处理方式(JSONException: Value of type java.lang.String cannot be converted to JSONObject)
- Fixing error: “chromedriver” cannot be opened because the developer cannot be verified. Unable to launch the chrome browser on Mac OS
- Vue Nuxtjs Cannot set property 'render' of undefined解决方法
- WCF The service cannot be activated because it does not support ASP.NET compatibility
- WCF The service cannot be activated because it does not support ASP.NET compatibility
- Cannot Load KPI tile with Error message - Missing parameterization request
- 【codeforces 782B】The Meeting Place Cannot Be Changed
- Android【报错】java.lang.ClassCastException: android.widget.TextView cannot be cast to android.widget.Bu
- 在AS上导入第三方module项目后报错提示:Resource IDs cannot be used in a switch statement in Android library modules
- 成功解决ImportError: cannot import name ‘imresize‘
- 成功解决TypeError: cannot concatenate object of type ‘<class ‘scipy.sparse._csr.csr_matrix‘>‘; only Seri
- 成功解决ImportError: cannot import name ‘_validate_lengths‘
- 成功解决importError cannot import idnadata
- 已解决ImportError: cannot import name ‘DecisionBoundaryDisplay‘ from ‘sklearn.inspection‘
- SpringBoot程序启动报错:FileNotFoundException:class path resource [***] cannot be opened because it does not exist
- 解决 Cannot add foreign key constraint 无法添加外键约束的问题
- 【错误记录】p7zip 交叉编译 Android 版本 NDK 报错 ( error: case value evaluates to -2 , which cannot be narrowed )
- Appium----报Original error: Cannot find any free port in range 8200..8299错误的解决办法
- 【Tensorflow】解决Inputs to eager execution function cannot be Keras symbolic tensors, but found [<tf.Te
- java.lang.ClassCastException: android.support.v7.widget.AppCompatTextView cannot be cast to com.demo
- 【异常】java11提示: Cannot find any provider supporting RSA/ECB/PKCS1Padding的问题
- 完美解决linux编译动态库出现的问题:ERROR: ld.so: object LD_PRELOAD cannot be preloaded: ignored