Tag: Oracle

OEM 13c Monitoring Features – Part 4, Corrective Actions

This is the fourth in a series of blog posts covering the most important topics you should know to completely monitor your IT infrastructure with Oracle Enterprise Manager Cloud Control 13c. The previous posts covered how to set up basic…

Read More >

How to Test Data Guard Fast-Start Failover by Shutting Down Primary Server

This post will demonstrate the procedure to test Oracle Data Guard Fast-Start Failover by shutting down the server where the primary database is running from. The environment is a single instance database without any grid Infrastructure components. The same process…

Read More >

OEM 13c Monitoring Features – Part 3, Reports Based on Metric Data

This is the third in a series of blog posts covering the most important topics you should know to completely monitor your IT infrastructure with Oracle Enterprise Manager Cloud Control 13c. The previous posts covered how to set up basic…

Read More >

OEM 13c Monitoring Features – Part 2, Extended Metrics

This is the second in a series of blog posts covering the most important topics you should know to completely monitor your IT infrastructure with Oracle Enterprise Manager Cloud Control 13c. In the previous post, Part 1, we covered how…

Read More >

OEM 13c Monitoring Features – Part 1

This is the first in a series of blog posts covering the most important topics you should know to completely monitor your IT infrastructure with Oracle Enterprise Manager Cloud Control 13c.   Oracle Enterprise Manager (OEM) offers solid monitoring capabilities…

Read More >

How to Automate Killing Inactive Sessions with Resource Manager

Are you manually (or via a script) killing idle sessions on your database? As a consequence, your users are getting error “ORA-00028: your session has been killed” and probably getting angry at you. What about doing it automatically, in a…

Read More >

How To Downgrade Grid 19c Clusterware to 12.1

There may be many reasons for downgrading from Grid 19c to 12.1; however, the reason I am downgrading is to rerun a test requested by Oracle support from the 12.1 clusterware. Here are the steps performed. ### Check cluster: oracle@ol7-121-rac2…

Read More >

Mining GoldenGate Error Logs for Consumption Rates of Trail Files

After resolving Oracle GoldenGate issues, a question typically asked is, “When will the process catch up?” The usual method to find out is to use the lag command; however, I was more interested to see the rate of the trail…

Read More >

Mining Autoupgrade Results

We wanted to define a consistent process for upgrading databases using an autoupgrade method for single instance databases: Create directory for autoupgrade/log: $ORACLE_BASE/admin/$ORACLE_UNQNAME/autoupgrade/log, where $ORACLE_UNQNAME=db_unique_name Create upgrade.config as shown: $ORACLE_BASE/admin/$ORACLE_UNQNAME/${ORACLE_UNQNAME}_upgrade.config global.autoupg_log_dir=$ORACLE_BASE/admin/$ORACLE_UNQNAME/autoupgrade/log upg1.log_dir=$ORACLE_BASE/admin/$ORACLE_UNQNAME/autoupgrade/log upg1.dbname=$ORACLE_UNQNAME upg1.sid=$ORACLE_SID upg1.start_time=NOW upg1.source_home=/oracle/app/product/11.2/dbhome_1 upg1.target_home=/oracle/app/product/12.2/dbhome_1 upg1.upgrade_node=localhost upg1.target_version=12.2 upg1.timezone_upg=no…

Read More >

Do Not Mix Different Patch Types

I was preparing to apply a July 2019 path for a single instance database without ASM. Here are the available patch types for Oracle Database: PSU, SPU(CPU), Bundle Patches (Versions 12.1 & lower) via Doc ID 2118136.2 Review current patch…

Read More >
Page 2 of 16212345...10...Last Page »