ORA-32004 的错误处理

2014-11-24 18:43:31 · 作者: · 浏览: 0


1.出现的错误提示



2.查看告警日志获得如下信息



3.spfile参数中清除过时的参数后启动正常



4.查看当前版本不再建议使用的参数



5.下面是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]