removing parameter entry for spfile

[ronnie]

Hi,

We have a 4 node RAC cluster. I made a typo while modifying the undotablepsace of one of the clusters wherein i specified the nodename incorrecly.

The command I had issued to change the undotablespace was

alter system set undo_tablespace=UNDOTBS_TMP sid='NODE11';

Note the node name as node11. It should have been node 1.

I immediatly tried to correct this by isuing the correct command

alter system set undo_tablespace=undo_temp sid='NODE1';

Now I have entried for Node1 and Node11 in my spfile. How do I get rid of the Node11 entry for spfile.

NODE1.undo_tablespace='UNDOTBS_TMP'
NODE11.undo_tablespace='UNDOTBS_TMP' <-- Needs to be removed


Thanks
Ron

[pando]

alter system reset

[ronnie]

Thanks Pando. I tried it but seems like it wont work without actual bounce

SQL> alter system reset undo_tablespace sid='NODE11';
alter system reset undo_tablespace sid='NODE11'
*
ERROR at line 1:
ORA-32009: cannot reset the memory value for instance NODE11 from instance NODE1

This is a production system and I am concerned if there will be any other issues due to this additional entry.

Any other suggestions.

Thanks
Ron

[davey23uk]

scope = spfile

[ronnie]

I tried it, its not working too


SQL> alter system reset undo_tablespace sid='NODE11' scope=spfile;
alter system reset undo_tablespace sid='NODE11' scope=spfile
*
ERROR at line 1:
ORA-00933: SQL command not properly ended

Thanks
Ron

[davey23uk]

well you can just ignore it if you want, it wont ever be used or cause a problem- or create a pfile from the spfile, remove the offending line and then re-create the spfile

that command looks ok, but something is obviously up

[ronnie]

resolved.

the command is

alter system reset undo_tablespace scope=spfile sid='NODE11';

Thanks for your help.

-Ron