ORA-32004 的错误处理

àì夳堔傛蜴生んèń 2022-05-15 03:38 142阅读 0赞

\--=======================

\-- ORA-32004 的错误处理

\--=======================

启动数据库时，收到了ORA\-32004 的错误，错误多是一些过时且在当前版本中不在使用的参数，如果碰到类似的错误，只需要将其

reset即可。

1.出现的错误提示

sys@ORCL> startup

ORA-32004: obsolete and/or deprecated parameter(s) specified

ORACLE instance started.

Total System Global Area 184549376 bytes

Fixed Size 1218412 bytes

Variable Size 83888276 bytes

Database Buffers 96468992 bytes

Redo Buffers 2973696 bytes

Database mounted.

Database opened.

2.查看告警日志获得如下信息

sys@ORCL> ho oerr ora 32004 \--分析错误

32004, 00000, "obsolete and/or deprecated parameter(s) specified"

// \*Cause: One or more obsolete and/or parameters were specified in

// the SPFILE or the PFILE on the server side.

// \*Action: See alert log for a list of parameters that are obsolete.

// or deprecated. Remove them from the SPFILE or the server

// side PFILE.

\--从告警日志中获得如下信息

Deprecated system parameters with specified values:

sql\_trace

End of deprecated system parameter listing

3.从spfile参数中清除过时的参数后启动正常

sys@ORCL> alter system reset sql\_trace scope=spfile sid='\*';

System altered.

sys@ORCL> startup force;

ORACLE instance started.

Total System Global Area 184549376 bytes

Fixed Size 1218412 bytes

Variable Size 83888276 bytes

Database Buffers 96468992 bytes

Redo Buffers 2973696 bytes

Database mounted.

Database opened.

4.查看当前版本不再建议使用的参数

sys@ORCL> select \* from v$version where rownum < 2;

BANNER

\----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 \- Prod

sys@ORCL> select name,description

2 from v$parameter where isdeprecated='TRUE';

NAME DESCRIPTION

\------------------------------ --------------------------------------------------------------

lock\_name\_space lock name space used for generating lock names for standby/clo

ne 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)

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\]

7.更多参考

有关闪回特性请参考

[Oracle 闪回特性(FLASHBACK DATABASE)][Oracle _FLASHBACK DATABASE]

[Oracle 闪回特性(FLASHBACK DROP & RECYCLEBIN)][Oracle _FLASHBACK DROP _ RECYCLEBIN]

[Oracle 闪回特性(Flashback Query、Flashback Table)][Oracle _Flashback Query_Flashback Table]

[Oracle 闪回特性(Flashback Version、Flashback Transaction)][Oracle _Flashback Version_Flashback Transaction]

有关基于用户管理的备份和备份恢复的概念请参考：

[Oracle 冷备份][Oracle]

[Oracle 热备份][Oracle 1]

[Oracle 备份恢复概念][Oracle 2]

[Oracle 实例恢复][Oracle 3]

[Oracle 基于用户管理恢复的处理][Oracle 4](详细描述了介质恢复及其处理)

有关RMAN的恢复与管理请参考：

[RMAN 概述及其体系结构][RMAN]

[RMAN 配置、监控与管理][RMAN 1]

[RMAN 备份详解][RMAN 2]

[RMAN 还原与恢复][RMAN 3]

有关Oracle体系结构请参考：

[Oracle 实例和Oracle数据库(Oracle体系结构)][Oracle _Oracle_Oracle]

[Oracle 表空间与数据文件][Oracle 5]

[Oracle 密码文件][Oracle 6]

[Oracle 参数文件][Oracle 7]

[Oracle 数据库实例启动关闭过程][Oracle 8]

[Oracle 联机重做日志文件(ONLINE LOG FILE)][Oracle _ONLINE LOG FILE]

[Oracle 控制文件(CONTROLFILE)][Oracle _CONTROLFILE]

[Oracle 归档日志][Oracle 9]

[Oracle _FLASHBACK DATABASE]: http://blog.csdn.net/robinson_0612/archive/2010/12/27/6100429.aspx
[Oracle _FLASHBACK DROP _ RECYCLEBIN]: http://blog.csdn.net/robinson_0612/archive/2010/12/29/6105327.aspx
[Oracle _Flashback Query_Flashback Table]: http://blog.csdn.net/robinson_0612/archive/2011/01/02/6112607.aspx
[Oracle _Flashback Version_Flashback Transaction]: http://blog.csdn.net/robinson_0612/archive/2011/01/02/6112981.aspx
[Oracle]: http://blog.csdn.net/robinson_0612/archive/2010/08/05/5791597.aspx
[Oracle 1]: http://blog.csdn.net/robinson_0612/archive/2010/08/16/5816012.aspx
[Oracle 2]: http://blog.csdn.net/robinson_0612/archive/2010/08/05/5791585.aspx
[Oracle 3]: http://blog.csdn.net/robinson_0612/archive/2010/07/27/5768233.aspx
[Oracle 4]: http://blog.csdn.net/robinson_0612/archive/2010/11/28/6041217.aspx
[RMAN]: http://blog.csdn.net/robinson_0612/archive/2010/11/24/6032525.aspx
[RMAN 1]: http://blog.csdn.net/robinson_0612/archive/2010/11/24/6032597.aspx
[RMAN 2]: http://blog.csdn.net/robinson_0612/archive/2010/11/24/6032739.aspx
[RMAN 3]: http://blog.csdn.net/robinson_0612/archive/2010/11/28/6041247.aspx
[Oracle _Oracle_Oracle]: http://blog.csdn.net/robinson_0612/archive/2010/04/26/5529239.aspx
[Oracle 5]: http://blog.csdn.net/robinson_0612/archive/2010/05/20/5611738.aspx
[Oracle 6]: http://blog.csdn.net/robinson_0612/archive/2010/05/20/5611672.aspx
[Oracle 7]: http://blog.csdn.net/robinson_0612/archive/2010/05/05/5559174.aspx
[Oracle 8]: http://blog.csdn.net/robinson_0612/archive/2010/04/29/5542983.aspx
[Oracle _ONLINE LOG FILE]: http://blog.csdn.net/robinson_0612/archive/2010/07/20/5749556.aspx
[Oracle _CONTROLFILE]: http://blog.csdn.net/robinson_0612/archive/2010/07/15/5737527.aspx
[Oracle 9]: http://blog.csdn.net/robinson_0612/archive/2010/08/03/5784713.aspx