ORA-32004错误处理

青旅半醒 2022-05-23 04:40 125阅读 0赞

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)