EM Express Login – Get Flash

I have 12c setup on OEL 6.7 on  OVM and while trying to access EM express, I was receiving the error Just for the notes, a user can log into EM Express using URL https://<hostname&gt;:<port>/em and port details can be found using lsnrctl status | grep HTTP or select dbms_xdb_config.getHttpsPort() from dual; Clicking on the … Continue reading EM Express Login – Get Flash

Fixed Table x$ktfbue has not statistics

While playing around db, I ran my usual script to check tablespace usage details and it took ~59 secs (Elapsed: 00:00:59.02), which was high. Ran the sql using "gather_plan_statistics" hint and below lines in the execution plan were of interest - | 34 | HASH GROUP BY | | 1 | 6 | 3 … Continue reading Fixed Table x$ktfbue has not statistics

Oracle ASMLib

This blog post is more of a note for myself on configuring ASMLib. ASMLib is an optional utility that can be used on Linux systems to manage Oracle ASM devices. ASMLib consists of the following components: An open source (GPL) kernel module package: kmod-oracleasm An open source (GPL) utilities package: oracleasm-support A closed source (proprietary) … Continue reading Oracle ASMLib

Tuned-adm and Oracle

"Tuned" in RHEL7/OEL7 is tuning daemon for automatically tuning the system via the use of tuning profile. It can also be configured to react to changes to improve performance of the server and also to make system settings persistent. "tuned-adm" is a command line tool that provides a number of different profiles to improve performance. … Continue reading Tuned-adm and Oracle

12cR1 RAC Installation on OEL7

To build Oracle Clusterware Database at Home, I believe , RAC ATTACK is the best place to learn. Its is a free curriculum and platform for hands-on learning labs related to Oracle RAC. While reviewing the article, I thought to perform 12cR1 RAC installation on OEL 7.2. Attached is the document :- 12c_RAC_on_OEL7 The attached article is … Continue reading 12cR1 RAC Installation on OEL7