Manually add database/instance resources after a complete CRS reconfiguration

ORA-30012: undo tablespace ‘UNDOTBS1’ does not exist or of wrong type

Check UNDO tablespaces 
SQL>  select TABLESPACE_NAME, STATUS, CONTENTS from  dba_tablespaces where CONTENTS='UNDO';
------------------------------ --------- ---------
UNDOTBS2               ONLINE     UNDO
UNDOTBS3               ONLINE     UNDO
UNDOTBS4               ONLINE     UNDO

Verify undo_tablespace parameter 
SQL>  select inst_id,name,value from    gv$parameter where name like 'undo_tablespace' order by name,inst_id;
   INST_ID NAME               VALUE
---------- ------------------------------ ------------------------------
     1 undo_tablespace          UNDOTBS1
     2 undo_tablespace          UNDOTBS2
     3 undo_tablespace          UNDOTBS3
--> Recreate or Rename tablespace 

3 thoughts on “Manually add database/instance resources after a complete CRS reconfiguration”

  1. Your Site is very informative and helpful. You are a master
    I just wanted know what is the actual command for “crs” as i dont see there is “CRS” command.
    Following is one of the example you are using to find the svc details, but i could not use this command
    I tried crsctl stat res -t /p etc., but couldnt get output what you get from this
    crs | egrep ‘hr.svc|NAME|—-‘

    Appreciate if you could help with this

    1. Hi,
      crs [ and crsi ] are both shell scripts to display the CRS status.
      You can download these scripts by using Menu Path
      RAC -> RAC Generic -> RAC Scripts

Leave a Reply

Your email address will not be published. Required fields are marked *