"U" entries in MLOG$

Posted Leave a commentPosted in Oracle

Recently in a discussion with colleague, on what entries do MLOG$ have, the following was agreed to :- 1. “I” for insert 2. “D” for delete 3. “D” + “I” for update. Along with the above entries, you might notice “U” also. The “U” entry is for update. But then, on what condition do we […]

EM Express Login – Get Flash

Posted Leave a commentPosted in Oracle

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>:<port>/em and port details can be found using lsnrctl status | grep HTTP or select dbms_xdb_config.getHttpsPort() from dual; Clicking on the […]

Oracle ASMLib

Posted 2 CommentsPosted in Oracle

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) […]

Tuned-adm and Oracle

Posted 1 CommentPosted in 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. […]

12cR1 RAC Installation on OEL7

Posted Leave a commentPosted in Oracle

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 […]

Online Partition Move fails with ORA-00932 – 12.1.0.2

Posted 2 CommentsPosted in Oracle

Oracle 12c introduced feature to move table partitions and sub-partitions as online operations.So, this blog is related to this feature and the issue I faced. The database was upgraded from 11.2.0.4 to 12.1.0.2 and this issue is seen in upgraded databases only. Lets start!!! SQL> create table sales_part (product char(25),channel_id number,cust_id number, amount_sold number, time_id […]

PDB Saved state – 12.1.0.2

Posted Leave a commentPosted in Oracle

Prior to 12.1.0.2 version, whenever container database was restarted,the pluggable databases within the container database remained in MOUNT state. Startup trigger were written to open the database in READ-WRITE/READ-ONLY mode.Starting from 12.1.0.2, this can be done with PDB save state feature SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ———- —————– ———- ———- 2 PDB$SEED […]