Ed Chen Logic

How to Patch Oracle Database 19c on Linux (DBRU 19.18)

by Ed Chen
February 14, 2023March 2, 2023

Here are steps to apply Database Release Update (DBRU) 19.18 (REL-JAN230131, 34765931) to Oracle database 19c (19.3) on Linux. Upload Patches Update Opatch utility Backup… Read More »

How to Run NETCA in Silent Mode

by Ed Chen
February 13, 2023February 18, 2023

By design, we split the entire installation into several clear sections and make the job easy to troubleshoot. Install Oracle Software Only in Silent Mode… Read More »

How to Resolve ORA-27125: unable to create shared memory segment

by Ed Chen
February 10, 2023January 12, 2023

ORA-27125 We found error ORA-27125 when we create the second database by Database Configuration Assistant (DBCA). ORA-27125 means that oracle has been bound to the… Read More »

How to Resolve ORA-01523: cannot rename data file to

by Ed Chen
February 9, 2023January 10, 2023

ORA-01523 Tried to rename a data file, but it failed with ORA-01523. SQL> alter database rename file '/u01/app/oracle/oradata/ORCLCDB/ORCLPDB/data_file_02.dbf' to '/oradata/ORCLCDB/ORCLPDB/data_file_01.dbf'; alter database rename file '/u01/app/oracle/oradata/ORCLCDB/ORCLPDB/data_file_02.dbf'… Read More »

How to Resolve ORA-00439: feature not enabled

by Ed Chen
February 8, 2023January 8, 2023

ORA-00439 We saw error ORA-00439 when we tried to create an index online. SQL> create index erp.bill_hist_idx2 on erp.bill_hist (SQ_NO) online; create index erp.bill_hist_idx2 on… Read More »

How to Resolve ORA-13780: SQL statement does not exist

by Ed Chen
February 7, 2023February 8, 2023

ORA-13780 Tried to create a SQL tuning task for specific SQL ID, but it failed with ORA-13780. SQL> select DBMS_SQLTUNE.CREATE_TUNING_TASK ( sql_id => '21zq47mj49f7w', scope… Read More »

SQL Statement Hang? Why?

by Ed Chen
February 6, 2023February 14, 2023

SQL Statement Hang Statements hanging or waiting always has a reason, lock release. Let's see some cases. UPDATE TABLE Hangs You may saw something is… Read More »

How to Resolve ORA-01647: tablespace is read-only, cannot allocate space in it

by Ed Chen
February 3, 2023January 5, 2023

ORA-01647 Tried to move a table to another tablespace, but it failed with ORA-01647. SQL> alter table employees move tablespace example; alter table employees move… Read More »

How to Resolve ORA-00372: file cannot be modified at this time

by Ed Chen
February 2, 2023February 4, 2023

ORA-00372 Tried to update a table, but it failed with ORA-00372 and ORA-01110. SQL> show user USER is "HR" SQL> update employees set first_name =… Read More »

How to Resolve ORA-39109: Unprivileged users may not operate upon other users' schemas

by Ed Chen
February 1, 2023January 5, 2023

ORA-39109 Saw error ORA-39109 when we tried to export someone's data from the database. C:\Users\Administrator>expdp ERPAPP@APPDB1 schemas=FINAPP dumpfile=FINAPP-export.dmp logfile=FINAPP-export.log ... ORA-31631: privileges are required ORA-39109:… Read More »