AEM Blue

BLOG

Changing Oracle Database Passwords with No Downtime

Some customers want to change all passwords every 60 days, which is a more secure security practice yet is a burden to the administrative staff needing to work off hours due to the system impact.

How to Resolve “Audit Tablespace Full” on a Pluggable Database

Most Database Administrators are used to the occasional crisis—it comes with the job. The level of stress involved can vary greatly depending on the frequency of the issue, how well you remember the fix, and/or how quickly can you find a resolution using a Google search. Hopefully, this wasn’t too hard to find on Google.

6 Steps to Ease Your Silent Upgrade of OEM to 13.4

Oracle Enterprise Manager (OEM) is a vital tool for any Oracle DBA to properly manage and monitor the operational environment. OEM helps identify issues and measure database performance in an accessible format providing an enterprise-wide view of their databases with the ability to zoom in for detailed information, as needed.

Like any piece of software, it is important to keep OEM up to date through patches and version releases. In this blog post, we will tackle one of the more challenging scenarios when it comes to upgrading OEM – Upgrading from 13.2 to 13.4 using the silent upgrade option.

A Practice Scenario for Tuning SQL Statements

Tuning SQL statements and databases can be intimidating to Database Developers and DBAs alike. If you take too long, say something is “good enough,” or declare that something cannot be fixed, it may hurt your reputation or even have you looking for a new employer! But if done well, the benefits of resolving a performance issue range from helping your coworker to improving the lives of the operational community.