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 ...

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 ...

TNS-12564 Errors and the Importance of LOCAL_LISTENER During a Data Guard Switchover

A couple of weeks ago a client of mine had a situation where a Data Guard (DG) ...

A couple of weeks ago a client of mine had a situation where a Data Guard (DG) switchover that should have taken five ...

How I Finished a Recovery From an Active Duplicate After Facing Errors ORA-19909 and ORA-01110

The other day I was doing a database cloning in 11.2.0.4 from an active duplicate, ...

The other day I was doing a database cloning in 11.2.0.4 from an active duplicate, and got the following error: ...

Configuring MySQL in a Docker Container

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

Ansible Inventory Automation Using Consul and Orchestrator

Here at Pythian we get a lot of exposure to new technologies and implementation strategies via the work we do ...

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 ...

Issues With Database Service Names Starting With Pluggable Database (PDB) Name

In this post I'll describe a problem which occurs when creating and using a database service name which starts with the ...

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 ...

Heart Disease Prediction Using Keras Deep Learning

Heart disease covers a range of different conditions that could affect your heart. It is one of the most complex ...

Converting Oracle Enterprise Manager Management Service (OMS) Repository from Legacy Non-CDB to CDB Architecture

The other day I was given the task of converting a single instance Oracle ...

The other day I was given the task of converting a single instance Oracle Enterprise Manager Management Service (OMS) ...

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, ...

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 ...

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 ...

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) ...

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 ...