Tag: Oracle

Using El Carro Operator on AWS

Introduction Google recently released a Kubernetes operator for Oracle, El Carro. The project includes good examples of how it works on GCP and on your local computer (using minikube). Given it is a portable implementation, we wanted to give it…

Read More >

Part One: Deploying High Available Applications in Oracle Cloud Infrastructure: Preparing Your Environment

This is Part One in a five-part series that covers the details around deploying a high available setup of Oracle Enterprise Manager 13.5 using Oracle Cloud Infrastructure resources exclusively.   Overview This series will show how you can use Oracle…

Read More >

Understanding the Implications of Creating a New PDB Using CREATE_FILE_DEST

Overview When creating a new pluggable database, or PDB, you can optionally include the CREATE_FILE_DEST clause. Here’s an example: create pluggable database PDB1 admin user admin identified by “************” create_file_dest = ‘+DATA_DG’;   The value provided can be an ASM…

Read More >

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: [[email protected] ~]$ crsctl query crs releaseversion Oracle High Availability Services release version on the local node is [12.1.0.2.0] [[email protected] ~]$ 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 >
Page 1 of 16612345...10...Last Page »