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:
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.
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 184.108.40.206 and became mandatory in 220.127.116.11 and should be automatically installed with Oracle Grid Infrastructure 12c release 1 (18.104.22.168). 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 22.214.171.124.0.141206.1.
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.
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".
SUBSTR(x.INPUT_VAL, 1, INSTR(x.INPUT_VAL, '|', 1, 1)-1) as "EQ_JOB_FUNCTION",
Those days, while adding a new PDB to my Oracle 12c database (PSU 126.96.36.199.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 188.8.131.52, as per MOS doc.
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.)
If you want install multiple instances of a software, for example you host the ERP for several companies or subsidiaries, you have 3 solutions: