Ed Chen Logic

How to Resolve ORA-01641: tablespace is not online - cannot add data file

by Ed Chen
August 5, 2022July 26, 2022

ORA-01641 Tried to add a data file to a tablespace, but it failed with ORA-01641. SQL> alter tablespace example add datafile '/u01/app/oracle/oradata/ORCLCDB/ORCLPDB/example01.dbf' size 10m autoextend… Read More »

How to Resolve ORA-03001: unimplemented feature

by Ed Chen
August 4, 2022July 26, 2022

ORA-03001 Tried to use RENAME TO statement to rename a schema object, but it failed with ORA-03001. SQL> rename add_job_history to add_job_history_all; rename add_job_history to… Read More »

How to Resolve PLS-00753: malformed or corrupted wrapped unit

by Ed Chen
August 3, 2022July 26, 2022

PLS-00753 Found a compile error PLS-00753 after we compiled trigger CAT_ROLLBACK_TRIGGER owned by GSMADMIN_INTERNAL. PLS-00753: malformed or corrupted wrapped unit Finally, we found that some… Read More »

How to Resolve CRS-4654: Server could not be found.

by Ed Chen
August 2, 2022July 26, 2022

CRS-4654 Tried to check the status of a specific server by crsctl status resource, but it failed with CRS-4654. [grid@primary01 ~]$ crsctl stat res -t… Read More »

How to Resolve CRS-4405: The following nodes are unknown to Oracle High Availability Services

by Ed Chen
August 1, 2022August 2, 2022

CRS-4405 Tried to check the status of a specific server by crsctl check cluster, but it failed with CRS-4405. [grid@primary01 ~]$ crsctl check cluster -n… Read More »

How to Resolve ORA-01542: tablespace is offline, cannot allocate space in it

by Ed Chen
July 29, 2022June 17, 2022

ORA-01542 Tried to move a table to another tablespace, but we got ORA-01542. SQL> alter table employees move tablespace users online; alter table employees move… Read More »

How to CTAS to Another Tablespace

by Ed Chen
July 28, 2022July 25, 2022

Backup Table by CTAS Without specifying tablespace, Create Table As Select (CTAS) will go to the default tablespace of the user. How about specifying a… Read More »

How to Resolve ORA-01157: cannot identify/lock data file

by Ed Chen
July 27, 2022July 28, 2022

ORA-01157 Saw error ORA-01157 when we tried to bring a tablespace online. SQL> alter tablespace example online; alter tablespace example online * ERROR at line… Read More »

How to Resolve ORA-00376: file cannot be read at this time

by Ed Chen
July 26, 2022July 25, 2022

ORA-00376 ORA-01110 Someone tried to perform a query, but it failed with ORA-00376 and ORA-01110. SQL> select first_name from employees where last_name = 'Chen'; select… Read More »

How to Resolve ORA-01113: file needs media recovery

by Ed Chen
July 25, 2022July 26, 2022

ORA-01113 ORA-01110 Tried to bring a data file online, but it failed with ORA-01113 and ORA-01110. SQL> alter database datafile '/u01/app/oracle/oradata/ORCLCDB/ORCLPDB/example01.dbf' online; alter database datafile… Read More »