ORA-32004: obsolete and/or deprecated parameter(s) specified
来源:互联网 发布:在线代码编辑器java 编辑:程序博客网 时间:2024/05/17 12:20
启动数据库时,报如下错误:
SQL> startup
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE 例程已经启动。
Total System Global Area 171966464 bytes
Fixed Size 787988 bytes
Variable Size 145488364 bytes
Database Buffers 25165824 bytes
Redo Buffers 524288 bytes
数据库装载完毕。
数据库已经打开。
SQL> ALTER SYSTEM RESET log_archive_start SCOPE=SPFILE SID='*';
系统已更改。
SQL> shutdown immediate
数据库已经关闭。
已经卸载数据库。
ORACLE 例程已经关闭。
SQL> startup
ORACLE 例程已经启动。
Total System Global Area 171966464 bytes
Fixed Size 787988 bytes
Variable Size 145488364 bytes
Database Buffers 25165824 bytes
Redo Buffers 524288 bytes
数据库装载完毕。
数据库已经打开。
知所以然:见下文[url]http://www.dbanotes.net/archives/2004/12/caecora32004.html[/url]SQL> STARTUP;
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.
Total System Global Area 213909504 bytes
Fixed Size 778156 bytes
Variable Size 128983124 bytes
Database Buffers 83886080 bytes
Redo Buffers 262144 bytes
Database mounted.
Database opened.
SQL>
SQL> host oerr ora 32004
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 from the SPFILE or the server
// side PFILE.
SQL>Deprecated system parameters with specified values:
log_archive_start
End of deprecated system parameter listingSQL>ALTER SYSTEM RESET log_archive_start SCOPE=SPFILE SID='*';
System altered.
SQL> SHUTDOWN immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> STARTUP
ORACLE instance started.
Total System Global Area 213909504 bytes
Fixed Size 778156 bytes
Variable Size 128983124 bytes
Database Buffers 83886080 bytes
Redo Buffers 262144 bytes
Database mounted.
Database opened.
SQL>SQL> SELECT NAME, description
2 FROM v$parameter
3 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 keep buffer pool
buffer_pool_recycle Number of database blocks/latches in recycle buffer pool
log_archive_start start archival process on SGA initialization
parallel_server if TRUE startup in parallel server mode
parallel_server_instances number of instances to use for sizing OPS SGA structures
fast_start_io_target Upper bound on recovery reads
max_enabled_roles max number of roles a user can have enabled
global_context_pool_size Global Application Context Pool Size in Bytes
plsql_compiler_flags PL/SQL compiler flags
parallel_automatic_tuning enable intelligent defaults for parallel execution parameters
drs_start start DG Broker monitor (DMON process)
12 rows selected.
SQL>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
- ORA-32004: obsolete and/or deprecated parameter(s) specified
- ORA-32004: obsolete and/or deprecated parameter(s) specified
- ORA-32004: obsolete and/or deprecated parameter(s) specified
- ora-32004 obsolete and/or deprecated parameter(s) specified
- ORA-32004: obsolete and/or deprecated parameter(s) specified
- ORA-32004: obsolete and/or deprecated parameter(s) specified
- ORA-32004: obsolete and/or deprecated parameter(s) specified
- ORA-32004: obsolete and/or deprecated parameter(s) specified
- ORA-32004 obsolete and/or deprecated parameter(s) specified
- obsolete and/or deprecated parameter(s) specified
- ORA-32004: obsolete or deprecated parameter(s) specified for
- ORA-32004:obsolete and/or deprecated parameter
- ORA-32004: obsolete and/or deprecated parameter(s) specified(切换非归档数据库为归档时出现的)
- ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
- ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
- ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
- ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
- ORA-32004 obsolete or deprecated parameter(s) specified for RDBMS instance
- 如何增加有效的外链
- ASP.NET自定义控件组件开发(三)
- 2010移动开发者大会系列报道:国内移动产业五霸称雄
- 百度优化是网站内容的建立
- 会议法则之:头脑风暴会
- ORA-32004: obsolete and/or deprecated parameter(s) specified
- 如何让你的PR值快速提升
- 用plot,hist等函数画各种图示
- 分析百度与谷歌的区别
- 如何让自己新站的权重快速增加
- 字符编码趣事
- 我们为何要做SEO
- .html 映射到.net托管(用于实现页面伪静态)
- filelist