Author: Matheus Boesing

Data Guard Broker—ORA-16714: The Value of Property LogFileNameConvert Is Inconsistent with the Database Setting

This seems like a simple message to fix, right? The parameter is different between the broker configuration and the database parameters—it was most likely changed directly on the database after the DG (Data Guard) broker configuration was created or the…

Read More >

Automating APEX Applications Backup

In a previous post, I discussed that the APEXExport tool may be the best one to use when exporting APEX applications. You may also have experience using this tool. Today, I’d like to present some alternatives to the APEXExport tool….

Read More >

“The Cluster Upgrade State is [ROLLING PATCH]” with Correct Patch Level in all Nodes

I was performing a spot health check in a client environment, when I encountered this: [[email protected] ~]$ crsctl query crs releaseversion Oracle High Availability Services release version on the local node is [12.1.0.2.0] [[email protected] ~]$ crsctl query crs activeversion -f Oracle…

Read More >

Post-Mortem Analysis Tools: Using Preliminary Connection

Editor’s note: This “post-mortem analysis” series consists of four posts in total. Make sure you also check out: Post-Mortem Analysis Tools: Systemstate Dump Post-Mortem Analysis Tools: ASH Dump Post-Mortem Analysis Tools: Hanganalyze Now, onto today’s post: Many DBAs have been…

Read More >

Post-Mortem Analysis Tools: Hanganalyze

Editor’s note: This “post-mortem analysis” series consists of four posts in total. Make sure you also check out: Post-Mortem Analysis Tools: Systemstate Dump Post-Mortem Analysis Tools: ASH Dump Post-Mortem Analysis Tools: Using Preliminary Connection (publishing Thursday, April 22) Now, onto…

Read More >

Post-Mortem Analysis Tools: ASH Dump

Editor’s note: This “post-mortem analysis” series consists of four posts in total. Make sure you also check out: Post-Mortem Analysis Tools: Systemstate Dump Post-Mortem Analysis Tools: Hanganalyze Post-Mortem Analysis Tools: Using Preliminary Connection (publishing Thursday, April 22) Now, onto today’s…

Read More >

Post-Mortem Analysis Tools: Systemstate Dump

Editor’s note: This “post-mortem analysis” series consists of four posts in total. Make sure you also check out: Post-Mortem Analysis Tools: ASH Dump Post-Mortem Analysis Tools: Hanganalyze Post-Mortem Analysis Tools: Using Preliminary Connection (publishing Thursday, April 22) Now, onto today’s…

Read More >

Moving APEX Applications Repository with APEXExport

Most likely you’ve landed here because you need to migrate APEX applications/workspaces from one database to another. If so, you’re in the right place! We’ll use APEXExport to accomplish this. I’m providing a quick summary of the steps for using…

Read More >

Creating a Read-Only Account on Database with VPD or Label Security

I have an interesting case to share in this post. The story started when a client asked for a read-only account (let’s call it RO_USER) with access to objects under another schema (let’s call it SCHEMA_OWNER). Easy going, right? Create…

Read More >

Relying on Guaranteed Restore Points? Be careful!

Are you relying on guaranteed restore points (GRP) as a fallback plan for your migration or upgrade strategy? If you’re using RAC, especially before 12.2, be careful! When performing a non-prod upgrade with the AutoUpgrade tool, after completing the upgrade,…

Read More >
Page 1 of 41234