ORA-32004:obsolete and/or deprecated parameter(s) specified ORACLE instance started的问题
环境oracle10gR2 solaris10
在执行sql_trace查看一些sql执行情况时，做了一下操作：
1 SQL>alter system set sql_trace scope=both;
2 SQL>shutdown immediate
3 SQL> startup
4 ORA-32004: obsolete and/or deprecated parameter(s) specified
5 ORACLE instance started.
6 Total System Global Area 167772160 bytes
7 Fixed Size 1218316 bytes
8 Variable Size 71305460 bytes
9 Database Buffers 92274688 bytes
10 Redo Buffers 2973696 bytes
11 Database mounted.
12 Database opened.
www.2cto.com
查看$ORACLE_BASE/admin/TEST/bdump/alter_TEST.log文件
Tue Jul 03 10:10:40 CST 2012
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.5.0.
System parameters with non-default values:
processes = 150
__shared_pool_size = 121634816
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
sga_target = 289406976
control_files = /oradb/oracle/oradata/TEST/control01.ctl, /oradb/oracle/oradata/TEST/control02.ctl, /oradb/oracle/oradata/TEST/control03.ctl
db_block_size = 8192
__db_cache_size = 150994944
compatible = 10.2.0.5.0
log_archive_dest_1 = LOCATION=/oradb/oracle/arch
log_archive_format = %t_%s_%r.dbf
db_file_multiblock_read_count= 8
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
global_names = TRUE
service_names = www.2cto.com
dispatchers = (PROTOCOL=TCP) (SERVICE=TESTXDB)
job_queue_processes = 10
background_dump_dest = /oradb/oracle/admin/TEST/bdump
user_dump_dest = /oradb/oracle/admin/TEST/udump
core_dump_dest = /oradb/oracle/admin/TEST/cdump
audit_file_dest = /oradb/oracle/admin/TEST/adump
db_name = TEST
open_cursors = 300
sql_trace = FALSE
pga_aggregate_target = 96468992 Deprecated system parameters with specified values:
sql_trace
End of deprecated system parameter listing
PMON started with pid=2, OS id=1024
PSP0 started with pid=3, OS id=1026
MMAN started with pid=4, OS id=1028
DBW0 started with pid=5, OS id=1030
LGWR started with pid=6, OS id=1032
CKPT started with pid=7, OS id=1034
SMON started with pid=8, OS id=1036
RECO started with pid=9, OS id=1038
CJQ0 started with pid=10, OS id=1040
MMON started with pid=11, OS id=1042
Tue Jul 03 10:10:43 CST 2012
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=1044
Tue Jul 03 10:10:43 CST 2012
starting up 1 shared server(s) ...
Tue Jul 03 10:10:43 CST 2012
ALTER DATABASE MOUNT
Tue Jul 03 10:10:50 CST 2012
Setting recovery target incarnation to 2
Tue Jul 03 10:10:50 CST 2012 www.2cto.com
Successful mount of redo thread 1, with mount id 2085797798
Tue Jul 03 10:10:50 CST 2012