When upgrading Oracle REST Data Services (ORDS) to version 23.1 or later, it completes with warnings as following WARNING: Procedure APEX_...

 File Name   sess_blocking_tree.sql Description   Displays Oracle databsae session blocking tree.   It support both single instance and RAC ...

 The demonstration is tested on following environment, Windows Domain controller: DC01.lab.dbaplus.ca - Windows 2022 Workstation 1: wkstn0...

 After applying patches on Oracle Database home with out-of-place patching. The listener cannot be started with error, TNS-01201: Listener c...

 This PowerShell script picks up server machines from given text file which includes all SQL server host names. In order to run the script s...

Beginning with 19.22 Jan2024 RU, the 19c database is certified on Oracle Linux 9.x and Red Hat Enterprise Linux (RHEL) 9.x. The minimum ker...

The SQL Developer shipped with OEM 13c (13.4.1.0.0 and later) includes Apache Log4j 1.x and 2.x, which is scanned out with following vulner...

NAME   CkSpaceBLOB.sql DESCRIPTION   Check the space usage of BLOB column which is stored as LOBSEGMENT type segment   USAGE       CkSapce...

Oracle database 12.2, 18c or 19c database alert log file reports ORA-00600: [qosdExpStatRead: expcnt mismatch]. The error message is somethi...

When creating Oracle 19c databases, got errors as following, comment on table AUDSYS.AUD$UNIFIED is * ERROR at lin...

This document is for upgrading JDK used by Enterprise Manager (EM) 13.5 in both OMS and Agent home on Linux, Solaris and Windows. 

Oracle Enterprise Manager (EM) 13.4/13.5 agent patch is released as one-off patch, Release Update, or bundle patches. These patches can be a...

This instruction applies to Oracle WebLogic Server (WLS) 12.2.1.x standalone (Lite, Slim, Generic), Oracle Fusion Middleware (FMW) 12.2.1.x...

Simple Oracle Document Access (SODA ) collections can be exported and imported using Oracle Data Pump Utilities starting with version 19.6. ...

When creating users during importing workspace in APEX, got ORA-02291 error like following ORA-02291: integrity constraint (APEX_200100. W...

When deciding to configure Oracle Enterprise Manager with custom or third-party SSL certificates,  you usually need to complete configurati...

The script creates a password complexity verification function, and enable the function with database profile. It also sets password policy ...

One of the reason why I prefer SQLcl to SQL*Plus is that SQLcl has built-in "apex" commands. APEX workspace and application can be...

 When starting database, get errors ORA-01565 ORA-17503 ORA-27300 ORA-27301 ORA-27302. For example, $ srvctl start database -db db01 PRCR-...

Oracle SQL Developer Command Line (SQLcl) is a free command-line interface for Oracle Database that combines the power of SQL*Plus and SQL D...

 A bash script is used to find out the final regular source file or directory of a multi-level symbolic on Linux and Unix (AIX, Solaris) pla...

When opening pluggable database (pdb) on one node of two-node 19c RAC, got following errors sys@rac01> alter pluggable database pdb1 ope...

This issue happens in Oracle database 12.2 or higher version, the example in this post happened in 19.13.

When installing Oracle Grid Infrastructure (GI) 12c or higher version (18c, 19c, 21c), multiple network interfaces (NIC) can be used as pri...

When you enable or configure moniter or managerment features on compute instance in Oracle Cloud Infrastructure (OCI), you have to enable th...

The issue happens on Oracle Linux / Red Hat Enterprise Linux 7/8 on which chronyd is adopted as the network time protocol daemon instead of ...

In Oracle Enterprise Manager 12c/13c deployment, normally the OMS is responsible for sending all metric alert notifications, but in cases wh...

The agent status shows "Agent Unreachable (Post Blackout)" in Oracle Enterprise Manager 13c console. On the agent home page, it sh...

RMAN jobs can successfully backup database to tape with NetBackup, but leave server processes (RMAN channels) and NetBackup nborautil proce...

 Minimal install is an important security for deploying Linux. It means only essential packages are installed. Therefore, GUI is usually not...

When installing Oracle 19c Grid Infrastructure (GI) or 19c Database (runInstaller), got following error, [INS-08101] Unexpected error while...

Oracle internal events can be set at both sesson level and system level as following,

You may have to find out the SQL statements which are using temporary tablespace when you get storage pressure for temporary tablespace.

When the command "griddSetup.sh -switchGridHome" is used to perform Oracle database 19c out of place (OOP) patching, it will promp...

EM 12c/13c create Agent Unreachable alerts as follows:  Host=host01.dbaplus.ca Target type=Agent Target name=host01.dbaplus.ca:3872 Cate...

When feeling tired to select the text before copying them, I decide to add a COPY button to every code example block in my blog. The button ...

 When I shared the source code in my blog before, I used to reference source code by highlighting the code lines with HTML tag. It was not a...

The listener is up and running. However, the lisener target shows as Down in the Oracle Enterprise Manager Cloud Control Console and the inc...

In Oracle Data Guard configuration, redo transport uses Oracle Net sessions to transport redo data. These redo transport sessions are authen...

Oracle database startup failed with ORA-00600 as following SQL> startup ORACLE instance started.

In RAC database, the Advanced Queue (AQ) message MSG_STATE (column of view AQ$<QUEUE_TABLE>) stays with value 'WAIT' and will ...

 As out-of-place patching can dramatically help minimize database downtime, especially when multiple databases run out of same home, it does...

The Lifecycle Status property of EM targets is often used to prioritize the notification of incident rule. For example, DBA will be paged wh...

 When agent is deployed to new host, or new targets is installed or created on existing hosts, Oracle Enterprise Manger (EM) Cloud Control c...

This script can be used to run datapatch against all currently running instances in parallel to apply sql patches after patches are applied ...

There are many ways to install PostgreSQL on Linux box. Here, I am going to use yum to install different version of PostgreSQL on Red Hat En...

Oracle database Jave stored procedure failed with "java.lang.OutOfMemoryError", the error stack looks like ORA-29532: Java call te...

When applying Oracle GI Release Update 19.11.0.0.210420 on AIX, command "roothas.sh -postpatch" failed with "Out of memory...

When using yum to maintain packages on hosts running Red Hat Enterprise Linux (RHEL), Oracle Linux (OL) or Fedora, you may have to configure...

 The PowerShell command prompt indicates that PowerShell is ready to run a command, PS C:\> It is determined by the built-in Prompt funct...

For some reason, Oracle desupported the placement of OCR and voting files directly on a shared file system from Grid Infrastructure 12.2 unt...

Windows Command Prompt console does not have built-in facility to log the console output to file. In order to implement logging function, Po...

 When EM discovers database targets, it generates default target name for the database in one of following formats,   db_unique_name.db_doma...

After Oracle database 19c home is applied Release Update 19.11.0.0.210420, the home cannot be de-installed anymore. The deinstall utility wi...

Updated on Thursday, Oct 21, 2021 with following , The error is also found with RU 19.13 (19.13.0.0.211019). I believe it is same thing wi...

In EM 13c console, access "Software Standardization Advisor" as following,  Targets -> Databases -> Administration -> Sof...

 When custom certificate is configured for OEM 13c, WebLogic Servers installed as part of Enterprise Manager Cloud control (Administration S...

"EM Jobs Service" target status is showing down in Enterprise Manager Cloud Control(EM) console even though all associated targets...

When deploying agent on OEM 12c/13c using 'Add Host Targets' wizard, the deployment fails with Remote Validations:  Shell Path valid...

When discovering or refreshing a WebLogic Domain or Fusion Middleware Farm in Enterprise Manager (EM) 13.4 Cloud Control, the Node Manager t...