Senior Database Consultant specialist on infrastructure, HA and performance tuning. Oracle ACE Director ♠. Matheus is the youngest ACE Director in the world and is also the first ACE Cloud in Brazil.
Matheus is passionate DBA, addicted to learn and share knowledge, being founder of this blog. You can expect posts from him at least once a week!
Oracle Database 12c Maximum Availability Certified Expert (OCE)
Oracle Database 12c Performance Management and Tuning Certified Expert (OCE)
Oracle Database 12c Data Guard Administrator Certified Expert (OCE)
Oracle Database 12c RAC and Grid Infrastructure Administrator Certified Expert (OCE)
Oracle Database 12c Administrator Certified Professional (OCP)
Oracle Enterprise Manager 12c Certified Implementation Specialist (OCS)
Oracle Database SQL Certified Expert (OCE)
Oracle Database 11g Performance Tuning Certified Expert (OCE)
Oracle Real Application Clusters 11g Certified Implementation Specialist (OCS)
Oracle Database 11g Certified Implementation Specialist (OCS)
Oracle Database 11g Administrator Certified Professional (OCP)
Oracle Database 11g Administrator Certified Associate (OCA)
EXIN: Certified Integrator Secure Cloud Services
EXIN: Cloud Computing Foundation
EXIN: ITIL® Foundation Certificate in IT Service Management
EXIN: ISO/IEC 20000 – IT Service Management Foundation
EXIN: ISO/IEC 27002 – Information Security Foundation
EXIN: Green IT Citizen
ISACA: COBIT 4.1 Foundation for IT Services
Microsoft Technology Associate – SQL Server (MTA)
List of Posts (expand all):
Exadata: Cell Server Crashing on ORA-00600: [LinuxBlockIO::reap]
Automatic Killing Inactive Sessions with Resource Manager
Advise: Setting underScore/Hidden Parameters
ORA-20001: Statistics Advisor: Invalid task name for the current user
ODA Useful Commands to Manage VMs
General ILOM Faults Management
Diagsnap Causing Node Eviction on 12c
Automatic SQL Tuning Advisor Raising ORA-00600: internal error code, arguments: [qksvcReplaceVC0]
Orphan ASM File Cleanup Script
Extracting DML Stats With GGate
ORA-02056: 2PC: k2lcom: bad two-phase command number rdonly from coord
OEM 12c Agent: java.lang.OutOfMemoryError: Java heap space
ORA-04030: out of process memory when trying to allocate % bytes (kkoutlCreatePh,ub1 : kkoabr)
Amazon RDS: How to perform RMAN operations?
AWS RDS: Read Oracle Traces from SQL*Plus
Oracle Script: hcheck.sql
Checking Basic Licensing Info on a DB Server
Automatic Graceful Shutdown and Consistent Startup Method for Oracle DB on Linux
AWS: ALTER SYSTEM and Managing SYS Objects in RDS
Clear Exadata Component Messages After Maintenance
ORA-02019 While SELECT From A View Owned By Another User Using Dblink
ORA-00600: internal error code, arguments: [kghfrempty:ds]
ORA-65532: cannot alter or drop automatically created indexes
Stop Migrating Databases to 12c!
Value FROM v$option where parameter = ‘Unified Auditing’
Preventing License Violation with CHOPT
How to Prevent Violate Active Dataguard License?
How to Disable AWR and Prevent Violating Diagnostic Tuning Pack License
Licensing: Remove Options During DB Creation
DO NOT uninstall Database Vault from a CDB!
OEM Real-Time Data not Displayed
Oracle New Visual Online Tools
AWR Scripts List
Everything Stopped on ORA-02002!
12.2 Scheduler Job Disappeared After Creation
ORA-00600: internal error code, arguments: ,  on SYS.DBMS_AQ_INV
Oracle 11g Semantic Hints
12c Datapatch Failing on ORA-65108: Applying Datapatch Manually
OEM Report: Last 6 month Database Space Usage and Growth 
AWS EC2: Custom Functions to Verify Passwords
Oracle Read Only Tables: Do you use it?
Starting ASM: ORA-29701: unable to connect to Cluster Synchronization Service
OEM: HttpConnectionException:Response code:404
Oracle: Explicitly Lock a Table
OEM Report: Last 6 month Database Space Usage and Growth
Oracle Trigger Follows Clause: Simultaneous Ordered Triggers
12cR1 – Stop CRS: OC4J Fails to Stop
Check Ports in use by OEM
Regular Expressions with SUBEXPR
Amazon EC2: How to Flush Shared Pool or Buffer Cache?
Oracle: Create Disabled Triggers
Oracle Invisible indexes
OEM13c: Regions that display real-time data will not be displayed. Exception while loading RAC Database Home Page: null
Oracle SQL Join Factorization Transformation (JFT)
Oracle: “Invisible” Locks!
AWS EC2: Grant Privileges to SYS Objects
11g SQL transformations (CBQT, CNT, JE, JPPD)
OEM Metric “Memory Utilization” Different on 12c and 13c
MySQL: Sed for Scripts using “Show” from Command Line
Amazon EC2: X11 Forwarding After Sudo SSH Session
OMSPatcher finds that previous patching session is not yet completed – What to do?
Disabling PL/SQL Warnings
MySQL: ERROR 1356 (HY000): View ‘sys.innodb_lock_waits’ references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
Exadata: Generate a Sundiag
Script to Setup ADRCI Policies
ORA 600 [kdt_bseg_srch_cbk PITL1] / ORA-00700 [PITL6] / ORA-00700 [PITL5]
Pluggable Database in Mount after Restart
OEM: Quickly Ignore ORA Error on Agent Layer
Auditing Logons with Triggers
ORA-01450 on Index Rebuild
Oracle ACE Program 
PL/Scope – Did you know that?
ORA-02429 on Drop Tablespace
Oracle SQL: Aggregate List – LISTAGG
dba_registry_sqlpatch/cdb_registry_sqlpatch Empty after Patch
PLSQL: Which code is taking longer?
Oracle Pivot and Unpivot Operators
AWS – Kill Sessions on RDS Oracle Database
Increase PLSQL Performance with SIMPLE_INTEGER Data Type
OEM 13C: How to Set Up Out Of Band Notifications
Oracle Compound Triggers
Segment Creation on Demand or Deferred Segment Creation
Even Better Script: Map ASM Disks to Physical Devices
CRS-10051: CVU found following errors with Clusterware setup : PRCW-1015 : Wallet % does not exist
OEM: The number of hanging transactions are hang_trans is %
Script: Map ASM Disks to Physical Devices
Oracle Virtual Columns
Reduce Exadata Core Count
Oracle: Easily Decoding ROWID
11g Improvements: New Grants
OEM Information Reports: ORA-00600 [kpndbcon-svchpnotNULL]
Disable/Enable Maintenance Jobs
Exadata Compute Node Not Starting after a long Period
PL/SQL Generalized Invocation
OEM after a Maintenance: A memory component is suspected of causing a fault with a 100% certainty. Component Name : % Fault class : fault.memory.intel.dimm_ce
Oracle Streams: Adding a Table to Streams Replication
PLSQL: Working with NULLs and Function NHT_VALUE
/bin/rm: cannot execute [Argument list too long]
Services [not] Starting Automatically with CRS after Reboot
Oracle Security: Immediate Protection for JVM Exploits (CVE-2018-3110)
WHEN OTHERS -> NULL: Hidding your PLSQL Errors?
Cross-Session PL/SQL Function Result Cache
Moving Audit Trails (AUD$ and FGA_LOG$) to a Different Tablespace
IPv6 Formatting for JDBC and SQLPlus
After Patch: MRP0: Background Media Recovery terminated with error 10485
Managing AWR Warehouse Repository Database
Oracle 188.8.131.52 Trace Facility Problems
OEM: The ILOM server is currently offline or unreachable on the network.
Oracle SecureFiles | In 11.2 extended to Oracle Database File System – DBFS
11g+ Features: Extended Statistics
Tips to Improve your Oracle DB Shellscripting!
GGate: STOP request pending. There are open, long-running transactions.
OEM 13C Patching Agent: [ERROR- Failed to Update Target Type Metadata]
Shellscript & Oracle: Run Script for a List of Databases
GGATE ABBENDED: ORA-00308: Cannot Open Archived Log
Scheduler Job Start Time Changed After DST Change
Verifying topology of Exadata
Oracle Security: Users with Default Passwords
Scheduler Job for OS Audit Trail Cleanup Routine
12c New Feature: Unused Privileges
Database Resident Connection Pool (DRCP)
Database in Cloud: Quickest Procedure to Clone a Schema
Exacheck: The bundle patch version installed does not match the bundle patch version registered in the database
Application Named Variables Returning ORA-01008: not all variables bound
Trace on Standby: Tracing MRP Process
Am I in RHEL or OEL?
RAC: ORA-01265: Unable to delete ARCHIVED LOG
Guru99: PL/SQL 101 Completely Free!
11g Named and Mixed Notation in PL/SQL Subprogram Invocations
Recover Standby Using an Incremental Backup
KSar: Generating Graphs from SAR Reports
DFS Lock Handle During RMAN Backup on Standby Database
Formatting DBMS_GET_DDL Output on SQLPlus
11g Feature: Fine Grained Dependency Tracking (FGDT)
Linux: Finding Files Being Written Right Now!
11g Feature: Fine-Grained Access Control (FGAC) on Network Services
ORA-29278 When Trying to Use SMTP with GMail
11g Feature: PLS-00436 Restriction in FORALL Statements Removed
How to Setup Automatic Startup and Shutdown of an Oracle Database on Linux (Not Using Oracle-Restart)
11g Feature: Skip Locked Syntax in SELECT FOR UPDATE
Orphan AWR Data Consuming SYSAUX Space
Oracle Heterogeneous Services for PostgreSQL (ODBC Driver): Error (HY000,NativeErr = 1)
Oracle Database Lock Performance / False Locks
Purging a SQL Cursor in 10g
Install Oracle Client 12c on Windows 10 – INS-20802: Oracle Net Configuration Assistant failed
ORA-00932 to Export Statistics After 12c Upgrade – Undocumented
EM Event: Metrics “Current Open Cursors Count” is at %
Exadata: 7 Useful Commands to check Port/Sensor Alarms
Long running jobs AQ$_PLSQL_NTFN_%
Purge Recycle Bin Older than…
Oracle ASR: Communication Issues
Logs Exploding: ORA-00904: “UTL_RAW”.”CAST_FROM_NUMBER”: invalid identifier
OEM Alarm – %MB of Audit Trail files (sizeOfOSAuditFiles:FILE_SIZE)
OEM Alarms: TaskZombieException
OEM 12c+: Prevent OMS from Sending Old Notifications for Events
SQLNET.ORA Parameter: SQLNET.EXPIRE_TIME
CRS Not Starting after Removing OS User: How to Workaround and How to Solve!
ORA-07445: exception encountered: core dump [nstimexp()+45] [SIGSEGV] [ADDR:0x58] [PC:0x7F42ABB] [Address not mapped to object] 
ORA-00600: internal error code, arguments: 
ORA-24093: AQ agent SCHED$_% not granted privileges of database user %
ORA-00600: internal error code, arguments: [ktsapsblk-1]
Online Data Patch Apply with multiple Databases on same Oracle Home: OPatch failed with error code 26
SnapManager for Oracle: How to Get Backup Info?
ORA-00001: unique constraint (RMAN.CKP_U1) violated
Exadata: ORA-07445: exception encountered: core dump [ocl_lock_get_waitobj_owner()+26]  [0x000000000]   
EMagent 12c with high number of threads causing “su: cannot set user id: Resource temporarily unavailable”
Oracle Database 9i: Where is my SQL_ID? Which SQL is in lock?
AIX: “WARNING: Heavy swapping observed on system in last 5 mins.”
Metric evaluation error start – Get dynamic property error,Dynamic Category property error,Computation of a critical dynamic property failed. Retries Completed.
ORA-00600: internal error code, arguments: , 
Parameter Workarounds: Changing your Entire Database’s Behavior Because of a Query
Adaptive Query Optimization: SQL Plan Directives Causing High CPU after 12c Upgrade
EM Event: Number of failed login attempts exceeds threshold value [Part 2]
EM Event: Number of failed login attempts exceeds threshold value [Part 1]
User EXPIRED(GRACE) – How to Never Expire!
EM Repository: ORA-00060: Deadlock detected error in alert log
Shellscript: Which database is this service_name from?
“java.sql.SQLException: ORA-28040: No matching authentication protocol” After Upgrade Database to 12c
Target MGMTLSNR or MGMTDB Down in OEM
Killing Killed Session Without SPID
Infiniband Error: Cable is present on Port “X” but it is polling for peer port
RS-7445 [Serv MS leaking memory] [It will be restarted]          
Converting Between SQLServer, Oracle, PostgreSQL, MySQL, Sybase and others…
Oracle – Free DevOps Massive Open Online Course (MOOC)
What we got? GrepOra.com in 2016!
ASHDUMP for Instance Crash/Hang ‘Post Mortem’ Analysis
HANGANALYZE Part 2
HANGANALYZE Part 1
Materialized View with DBLink: ORA-00600: internal error code, arguments: [kkzuasid]
Webinar about Oracle Licensing…
Upgrade your JDBC and JDK before Upgrade your Database to 12c Version!
Whats is the main characteristics/skills of a DBA? [part Osborne]
Solving Simple Locks Through @lock2s and @killlocker
Backup Not Backuped Archivelogs and Delete Input
MySQL Network Connections on ‘TIME_WAIT’
RAC on AIX: Network Best Practices
Compilation Impact: Object Dependencies
ORA-01153: an incompatible media recovery is active
RHEL: Figuring out CPUs, Cores and Hyper-Threading
x$kglob: ORA-02030: can only select from fixed tables/views
Searching entries on Alert.log: A Better Way
PL/SQL Developer Taking 100% of Database CPU
ORA-02296: cannot enable (string.) – null values found
ORA-06512 ORA-48168 ORA-12012 for ADR Job Raising Errors
After adding Datafile in Primary the MRP Stopped in Physical Standby (Dataguard)
ODI 10gR1: Connection to Repository Failed after Database Descriptor Change
ADRCI Retention Policy and Ad-Hoc Purge Script for all Bases
“tail -f” vs “tail -F”: Do you know the difference?
ARCH Process Killed – Fix Without Restart
ORA-01950 On Insert but not on Create Table
Alert Log: “Private Strand Flush Not Complete” on Logfile Switch
Statistics not Being Auto Purged – Splitting Purge
Package Body APEX_030200.WWV_FLOW_HELP Invalid after Oracle Text Installing
Vulnerability: Decrypting Oracle DBlink password (<184.108.40.206)
ORA-12012: error on auto execute of job “SYS”.”BSLN_MAINTAIN_STATS_JOB”
TPS Chart on PL/SQL Developer
Oracle TPS: Evaluating Transaction per Second
RMAN Raise ORA-19913 ORA-28365 On Restore from Cloud Backup
UnknownHostException: Could not authenticate to Oracle Database Cloud Backup Module
kernel.panic_on_oops: New Oracle 12c Installation Requirement
Oracle Database: Compression Algorithms for Cloud Backup
Installing and Configuring ASMLIb on Oracle Linux 7
Oracle Licensing: Weblogic Tip!
Oracle Database Licensing: First Step!
Kludge to keep Database Alive
Oracle Database Backup to Cloud: KBHS – 01602: backup piece 13p0jski_1_1 is not encrypted
Getting today’s Errors and Warnings from MySQL log
AIX: NTP Service Basics
VMWare: Adding Shared Disks for Clustered Oracle Database
Linux: Resizing Swap Online
MySQL: Unable to connect to database ‘xxx’ on server ‘xxx’ on port xx with user ‘root’
Transporting 12TB Database Over 4.000 km with EMC DDomain
Monitoring MySQL with Nagios – Quick View
Alter (Fix) Oracle Database Date
VMware: Recognize Memory Addition Online
Export/Backup directly to Zip using MKNOD!
Linux Basic: Creating a Filesystem
Tip for the Future: Segmentation fault because of LD_LIBRARY_PATH
Optimize fragmented tables in MySQL
Explain ORA-XXX on SQL*Plus
PRCR-1079 CRS-2674 CRS-5017 ORA-27102: out of memory Linux-x86_64 Error: 28: No space left on device
Shellscript: Master Blaster KB!
ORA-01994: GRANT failed: password file missing or disabled
Migrating 220.127.116.11 to 11gR2: Feel the pain….
MySQL: Difference Between current_date(), sysdate() and now()
It’s not so hard to understand, right?
Is My Linux Server Physical or Virtual?
GoldenGate Plugin for EM13c!
18.104.22.168: ORA-00600: internal error code, arguments: , , , , , , , , , , , 
PSUs for Databases 10.2.0.4 and above
ORA-10456: cannot open standby database; media recovery session may be in progress
EXP Missing Tables on 11.2
ORA-04091: Table is Mutating, Trigger/Function may not see it
ORA-00600: internal error code, arguments: [ktecgetsh-inc], 
Purge SYSAUX Tablespace
ORA-12014: table does not contain a primary key constraint
OGG-0352: Invalid character for character set UTF-8 was found while performing character validation of source column
Script: Copy Large Table Through DBLink
ORA-27369: job of type EXECUTABLE failed with exit code: Operation not permitted
Creating RMAN Backup Catalog
Mount Diretory from Remote RHEL7 Server (NFS)
EXP-00079 – Data Protected
VKTM Hang – High CPU Usage
Charsets: Single-Byte vs Multibyte Encoding Scheme Issue
GrepORA at GUORS!
Kludge: Mounting ACFS Thought Shellscript
DDBoost: sbtbackup: dd_rman_connect_to_backup_host failed
Just another post about Flush DNS…
Scheduler Job by Node (RAC Database)
CRSCTL: AUTO_START of Cluster Services
TFA – Collecting Period
ORA-28004: invalid argument for function specified in PASSWORD_VERIFY_FUNCTION
Flush DNS Cache
Adding datafile hang on “enq: TT – contention”
Lock by DBLink – How to locate the remote session?
Date Format in RMAN: Making better!
ORA-15186: ASMLIB error function
(12c) RMAN-07539: insufficient privileges to create or upgrade the catalog schema
Cloud Computing Assessment – Free
ORA-15081: failed to submit an I/O operation to a disk
ORA-02062: distributed recovery
ORA-19751: could not create the change tracking file
ORA-27302: failure occurred at: sskgpcreates
Database Migration/Move with RMAN: Are you sure nothing is missing?
Sqlplus: Connect without configure TNSNAMES
Windows: “ORA-12514” After Database Migration/Moving (Using DNS Alias)
Create SPFILE on ASM from PFILE on Filesystem
ORA-29760: instance_number parameter not specified
ASM: Disk Imbalance Query
OUI: RHEL Permission Denied error
RHEL5: Database 10g Installation – Checking operating system version error
RMAN-06059: expected archived log not found
Listing Sessions Connected by SID
RHEL: Adding User/Group to SSH and SUDOERS file
ORA-00845: MEMORY_TARGET not supported on this system (RHEL)
ORA-01548: active rollback segment found, terminate
GoldenGate: RAC One Node Archivelog Missing
Error: Starting ACFS in RHEL 6 (Can’t exec “/usr/bin/lsb_release”)
Getting Oracle Parameters: Hidden and Unhidden
Application Hangs: resmgr:become active
Application Looping Until Lock a Row with NOWAIT Clause
High CPU usage by LMS and Node Evictions: Solved by Setting “_high_priority_processes”
VPD: “row cache objects” latch contention
Adding ASM Disks on RHEL Cluster with Failgroups
Manually Mounting ACFS
Rebuild all indexes of a Partioned Table
How to Prevent Automatic Database Startup
Service Detected on OEM but not in SRVCTL or SERVICE_NAMES Parameter?
Ordering Sequences over RAC – Hang on ‘DFS lock handle’
ASM: Adding disk “_DROPPED%” FORCE
Whats is the main characteristics/skills of a DBA? [part 2]
ORA-10456: cannot open standby database; media recovery session may be in progress
Grepping Entries from Alert.log
Grepping Alert by Day
Leap Second and Impact for Oracle Database – (June 30, 2015 at 23:59:59)
GB vs GiB | MB vs MiB | KB vs KiB
Unplug/Plug PDB between different Clusters
Whats is the main characteristics/skills of a DBA? [part 1]
Oracle Convert Number into Days, Hours, Minutes
How to list all my Oracle Products from Application park?
How to list all my Oracle Products from Database park?
ORA-24777: use of non-migratable database link not allowed
Acentuação no SQLPLUS com Windows em inglês