Tag: Oracle

Oracle Scheduler Job is Not Running as Expected After Bouncing Databases

dev database

One of our clients had issues with their scheduler jobs in DEV and PROD databases and all scheduler jobs stopped running after July 31st, 2021. Both databases were 19c and patched with July 2021 19.12 RU and the parameter job_queue_processes…

Read More >

RAC – Clusterware Intermittently Fails to Start

laptop red post it

While working on a new Grid Infrastructure installation on Red Hat V8.4, we had some issues testing a new cluster: The clusterware failed to come back up after a node reboot… but sometimes it worked. We had the latest 19c…

Read More >

EBS: Access the PDF Outputs After the Migration to AWS

migrate wooden blocks

During the Oracle E-Business Suite migrations from on-premise to AWS Cloud (similar to any cloning exercise), you may need to preserve access to concurrent request log and output files, especially the reports. Usually, it’s an easy task that involves tricks…

Read More >

Adding DML Parallelization to Oracle Jobs

code on screen laptop

When investigating why an Oracle job is taking a long time to execute, normally the DBA will identify the DML instructions or select queries running longer and different approaches might be used to improve the performance, e.g., create new indexes,…

Read More >

Restoring a Dropped Oracle PDB Without a CDB Backup

Background I ran into a situation where we needed to restore just one dropped (and recreated) pluggable database (PDB) in an Oracle 19c Container Database (CDB), but we did not have any backups for CDB$ROOT, PDB$SEED, etc. Our only backup…

Read More >

DataOps – Liquibase to Manage Changes in Snowflake

What is this about? Well, as the title implies, I will show how to set up Liquibase to manage changes in Snowflake as part of a DataOps practice. Why? Because I am going deep-dive into DataOps around Snowflake and I’ve…

Read More >

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

qOverview 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 >
Page 3 of 16912345...10...Last Page »