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 …

Advertisement

Fixed Table x$ktfbue has not statistics

While playing around 12.1.0.2 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 …

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

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 …

Online Partition Move fails with ORA-00932 – 12.1.0.2

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

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

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

PRCA-1057 : Failed to retrieve the password file location used by ASM

After the Oracle Restart (Grid Infrastructure) upgrade from 11.2. to 12.1.0.2 , you might encounter the below lines in the ASM alert log file Tue Jun 23 01:16:01 2015 WARNING: unknown state for ASM password file location resource, Return Value: 3 WARNING: unknown state for ASM password file location resource, Return Value: 3 After the …

12c Upgrade – It can be slow!!!!

This post is for some of you who are planning to upgrade to 12c.I worked on upgrading single instance database from 11.2.0.3.13 to 12.1.2.0.3, so thought to share my experience. From 12c catupgrade.sql has been deprecated and Oracle has introduced catctl.pl script for upgrade. With catctl.pl script Oracle tries to perform as much work as …