ORA-32000: write to SPFILE requested but SPFILE is not modifiable
来源:互联网 发布:unity3d软件下载 编辑:程序博客网 时间:2024/06/05 16:58
今天检查节点2 Alter.log 发现
Fatal NI connect error 12514, connecting to: (description=(address=(protocol=tcp)(host=惺惺惜惺惺)(port=1521))(connect_data=(server=dedicated)(SERVICE_NAME=xxxx_DGB)
关闭了dg_broker_start
alter system setdg_broker_start=true
ORA-32000: write to SPFILE requested but SPFILE is not modifiable
所有的节点都使用SPFILE启动的呀
而且SPFILE都指向ASM盘上的共享SPIFLE
然后发现节点2上的SPFILE
[oracle@node2 dbs]$ cat spfilesharkdb2.ora
C"\)H01CC"&j*.SPFILE='+DATA/posdb/spfilesharkdb2.ora'
CC"@eC
[oracle@node2 dbs]$ strings spfilesharkdb2.ora
C*.SPFILE='+DATA/posdb/spfilesharkdb2.ora'
前还有一些不知名的乱码. 果觉VI 删除前面的.然后就好了呀
- ORA-32000: write to SPFILE requested but SPFILE is not modifiable
- ORA-32000: write to SPFILE requested but SPFILE is not modifiable
- ORA-32001: write to SPFILE requested but no SPFILE is in use
- ORA-32001:write to SPFILE requested but no SPFILE is in use
- ORA-32001: write to SPFILE requested but no SPFILE specified at startup问题的解决
- ORA-16179: incremental changes to "log_archive_dest_1" not allowed with SPFILE
- ORA-16179: incremental changes to "log_archive_dest_1" not allowed with SPFILE
- ORA-16179: incremental changes to "log_archive_dest_1" not allowed with SPFILE
- ORA-16179: incremental changes to "log_archive_dest_1" not allowed with SPFILE
- ORA-16179: incremental changes to "log_archive_dest_31" not allowed with SPFILE
- spfile
- spfile
- ORA-16179: incremental changes to "log_archive_dest_1" not allowed with SPFILE 错误解决
- ORA-16179: incremental changes to "log_archive_dest_1" not allowed with SPFILE 错误解决
- 告警日志报“ORA-01565 Unable To open Spfile”
- srvctl modify the spfile,but db start using old spfile
- incremental changes to "log_archive_dest_1" not allowed with SPFILE
- startup alter.log spfile.ora
- svm理论与实验之4 — 问题的描述
- EFM32片内外设--DAC之Alt output
- DB2修改表结构
- 伸展树(Splay Tree)尽收眼底
- Color 颜色码-英文名称-十六进制-RGB对照表
- ORA-32000: write to SPFILE requested but SPFILE is not modifiable
- hibernate的配置文件中mapping节点的class和resource的区别
- UVA 11081 Strings
- ocr介绍
- Ext.Net中 combobox 禁止手输
- 分享一个网站:在线编译http://www.compileonline.com/
- ocr恢复测试
- Oracle的锁表与解锁
- VS2008如何使用用户自定义宏(User Macros