How Oracle Rename Database
It depends on what name you want to change in the database. Usually, database name can be DB_NAME, DB_UNIQUE_NAME or both in Oracle. We have… Read More »How Oracle Rename Database
Administration
How to Install USER_LOCK Package
USER_LOCK USER_LOCK is not a default package of SYS, you need to install it before using it. SQL> conn / as sysdba Connected. SQL> @?/rdbms/admin/userlock.sql… Read More »How to Install USER_LOCK Package
How to Resolve ORA-01507: database not mounted
ORA-01507 ORA-01507 means that the command you want to execute cannot be done at NOMOUNT state, you should mount the database from NOMOUNT for further… Read More »How to Resolve ORA-01507: database not mounted
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 Subprograms All Available List
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 Subprograms All Available List
How to DBMS_SCHEDULER.STOP_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 DBMS_SCHEDULER.STOP_JOB
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
Data Dictionary View Sets Comparison
DBA_, ALL_ and USER_ Views You may think all dictionary views have their corresponding ones in different sets or scopes. For example, I'd like to… Read More »Data Dictionary View Sets Comparison
How to Resolve DIA-48448: This command does not support multiple ADR homes
DIA-48448 Tried to purge trace files in ADRCI, but it failed with DIA-48448 adrci> purge -age 10080 DIA-48448: This command does not support multiple ADR… Read More »How to Resolve DIA-48448: This command does not support multiple ADR homes