ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-32004: obsolete and/or deprecated parameter(s) specified

ORA-32004: obsolete and/or deprecated parameter(s) specified

原创 Linux操作系统 作者:tolywang 时间:2010-04-06 07:43:18 0 删除 编辑

如果在某个高一些的版本Oracle中使用了不再支持的参数,那么可能在开启数据库的时候会报错 :

SQL> startup 
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.

Total System Global Area 3154116608 bytes
Fixed Size                  2087248 bytes
Variable Size             671090352 bytes
Database Buffers         2466250752 bytes
Redo Buffers               14688256 bytes
Database mounted.
Database opened.
SQL>

 

If you are using an spfile, values for this are given in v$spparamter, not v$parameter. You can confirm whatever initialization parameters are in effect at any given time by doing a 'show parameter parallel' to show what initialization parameter values are at that time for any parameter that has 'parallel' in it's name.

Anyway, to remedy the problem, even if parallel_server is not false, there is still an entry for it in the spfile, and that is why you are receiving the error. It is not serious, but to remove it you will have to recreate the spfile, or start using an init.ora text file instead. Use Step B from note 137483.1 to do this. You can create a pfile from the spfile, remove the parallel_server setting altogether from the pfile, then use the pfile to recreate the spfile.

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/35489/viewspace-631374/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
Oracle , MySQL, SAP IQ, SAP HANA, PostgreSQL, Tableau 技术讨论,希望在这里一起分享知识,讨论技术,畅谈人生 。

注册时间:2007-12-10

  • 博文量
    5595
  • 访问量
    14695902