Scheduled Jobs Running at Wrong Time
If you found this problem in a Pluggable Database (PDB), then we might have the same issue. My finding is that AUTOTASK is always triggered… Read More »Scheduled Jobs Running at Wrong Time
How to Set Scheduler Time Zone
Scheduler Time Zone Before doing that, we have make sure the time zone region you want to set is valid for Oracle. Then we change… Read More »How to Set Scheduler Time Zone
DBMS_SCHEDULER All Available Subprograms
PACKAGE DBMS_SCHEDULER I found that some subprograms of DBMS_SCHEDULER package are no listed in the Oracle documentation. However, we get the complete list by describing… Read More »DBMS_SCHEDULER All Available Subprograms
How to Stop a Running Scheduler Job
Sometimes, we may find scheduled jobs currently impact other running sessions, we may consider to turn it off right away. Killing the scheduled job sessions… Read More »How to Stop a Running Scheduler Job
LAST_DDL_TIME was Changed, Why?
What is LAST_DDL_TIME? Generally speaking, LAST_DDL_TIME means the last change date time of the object definition, all by Data Definition Language (DDL). But sometimes, it's… Read More »LAST_DDL_TIME was Changed, Why?
How to Resolve rm: 0653-609 Cannot remove
0653-609 Cannot remove Tried to remove some files, but it failed with 0653-609 Cannot remove. Let's see the case. [oracle@primary01 export]$ pwd /backup/export [oracle@primary01 export]$… Read More »How to Resolve rm: 0653-609 Cannot remove
How to Resolve ORA-46659: master keys for the given PDB not found
ORA-46659 Saw ORA-46659 when I tried to clone a PDB with TDE remotely through a database link. SQL> create pluggable database ERPAPP_CLONE from ERPAPP@erpapp_link storage… Read More »How to Resolve ORA-46659: master keys for the given PDB not found
How to Resolve Toad Error ORA-00904: "REF": invalid identifier
Tried to display "Script" (DDL) of a table in Toad for Oracle, we saw ORA-00904: "REF": invalid identifier. Typically, ORA-00904 is an unmatched column issue,… Read More »How to Resolve Toad Error ORA-00904: "REF": invalid identifier
How to Resolve OPEN_NO_MASTER_KEY after Cloning PDB
OPEN_NO_MASTER_KEY of AUTOLOGIN After cloning a PDB with TDE into a RAC database, we saw OPEN_NO_MASTER_KEY in the second instance of the new PDB. In… Read More »How to Resolve OPEN_NO_MASTER_KEY after Cloning PDB
How to Resolve ORA-32016: parameter "db_name" cannot be updated in SPFILE
ORA-32016 Tried to change DB_NAME in SPFILE when the instance is running, but it failed with ORA-32016. Let's see current value of DB_NAME. SQL> show… Read More »How to Resolve ORA-32016: parameter "db_name" cannot be updated in SPFILE