Using Oracle 12c with Pivotal Cloud Foundry Applications

In this post I walk through what it would take to access Oracle 12c using a spring boot application deployed to Pivotal Cloud Foundry PCF all from my Macbook Pro. Of course this can be done outside of an isolated laptop like my Macbook Pro but handy while doing DEV/TEST and still being able to use Oracle 12c.

Requirements
  • Oracle 12c instance
  • PCFDev 
  • Git Client

1. First you will need a 12c Database and the (more...)

Oracle OpenWorld 2016 : Thursday – Day 4

And here we are. The last day of Oracle OpenWorld 2016…

The first session I went to was a panel session called “Thinking Clearly About Database Application Architecture” with Gerald Venzl, Bryn Llewellyn, Connor McDonald, Toon Koppelaars, Cary Millsap. The session started with an introduction by Toon, explaining how the thick database architecture model is provably superior to the thin database model, especially from a performance perspective. I am definintely in (more...)

NetFlix – Blockbuster Movies

I mean, in principle it’s not that special, being that the info is already on…

Oracle Open World 2016 from a PeopleSofter point of view: Thursday 22nd and Wrap Up

So Open World 2016 has come to an end. But before the curtains fell, there was still some activity and interesting PeopleSoft sessions to attend.

Reporting and Analytics

My day started with a session name Getting the most Out of PeopleSoft - Reporting and Analytics [CON7075] with the participation of Matthew Haavisto, Jody Schnell and Ramasimha Rangaraju.

Reporting has evolved a lot in the last few years, and not only in PeopleSoft. Gone are (more...)

Slides for OOW16 Session Preventing Bad SQLs

Uncategorized
| Sep 22, 2016
Thank you for coming to my session Preventing Bad SQLs at Oracle Open World despite being at lunchtime on the last day.

Congratulations to the winners of my book.

Download slides here http://bit.ly/2cGJqR7

Oracle 12.2 Cool New Features

As you know, Oracle Open World is over (for me at least), and one of the major topics there was Oracle 12cR2 (or 12.2). It looks like a really cool version, the downside is that is currently available on Oracle cloud only. We are all waiting for the on-premise release so we can install and … Continue reading Oracle 12.2 Cool New Features

Oak Table World 2016 Followup

The Oak Table network is a closed membership of about 100 technical scientists who have a passion for technology and the world around them.  These men and women, representing some of the brightest minds from each of their companies, are individuals who have built companies and major technical innovations.

Initially, much of their research and work was presented at Oracle Open World.  Over time, Oracle Open World welcomed (more...)

OBIEE12c – Upgrading to Version 12.2.1.1

INTRODUCTION

The new version of OBIEE 12c, 12.2.1.1 to be exact, is out, so let’s talk about it. It’s my intent that after reading this, you can expect some degree of comfort in regards to possibly doing this thing yourself (should you find yourself in just such a circumstance), but if not, feel free to drop us a line or give us a ring. It should be noted that Oracle documentation explicitly (more...)

Becky’s BI Apps Corner: OBIA 11.1.1.10.2 New Features Part 1 – Health Check & ETL Diagnostics

I have been working with BI Applications since OBIA switched to ODI in version 11.1.1.7.0. I have installed and worked with all of the 11.x versions using several different sources. This most recent version of OBIA may only be a Patch-Set release, but it has some new features that make it very compelling; ETL automatic error handling, Health Check, ETL Diagnostics, and built in Email notifications.

If you've been using (more...)

Oracle Open World 2016 from a PeopleSofter point of view: Wednesday 21st

We are reaching the end of Oracle Open World. Wednesday ended with the Appreciation Event which included the star appearances of Gwen Stefani and Sting. Both were really appreciated by the public, but I personally found Sting's performance just fantastic.


Anyway, let's live music behind before it clearly shows I don't have a clue about it. Wednesday was also a very intense day around PeopleSoft. I was able to attend very valuable sessions around different (more...)

Using H2 Console in development with Spring Boot then NOT when deployed to Pivotal Cloud Foundry

Frequently when developing Spring based applications, I will use the H2 in memory database during your development process. H2 ships with a web based database console, which you can use while your application is under development. It is a convenient way to view the tables created by Hibernate and run queries against the in memory database. In this post I show what is required to set this up as well as what it means to (more...)

Oracle NEW_TIME Function with Examples

In this article, I’ll explain what the NEW_TIME function does and show you some examples. Purpose of the Oracle NEW_TIME Function The NEW_TIME function converts a date from one timezone to another timezone.   Syntax The syntax of the NEW_TIME function is: NEW_TIME ( input_date, timezone1, timezone2 )   Parameters The parameters of the NEW_TIME […]

When would you use a normal table function?

Dear Patrick,

Last year I did a presentation on table functions at KScope. One of the questions I got was: ‘If pipelined table functions provide their results faster, why would you want to use a normal table function?’ I couldn’t come up with the answer then, maybe you can help?

Erik van Roon

Dear Erik,

Let’s start with explaining a bit what table functions are. Table Functions are functions that return a collection of (more...)

Oracle Midlands : Event #17

Don’t forget Oracle Midlands Event #17 next week!

om17

I don’t know about you, but I would like to know what Oracle have been up to. There has been very little in the way of publicity from them recently… 🙂

If you live near, please show your support for the event and come along. It’s free thanks to the sponsorship by RedStackTech.

Cheers

Tim…


Oracle Midlands : Event #17 was first posted on September 22, 2016 at 7:41 am.
©2012 (more...)

Oracle OpenWorld 2016 : Wednesday – Day 3

I started the day by meeting up with a bunch of people at the Dbvisit breakfast. This has become a regular event over the last few years. Followers of the blog know I like the Dbvisit folks and they tend to attract people I find fun and interesting. After food, loads of coffee and interesting conversation, it was time to head across to the conference.

I bumped into Liron and Zohar at the OTN lounge and walked over with them to watch Connor (more...)

Oracle Database 12.2 New Features (Part I) – Application Express

As you know, Oracle Open World 2016 conferences continue at San Francisco (September 18-22, 2016).

At keynote Session, Larry Ellison (CTO of Oracle Corporation) annoucemented the Oracle Database Exadata Express Cloud Service on new database version 12.2. Here is released cloud documentation

There have very interesting little guide for new features of Oracle Database 12c Release 2.
Why littel , because it is not all features of Oracle Database 12c Release 2, have more interesting (more...)

The simple fix to date queries

We had question in the OpenWorld panel about why queries on date columns are “always slow”.  Well….they aren’t Smile but here’s a common cause of that misconception.

Let’s create a table as a copy of DBA_OBJECTS, and index the CREATED column (which is  a date).


SQL> create table t as
  2  select *
  3  from dba_objects;

Table created.

SQL>
SQL> create index t_ix on t ( created );

Index created.

The problems start when (more...)

Creating interactive graphics in APEX with Raphaël (RaphaelJS)

Some of you may know of my personal interest for SVG interaction in APEX applications. I have been working with a JavaScript library called "Raphaël" (RaphaelJS, raphael.js or just raphael) for a while now. It is an amazing plugin to create all kind of customized business solutions. But before I show you how I have used Raphaël I tell you how I came to the technology and what happened in the last few years.


(more...)

OOW16

I didn’t have a lot of time to blog during OOW16, so here is the summary of the last 4 days here. On the sessions side I didn’t go to a lot of them (as expected). I managed to miss my friends sessions (Zohar Elkayam and Ami Aharonivich) I did go to an ODA hands … Continue reading OOW16

Flashback database – dont forget the standby

Today an  application team had a problem with a production system and they wanted the database restored to a point a couple of days ago. It is a configuration management system and they figured they could lose any changes . Their call.

I did all the good things

  • Checked we had a change in place
  • Blacked out primary and standby in OEM
  • Checked flashback was on  –
select flashback_on from v$database;