First setup of a connection from Node.js to an Oracle Database

In this article I will demonstrate how to make a connection to a remote Oracle database from Node.js running on linux 7. We will be using the node-oracledb module to accomplish this. Lucas Jellema gave a great explanation about this module in his recent article Running node-oracledb – the Oracle Database Driver for Node.js – in the Pre Built VM for Database Development

As described in that article, the node-oracldb module is depending on (more...)

Set Operations

A recent post on the OTN database forum highlights a couple of important points ideas for optimising SQL. There are: (a) is there a logically equivalent way of stating the SQL and (b) is there a different “natural language” way of posing the problem.

The posting starts with a query, part of an execution plan, and a request to “get rid of the tablescan”. I guessed originally that the query came from an 11g instance, (more...)

NoCOUG changes its name (Happy April Fools Day)‏

The board members of NoCOUG meets in closed session to discuss the continuing decline in memberships and conference attendance.(read more)

GoldenGate 12.2 Big Data Adapters: part 3 – Kafka

This post continues my review of GoldenGate Big Data adapters started by review of HDFS and FLUME adapters. Here is list of all posts in the series:

  1. GoldenGate 12.2 Big Data Adapters: part 1 – HDFS
  2. GoldenGate 12.2 Big Data Adapters: part 2 – Flume
  3. GoldenGate 12.2 Big Data Adapters: part 3 – Kafka

In this article I will try the Kafka adapter and see how it works. Firstly, I think it (more...)

Oracle TNS-12535 and Dead Connection Detection

These days everything goes to the cloud or it has been collocated somewhere in a shared infrastructure. In this post I’ll talk about sessions being disconnected from your databases, firewalls and dead connection detection.

Changes

We moved number of 11g databases from one data centre to another.

Symptoms

Now probably many of you have seen the following error in your database alertlog “TNS-12535: TNS:operation timed out” or if you haven’t you will definitely see it (more...)

Oracle Cloud Einsatzszenarien

Im heute erschienenen vorerst letzten Video der Reihe "Oracle Cloud Now" zeigt Ihnen Frank Schneede einige mögliche Einsatzszenarien für Oracle Database Cloud Services.

Außerdem geht er näher auf den Exadata Cloud Service ein.

Wenn Sie das Thema Oracle Database Cloud Services auch einmal "live" erleben wollen, sollten Sie sich außerdem jetzt schon für das kostenfreie Event anmelden:
"Digital Transformation IT Summit" am 20.04. in München

Real-time model scoring for streaming data – a prototype based on Oracle Stream Explorer and Oracle R Enterprise

Whether applied to manufacturing, financial services, energy, transportation, retail, government, security or other domains, real-time analytics is an umbrella term which covers a broad spectrum of capabilities (data integration, analytics, business intelligence) built on streaming input from multiple channels. Examples of such channels are: sensor data, log data, market data, click streams, social media and monitoring imagery.

Key metrics separating real-time analytics from more traditional, batch, off-line analytics are latency and availability. At one end (more...)

Generating a Web Service Client and Proxy with JDeveloper 12c


Overview

This blog describes how to generate a web service client and proxy that can be used to invoke Fusion web services.  This example shows how to create a proxy to invoke the HCM WorkerService.  This blog represents a portion of a more detailed blog: Using Fusion web services to terminate a work relationship.



System Requirements

JDeveloper 12c (Studio Edition 12.1.2.0.0 or greater)

Java 7

Fusion SaaS release (more...)

Using Fusion web services to terminate a work relationship


Overview

This blog describes how to use Fusion web services to terminate a work relationship.



System Requirements

JDeveloper 12c (Studio Edition 12.1.2.0.0 or greater)

Java 7

Fusion SaaS release 9+ environment



Step 1 - Create the project

1a) Create a new "custom application" in JDeveloper.


1b) Follow the steps in the wizard to create the project.  Be sure to select "SOAP Web Services" from the "Project Features" tab on the (more...)

The First and Last Word on NoSQL

Amazon had the first word on NoSQL but the creator of relational theory, Dr. E. F. Codd, gets the last word.(read more)

The company that is most responsible for NoSQL is not Amazon

The company that is most responsible for NoSQL is not Amazon but Oracle Corporation.(read more)

Graph Databases and NoSQL

Andrew Cobley from The Register writes about Graph Databases and NoSQL.  Take a look at: http://www.theregister.co.uk/2016/03/29/in_defense_of_graph_databases/  .  In the article, he does refer to Oracle NoSQL Database.  "Oracle's NoSQL goes further, storing JSON or name value pairs across a sharded, shared nothing system."

Take a look at the article. 

Gluent Demo Video Launch

Although we are still in stealth mode (kind-of), due to the overwhelming requests for information, we decided to publish a video about what we do :)

It’s a short 5-minute video, just click on the image below or go straight to http://gluent.com:

Gluent Demo video

And this, by the way, is just the beginning.

Gluent is getting close to 20 people now, distributed teams in US and UK – and we are still hiring!

 

 

 

NB! (more...)

Improving Equipment Maintenance with Oracle IoT

The Gemü Group is a leading manufacturer of valves, measurement and control systems. When they decided they needed an innovative Internet of Things (IoT) solution for paperless maintenance, they found the Oracle IoT Cloud Service to be the best fit for their needs. With Oracle IoT, they can now link back data from their devices at customer sites to a centralized service portal in the cloud to easily track availability and performance and better serve (more...)

HOUG Konferencia 2016 április 4-6. Még lehet jelentkezni

2016. április 4-6. között lesz a HOUG Konferencia 2016.

Még lehet jelentkezni, érdemes megnézni a részletes szakmai programot.

Looking for guidance on the future state of your database platform?


Whether you are developing and deploying enterprise applications, building smarter database architectures, or managing your customer’s IT infrastructure, the demands on the modern data platform are constantly evolving. Trying to keep up with every business need can be challenging, but ignoring them simply isn’t an option. This is where best practice & insights from experts and peers can help. 
Attend one of these Oracle Database Insights Forum events:

· Paris on 7 April

· (more...)

Looking for guidance on the future state of your database platform?

Whether you are developing and deploying enterprise applications, building smarter database architectures, or managing your customer’s IT infrastructure, the demands on the modern data platform are constantly evolving. Trying to keep up with every business need can be challenging, but ignoring them simply isn’t an option. This is where best practice & insights from experts and peers can help. 

Attend one of the Oracle Database Insights Forum events:

· Kuwait on 4 April

· (more...)

Looking for guidance on the future state of your database platform?


Whether you are developing and deploying enterprise applications, building smarter database architectures, or managing your customer’s IT infrastructure, the demands on the modern data platform are constantly evolving. Trying to keep up with every business need can be challenging, but ignoring them simply isn’t an option. This is where best practice & insights from experts and peers can help. 
Attend one of these Oracle Database Insights Forum events:

· Manchester on 20 April

· (more...)

A complete family of data management products that solve all use cases

Oracle has a complete family of data management products that solve all use cases.(read more)

Hackathons at AddThis: Serious Playtime

AddThis Hackathons are Serious Playtime for EngineersWe’re in the age of the Hackathon – a time when professional hackathon organizations organize self-proclaimed hackers vying for money and bragging rights.

Packing individuals on (more...)