Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Tue Jul 03 10:10:50 CST 2012
ALTER DATABASE OPEN
Tue Jul 03 10:10:50 CST 2012
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=16, OS id=1053
Tue Jul 03 10:10:50 CST 2012
ARC0: Archival started
ARC1: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC1 started with pid=17, OS id=1055
Tue Jul 03 10:10:50 CST 2012
Thread 1 opened at log sequence 10
Current log# 1 seq# 10 mem# 0: /oradb/oracle/oradata/TEST/redo01.log
Successful open of redo thread 1
Tue Jul 03 10:10:50 CST 2012
ARC0: Becoming the 'no FAL' ARCH
ARC0: Becoming the 'no SRL' ARCH
Tue Jul 03 10:10:50 CST 2012
ARC1: Becoming the heartbeat ARCH
Tue Jul 03 10:10:50 CST 2012
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Tue Jul 03 10:10:50 CST 2012
SMON: enabling cache recovery
Tue Jul 03 10:10:51 CST 2012
Successfully onlined Undo Tablespace 1.
Tue Jul 03 10:10:51 CST 2012
SMON: enabling tx recovery
Tue Jul 03 10:10:51 CST 2012
Database Characterset is WE8ISO8859P1
Opening with internal Resource Manager plan
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=18, OS id=1057
Tue Jul 03 10:10:53 CST 2012
Completed: ALTER DATABASE OPEN
然后查看一下信息，发现sql_trace已经作为不可用参数了
1 SQL>select name from v$parameter where isdeprecated = 'TRUE';
2 NAME www.2cto.com
4 lock_name_space
5 buffer_pool_keep
6 buffer_pool_recycle
7 max_commit_propagation_delay
8 remote_archive_enable
9 log_archive_start
10 parallel_server
11 parallel_server_instances
12 fast_start_io_target
13 logmnr_max_persistent_sessions
14 serial_reuse
15
16 NAME
17 --------------------------------------------------------------------------------
18 max_enabled_roles
19 global_context_pool_size
20 cursor_space_for_time
21 plsql_compiler_flags
22 sql_trace
23 parallel_automatic_tuning
24 drs_start
25
26 18 rows selected.
www.2cto.com
解决方案：
1、通过alter system命令修改spfile
1 SQL>alter system reset sql_trace scope=spfile SID='*';
2、通过pfile修改启动参数，然后再重建spfile
1 SQL>create pfile from spfile;
2 SQL>show parameter pfile
3 NAME TYPE VALUE
4 ------------------------------------ ----------- ------------------------------
5 spfile string /oradb/oracle/102/dbs/spfileTE
6 ST.ora
1 bash#vi /oradb/oracle/102/dbs/initTEST.ora
注释掉sql_trace=FALSE 后执行create spfile from pfile 然后重新启动
数据库。
作者 刘伟华