Vinicius | Vinicius DBA

CRS-42216: No interfaces are configured on the local node for interface definition ethN

Hi everyone, Hope you’re doing good! I was working for a client where they were upgrading their Servers from RHEL 7 to RHEL 8. As part of this project, DB Servers are part of upgrade. On this client, they use a naming convention for network…

Vinicius, 5 months ago 0 8 min read

Administration, Database

Effective Management of $ORACLE_HOME/.patch_storage: Cleanup and Archive Strategies

Hi all, Hope you’re doing good! I had a call with one of our clients, long story short, they would like to cleanup some space under $ORACLE_HOME/.patch_storage directory. There are a lot of options to accomplish this. I will talk a little bit here about…

Vinicius, 5 months ago 0 17 min read

Administration, Database

Automating Bulk Data Loads into Oracle Database with Shell Script and SQL*Loader

Hey everyone, Hope you’re doing good! Recently, a client approached me with an urgent issue: they needed to load 456 files into an Oracle Database table to resolve an integration problem. These files were compressed in ZIP format and contained data in fixed-position records with…

Vinicius, 5 months ago 0 8 min read

Administration, Database

How to Calculate Database Uptime Querying the Oracle Enterprise Manager Views

Hi everyone, Hope you’re doing good! Ensuring high availability of your Oracle databases is crucial for maintaining optimal performance and meeting Service Level Agreements (SLAs). Oracle Enterprise Manager (OEM) provides a comprehensive way for monitoring and managing database uptime. With that said, I received a…

Vinicius, 5 months ago 0 4 min read

Administration, Database

Why is the INSERT Statement Slow? Understanding ‘db file sequential read’ Waits

Some weeks ago, a client called complaining about a slowness during its load in a table. The scenario it was pretty simple: They are loading the table using the INSERT statement for each agency (agency_id), with thousands of records for each agency. They complained that…

Vinicius, 5 months ago 0 9 min read

Administration, Database

How to Efficiently Export a Large List of Tables with DataPump

Hi everyone, hope you’re doing good! I’m a member of a WhatsApp Group in Brazil for DBAs (not only Oracle), and one of the members asked about how to export a large list of tables with DataPump. This question may sound a little bit basic,…

Vinicius, 6 months ago 0 3 min read

Enterprise Manager

Ansible Playbook to Show the Current RU for OEM Agents

Hi everyone, Hope you’re doing good! In my last blog post I explained how to update Oracle Enterprise Manager and its OEM Agents from RU 13.5.0.16 to RU 13.5.0.20. You can check it here: How to Update Oracle Enterprise Manager from RU 13.5.0.16 to RU…

Vinicius, 8 months ago 0 6 min read

Enterprise Manager

How to Update Oracle Enterprise Manager from RU 13.5.0.16 to RU 13.5.0.20

Hi everyone, Hope you’re doing good. A client contacted us asking to update their Oracle Enterprise Manager and its agents from 13.5.0.16 to latest Release Update available. First of all, we need to understand from which note we can find the latest OEM RU available….

Vinicius, 8 months ago 4 14 min read

Author: Vinicius

CRS-42216: No interfaces are configured on the local node for interface definition ethN

Effective Management of $ORACLE_HOME/.patch_storage: Cleanup and Archive Strategies

Automating Bulk Data Loads into Oracle Database with Shell Script and SQL*Loader

How to Calculate Database Uptime Querying the Oracle Enterprise Manager Views

Why is the INSERT Statement Slow? Understanding ‘db file sequential read’ Waits

How to Efficiently Export a Large List of Tables with DataPump

Ansible Playbook to Show the Current RU for OEM Agents

How to Update Oracle Enterprise Manager from RU 13.5.0.16 to RU 13.5.0.20

About

Blog recognized by:

Disclaimer

Find

Archive

Blogroll Internacional

Blogroll Nacional

Links

Visitors