2 Replies Latest reply: May 7, 2012 1:33 AM by misterimran RSS

    How to edit spfile in RAC with location +DATA/

    misterimran
      Dear All,

      My RAC is 2 node 11gR2 on Linux.

      I need to modify my spfile since my UNDO tablespace is giving error while Oracle Starts up:

      ORA-01092: ORACLE instance terminated. Disconnection forced
      ORA-30012: undo tablespace 'UNDOTBS2' does not exist or of wrong type

      I changed UNDO TABLESPACE recently using alter system only.

      Now I want to change the UNDO TABLESPACE in spfile.

      When i go to dbs directory i can see the parameter file and its contents are: SPFILE='+DATA/racdb/spfileracdb.ora'

      I need to edit this file, how can i edit it?

      Kindly help

      Regards,
      Imran