Unusual Use of the RMAN uncatalog Command

rman uncatalog command

A fresh year is the perfect time to learn something new. Recently, I have come across warning messages in the RMAN level 0 backup log file and this post describes how I dealt with them.       The file…

Read More >

Migrate RDB to Cloud SQL Using Google’s Dataflow

rdbms data transfer

Most corporations have huge amounts of data in RDBMS (relational database management system). When considering a RDBMS data transfer and you only need a subset of data to migrate to the cloud, follow this very efficient and easy data ingestion…

Read More >

OS Migration on Cloud

Oracle EBS 12.1

Recently a client asked to upgrade their Oracle EBS 12.1 running on RHEL6 to RHEL7 hosted on Amazon Cloud. On the surface, it didn’t look like a job for an Application DBA, but rather, for a SysAdmin or CloudOps team….

Read More >

Licensing Oracle Enterprise Manager

oracle enterprise manager

What are the licensing considerations for deploying Oracle Enterprise Manager and using OEM for monitoring database servers? Read on to find out.     Oracle documentation states that base installation of Enterprise Manager Cloud Control 13c is free when used…

Read More >

Practical Tips For Moving Indexes Between Tablespaces

tablespaces

From time to time, a simple request to reorganize space in a tablespace leads to a more complex solution. Here’s how we moved  indexes between tablespaces.       A client requested we reduce the size of an Automatic Storage…

Read More >

Part Six: Deploying High Availability Applications in Oracle Cloud Infrastructure—Oracle Management Servers

management servers

This is the sixth in a series of blog posts, that covers the details to deploy the Oracle Management Servers for a high available set up of Oracle Enterprise Manager 13.5 using Oracle Cloud Infrastructure’s resources.   Recap This is…

Read More >

ORA-19665: Size in File Header Does Not Match Actual File Size of String

ORA19665

I received the above message related to an ORA-7445 on my 11.2.0.4 database: ORA-07445: exception encountered: core dump [kcflfi()+1016] [SIGFPE] [Integer divide by zero] [0x10053AD10] [] []     After some checks, I noticed the following: SQL> select file_name, bytes…

Read More >

CVE-2021-44228 and Your Oracle E-Business Suite/Fusion Middleware Systems

CVE-2021-44228

For many of us, the recent log4j vulnerability (CVE-2021-44228) became a severe headache this past weekend. I thought we’d publish a summary of some of our findings gathered so far. We’ll  keep it updated with news and details published by…

Read More >

ExaCC vs. ExaCS – Which One is Right for You?

ExaCC vs. ExaCS

Exadata has been Oracle’s gold standard platform for running mission-critical Oracle databases for over a decade. Oracle is extending the availability of Exadata onto the cloud by offering it in two flavors: Exadata Cloud @ Customer (ExaCC) and Exadata Cloud…

Read More >

Exadata Health Check: My Top 5 Tools and Features

exadata health check

From ORAchk/EXAchk/ODAchk, Database Security Assessment Tool (DBSAT) and Hang Manager, to Cluster Health Advisor (CHA), Cluster Verification Utility (CVU), Memory Guard and Tracefile Analyzer (TFA), Oracle DBAs have an abundance of great tools at their fingertips. Another plus is there’s…

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