Resizing ASM Disks On Modern Systems. Real Application Clusters Doesn’t Make It Any More Difficult. An XtremIO Example With RAC.

My recent post about adding space to ASM disk groups by resizing them larger, as opposed to adding more disks, did not show a Real Application Clusters example. Readers’ comments suggested there is concern amongst DBAs that resizing disks (larger) in a RAC environment might somehow be more difficult than in non-RAC environments. This blog entry shows that, no, it is not more difficult. If anything is true it is that adding disks to ASM (more...)

Last week in Stream Processing & Analytics 8/30/2016

This is the 29th installment of my blog series around Stream Processing and Analytics.

As usual, find below the new blog articles, presentations, videos and software releases from last week:

News and Blog Posts

General

Top tweets SOA Partner Community – August 2016

image

August 2016 top tweets by soaCommunity

Send your tweets @soacommunity #soaCommunity and follow us at http://twitter.com/soacommunity. Make sure you share your content with the community!

SOA & BPM Partner Community

For regular information on Oracle SOA Suite become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center.

Blog (more...)

Generic BigDecimal Formatter in ADF 12.2.1.1

I have implemented couple of improvements for BigDecimal formatter based on ADF 12.2.1.1. Originally formatter was implemented and described in this post - Handling Format for BigDecimal Numbers in ADF BC. New improvements: option to support trailing zeros and disabling number rounding.

1. Support for trailing zeros

If you type number 3000.10, BigDecimal type attribute will keep it as 3000.10. But in database it will be saved without trailing zero (more...)

PeopleSoft Partner of the Year

I would like to borrow a few minutes of your time to ask a quick favour. If you haven’t already, could you please vote ‘Gold’ for Cedar in the UK PeopleSoft Partner of the Year competition.

http://pya.ukoug.org/index.php/survey/index

Here’s why I believe we’re worth your vote:

  • We’ve been serving PeopleSoft customers for 20+ years, and in each of the last few years we’ve worked with more than 40 clients
  • We’re active members of UKOUG, with (more...)

Simple Cold Backup using tar

At times, I find it much simpler to shutdown my test database and create cold backup which will allow me to revert from any errors.

$ echo $ORACLE_SID
DB01

$ tar -cvzf /media/sf_OracleSoftware/$ORACLE_SID_$USER_`hostname -s`_backup.tar.gz .
./
./obj_source.out
./onlinelog/
./onlinelog/o1_mf_1_cw3syboq_.log
./onlinelog/o1_mf_2_cw3sybrt_.log
./onlinelog/o1_mf_3_cw3syc03_.log
./controlfile/
./controlfile/o1_mf_cw3sybl0_.ctl
./datafile/
./datafile/o1_mf_temp_cw3syrhz_.tmp
./datafile/o1_mf_users_cw3syrk7_.dbf
./datafile/o1_mf_sysaux_cw3syl2w_.dbf
./datafile/o1_mf_demo_cw4tz56f_.dbf
./datafile/o1_mf_undotbs1_cw3syoc6_.dbf
./datafile/o1_mf_system_cw3syd5k_.dbf

$ ll /media/sf_OracleSoftware/DB01_oracle_arrow_backup.tar.gz
-rwxrwx---. 1 root vboxsf 382676286 Aug 28 13:09  (more...)

Integrating Critical Patch Updates (CPU) into your WebLogic Server on Docker

Bruno Borges is doing a great job providing Docker Images for various Oracle WebLogic scenarios within the GitHub Repository https://github.com/oracle/docker-images/tree/master/OracleWebLogic

The provided samples are a real good starting point to create your Oracle WebLogic Servers and Domains including sample application.

But I personally miss one point within the Installation process of the Oracle WebLogic Server, applying Critical Patch Updates.

The integration is really simple.
As an example I will take Bruno's build file https://github. (more...)

Fix Interactive Report headers issue when using a Region Display Selector

When you have multiple Interactive Reports (IR) on your page and use a Region Display Selector to mimic tabs, you might notice some weird behaviour in the IR headings if you switch tabs. The headings are not positioned correctly and you get an extra empty row under the headings. It just looks weird and ugly. But if you resize your browser window, it all looks fine again (until you switch to another tab..)

The Complete Guide To Data Warehousing and Big Data at Oracle OpenWorld 2016

The COMPLETE guide for OpenWorld provides a comprehensive day-by-day list of all the most important sessions and hands-on labs for Oracle's data warehouse and big technologies: Oracle Database 12c Release 2, Oracle Cloud, engineered systems, partitioning, parallel execution, Oracle Optimizer, analytic SQL, analytic... [Read More]

Talk to your UI from your BPM process by Fernando

clip_image002


A few weeks back we had the opportunity to participante in an 12c challenge which had lots of different flavours (BPM, Coherence, ADF, etc.) and some very strict performance requirements.

Scenario

In this solution, an operator would be logged on to an ADF application showing different regions, with one particular region that would update as the BPM instance progressed through the different human tasks in the process. The team had opted for a simple (more...)

Oracle Data Integrator: Upgrade to ODI 12c – A Case Study

We don’t often get a chance to share our customer success stories due to various reasons, such as required anonymity of the client or certain other legalities. But when we do, it sure feels great! Recently, Eurocontrol, a longtime Rittman Mead client in Brussels, Belgium, performed an upgrade of Oracle Data Integrator from 11g to 12c. With the help of Rittman Mead, and specifically data integration expert Jérôme Françoisse, Eurocontrol was able to (more...)

Should You Register for a Certification Exam or Buy an Exam Voucher?


Have you been thinking about getting Oracle Certified? 

If so, that's great! 

You're one step closer to advancing your skill set and empowering yourself as a professional dedicated to continuous learning and self-improvement.

So should you buy an exam voucher or register for an exam? We'll explain the difference below. 

Buy an Exam Voucher from Oracle University

Select this option if:

  • You wish to purchase your exam voucher now and schedule your (more...)

Why You Should Take The Oracle Database Cloud Service Exam

If you read our recent article Are Your Database or Java Skills Cloud Ready?, you may be wondering what the big deal is about exam 160 or how it can lead to so many different certifications.

I want to help clear the confusion.

Oracle Database Cloud Service | 1Z0-160 tests your Oracle Database Cloud Service skills, demonstrating your ability to administer your database in the Cloud. The resulting certification depends on your background.

Client Side Filtering in the Grids

Just what it sounds like – you ask to see LESS data in a grid, and we don’t re-query the database. Instead, we filter only on the client-side. This means it’s FAST. No asking the database to run the query again. This also means you might not be getting the WHOLE truth, or the latest truth. Unless... [Read More]

Started at Amazon! … want to join me?

 

 

 

(Disclamer: any opinions expressed here are fully my own and not representative of my employer)

11039191375_cac06fb854_z

photo by alvaroprieto  (cc 2.0)

Super excited to be working at Amazon on my passion which is performance data visualization and database monitoring. Suffice it to say this is the most excited I’ve been about work in my career and I’ve had ample opportunity to work on database performance in the past such as at (more...)

Unicode and Oracle SQLcl…on Windows

I have an UMLAUT table. Pretty simple really… CREATE TABLE "HR"."UMLAUT" ( "CHARACTERS" VARCHAR2(2) ) ; REM INSERTING INTO UMLAUT SET DEFINE OFF; INSERT INTO UMLAUT (CHARACTERS) VALUES ('Ñ'); INSERT INTO UMLAUT (CHARACTERS) VALUES... [Read More]

ORACLE OPENWORLD – Hands on Labs for Oracle Linux and Virtualization

Hi everyone, 

This week's Friday Spotlight is about Oracle OpenWorld Hands-on Labs for Oracle Linux and Virtualization. Last week, we covered our conference sessions. If you are still deciding whether or not to come, the sessions below should be the reason to attend. These are 1-hr sessions where you will be guided to install or setup an environment or products and troubleshoot with experts while you are working on them. Here’s what a few of (more...)

Oracle Forms Stand-alone Application Launcher (FSAL)

Since Oracle Forms 12c its possible to start your Oracle Forms without invoking a browser, this is called Oracle Forms Stand-alone Application Launcher (FSAL).

As pre requirement you will need either a JRE or JDK on your desktop, which should execute the Oracle Forms.

For this new Feature Oracle has integrated a short description Website within your installed and configured Oracle Forms & Reports Server 12c. The description website can be reached under following URL (more...)

Umwandlung von LONG in CLOB mit SYS_DBURIGEN

Meine Standardantwort auf die Frage, wie man die Inhalte von LONG-Spalten auslesen kann, war seit vielen Jahren: ich hab's vergessen, aber Adrian Billington hat alles notiert, was man über diesen unerfreulichen Datentyp wissen muss. Diese Antwort kann ich jetzt modifizieren: der handlichste Weg, um LONGs in etwas weniger Häßliches zu verwandeln, ist die Verwendung der builtin-Funktion SYS_DBURIGEN, der von Marc Bleron (aka odi_63) in seinem Blog beschrieben wird. Intern erzeugt Oracle in diesem Zusammenhang ein (more...)

Node.js and Oracle NoSQL Database

Oracle NoSQL Database is an interesting option to consider when you want a schemaless, fast, scale-able database which can provide relaxed (eventual) consistency. Oracle provides a Node.js driver for this database. In this blog I’ll describe how to install Oracle NoSQL database and how to connect to it from a Node.js application.

The Node.js driver provided by Oracle is currently in preview version 3.3.7. It uses NoSQL client version 12. (more...)