Ed Chen Logic

How to Open Port 1521 on Linux Server

by Ed Chen
June 22, 2023July 18, 2023

Firewall on Linux A firewall monitors and controls incoming and outgoing network traffic based on preconfigured security rules. It's not necessarily an appliance, it could… Read More »

How Oracle Grant All Privileges to User

by Ed Chen
June 21, 2023May 23, 2023

In Oracle, "all privileges" means all system privileges or all privileges on an object. So we talk about it separately. All System Privileges All Object… Read More »

How to Resolve ORA-20000: Insufficient privileges to analyze an object in Schema

by Ed Chen
June 20, 2023August 25, 2023

ORA-20000 A normal user can analyze its own schema without problem, but it cannot analyze other's schema. If do it, ORA-20000 will be thrown. Let's… Read More »

How DBMS_SCHEDULER.SET_ATTRIBUTE

by Ed Chen
June 19, 2023August 18, 2023

DBMS_SCHEDULER.SET_ATTRIBUTE The default maintenance window for weekdays is from 22:00 to the next day 02:00, which may be still too early for some batch jobs,… Read More »

SQL Developer Create Index Partition

by Ed Chen
June 16, 2023May 12, 2023

Partitioned Index To align with the partitioned table we created by SQL developer previously, we can add a partitioned index for it to improve data… Read More »

How to Resolve ORA-45909: restore, recover or block media recovery may be in progress

by Ed Chen
June 15, 2023June 24, 2023

ORA-45909 Tried to restore a data file by RMAN, it failed with ORA-45909, ORA-19890 and ORA-19573. RMAN> restore datafile 13; ... ORA-19870: error while restoring… Read More »

How to Resolve RMAN-06509: only SPFILE or control file can be restored from AUTOBACKUP

by Ed Chen
June 14, 2023June 24, 2023

RMAN-06509 When we tried to restore a datafile from a backup piece in RMAN, we saw error RMAN-06509. RMAN> restore datafile 1 from '/home/oracle/datafile-0a1r6qon_1_1'; ...… Read More »

How to Resolve ORA-19697: standby control file not found in backup set

by Ed Chen
June 13, 2023June 24, 2023

ORA-19697 Tried to restore controlfile from a backup set by RMAN, but it failed with ORA-19697. RMAN> restore controlfile from '/home/oracle/031r656h_1_1'; ... ORA-19697: standby control… Read More »

How to Resolve ORA-19687: SPFILE not found in backup set

by Ed Chen
June 12, 2023May 3, 2023

ORA-19687 Tried to restore SPFILE from a backup set by RMAN, but it failed with ORA-19687. RMAN> restore spfile from '/backup/rman/051r6emh_1_1'; ... ORA-19687: SPFILE not… Read More »

Toad No Valid Oracle Clients Found

by Ed Chen
June 9, 2023June 29, 2023

At the first time startup of Toad for Oracle, you may want to new a connection to start to use the tool. But sometimes, you… Read More »

JavaScript is not enabled. Please enable it and reload the page.