Administration

Removing Oracle Application Express (APEX) on 19c database fails

Oracle APEX Release 21.1.0 was released on May 12, 2021. My 19c Oracle Database came with Oracle Application Express Release 18.1. I had a requirement to install the latest version of Apex on our 19c Oracle Database. Oracle recommends to containerize Apex installs within a PDB for...

SQLs slow in 19c

Issue We patched our Oracle databases to 19.9 and this issue started. Some of our SQLs were slow and started taking longer to execute. We did not see this issue in an earlier release of 19c. Here is a pattern...

Steps to remove OEM Agent

Recently I migrated all targets (Cluster, Databases, Instances, ASM, etc) and their jobs to a 13c OEM system. I had to clean up the targets from 12c OMS and remove the OEM agent. Here are the steps to properly delete/remove a monitored host and its targets from...

How to rename a PDB in 19c

Let's look at how to rename a PDB in 19c. The steps are the same as 12c. Per Oracle note referenced below, you must have the ALTER DATABASE privilege, either granted commonly or granted locally in the PDB. You must also have the RESTRICTED SESSION privilege, either...

How to change the ethernet switch password on Exadata

Let's look at how to log in and change the ethernet switch (adm) password on an Exadata system. During the installation of the system, the admin user is created. You must have got the admin user credentials when the Exadata was handed off.

Install Oracle GoldenGate Plug-in on Oracle Enterprise Manager Cloud Control 13c

In this post, we will install and deploy Oracle GoldenGate Plug-in 13.4.1.0 on Oracle Enterprise Manager Cloud Control 13c Release 4. I have an Active-Active OMS 13c setup that is load-balanced via SLB. While the plug-in install is an online operation, the plug-in...

Fixed – EXPDP – OS/ Wallet Authentication does not work, prompts for password

I recently encountered a strange issue on a newly created multitenant database on 19.6 version. Our EXPDP job uses wallet to authenticate to the pluggable database. SQLPLUS could successfully connect/ authenticate to the database using credentials stored in the wallet. But, authentication failed for EXPDP using the...

How to Install VNC on Exadata Linux servers

Oracle Exadata servers do not come with VNC server installed. Let's look at how to install VNC on Exadata Linux servers. In this post, I will list the steps needed to get VNC working on Oracle Enterprise Linux 7 (OEL 7). There are many posts you can...

Latest posts

Removing Oracle Application Express (APEX) on 19c database fails

Oracle APEX Release 21.1.0 was released on May 12, 2021. My 19c Oracle Database came with Oracle...
- Advertisement -

SQLs slow in 19c

Issue We patched our Oracle databases to 19.9 and this issue started. Some of...

Steps to remove OEM Agent

Recently I migrated all targets (Cluster, Databases, Instances, ASM, etc) and their jobs to a 13c OEM...

Must read

- Advertisement -

You might also likeRELATED
Recommended to you

Removing Oracle Application Express (APEX) on 19c database fails

Oracle APEX Release 21.1.0 was released on...