ORA-32004错误表示在Oracle数据库实例启动时,检测到了过时(obsolete)或被弃用(deprecated)的参数。这通常意味着数据库配置文件(如SPFILE或PFILE)中包含了在当前Oracle数据库版本中不再支持或不再推荐使用的参数。 可能导致ORA-32004错误的常见原因 升级Oracle数据库版本:在数据库升级过程中,某些参数可
1、启动报错 SQL> startup ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance ORACLE 例程已经启动。 Total System Global Area 1887350784 bytes Fixed Size 2176848 bytes Variable Size 1325402288 bytes Database Buffers 553648128 bytes Redo Buffers 6123520 bytes 数据库装载完毕。 数据...
Database opened. PRIMARY-SYS@TESTDB2> ho oerr ora 32004 32004, 00000, "obsolete or deprecated parameter(s) specified for %s instance" // *Cause: Obsolete or deprecated parameters for this instance type // were specified in the SPFILE or the PFILE on the server side. // *Action: See ale...
32004, 00000, "obsolete and/or deprecated parameter(s) specified" // *Cause: One or more obsolete and/or parameters were specified in // the SPFILE or the PFILE on the server side. // *Action: See alert log for a list of parameters that are obsolete. // or deprecated. Remove them ...
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance ORACLE 例程已经启动。 Total System Global Area 1887350784 bytes Fixed Size 2176848 bytes Variable Size 1325402288 bytes Database Buffers 553648128 bytes Redo Buffers 6123520 bytes ...
模拟解决故障:ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance 如:在Oracle 11g中手工设置了log_archive_start 为true,在启动时就会出现ORA-32004 从10g以后当数据库为归档模式时,oracle会自动启动归档进程。不在需要设置log_archive_start参数。
方法/步骤 1 1.工作中遇到在启动数据库实例的时候报错ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance 2 2.经查找发现是有已过期或不推荐使用参数，即使用的参数文件里有已过期或不推荐使用的参数。3 3.解决方法3.1先用静态参数文件pfile启动数据库，发现使用静态参数文件启动时没有...
ORA-32004: obsolete or deprecated parameter(s) specified forRDBMS instance ORACLE instance started.(有陈旧或过时的参数) Total System Global Area417546240 bytes Fixed Size2213936 bytes Variable Size318769104 bytes Database Buffers92274688 bytes Redo Buffers4288512 bytes ...
1 启动数据库到nomount状态[oracle@oracle11g dbs]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Mon Nov 3 09:43:56 2014Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to an idle instance.SQL> startup nomount;ORA-32004: obsolete or deprecated parameter(s...
如果在启动数据库时遇到ORA-32004: obsolete and/or deprecated parameter(s) specified 错误,这个是因为数据库里面设置了过时或不推荐使用的参数,如下描述所示: SQL> ho oerr ora 32004 32004, 00000, "obsolete and/or deprecated parameter(s) specified" ...