Total System Global Area 343932928 bytes
Fixed Size 1261684 bytes
Variable Size 188747660 bytes
Database Buffers 146800640 bytes
Redo Buffers 7122944 bytes
Database mounted.
Database opened.
SQL>
SQL> alter system reset sql_trace scope=spfile sid='*';
System altered.
究其原因：
之前曾经使用过alter system set sql_trace=true scope=spfile语句，使sql_trace字段写入了spfile文件中
解决方法：
(1)创建pfile;
(2)修改pfile后，重新生成spfile
SQL>create spfile from pfile='/u01/oracle/dbs/inittest.ora';
(3)重新启动数据库
数据库成功启动
注：在 Oracle 10g 中，以前熟悉的一些参数已经 deprecated
原来在 10g 中，当打开归档模式(archive log mode) ，则 ARCH 进程被隐性的自动设定。10g 中也就不会出现 9i 以前那种数据库已经在归档模式，但是自动归档没有被设定的情况了。这也算是 Oracle 修正的一个小Bug。如果是从 9i 升级到 10g 的话，不注意可能会有点小问题的。要解决该问题，需要重置 log_archive_start 参数
查看一下 10g 中都有那些参数是 deprecated 的:
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
buffer_pool_keep Number of database blocks/latches in kee
p buffer pool
buffer_pool_recycle Number of database blocks/latches in rec
ycle buffer pool
max_commit_propagation_de Max age of new snapshot in .01 seconds
lay
NAME DESCRIPTION
------------------------- ----------------------------------------
remote_archive_enable remote archival enable setting
log_archive_start start archival process on SGA initializa
tion
parallel_server if TRUE startup in parallel server mode
parallel_server_instances number of instances to use for sizing OP
S SGA structures
fast_start_io_target Upper bound on recovery reads
logmnr_max_persistent_ses maximum number of threads to mine
NAME DESCRIPTION
------------------------- ----------------------------------------
sions
serial_reuse reuse the frame segments
max_enabled_roles max number of roles a user can have enab
led
global_context_pool_size Global Application Context Pool Size in
Bytes
plsql_compiler_flags PL/SQL compiler flags
sql_trace enable SQL trace
NAME DESCRIPTION
------------------------- ----------------------------------------
parallel_automatic_tuning enable intelligent defaults for parallel
execution parameters
drs_start start DG Broker monitor (DMON process)
17 rows selected.
参数替代情况
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