ORA-32004问题的原因及解决

ORA-32004问题的原因及解决，在 Oracle 10g 中，以前熟悉的一些参数已经 deprecated原来在 10g 中，当打开归档模式(archive log

Version:SQL*Plus: Release 10.2.0.3.0
SQL> startup
ORA-32004: obsolete and/or deprecated parameter(s) specified
Oracle instance started.

Total System Global Area 343932928 bytes
Fixed Size 1261684 bytes
Variable Size 188747660 bytes
Database Buffers 146800640 bytes
Redo Buffers 7122944 bytes
Database mounted.
Database opened.
SQL>
SQL> alter system reset sql_trace scope=spfile sid='*';
System altered.

究其原因：

之前曾经使用过alter system set sql_trace=true scope=spfile语句，使sql_trace字段写入了spfile文件中

解决方法：
(1)创建pfile;
(2)修改pfile后，重新生成spfile
SQL>create spfile from pfile='/u01/oracle/dbs/inittest.ora';
(3)重新启动数据库
数据库成功启动

注：在 Oracle 10g 中，以前熟悉的一些参数已经 deprecated
原来在 10g 中，当打开归档模式(archive log mode) ，则 ARCH 进程被隐性的自动设定。10g 中也就不会出现 9i 以前那种数据库已经在归档模式，但是自动归档没有被设定的情况了。这也算是 Oracle 修正的一个小Bug。如果是从 9i 升级到 10g 的话，不注意可能会有点小问题的。要解决该问题，，需要重置 log_archive_start 参数

查看一下 10g 中都有那些参数是 deprecated 的:
select name,description from v$parameter where isdeprecated='TRUE';
NAME DESCRIPTION
------------------------- ----------------------------------------
lock_name_space lock name space used for generating lock
names for standby/clone database

buffer_pool_keep Number of database blocks/latches in kee
p buffer pool

buffer_pool_recycle Number of database blocks/latches in rec
ycle buffer pool

max_commit_propagation_de Max age of new snapshot in .01 seconds
lay

NAME DESCRIPTION
------------------------- ----------------------------------------

remote_archive_enable remote archival enable setting
log_archive_start start archival process on SGA initializa
tion

parallel_server if TRUE startup in parallel server mode
parallel_server_instances number of instances to use for sizing OP
S SGA structures

fast_start_io_target Upper bound on recovery reads
logmnr_max_persistent_ses maximum number of threads to mine

NAME DESCRIPTION
------------------------- ----------------------------------------
sions

serial_reuse reuse the frame segments
max_enabled_roles max number of roles a user can have enab
led

global_context_pool_size Global Application Context Pool Size in
Bytes

plsql_compiler_flags PL/SQL compiler flags
sql_trace enable SQL trace

NAME DESCRIPTION
------------------------- ----------------------------------------
parallel_automatic_tuning enable intelligent defaults for parallel
execution parameters

drs_start start DG Broker monitor (DMON process)

17 rows selected.

参数替代情况
Deprecated parameters in release 10g:
------------------------------------------------

BUFFER_POOL_KEEP (replaced by DB_KEEP_CACHE_SIZE)
BUFFER_POOL_RECYCLE (replaced by DB_RECYCLE_CACHE_SIZE)
PLSQL_COMPILER_FLAGS (replaced by PLSQL_CODE_TYPE and PLSQL_DEBUG)
DRS_START (replaced by DG_BROKER_START)
FAST_START_IO_TARGET (replaced by FAST_START_MTTR_TARGET)
MTS_CIRCUITS (replaced by CIRCUITS)
MTS_DISPATCHERS (replaced by DISPATCHERS)
MTS_MAX_DISPATCHERS (replaced by MAX_DISPATCHERS)
MTS_MAX_SERVERS (replaced by MAX_SHARED_SERVERS)
MTS_SERVERS (replaced by SHARED_SERVERS)
MTS_SESSIONS (replaced by SHARED_SERVER_SESSIONS)
PARALLEL_SERVER (replaced by CLUSTER_DATABASE)
PARALLEL_SERVER_INSTANCES (replaced by CLUSTER_DATABASE_INSTANCES)
废弃的参数:
Obsolete parameters in 10g:
---------------------------------------

DBLINK_ENCRYPT_LOGIN
HASH_JOIN_ENABLED
LOG_PARALLELISM
MAX_ROLLBACK_SEGMENTS
MTS_CIRCUITS
MTS_DISPATCHERS
MTS_LISTENER_ADDRESS
MTS_MAX_DISPATCHERS
MTS_MAX_SERVERS
MTS_MULTIPLE_LISTENERS
MTS_SERVERS
MTS_SERVICE
MTS_SESSIONS
OPTIMIZER_MAX_PERMUTATIONS
ORACLE_TRACE_COLLECTION_NAME
ORACLE_TRACE_COLLECTION_PATH
ORACLE_TRACE_COLLECTION_SIZE
ORACLE_TRACE_ENABLE
ORACLE_TRACE_FACILITY_NAME
ORACLE_TRACE_FACILITY_PATH
PARTITION_VIEW_ENABLED
PLSQL_NATIVE_C_COMPILER
PLSQL_NATIVE_LINKER
PLSQL_NATIVE_MAKE_FILE_NAME
PLSQL_NATIVE_MAKE_UTILITY
ROW_LOCKING
SERIALIZABLE
TRANSACTION_AUDITING
UNDO_SUPPRESS_ERRORS
DISTRIBUTED_TRANSACTIONS
MAX_TRANSACTION_BRANCHES
PARALLEL_BROADCAST_ENABLED
STANDBY_PRESERVES_NAMES
ALWAYS_ANTI_JOIN
ALWAYS_SEMI_JOIN
DB_BLOCK_LRU_LATCHES
DB_BLOCK_MAX_DIRTY_TARGET
DB_FILE_DIRECT_IO_COUNT
GC_DEFER_TIME
GC_RELEASABLE_LOCKS
GC_ROLLBACK_LOCKS
HASH_MULTIBLOCK_IO_COUNT
INSTANCE_NODESET
JOB_QUEUE_INTERVAL
OPS_INTERCONNECTS
OPTIMIZER_PERCENT_PARALLEL
SORT_MULTIBLOCK_READ_COUNT
TEXT_ENABLE

伴沃教育还为您提供以下相关内容希望对您有帮助：

Oracle ORA-32004 解决办法，造成这个错误的原因是因为指定了已经废弃的参数。Oracle ORA-32004 解决办法，造成这个错误的原因是因为指定了已经废弃的参数。可以查看alert日志，在启动加载参数文件的时候。System parameterswith non-default values:processes = 150 __shared_pool_size = 121634816 __large_p...

你设置了当前版本不用的参数，把参数reset就好了。LD_LIBRARY_PATH 不指定,不会有什么影响。sql_trace 很明显这个参数设置有问题.RESET一下 。

1. ORA-32004错误：这个错误是因为你的参数文件中有过期参数。查看警告文件看哪些参数过期，然后alter system reset xxx scope = spfile sid = 'xxxx'。警告文件的位置查看background_dump_dest参数得知。 2.ORA-00265错误：原因：因为上一次的数据库关闭用的abort选项，用abort选项关闭数据库是个非常不...

1、工作中遇到在启动数据库实例的时候报错ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance。2、先用静态参数文件pfile启动数据库，发现使用静态参数文件启动时没有报错。3、利用静态参数文件重建动态参数文件spfile并重启数据库，发现问题已经解决，不再有失效参数错误。4、查看...

最好是修改client端的会话的字符集环境。SQL>SHUTDOWN IMMEDIATE;SQL>STARTUP MOUNT EXCLUSIVE;SQL>ALTER SYSTEM ENABLE RESTRICTED SESSION;SQL>ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;SQL>ALTER SYSTEM SET AQ_TM_PROCESSES=0;SQL>ALTER DATABASE OPEN;SQL>ALTER DATABASE NATIONAL CHARACTER SET ...

1、工作中遇到在启动数据库实例的时候报错ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance。2、先用静态参数文件pfile启动数据库，发现使用静态参数文件启动时没有报错。3、利用静态参数文件重建动态参数文件spfile并重启数据库，发现问题已经解决，不再有失效参数错误。4、查看...