Author: Andrey Goryunov

Change of Database Passwords Through OEM

Once in a while passwords for system database accounts should be changed due to different requirements; it is a boring routine task, but it still needs to be completed. However, with the help of OEM it can be automated and…

Read More >

Cloning Oracle Grid Infrastructure Using Ansible

Sometimes your organization may decide to move to new hardware, to new data center and you, as an Oracle DBA, would need to be involved in preparation and configuration of new servers at new location. It is very often that…

Read More >

Add Space to Tablespace – Corrective Action in OEM 13c

A step-by-step guide to adding space to tablespaces in OEM 134c.

Read More >

OEM 12c Silent Installation

“What’s for lunch today?”, said the newly born ready to run Red Hat 6.4 server. “Well, I have an outstanding 3-course meal of OEM12c installation. For the appetizer, a light and crispy ASM 12c, DB 12c with patching for the…

Read More >

EMCLI Opens Windows for OEM Interaction

Oracle Enterprise Manager 12c rel.3 not only comes with EMCLI in interactive and scripting mode, but also opens ways to interact with OEM through building a custom GUI. Using Jython with Java Swing libraries can bring EMCLI usage to a…

Read More >

UDM is watching you, UDMs

With time monitoring of several thousand targets of different versions and on different operating systems accumulates additional checks and user-defined metrics for specific requirements. With the presence of a dozen super administrator accounts, the Oracle Enterprise Manager environment demands specific…

Read More >

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 >

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 >

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 >

Database Validation in Data Guard 12c

Data Guard Broker in #DB12c introduced a new command, VALIDATE DATABASE, which tremendously lightens the process of information gathering to make sure role change operations succeed. It is very helpful in the case of RAC database usage in Data Guard configuration.

Read More >
Page 1 of 3123