Oracle E-Business Suite Database Upgrade to 19c

Oracle E-Business Suite has been certified with Oracle Database 19c for over a year now. We've been seeing an uptick in ...

Top 10 New Features of SQL Server 2019

Editor’s Note: Because our bloggers have lots of useful tips, every now and then we bring forward a popular post from ...

Scaling ProxySQL Rapidly in Kubernetes

Editor’s Note: Because our bloggers have lots of useful tips, every now and then we update and bring forward a popular ...

Oracle Database and 2FA Using Cisco Duo

Background Oracle Database connectivity using multi-factor (MFA) or two-factor (2FA) authentication is rather simple to ...

Testing the 19c Grid Infrastructure by Performing a Dry-Run Upgrade

Testing oracle grid infrastructure upgrades Editor’s Note: Because our bloggers have lots of useful tips, every now and ...

Save Time With This Quick OCI CLI Installation

Editor’s Note: Because our bloggers have lots of useful tips, every now and then we update and bring forward a popular ...

Migrating Oracle Workloads to Google Cloud - PostgreSQL on Cloud SQL or GCE

When working with clients on database migration, there are a range of options we help them assess and evaluate. These ...

Create 19c Database in Archive Mode Using DBCA Silent

I wanted to export 11.2 database schema and import it into a 19c database; creating the database in archive mode to ...

How I Finished a GI OOP Patching From 19.6 to 19.8 After Facing cluutil: No Such File or Directory and clsrsc-740 Errors

This past weekend I was doing a production grid infrastructure (GI) out-of-place ...

This past weekend I was doing a production grid infrastructure (GI) out-of-place patching (OOP) from 19.6 to 19.8 for a ...

Migrating Oracle Workloads to Google Cloud - BMS

In these challenging and ever-changing times, most organizations would welcome the opportunity to reduce overhead, ...

Five Best Practices for Setting Dispatchers on Shared Connections

In this post I’d like to present five best practices/tips for setting dispatchers for database shared connections: 1. ...

How to Secure Your Elastic Stack (Plus Kibana, Logstash and Beats)

Editor’s Note: Because our bloggers have lots of useful tips, every now and then we bring forward a popular post from ...

Recreate Redo / Standby Logs in a DG Broker Environment

While increasing the redo log file size for my production environment, I came across a requirement I’d like to share ...

Select vs Assign – How To Assign PL/SQL Variables

Select vs Assign It isn’t unusual to see PL/SQL that contains select columns into variables from some_table This is ...

Watch Out When Running Out of Disk Space With InnoDB Group Replication Cluster

Oracle MySQL Community Edition comes with a native, virtually synchronous, clustering solution called InnoDB Cluster. ...

How to Make Oracle Use the Correct Index

Introduction When the “wrong” index is used for a SQL query, it’s sometimes a struggle to coerce Oracle to use the ...

Automating Oracle Patching With an Ansible Module

Editor’s Note: Because our bloggers have lots of useful tips, every now and then we bring forward a popular post from ...

Using ADRCI to Review Recurrent Issues

Managing diagnostic data across multiple systems with ADRCI Reviewing recurrent issues for database systems is ...

Graph Algorithms and Inference

Context If you’ve used Google Maps for directions or “friended” someone on Facebook, you’ve experienced graph theory. ...

AutoUpgrade: Plug Noarchive Non-CDB Database as Upgraded PDB

The Database AutoUpgrade utility has been slowly developing its capability to cover all possibilities of database ...

Installing Elasticsearch Using Ansible – the Quick Way!

Editor’s Note: Because our bloggers have lots of useful tips, every now and then we bring forward a popular post from ...

How To Easily Purge Logs for GI and DB

Simplifying log management with purgeLogs With a total of 33 directories for GI (Grid Infrastructure) and DB (database) ...

Detect and Notify Linux Server Restart

When Oracle support performs maintenance for Exadata Cloud, communication can sometimes be a bit sparse. Typically, ...

How to Execute 19c runcluvfy.sh With Root and Sudo Method

Editor’s Note: Because our bloggers have lots of useful tips, every now and then we bring forward a popular post from ...

User “guest” does not have permission to run DBCC CHECKIDENT for object

DBCC CHECKIDENT example DBCC CHECKIDENT is used to check or change the value of an identity column in the specified ...

Oracle Service Bus (OSB) 12c LDAP Authorization – HTTP 401 (Unauthorized)

Context Oracle Service Bus 12.2 and onwards is available to download on Oracle Support. As you might expect, the new ...

How to Clear RMAN Channel Configuration

I’m glad to get back to blog writing and, after a bit of a break, I’m starting with a brief post. We DBAs have probably ...