Tag: Oracle

Data Guard Broker—ORA-16714: The Value of Property LogFileNameConvert Is Inconsistent with the Database Setting

This seems like a simple message to fix, right? The parameter is different between the broker configuration and the database parameters—it was most likely changed directly on the database after the DG (Data Guard) broker configuration was created or the…

Read More >

Automating APEX Applications Backup

In a previous post, I discussed that the APEXExport tool may be the best one to use when exporting APEX applications. You may also have experience using this tool. Today, I’d like to present some alternatives to the APEXExport tool….

Read More >

“The Cluster Upgrade State is [ROLLING PATCH]” with Correct Patch Level in all Nodes

I was performing a spot health check in a client environment, when I encountered this: [oracle@dbserver1 ~]$ crsctl query crs releaseversion Oracle High Availability Services release version on the local node is [12.1.0.2.0] [oracle@dbserver1 ~]$ crsctl query crs activeversion -f Oracle…

Read More >

Moving APEX Applications Repository with APEXExport

Most likely you’ve landed here because you need to migrate APEX applications/workspaces from one database to another. If so, you’re in the right place! We’ll use APEXExport to accomplish this. I’m providing a quick summary of the steps for using…

Read More >

Creating a Read-Only Account on Database with VPD or Label Security

I have an interesting case to share in this post. The story started when a client asked for a read-only account (let’s call it RO_USER) with access to objects under another schema (let’s call it SCHEMA_OWNER). Easy going, right? Create…

Read More >

Connect to Vagrant Virtual Machine over Wi-Fi Network

I recently had the need to quickly set up an Oracle 19c database lab environment on Linux to run some tests. My laptop was already running a VirtualBox VM with Oracle 12.2 release and I wanted to have a different…

Read More >

Relying on Guaranteed Restore Points? Be careful!

Are you relying on guaranteed restore points (GRP) as a fallback plan for your migration or upgrade strategy? If you’re using RAC, especially before 12.2, be careful! When performing a non-prod upgrade with the AutoUpgrade tool, after completing the upgrade,…

Read More >

Opatchauto Failing On “CheckActiveFilesAndExecutables” during Prerequisite Check

Very recently, when applying the 2021 January CPU in a client environment, the following happened: [root@dbserver01 32226239]# $ORACLE_HOME/OPatch/opatchauto apply OPatchauto session is initiated at Sun Mar 14 03:00:06 2021 System initialization log file is /u01/app/oracle/product/19c/grid/cfgtoollogs/opatchautodb/systemconfig2021-03-14_03-00-08AM.log. Session log file is /u01/app/oracle/product/19c/grid/cfgtoollogs/opatchauto/opatchauto2021-03-14_03-00-13AM.log…

Read More >

Clear Exadata Component Messages after Maintenance

What can you do if you’ve completed maintenance in a component (a memory component, as per the example below) but keep receiving failure messages? First, try clearing all the error messages after completing the maintenance. Now, check if the threshold…

Read More >

AWS RDS: Read Oracle Traces from SQL*Plus

Today’s post is another dealing with AWS services. Let’s say you need to read trace files from RDS — how would you do it? Here’s an example of how to list and read those files based on the directories from…

Read More >
Page 1 of 16612345...10...Last Page »