Tag: Pythian

Silent Installation of RAC 12c database

Nowadays everyone is installing #db12c in different variants, posting screenshots, talking about a better tool to run GUI through. However I could not find posts about silent installation of GI and RDBMS. Yes, installation without sleek graphical interfaces, just pure…

Read More >

Troubleshooting Transactional Replication Latency Using Agent Statistics

In this blog post, we will look at how you can leverage the Agent statistics to troubleshoot the replication latency issues. Before understanding how to decode the agent statistics, let’s take a look at the some of the basic things…

Read More >

Table recovery with rman in Database 12c

A quick look at table-level recovery with Database 12c including sample script and output.

Read More >

Breaking News: Oracle E-Business Suite Release 12.2.2

Oracle E-Business Suite Release 12.2.2 is out! Big times ahead of us folks! My team is planning to blog about it a lot. Stay tuned. This is my prediction: Online patching a game-changer in Oracle E-Business Suite 12.2 Oracle Press Release Steven…

Read More >

Duplication: divide et impera

For me, every Monday morning starts with the same routine. I refresh some QA databases from PeopleSoft production one. Even though the process is almost fully automated (all commands are automatically generated) it takes several hours to perform the final…

Read More >

Not so good news for MCM Aspirants

A few days back, late Friday (30th August 2013) MS has made an announcement – that they are cancelling the MCM Certification, not so good news for MCM aspirants. This announcement has upset many in the SQL Community including myself….

Read More >

Oracle OpenWorld 2013 – Bloggers Meetup

Oracle OpenWorld 2013 is just few weeks away, and of course, we are organizing the Annual Oracle Bloggers Meetup — one of your top favorite events of OpenWorld. What: Oracle Bloggers Meetup 2013 When: Wed, 25-Sep-2013, 5:30pm Where: Main Dining…

Read More >

How to Fix a Target with a Pending Status in OEM 12cR2

The other day we had a situation with an OEM 12cR2. We performed maintenance in a 2-node cluster and both instances came up fine, but one of the instances in OEM’s Cluster Database target was showing a pending status. It goes to say that before the maintenance, both showed as up.

Read More >

Proactive FRA Monitoring Using OEM Metrics

As you know, thresholds for flash/fast recovery area (FRA) usage are set internally in a database to 85 and 97 per cent, and there are no ways to change the thresholds — at least none that are supported by Oracle. This might work fine in most cases, but being aware of changes in FRA usage can sometimes be helpful. You can then contact your DBA and suggest verifying your database’s settings.

Read More >

RAC Attack at Oracle OpenWorld 2013 (Operation Ninja)

I am happy to announce that, thanks to all the volunteers’ hard work and Oracle Technology Network’s support, RAC Attack is going to be part of the Oracle OpenWorld 2013 conference in less than a month’s time.

Read More >