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'; TABLESPACE_NAME STATUS CONTENTS ------------------------------ --------- --------- 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 SQL> ALTER TABLESPACE UNDOTBS4 RENAME to UNDOTBS1;
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
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
useful information provided