Oracle VM Consulting
view counter

Database Feed

Oracle Database, Oracle 10g, Oracle 11g, Oracle XE, Oracle RAC, Oracle Instant Client, Oracle Data Guard and Oracle Exadata resources, news, and support articles.

Saving time and increasing service availability with MySQL Enterprise Monitor 2.3

Nowadays MySQL Databases are encapsulated into many mission critical software solutions. Lots of companies host one or many MySQL databases in their data center, sometimes even without knowing it except when the MySQL service is no more available. In order to increase this service availability it is mandatory to have a monitoring solution. Regardles of you are using MySQL Server, MySQL replication or cluster the Oracle/MySQL monitoring solution is called MySQL Enterprise Monitor.

Book of the Month – “Oracle GoldenGate 11g Implementer’s Guide” by John P. Jeffries

My relationship with Oracle Golden Gate is first emotional and then professional. My Oracle Corporation boot camp was in Ireland in early January 2010 after Oracle had acquired Golden Gate, and so most of my boot camp mates were from … Continue reading

SASH visualization using Excel

OraSASH is a free implementation of Oracle Active Session History mechanism but it is providing only raw tables with data. To help other people use that functionality and inspired by Charles Hooper blog I have created a Excel based simple GUI interface for SASH. It is providing historical and real time view based on repository.

Oracle Instant Client on Ubuntu…with added Aliens

“This is the voice of the Mysterons…have you got any Lemsip ?”
Yep, I’ve caught Deb’s cold and now sound like the alien menace from Captain Scarlet.
This provides a somewhat tenuous link to the subject at hand – namely installing Oracle Instant Client on Ubuntu.

Cricket Cricket Cricket Cricket

I am big fan of Cricket. On 02-April-2011 it became a 22 years of dream which came true for 1.2 billion Indians. We won the match in a classic style and I am really proud of the team.

Just wanted to share some picture

The whole Indian Team when they lifted the World Cup.

How to Gracefully Reboot Exadata Database Machine

Restarting Oracle Exadata database machine involves rebooting first the cell nodes and then the compute nodes. But before that you have to bring down the RDBMS instances, ASM instances, and CRS.

Steps to Restart Exadata:

1- With oracle user, Shutdown the RDBMS and ASM instances by doing From any compute node:

srvctl stop database -d

2- With root user, from $ORA_CRS_HOME, shutdown the CRS:

 ./crsctl stop cluster

Salesforce API call from Oracle APEX

This post is about integrating Salesforce with Oracle using the Salesforce API.
I will try to show you how you can write a PL/SQL procedure to quickly send an SQL INSERT you do in an Oracle table to a Salesforce custom object as well. That is, how you can INSERT to a Salesforce object simultaneously when you insert to an Oracle table. I will use Oracle APEX, an Oracle RAD (Rapid Application Development) tool, as the Oracle database. 

Oracle XE 11g - beta release


Good news Oracle XE 11g has been released. Right now it is a beta version but we can expect production release soon. I was waiting for that release as my idea was to use it a repository database for S-ASH. I'm going to check if all new 11g functionality like PIVOT functions will be working fine.


Oracle Database 11.2 Express Edition Beta comes with weak default password

Yesterday Oracle released the first beta of Oracle Database 11.2. Express Edition. I downloaded the beta and after installation I run our database scanner Repscan against it.
It was surprising that Oracle delivers 11.2 Express Edition with a default password for the open APEX_040000. Additionally APEX4 was not patched properly (Patch 4.0.2 was missing).

C:\>sqlplus apex_040000/oracle@
SQL*Plus: Release [...]

How to display content attributes on Exadata Storage?

On Exadata, After We created flashcache on exadata storage. How to know it work!!! Because on database, we don't change anything.
On Database: we can check...

SQL> select name,value from v$sysstat where name in ('physical read total IO requests','cell flash cache read hits');


view counter