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

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

ORDIM – Oracle Multimedia – Invalid after upgrade

Posted Leave a commentPosted in Oracle

ORDIM – The Oracle Multimedia component might be in INVALID state after the database upgrade to 12c. While I was testing the upgrade on test server, received below errors after the catctl.pl completion. Serial Phase #:69 Files: 1 Use of uninitialized value $gsRTInclusion in concatenation (.) or string at catctl.pl line 1500. Time: 49s —————————————————— […]

Interesting blogs after OOW

Posted Leave a commentPosted in Oracle

It has been long time since i have posted something. After the OOW week and 12c db version being on its way, there have been few blogs which i would recommend to read http://portrix-systems.de/blog/brost/favourite-oracle-12c-database-features-of-openworld-bloggers/ http://hansforbrich.blogspot.sg/2012/10/toms-12-top-new-features.html http://dbastreet.com/blog/?p=908 http://momendba.blogspot.in/2012/10/oow-2012-oracle-12c-new-features.html http://momendba.blogspot.in/2012/10/oracle-rac-12c-new-featues.html http://uhesse.com/2012/10/01/exadata-x3-key-points/ Happy reading 🙂