Oracle Virtualization and Cloud 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.

Extract Exadata cells historical metrics in CSV format

Exadata provides a lot of useful metrics to monitor the Cells and you may want to retrieve historical values for some metrics. To do so, you can use the “LIST METRICHISTORY” command through CellCLI on the cell.
But as usual, visualising the metrics is even more better. For this purpose, you can use a perl script (see the download link in the remarks section) that extracts the historical metrics in CSV format so that you can graph them with the visualisation tool of your choice.
Let’s see the help:

Extending vmdk Size for VirtualBox VM

Recently I ran out of space on one of my Windows virtual machines. I needed to increase the size of the disk to allow me to install some new software. When creating the VM I had created the disks as VMDK. Yes I know now that is not the best format to use :-( VMDK disks/files do not allow you to dynamically change their size :-( So what can you do? Is it possible in any way? If so how? Well this is what I did (after a bit of research using the google and StackOverFlow.

  1. Make a copy of the vmdk file on the OS. Just in case anything happens!

Announcement: Singapore Oracle Sessions III

Yes, it's that time again although I decided we should delay it a little while when I realised we could take advantage of the visit of Lucas Jellema to Singapore!

MGMTDB not automatically created on Exadata X5 and GI 12.1.0.2

While deploying an X5 Full Rack recently it happened that the Grid Infrastructure Management Repository was not created by onecommand. The GIMR database was optional in 12.1.0.1 and became mandatory in 12.1.0.2 and should be automatically installed with Oracle Grid Infrastructure 12c release 1 (12.1.0.2). For unknown reason to me that didn’t happen and I had to create it manually. I’ve checked all the log files but couldn’t find any errors.  For reference the OEDA version used was Feb 2015 v15.050, image version on the Exadata was 12.1.2.1.0.141206.1.

Cloudera Quickstart VM 5.3 Apache Pig configuration

Introduction

Cloudera provides a pseudo-distributed node for working with Apache Hadoop. It is called the Cloudera Quickstart VM. While most tools in the Hadoop ecosystem such as Apache Sqoop and Apache Hive work right out of the box , Apache Pig requires some additional configuration to make it work smoothly. This blog post provides the details of such additional configuration steps.

Issue - Multiple function call in SELECT statement

Hi folks,

Need a SQL/PLSQL related help. Please see the below SQL query. In this query, I am invoking a function "DERIVE_EQ_JF_JL_EXEC_FLAG", which returns a string value. That string contains 3 individual values separated by pipe delimter, which I further split into individual values using combinations of SUBSTR and INSTR functions. One sample value returned by the function "DERIVE_EQ_JF_JL_EXEC_FLAG" is "ABC|OPR|XYZ".

select
SUBSTR(x.INPUT_VAL, 1, INSTR(x.INPUT_VAL, '|', 1, 1)-1) as "EQ_JOB_FUNCTION",

Oracle 12c – ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilege

Those days, while adding a new PDB to my Oracle 12c database (PSU 12.1.0.2.3), I got the following error in my dbca:[Thread-50] [ 2015-06-30 16:50:36.315 BRT ] [BasicStep.handleNonIgnorableError:480] ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilegeThere is an Oracle Support Document 17182200.8 (Bug 17182200 – SET CONTAINER reports ORA-1035 even with restricted session privilege). It seems the same problem, but theoretically this bug was already solved in PSU 12.1.0.2, as per MOS doc.

#LoveWins! LGBTQ Bloggers Make Their Voices Heard

You might have noticed the rainbow banner across the top of WordPress.com over the weekend — our way of marking Pride month, celebrated by cities across the globe in June, as well as the US Supreme Court’s ruling legalizing same-sex marriage across all states. (The United States now joins 20 other countries, including my own, Portugal, in fully recognizing same-sex marriage nationwide.)

Multitenant vs. schema based consolidation

If you want install multiple instances of a software, for example you host the ERP for several companies or subsidiaries, you have 3 solutions:

view counter