Author: Suresh Karthikeyan

Change Port Number in Common Object Service (COS) Naming Service for Reports Server Discovery

Recently I received a request to change the port number used by an Oracle reports naming server. I looked into MOS and found no direct notes to address this change. Here are the details: Our Environment: Oracle Weblogic Application running…

Read More >

AutoUpgrade: Plug Noarchive Non-CDB Database as Upgraded PDB

The Database AutoUpgrade utility has been slowly developing its capability to cover all possibilities of database upgrades. Recently I’ve tested an upgrade of a database running in NOARCHIVELOG mode using this utility. I added more complications with this testing phase;…

Read More >

Recreate Redo / Standby Logs in a DG Broker Environment

While increasing the redo log file size for my production environment, I came across a requirement I’d like to share with you. The process should be quite straightforward as we can add / drop redo log files online. However, since…

Read More >

How to Clear RMAN Channel Configuration

I’m glad to get back to blog writing and, after a bit of a break, I’m starting with a brief post. We DBAs have probably come across the RMAN (Recovery Manager) utility many times in our lives. We are also…

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 >

Oracle Database: script to purge aud$ table using dbms_audit_mgmt package

With an increase in requirements on database security, database auditing is part of most production databases nowadays. The growth on Oracle database audit table”‘aud$” always add spice on a DBA’s life. Since this table growth directly impacts the database performance, this…

Read More >

Oracle Database: Query to List All Statistics Tables

If you were a big fan of manual database upgrade steps, perhaps you would have come across this step many times in your life while reading MOS notes, upgrade guides, etc. Upgrade Statistics Tables Created by the DBMS_STATS Package If you…

Read More >

Should AUD$ Table Exist on System Tablespace During DB Upgrade?

I see this following message on all My Oracle Support notes, which talks about database Oracle manual upgrade steps. 4.16 Verify the existence of the AUD$ tables Ensure that if the aud$ table exists that it is in the SYS…

Read More >

Purge statspack snaps of source db on test db having different DBID?

As most DBAs are aware, the clean deletion of the old statspack snaps is very difficult up to rdbms version 9i. Thanks to the statspack.purge procedure introduced by oracle from 10gR1 version, now it’s possible to purge un-referenced data too….

Read More >

How to recover a subset of an Oracle database

Today’s blog post will discuss how to recover a subset of an Oracle database. Many of you would have come across different recovery scenarios, but I’ll be talking about a very different one that happened to me. The following are…

Read More >
Page 1 of 212