Oracle OpenWorld 2016 : Come and Play!

In a few short weeks I’ll be jetting off to Oracle OpenWorld 2016. It’s pretty crazy to think this will be my 11th visit to OOW and San Francisco…

The rough itinerary for the trip will be…

New York City. I’m going to break my flight in NYC for a few days on my way to San Francisco. I’ve only recently confirmed my flights, but as soon as I did I reached out to NYOUG (more...)

Oracle Enterprise Manager Plugin for PostgreSQL

Oracle Enterprise Manager supports 3rd party plugins which can help you to extend its monitoring and manageability capabilities. There are already developers and companies specialized in plugin development. Blue Medora is one of them (and probably the most famous one). In this blog post, I’ll show you how we can use Blue Medora’s EM PostgreSQL plugin, which is part of their True Visibility Suite for Oracle. I’ll download and deploy the plugin on the OMS (more...)

Stop Constantly Adding Disks To Your ASM Disk Groups. Resize Your ASM Disks On All-Flash Array Storage. Adding Disks Is Really “The Y2K Way.” Here’s Why.

This blog post is centered on All-Flash Array(AFA) technology. I mostly work with EMC XtremIO but the majority of my points will be relevant for any AFA. I’ll specifically call out an array that doesn’t fit any of the value propositions / methods I’m writing about in this post.

Oracle Automatic Storage Management (ASM) is a very good volume manager and since it is purpose-built for Oracle Database it is the most popular storage presentation (more...)

#OOW16, San Francisco

This year, 2016, is turning out to be an amazing year again, with #OOW16 being once again on of the apices!

Looking back

After the discovery of the Oracle community in 2012, as a result of a very first trip to downtown San Francisco in 2010 for #OOW10, an amazing chain of events was set in motion. This very first introduction in the Oracle World was as ‘a mere participant’ in this awe-inspring, large (more...)

Process Timers – Controlling the time in which your process executes by Jose Rodrigues

clip_image002

Following up a series of questions around setting timers in the Oracle Community forums, I decided to write this article to try and guide their use and how these can be used to control process execution.

Let’s start!

The Use Case

We’ll begin by setting up the scenario in which we’ll have to control our process flow.

Imagine that you want to have a part of your process that executes immediately if the current time (more...)

Community and the “Hive Mind”

A really great thing about being part of the Oracle community is the networking and access to information it gives you. In my current job I have to do a number of things that are not really my forte. I know how to learn new stuff, but it’s always nice to get some feedback from people who know more than you. Over the last few years there have been a number of specific cases that (more...)

Business Activity Monitoring videos by Stefan Wörmke

This is a series of 8 short videos explaining how to create a BPM application using Oracle Process Cloud Services. Part 1 will show how to login and create a new application:

clip_image002Part 1

Part 2

Part 3

Part 4

Part 5

Part 6

Part 7

Part 8

The tutorial is also available at our Community blog Business Process Modelling and Business Activity Monitoring by Stefan Wörmcke

SOA & BPM Partner Community

For regular information (more...)

Meet Us at LinuxCon North America – Toronto

Oracle is a gold sponsor at LinuxCon North America, August 22nd – 24th, 2016. at Westin Harbour Castle, Toronto, Canada this year. Oracle has served on the board of the Linux Foundation since its inception in 2007 and remains steadfast to show its commitment to the open source community and their initiatives.  

We have great sessions lined up, one of these sessions will be presented by Robert Shimp, Product Management Group Vice President, (more...)

The Rosetta Stone of Database Platforms

This is a living document that I will continue to update and will add new database platforms to as I go along in my career.  I spend a lot of time translating database platforms I’ve worked in for all tiers of the technical business.  It just seems natural that we might need a location on the web where that information is kept.

alive

I’ll add some diagrams at a (more...)

Oracle PartnerNetwork Community – Get Certified FREE at Oracle OpenWorld

Written by Iulia Pantelimon, OPN


Partners can take certification exams during Oracle OpenWorld at no cost, only at the OPN Test Fest.

The OPN Test Fest runs from Monday, September 19 - Thursday, September 22 at the Courtyard San Francisco Downtown Hotel.

It’s an exceptional opportunity for partners to take Oracle PartnerNetwork exams for FREE!

Experience the benefits when achieving certification successfully. Candidates earn an OPN Certified Specialist credential, a digital badge to promote across (more...)

Getting started with Process Cloud Service by Waslley Souza

clip_image002

If you know and use Oracle BPM Suite, you will like to try the new cloud solution called Oracle Process Cloud Service or PCS. With PCS you can modeling your processes through the cloud without the need to install Oracle BPM Suite. Go to PCS section within the Oracle Cloud website to learn more about or try it: http://cloud.oracle.com/process.

In this post we will create a basic process to create and approve employees.
(more...)

Node-oracledb 1.11 Released to NPM

| Aug 19, 2016
We've pushed out a release of node-oracledb to GitHub and NPM. Top features: Connection Pool Cache The node-oracledb driver connects Node.js to Oracle Database for fast and functional applications. The changes in node-oracledb 1.11 are: Added a connection pool cache feature allowing pools to be given a... [Read More]

PHP OCI8 2.1.2 and OCI8 2.0.12 released on PECL

| Aug 18, 2016
PHP OCI8 2.1.2 (for PHP 7) and OCI8 2.0.12 (for PHP 5.2+) have been uploaded to PECL. The OCI8 extension allows PHP applications to connect to Oracle Database. Use pecl install oci8 to install PHP OCI8 2.1 for PHP 7. Use pecl install oci8-2.0.12 to install PHP OCI8 2.0 for PHP 5.2 - PHP 5.6. Note: PHP 5.6 is the... [Read More]

Commas at the beginning or end of a sql code line

Back in Nov 2015 I commented on a Oracle-L discussion about What happened to SQL*Developer SQL Formatter asking why people liked to see a comma at the beginning of the line in sql code and there was a fair bit of input into how it was easier to use and amend  – think of it like bullet points was one comment.

Fair enough I though and I have used that technique when I remember ever (more...)

The rlwrap utility for DBA.

I spend most of my time as a DBA in linux terminal and sqlplus. Everybody who works with oracle sqlplus knows about its power, but also about its limitations. For many years I have used the rlwrap utility developed by Hans Lub. It gives me command history, and the ability to edit my SQL Plus commands, and use auto completion if I set it up. In this post I will share some tips about installation (more...)

Basicfile LOBs

There are probably quite a lot of people still using Basicfile LOBs, although Oracle Corp. would like everyone to migrate to the (now default) Securefile LOBs. If you’re on Basicfile, though, and don’t want (or aren’t allowed) to change just yet here are a few notes that may help you understand some of the odd performance and storage effects.

Of course, there are a lot of variations in how you declare the LOB – pctversion (more...)

Introduction to Oracle Internet of Things Cloud Service – Webcast August 23rd 2016

image

Introduction to Oracle Internet of Things Cloud service 16.3.3 and IoT Asset Monitoring Mini-App

Speakers: Harish Gaur and Florian Tournier

Please join the Oracle Product Management team in an introduction to version 16.3.3 of the Oracle Internet Cloud Service. This webcast will provide an overview of the exciting new features available in this release.

It will feature a demo of the new, readily-deployable Asset Monitoring application for rapid integration of IoT (more...)

Red Summer School is on! – run a PaaS workshop for your university!

image

Want to recruit new employees? Want to try PaaS? Run a Summer School training like Link Consulting.

Link Consulting’s Red Summer School on Oracle technologies on the Cloud is on! Teams Alfa, Beta and Delta have been working hard, mentored by our BPM and ECM business manager, Oracle ACE Associate and founder of Red Mavericks, José Rodrigues.

Earlier on this week they learnt the concept of REST APIs using Postman and SoapUI and testing interaction (more...)

Configuring Multiple local_listener

I was working on configuring multiple local listeners and having difficulties setting local_listener using full address list.

How would you set up local_listeners?

Demo:

There are 4 listeners, 1-4.

$ lsnrctl status listener1

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 17-AUG-2016 21:34:31

Copyright (c) 1991, 2013, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1551)))
STATUS of the LISTENER
------------------------
Alias                     listener1
Version                   TNSLSNR for Linux: Version 11.2.0.4.0  (more...)

Approvals 1.5 for E-Business Suite Now Available

Approvals for EBS mobile screenshotA new version of the E-Business Suite Approvals mobile app is now available for iOS and Android.

Approvals for EBS 1.5 is part of a coordinated release of 18 E-Business Suite mobile apps.  These apps are designed to work with EBS 12.1.3 and 12.2 and are available for iOS and Android. 

This is our sixth set of updates to this family of EBS smartphone apps (a.k.a. "Release (more...)