How to a recreate disk group used by CRS

I will go through detailed steps here on how to recreate a disk group used by CRS. Some things to bear in mind: – I created this cluster based on another existing cluster, so I just followed the same patterns…

Read More >

Exadata: How to manage OS dependencies when upgrading to 19c

Exadata 19c comes with Linux 7 and Exadata 12c and 18c come with Linux 6. There will then be an upgrade to Linux 7 when upgrading from 12c or 18c to Exadata 19c or above. In this specific case, you…

Read More >

How to create an Oracle Database Cloud service (OCI) using the command line

The Oracle Cloud Infrastructure, also known as the second generation cloud, offers an integrated command line utility called OCI Command Line Interface (CLI) which can be used to perform almost all the activities we can do using the web console….

Read More >

Troubleshooting an enterprise user security database login and sudden ORA-12154

I encountered a new problem last week while trying to log in into LDAP-enabled Oracle Database (Enterprise User Security). I entered my SQL*Plus credentials that usually work fine, but received an error ending with ORA-12154. $ sqlplus aprokopjevs@EBSPROD SQL*Plus: Release…

Read More >

How to run DBSAT against Oracle RDS database

The scope of this article is to show how to run DBSAT (Oracle Database Security Assessment Tool) against an Amazon RDS Oracle instance. This is based on a real-life execution. The DBSAT version used was 2.0.2 over an RDS database…

Read More >

How to run DBSAT on RAC Instances

The scope of this article is to provide a brief summary of how to run Oracle Database Security Assessment Tool (DBSAT) on Oracle Real Application Cluster using the parameters to exclude sections on the Reporter to avoid duplicated information into…

Read More >

How to fix the status of of the Oracle GI CRS after a failed upgrade

A couple of weeks ago I was working on a two-node Oracle Grid Infrastructure upgrade from 12.1 to 18.5. Everything was going great as both rootupgrade.sh scripts ran correctly, so the only thing pending to run was the gridSetup.sh -executeConfigTools …

Read More >

Running new Oracle DBSAT version 2.1.0 against Autonomous Database

Recently Oracle released the newest version of the “Database Security Assessment Tool” (DBSAT 2.1.0). This version is certified to run against Oracle Cloud DBCS (PaaS) and Autonomous Databases. Also, the Discoverer option can now find sensitive and personal data in…

Read More >

Save time with this quick OCI CLI installation

This is more of a personal reminder than anything else, but hopefully it helps save some time for others trying to install the OCI CLI on their local Linux machines. The idea is to have a very basic set of…

Read More >

How to accurately measure data guard lag events

If you work with Data Guard, the lag between the primary and standby database is an informative but difficult metric to measure. I’ve encountered some “solutions” that use the COMPLETION_TIME in (G)V$ARCHIVED_LOG for the standby destination as the time of…

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