AEM Blue

Most Database Administrators are used to the occasional crisis—it comes with the job. Follow these six steps to resolve your “Audit Tablespace Full” issue 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.

Below, I provide steps to follow for fixing when the audit tablespace is completely full, designed to lower your stress and save the day!

The environment involved in this scenario is a more complicated configuration as it includes Oracle Real Application Clusters (RAC), a container with multiple pluggable databases, and unified auditing. If you can resolve the audit tablespace being 100% full given a more complex environment, you should have no problem with simpler configurations.

One of the first questions which may come to mind is—how do you know if your audit tablespace is 100% full? Hopefully, you have Oracle Enterprise Manager setup with email notifications set for appropriate warning and critical settings. This will give you a fighting chance to fix the issue before it’s too late. Of course, space issues never seem to happen at a great time, receiving an alert in middle of the night is typical.

If you don’t have OEM or some other equivalent tool or script setup to provide alert notifications, your first sign may be users complaining about system access or the application not responding. One of the first places to check for all potential database issues is the alert.log. If you have audit space issues, you will see something like the below…

ORA-1688: unable to extend table AUDSYS.AUD$UNIFIED partition SYS_P12345 by 128 in tablespace AUDIT_DATA

If that’s the case, just follow the steps provided below…

1. Connect into sqlplus as sysdba for the container database

image 1-2

2. Shut down the pluggable database containing the full audit tablespace

Image 2-1

3. Connect to the pluggable database

Image 3

4. Startup the pluggable database

Image 4

5. If the tablespace is set to smallfile (32 Gb datafile size limit), add a datafile. For a bigfile tablespace, run a query below to find the file name and then resize to a larger file size (200 Gb in this example)

Image 5

6. If you previously created a service such as Transparent Application Failover (TAF), please be sure to start this to avoid connection issues

Image 6

After six simple steps or so, you have restored peace and order back into your production environment. Be sure to save these steps somewhere because you will likely need them at some point again in your career… speaking from experience…

AEM can help your organization implement technologies such as Unified Auditing, Container/Pluggable Databases, and Oracle RAC. Please reach out to learn more about our service offerings.


5 Lessons for Finding the Right Test Automation Software

This is the second blog post in a two-part series examining test automation software. This blog post focuses on lessons learned for finding the right software product for your organization. We recommend you also read our first post, which is dedicated to understanding the process for moving from manual to automated testing.

5 Keys to Successful Test Automation

This blog post is the first in a two-part series on website testing automation that can help your organization better understand how to maximize the effectiveness of your tests and find the right tools to meet your needs. Below we offer insights that can help your organization improve its testing automation process. Our follow-on blog post will help your organization understand the different software tools available to begin automating your tests.

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.