Author: Matheus Boesing

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 >

How to Set up Automatic Startup and Shutdown of an Oracle Database on Linux without Using Oracle-Restart

We have all set up automatic startup and shutdown of an Oracle Database on Linux at some point. I, myself, have made some scripts to do it in the past. However, did you know there is an official way/script for…

Read More >

Services [not] Starting Automatically with CRS after Reboot?

Hello all! So, a client asked me to check why his database was not starting with CRS after a reboot. I started investigating and noticed this: On Oracle 11.2, the database auto-start policy in the Clusterware is “restore”, which means…

Read More >
Page 3 of 512345