[20180102]statistics_level=BASIC.txt

--//一个测试环境不知道谁设置statistics_level=BASIC,导致重启出现错误,自己在测试环境模拟看看:

SYS@book> create pfile='/tmp/@.ora' from spfile;
File created.

--//修改/tmp/book.ora,加入如下:
$ grep BASIC /tmp/book.ora
*.statistics_level=BASIC

SYS@book> shutdown immediate ;
Database closed.
Database dismounted.
ORACLE instance shut down.

SYS@book> startup pfile=/tmp/book.ora
ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings
ORA-00848: STATISTICS_LEVEL cannot be set to BASIC with SGA_TARGET or MEMORY_TARGET
ORA-01078: failure in processing system parameters

--//解决方法很简单取消statistics_level=BASIC设置,问题就解决了.

ITPub博客

[20180102]statistics_level=BASIC.txt

最新文章