ORA-32004: obsolete and/or deprecated parameter(s) specified
ORA-32004: obsolete and/or deprecated parameter(s) specified
接下来看查看alert：
Starting up ORACLE RDBMS Version: 10.1.0.3.0.
System parameters with non-default values:
processes = 150
__shared_pool_size = 50331648
__large_pool_size = 4194304
__java_pool_size = 8388608
sga_target = 167772160
control_files = /u01/app/oracle/oradata/orcl/control01.ctl, /u01/app/oracle/oradata/orcl/control02.ctl, /u01/app/oracle/oradata/orcl/control03.ctl
db_block_size = 8192
__db_cache_size = 100663296
db_cache_advice = OFF
compatible = 10.1.0.2.0
log_archive_start = TRUE
db_file_multiblock_read_count= 16
db_recovery_file_dest = /u01/app/oracle/flash_recovery_area/
db_recovery_file_dest_size= 2147483648
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
background_dump_dest = /u01/app/oracle/admin/orcl/bdump
user_dump_dest = /u01/app/oracle/admin/orcl/udump
core_dump_dest = /u01/app/oracle/admin/orcl/cdump
audit_trail = FALSE
db_name = orcl
open_cursors = 300
pga_aggregate_target = 16777216
Deprecated system parameters with specified values:
log_archive_start
End of deprecated system parameter listing
PMON started with pid=2, OS id=13659
MMAN started with pid=3, OS id=13661
DBW0 started with pid=4, OS id=13663
LGWR started with pid=5, OS id=13665
CKPT started with pid=6, OS id=13667
SMON started with pid=7, OS id=13669
RECO started with pid=8, OS id=13671
Thu Jan 20 10:42:24 2011
上网搜了一下：说是：原来10g的以下几个参数不能同时使用，否则，会导致本错误出现。
LOG_ARCHIVE_DEST
LOG_ARCHIVE_DEST_n
DB_RECOVERY_FILE_DEST
注意，10g默认使用快速恢复区。 DB_RECOVERY_FILE_DEST
我的alert的错误信息：
Deprecated system parameters with specified values:
log_archive_start
End of deprecated system parameter listing
系统反对使用 log_archive_start参数
查看 数据库
SQL> show parameter log_archive_start;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_start boolean TRUE
无意间把这个参数 设置成为 true，正常的应该是 false。
log_archive_start参数在10g中已经被抛弃，无意间给设置后所以产生以上的错误；
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.
Fixed Size 778212 bytes
Variable Size 66068508 bytes
Database Buffers 100663296 bytes
Redo Buffers 262144 bytes
Database mounted.
Database opened.
------------------------------------ ----------- ------------------------------
log_archive_start boolean FALSE
alter system reset log_archive_start scope=spfile
*
第 1 行出现错误:
ORA-00905: 缺失关键字
SQL> alter system reset log_archive_start scope=spfile sid='*'; 重置参数
数据库已经关闭。
已经卸载数据库。
ORACLE 例程已经关闭。
SQL> startup
ORACLE instance started.
Fixed Size 778212 bytes
Variable Size 66068508 bytes
Database Buffers 100663296 bytes
Redo Buffers 262144 bytes
Database mounted.
Database opened.
------到此：问题解决
总结：
原来10g有的参数被抛弃，所以修改之后，就会报错，只能重置参数才可以。
SQL> 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
Number of database blocks/latches in keep buffer pool
Number of database blocks/latches in recycle buffer pool
start archival process on SGA initialization
if TRUE startup in parallel server mode
number of instances to use for sizing OPS SGA structures
Upper bound on recovery reads
max number of roles a user can have enabled
Global Application Context Pool Size in Bytes
reuse the frame. segments
PL/SQL compiler flags
enable intelligent defaults for parallel execution parameters
start DG Broker monitor (DMON process)
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/24873454/viewspace-684349/ ，如需转载，请注明出处，否则将追究法律责任。
