ORA-32004错误处理

C:\Documents and Settings\Administrator> sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on 星期二 10月 9 23:48:03 2012
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
已连接到空闲例程。

SQL> startup
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE 例程已经启动。

Total System Global Area  612368384 bytes
Fixed Size                  1250428 bytes
Variable Size             222301060 bytes
Database Buffers          381681664 bytes
Redo Buffers                7135232 bytes
数据库装载完毕。

数据库已经打开。

SQL> select * from v$version where rownum < 2;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod

查看10g中都有那些参数是 deprecated 的：
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
buffer_pool_keep                                      Number of database blocks/latches in keep buffer pool
buffer_pool_recycle                                  Number of database blocks/latches in recycle buffer pool
max_commit_propagation_delay         Max age of new snapshot in .01 seconds
remote_archive_enable                         remote archival enable setting
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
logmnr_max_persistent_sessions      maximum number of threads to mine
serial_reuse                                              reuse the frame segments
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
sql_trace                                                    enable SQL trace
parallel_automatic_tuning                     enable intelligent defaults for parallel execution parameters
drs_start                                                     start DG Broker monitor (DMON process)

已选择17行。


SQL> alter system reset sql_trace scope=spfile sid='*';
alter system reset sql_trace scope=spfile sid='*'
*
第 1 行出现错误:
ORA-32010: 无法在 SPFILE 中找到要删除的条目


SQL> show parameter pfile;
NAME                                 TYPE        VALUE
------------------------------------ ----------- ---------------------------
spfile                               string      D:\ORACLE\PRODUCT\10.2.0\DB
                                                 DATABASE\SPFILEORCL.ORA

创建Pfile查看参数文件中过时的参数

SQL> create pfile='c:\pfile.ora' from spfile;
文件已创建。

查看spfile.ora文件的参数

*.log_archive_start=TRUE

重置参数
SQL> alter system reset log_archive_start scope=spfile sid='*';
系统已更改。


SQL> shutdown immediate
数据库已经关闭。
已经卸载数据库。
ORACLE 例程已经关闭。

SQL> startup
ORACLE 例程已经启动。
Total System Global Area  612368384 bytes
Fixed Size                  1250428 bytes
Variable Size             222301060 bytes
Database Buffers          381681664 bytes
Redo Buffers                7135232 bytes
数据库装载完毕。
数据库已经打开。

5.下面是Oracle 10gR2不再支持的参数 

 

    * ENQUEUE_RESOURCES (undocumented in 10gR2)

    * DBLINK_ENCRYPT_LOGIN

    * HASH_JOIN_ENABLED (undocumented parameter)

    * LOG_PARALLELISM (undocumented parameter)

    * MAX_ROLLBACK_SEGMENTS

    * MTS_CIRCUITS (this is replaced by CIRCUITS)

    * MTS_DISPATCHERS (this is replaced by DISPATCHERS)

    * MTS_LISTENER_ADDRESS

    * MTS_MAX_DISPATCHERS (this is replaced by MAX_DISPATCHERS)

    * MTS_MAX_SERVERS (this is replaced by MAX_SHARED_SERVERS)

    * MTS_MULTIPLE_LISTENERS

    * MTS_SERVERS (this is replaced by SHARED_SERVERS)

    * MTS_SERVICE

    * MTS_SESSIONS (this is replaced by SHARED_SERVER_SESSIONS)

    * OPTIMIZER_MAX_PERMUTATIONS (undocumented parameter)

    * 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 (undocumented parameter)

    * PLSQL_NATIVE_C_COMPILER

    * PLSQL_NATIVE_LINKER

    * PLSQL_NATIVE_MAKE_FILE_NAME

    * PLSQL_NATIVE_MAKE_UTILITY

    * ROW_LOCKING (undocumented parameter)

    * SERIALIZABLE (undocumented parameter)

    * TRANSACTION_AUDITING (undocumented parameter)

    * UNDO_SUPPRESS_ERRORS

   

6.下面是Oracle 10gR2不建议使用参数 

    * LOGMNR_MAX_PERSISTENT_SESSIONS (Oracle Streams uses it)

    * MAX_COMMIT_PROPAGATION_DELAY

    * REMOTE_ARCHIVE_ENABLE

    * SERIAL_REUSE

    * SQL_TRACE

    * BUFFER_POOL_KEEP [replaced by DB_KEEP_CACHE_SIZE]

    * BUFFER_POOL_RECYCLE [replaced by DB_RECYCLE_CACHE_SIZE]

    * GLOBAL_CONTEXT_POOL_SIZE

    * LOCK_NAME_SPACE

    * LOG_ARCHIVE_START

    * MAX_ENABLED_ROLES

    * PARALLEL_AUTOMATIC_TUNING

    * PLSQL_COMPILER_FLAGS [replaced by PLSQL_CODE_TYPE and PLSQL_DEBUG]   

以上不使用部分替代参数如下：

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)