Tag: Oracle

How To Easily Purge Logs for GI and DB

With a total of 33 directories for GI (Grid Infrastructure) and DB (database) homes, what’s the easiest method to remove files older than 90 days for all directories? Luckily, Oracle Support does offer purgeLogs; a one-button automation script, which can…

Read More >

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 the past. We originally published today’s post on September 9, 2019. One method to prepare for a Grid Infrastructure…

Read More >

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 the past. We originally published today’s post on February 13, 2019. This blog post has been on my To…

Read More >

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

Editor’s Note: Because our bloggers have lots of useful tips, every now and then we update and bring forward a popular post from the past. We originally published today’s post on August 14, 2019. In reviewing the Grid Infrastructure Installation…

Read More >

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 post from the past. We originally published today’s post on April 15, 2019. This is more of a personal…

Read More >

Weighing the Pros and Cons of Oracle Autonomous Database

Editor’s Note: Because our bloggers have lots of useful tips, every now and then we update and bring forward a popular post from the past. Today’s post was originally published on August 20, 2019. The next generation of managed database…

Read More >

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 pluggable database’s (PDB) name, and has a dot (“.”) after it: “<pdb_name>.<optional_suffix>.” I noticed this issue when I was…

Read More >

Reducing Contention on Hot Cursor Objects (Cursor: Pin S)

First, let me offer a little explanation about the wait event “cursor: pin S.” Oracle states: “A session waits on this event when it wants to update a shared mutex pin and another session is currently in the process of…

Read More >

OPatchAuto Bug on 19.3 GI/RDBMS When Patching to 19.6

The other day I was doing a fresh install of Oracle 19.3. I was using the binaries from edelivery, doing some testing in that version, then patching to 19.6. The installation and the tests went fine. Next, I proceeded to... Read More >

How to Enable RAM Cache in Oracle Exadata

A brief background on RAM cache or in-memory OLTP acceleration In this post I will present a feature — to simplify let’s call it RAM cache — introduced in Oracle Exadata Storage Server image 18.1. You’ve probably heard a lot…

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