Bryn Llewellyn (Distinguished Product Manager, Database Division, Oracle) presented at OOW2016 on new features in PL/SQL in Oracle Database 12cR2. One of the features that stood out was a new pragma deprecate that can be added to program units such as functions and procedures inside packages. This pragma is used to mark a program unit at deprecated, which typically means: the program unit is still valid, but has been superseded by a better option and (more...)
If you’re into integration, SOA or web services, you’ve probably heard the term Microservices fairly often lately. Is applying Microservices architecture the one-size-fits-all solution that can replace the traditional one-size-fits-all SOA solution that doesn’t fit anymore? Of course not, because the world isn’t just black and white and both architectural concepts have their pros and cons. However, I think we can learn from the Microservices movement to improve and modernize our traditional SOA systems.
One of those things SQL developers are frequently looking at is the generation of rows: having a query return records that do not really exist. For example to generate test data or to produce records for all days in a month. Tom Kyte usually selects from data dictionary views. Various tricks make the rounds, for example based on CONNECT BY or CUBE or UNPIVOT. This blog article by Natalka Roshak (2015) compares various row generation (more...)
I’m a mega Gary Numan fan. I’ve loved his stuff since the Tubeway Army days (I sometimes use “Are ‘Friends’ Electric?” as a heading on my presentations about smart user experiences) and his records were some of the first I bought.
I have been testing the latest Garmin vívomove activity tracker for real. Garmin has pretty much made their high-end wearable devices a no-brainer choice for the hardcore and committed athletics and fitness types, and I already use the mighty Garmin fēnix 3.
However, Garmin is also not content to leave the rest of the sports watch market to Fitbit and friends and the activity tracker market is now a large part of their business. The (more...)
This weekend, while preparing for a demo during Oracle OpenWorld 2016, I found a for me new way of publishing a new [version of an]application to Application Container Cloud: through Storage Cloud. The application archive – zip or tar – can be stored on Storage Cloud and the deployment to ACCS can be performed from Storage Cloud. I am not yet sure if this makes for a better automated workflow. What it does give me (more...)
In last p`ost, we have setup development environment for coding and uploading scratches to NodeMCU, an IoT device.
This post, we will upload and run two examples to demonstrate how IoT device sending data into Cloud and receiving commands from Cloud.
4. Architecture Diagram
It involves several tiers and components to make the whole IoT loop. However, you will just focus on device communication with MQTT, all other components have been setup properly.
AppsLab and OTN will jointly host IoT Workshop at Oracle OpenWorld and JavaOne conference in 2016. We look forward to seeing you at the Workshop.
Here is some details about the Workshop with step-by-step instructions. Our goal is that you will learn some basics and get a glimpse of Oracle IoT Cloud Service at the workshop, and you can continue playing it with IoT package after going home. So be sure to bring your computer (more...)
A brief headsup for everyone responsible for maintaining kernel options in the oracle executable.
The environment where I discovered this is a 3 node racattack cluster with Oracle GI & RDBMS 22.214.171.124.0. After enabling Unified auditing in my 126.96.36.199 database I noticed that all of a sudden database startup started failing with an almost unlimited amount of core dump files being generated.
SQL*Plus: Release 188.8.131.52. (more...)
Want to learn more about the Internet of Things?
Are you attending Oracle OpenWorld 2016 or JavaOne 2016? Then you are in luck! Once again we have partnered with the Oracle Technology Network (OTN) team to give OOW16 and JavaOne attendees an IoT hands-on workshop.
We will provide a free* IoT Cloud Kit so you can get your feet wet on one of the hottest emerging technologies. You don’t have to be an experienced electronic engineer to (more...)
After I changed the log entries to log with e.message, I got the line:
Wed Sep 07 11:17:43 CEST 2016:INFO:JSchException Algorithm negotiation fail
Now I needed more information than that. But the hint is at least that there is a mismatch in the available cyphers client side verses server (more...)
But for files and especially SFTP its a little (more...)
Recently, I used Heroku to deploy a website in the great wide open!
In this blogpost I want to tell about my first steps using Heroku, including the rookie mistakes I made: so you don’t have to make them.
Heroku in a nutshell:
“Heroku is a cloud platform that lets companies build, deliver, monitor and scale apps”
You can deploy your NodeJS application (or Rails or..) there with a simple git push.
The app (more...)
For one of my projects I need my users to log in to an 3rd party api (in my case strava) using oauth2.0
OAuth2 in a nutshell:
Someone wants to (more...)
[12:18:01 PM] ---- Deployment started. ----
[12:18:01 PM] Target platform is (Weblogic 12.x).
[12:18:01 PM] Running dependency analysis...
[12:18:01 PM] Building...
[12:18:08 PM] Deploying profile...
[12:18:09 PM] Wrote Archive Module to D:\Projects\2016DWN\SOASuite\HRApplication\DWN_CdmHR\trunk\SOA\DWN_CdmHR\CDMHRDomainService\deploy\sca_CDMHRDomainService.jar
[12:18:18 PM] Deploying sca_CDMHRDomainService.jar to partition "default" on server SoaServer1 [http://darlin-vce-db.darwin-it. (more...)
Today in a question about Roles on Oracle Community Forums, the reference to this elaborate blog entry was given: Restricted View, by Antony Reynolds.
I think that blog (more...)
I used to spend most of my time — blogging and consulting alike — on data warehouse appliances and analytic DBMS. Now I’m barely involved with them. The most obvious reason is that there have been drastic changes in industry structure:
So I thought, let's do it from an Oracle Linux 7 VM, as root. But it turns out that Oracle linux did not support NTFS by default.
But with the trick in this link I managed to (more...)
One suggestion is to set the 'Invocation Timeout Seconds' under MyDomain->Configuration->General->Advanced to a value like 2. And 'Management Operation Timeout' under Preferences->Shared Preferences to a value like (more...)