Oracle 10g不支持的参数及ORA-32004错误处理。

Posted on 2012-10-30 15:55  bingfeng  阅读(1296)  评论(0编辑  收藏  举报

ORA-32004错误原因:由于在初始化参数文件中存在一些在该Oracle版本中不支持的一些参数,因此会在启动的时候提示这个错误,但不影响系统的使用。既然发现有这个问题存在就应该解决了。解决步骤如下:

    (1)查看alert日志,从中搜索“deprecated(意思是弃用)",找到提示的哪个存在于spfile中弃用的参数

    (2)进入sqlplus,使用alter system reset log_archive_start scope=spfile sid='*';(注:这里使用的参数为log_archive_start)

     (3)重启数据库,即可正常。

因此需要关注下Oracle10G中不再支持的参数。

下面是Oracle 10gR2不再支持的参数 

 

    * ENQUEUE_RESOURCES (undocumented in 10gR2)

    * DBLINK_ENCRYPT_LOGIN

    * HASH_JOIN_ENABLED (undocumented parameter)

    * LOG_PARALLELISM (undocumented parameter)

    * MAX_ROLLBACK_SEGMENTS

    * MTS_CIRCUITS (this is replaced by CIRCUITS)

    * MTS_DISPATCHERS (this is replaced by DISPATCHERS)

    * MTS_LISTENER_ADDRESS

    * MTS_MAX_DISPATCHERS (this is replaced by MAX_DISPATCHERS)

    * MTS_MAX_SERVERS (this is replaced by MAX_SHARED_SERVERS)

    * MTS_MULTIPLE_LISTENERS

    * MTS_SERVERS (this is replaced by SHARED_SERVERS)

    * MTS_SERVICE

    * MTS_SESSIONS (this is replaced by SHARED_SERVER_SESSIONS)

    * OPTIMIZER_MAX_PERMUTATIONS (undocumented parameter)

    * 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 (undocumented parameter)

    * PLSQL_NATIVE_C_COMPILER

    * PLSQL_NATIVE_LINKER

    * PLSQL_NATIVE_MAKE_FILE_NAME

    * PLSQL_NATIVE_MAKE_UTILITY

    * ROW_LOCKING (undocumented parameter)

    * SERIALIZABLE (undocumented parameter)

    * TRANSACTION_AUDITING (undocumented parameter)

    * UNDO_SUPPRESS_ERRORS

   

6.下面是Oracle 10gR2不建议使用参数 

    * LOGMNR_MAX_PERSISTENT_SESSIONS (Oracle Streams uses it)

    * MAX_COMMIT_PROPAGATION_DELAY

    * REMOTE_ARCHIVE_ENABLE

    * SERIAL_REUSE

    * SQL_TRACE

    * BUFFER_POOL_KEEP [replaced by DB_KEEP_CACHE_SIZE]

    * BUFFER_POOL_RECYCLE [replaced by DB_RECYCLE_CACHE_SIZE]

    * GLOBAL_CONTEXT_POOL_SIZE

    * LOCK_NAME_SPACE

    * LOG_ARCHIVE_START

    * MAX_ENABLED_ROLES

    * PARALLEL_AUTOMATIC_TUNING

    * PLSQL_COMPILER_FLAGS [replaced by PLSQL_CODE_TYPE and PLSQL_DEBUG]   

Copyright © 2024 bingfeng
Powered by .NET 8.0 on Kubernetes