oracle 10g alter system reset,ORACLE 10G ALTER SYSTEM RESET遭遇ORA-00905

ORACLE版本: 10.2.0.4

重置参数的时候遭遇ORA-00905.GOOGLE了下.了解了个大概.下面是测试.

#ORACLE 11.2中是不会有这种情况的

[oracle@ora10g ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Mon Apr 16 12:57:14

2012

Copyright (c) 1982, 2007, Oracle. All Rights

Reserved.

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 171966464 bytes

Fixed

Size 2082496 bytes

Variable

Size 113248576 bytes

Database

Buffers 50331648 bytes

Redo

Buffers 6303744

bytes

Database mounted.

Database opened.

SQL> alter system reset undo_management

scope=spfile;

alter system reset undo_management scope=spfile

*

ERROR at line 1:

ORA-00905: missing keyword

SQL> alter system reset undo_management scope=spfile

sid='ora10g';

alter system reset undo_management scope=spfile sid='ora10g'

*

ERROR at line 1:

ORA-32010: cannot find entry to delete in SPFILE

SQL> alter system reset undo_management scope=spfile

sid='*';

System altered.

SQL>

可见SID是要指定的.据说SID的值和SCOPE的作用域也是有关的.这里就不做过多的测试了.

THE END