Author: Matheus Boesing

19c Auto-Indexing: ORA-65532: Cannot Alter or Drop Automatically Created Indexes

Hello! I recently noticed that: What if I’m not happy with the Oracle algorithm and I want to drop and auto-index on 19c? It should be easy, I initially thought. For example, something like “drop index XXXX;” right? Wrong. However,…

Read More >

AWS RDS: 5 Must-Know Actions for Oracle DBAs

Managing Oracle on AWS has some twists. Here are five daily DBA activities that have changed on AWS: Kill Sessions: begin rdsadmin.rdsadmin_util.kill( sid => &sid, serial => &serial, method => ‘IMMEDIATE’); end; /   Flush shared_pool or buffer_cache: exec rdsadmin.rdsadmin_util.flush_shared_pool;…

Read More >

Datapatch Failing on ORA-65108 (PDB$SEED): Applying Datapatch Manually

In a new 12c environment (which actually includes 18c and 19c, as per the 12c family), the datapatch failed on the following: ORA-00704: bootstrap process failure ORA-00604: error occurred at recursive SQL level 1 ORA-65108: invalid use of a cursor…

Read More >

Extracting DML Stats/Workload With GoldenGate

After setting up GoldenGate in your environment, you might ask yourself: How much work is being done by my GGate environment? Here’s another consideration: You just want to set up a dummy extraction so you can measure it before starting…

Read More >

IPv6 Formatting for JDBC and SQLPlus

Does IPv6 formatting for JDBC and SQLPlus seem new to you well, it’s been available since 11gR2. You’re familiar with IPv6, right? If not, click here. Basically, the only thing you need to do is enclose the IPv6 address in…

Read More >

Trace on Standby: Tracing MRP Process

Sounds simple, right? And it really is, although it might not seem obvious. Recently, I ran into an issue when trying to start a trace in a standby. The idea was to start a trace in MRP to monitor performance….

Read More >

CRS-10051: CVU found following errors with Clusterware setup

I recently found this interesting message error in a CRS alert log from a client environment: 2019-08-26 16:33:53.277 [SRVM(9624)]CRS-10051: CVU found following errors with Clusterware setup : PRCW-1015 : Wallet pythiandb does not exist. CLSW-9: The cluster wallet to be…

Read More >

How to Read Oracle Traces from SQL*Plus

Let’s say you need to read trace files from Amazon Relational Database Service (RDS). How do you do it? Here is an example of how to list and read those files using rdsadmin: SQL> select * from dba_directories; OWNER DIRECTORY_NAME…

Read More >

How to Quickly Ignore ORA Error on Agent Layer

I had a very specific situation where I wanted to ignore an error from a specific agent. It turns out that it is easier and quicker to ignore a specific error using an OEM Metric. How? By using an agent parameter….

Read More >

Automatic Graceful Shutdown and Consistent Startup Method for Oracle DB on Linux

Having questions about automatic startup and shutdown is quite common when dealing with new environments or configurations. There is more than one way to implement this depending on the environment configuration, licensing and version. So, here is a summary: 1….

Read More >
Page 1 of 3123