Oracle and Amazon Simple Email Service

Sending email from Oracle with utl_smtp via Amazon Simple Email Service (SES) Sometimes I want to send email from my own databases for testing purposes. Lacking a mail server, I opted to use Amazon’s Simple Email Service (SES).  SES is a…

Read More >

How to fix an AWR Warehouse after credentials change

We had an AWR Warehouse (AWRW) installation (OEM 12.1.0.5 on Linux) collecting data from +50 databases for a few months. A few days ago we tried to connect and found it was not working, with the AWRW console showing an…

Read More >

Oracle OpenWorld 2017 Bloggers Meetup

DON’T PANIC. Yes, we are doing the OOW Bloggers Meetup this year. Yes, it’s the same time. Yes, it’s the same location. Yes, it’s more fun every year. What: Oracle Bloggers Meetup 2017. When: Wed, 04-Oct-2017, 5:30pm. Where: Main Dining…

Read More >

Chart Your Course With sar

The sar (system activity reporter) is a Linux utility that actually started life long ago in System V Unix. In spite of its ancient origins, sar is still quite useful, and has even been enhanced in recent versions of Linux….

Read More >

What You Should Know About Docker Containers for Oracle Data Integrator

Not long ago, Oracle adopted the Docker engine as one of the accepted platforms for its products and published a set of scripts and examples in the Oracle GitHub repository. This includes sets for rapid deployment of Oracle databases, Weblogic…

Read More >

Automating Oracle RMAN backup configuration on Linux with Ansible

Having valid backup of the databases is one of the most important tasks for every DBAs. Having proper RMAN backup scripts on place and covering all aspects to protect your databases can be lifesaving in the event that a crisis hits. However, when you’re…

Read More >

Oracle Scheduler Fail To Send Email Notifications

In this blog post I would like to share an interesting issue we encountered couple of months ago related to scheduler job email notifications. As some of you may know, starting with Oracle 11.2 you can subscribe to receive notification…

Read More >

EM13cR2 Installation Failing on BI Publisher Configuration

This is going to be a short post as there wasn’t much information on this type of failure when searching for it. Also, the IP’s are changed due to security reasons I was working on an Oracle EM13cR2 installation and…

Read More >

Upgrade Existing TDE to Use New Unified Key Management in 12c Upgraded Database (non-cdb)

I’m really excited to be writing this post and I’m hoping it serves as helpful content. When reviewing the new unified key management in RDMS 12c, I came across old commands like ‘ALTER SYSTEM’ to manage the TDE keys that are…

Read More >

Automating Password Rotation for Oracle Databases

Password rotation is not the most exciting task in the world, and that’s exactly why it’s a perfect candidate for automation. Automating routine tasks like this are good for everyone – DBAs can work on something that’s more exciting, companies…

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