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;

Oracle Financial Services Training Goes Digital! Access New Oracle Learning Subscriptions Today

Are you transitioning to Oracle Financial Services banking applications? Are you looking to enhance proficiency in setting up, managing and using your Oracle Financial Services applications?

Oracle now offers Oracle Learning Subscriptions to help you get the most out of your investment in Oracle Financial Services applications.

Here are 5 reasons why an Oracle Learning Subscription should interest you.

1. New Oracle Learning Subscriptions - Now Available

New powerful digital learning subscriptions are now available (more...)

Read Only Users and Database Performance

One of the questions we see being asked reasonably frequently is how to allow read only access to someone who wants to view database performance issues, using tools such as Real Time ADDM, ASH Analytics and so on. This is generally asked for someone like an application developer, who can use this information to identify performance issues in Production and then fix the root cause in their Development environments.

Well, that’s a reasonable question to (more...)

Mumbai version 3.1.1 available

Yes, it is still alive.🙂 Version 3.1.1 of Mumbai is available for download.

Mumbai served me well over the last months, so there were no updates for quite some time. However, it’s time to do at least some compatibilty fixes, especially in regards to 12c.

So here is the first shot which fixes some of the major compatibilty problems. I expect that there are more things to fix (and extend) regarding 12c and RAC (more...)

Wednesday at OpenWorld and JavaOne

Wednesday at the OTN Lounge and Java Hub have activities still in full swing. Have you visited the IoT Workshop in the OTN Lounge? Interact with your fellow attendees by getting your own wi-fi micro microcontroller and connect it to Oracle IoT Cloud Service. OTN is partnering with the AppsLab, the OAUX... [Read More]

4.2 Tweak, Working with Views

Someone said we should make the view source searchable, and that we should show any errors on a view. Actually, it might have been a few dozen of you. A reader reminded me that we actually implemented this in v4.2. The split editor trick, you know this one, right? Code Outline (adsbygoogle = window.adsbygoogle... [Read More]

Oracle Open World 2016 from a PeopleSofter point of view: Tuesday 20th

We are now at full steam in what regards PeopleSoft at Oracle Open World. As my jet lag gets better (today I woke up at 4.30am, quite an achievement), so does the announcements at the PeopleSoft specific sessions.

The day started with a general keynote facilitated by Safra Catz and Thomas Kurian. I have found the second part most interesting as it went deeper into the announcements made last Sunday by Larry Ellison. Compared (more...)

OOW16: Daily Digest – Wednesday, Sept 21

Hello to you on another beautiful morning from Oracle OpenWorld.

In case you missed the Oracle OpenWorld keynotes last two days, here's the on demand link.

Today's keynote is "Oracle Converged Infrastructure—On-Premises Solutions with Cloud Insurance" by Dave Donatelli, and "A Revolution in Compute and Data Management" by John Fowler and Juan Loaiza, 9:00 a.m.–10:15 a.m., at Moscone North, Hall D.  Live streaming is available for keynotes in case (more...)

Show report tooltip as notification

Last week I described a method to make the tooltip on information more accessible to the end user.

Here is how you could make the same information available to touchscreen users.

1) First step, as before, is to define the HTML Expression of the column to include the title tag.
In this case I also stored my row identifier as an extra data- attribute.
<span title="#RECENT_NOTE#" data-key="#ROW_KEY#">#MY_COLUMN#</span>

2a) Create a dynamic action on click (more...)

Show report tooltip as notification

Last week I described a method to make the tooltip on information more accessible to the end user.

Here is how you could make the same information available to touchscreen users.

1) First step, as before, is to define the HTML Expression of the column to include the title tag.
In this case I also stored my row identifier as an extra data- attribute.
<span title="#RECENT_NOTE#" data-key="#ROW_KEY#">#MY_COLUMN#</span>

2a) Create a dynamic action on click (more...)

Configure jobStatusRepository in Oracle Reports 12c

Within this blog post I will show you how to configure the Oracle Reports 12c jobStatusRepository against an Oracle Database.

Within Oracle Reports 12c a major change is, that within the jobStatusRepository configuration, we have now to use an entry in the Credential Store Facility (CSF).

At first create in your target database for the Reports Server Queue a user:

create user rwadmin identified by "Oracle12c" default tablespace users quota unlimited on users;
grant create (more...)

Oracle and Phemi Present: Big Data from the Trenches: The Researcher and Data Scientist Weigh-In

Oracle and Phemi Present: Big Data from the Trenches: The Researcher and Data Scientist Weigh-In will focus on two points of view regarding the implementation of big data in healthcare.

The data scientist and the researcher help will inform the attendees what they can expect in terms of obstacles & best practices.

Register today.

SOA & BPM Community Newsletter September 2016

Thanks for attending the PaaS Summer Camps and the Virtual Summer Camps 2016.

In case you could not make it to Lisbon, we will publish most of the training content at the community workspace (membership required).

In case you did not get a seat for the Virtual Summer Camps, we opened the registration for the autumn edition including a SOA 12c Bootcamp and a BPM Suite 12c Bootcamp both on-demand in October 2016.

To read (more...)

How to reinstate the old Primary as a Standby after Failover in #Oracle

You have done a failover to your Standby database so it becomes the new Primary. It may be possible to convert the old Primary into a Standby database now instead of having to do a time consuming duplicate again. The old Primary must have been running in flashback mode before the failover. The playground:

DGMGRL> show configuration;

Configuration - myconf

  Protection Mode: MaxAvailability
  Members:
  prima - Primary database
    physt - Physical standby database

Fast-Start Failover:  (more...)

The #1 Open Source Database is Now Available in Oracle Cloud!


We're very excited to announce the General Availability of Oracle MySQL Cloud Service!

The most comprehensive MySQL offering in the cloud that includes advanced features, tools and support. Oracle MySQL Cloud Service allows you to accelerate innovation and to rapidly, securely and cost-effectively develop & deploy modern applications powered by the world’s most popular open source database.

Built on the proven MySQL Enterprise Edition and powered by the Oracle Cloud, it provides a simple, automated, (more...)

Oracle NANVL Function with Examples

The Oracle NANVL function is useful when working with number values. Learn what it does and how to use it in this article. Purpose of the Oracle NANVL Function The NANVL function is used to return a different value if the specified value is NaN (not a number). It’s useful for floating-point numbers such as […]

I don’t like the Mediator by Luc Gorissen

clip_image002

Ok, so there you have it: I just don’t like the Mediator. I don’t really know why. But now that it’s in the open, let’s discuss it.

I often see a pattern where a composite with a synchronous operation is implemented with a Mediator and BPEL component:

I think that in most of these cases, it would be better to either leave out the Mediator component completely. Or replace it with a BPEL component that (more...)

Approximate Query Processing in 12c Release 2

Approximate Query Processing appears to be a major feature of Oracle Database 12c Release 2 SQL. In 12cR1 patchset 2 (12.1.0.2), we saw one approximate query function appear – APPROX_COUNT_DISTINCT to use instead of COUNT(DISTINCT). In 12.2 there are several APPROX functions introduced:   APPROX_COUNT_DISTINCT_DETAIL APPROX_COUNT_DISTINCT_AGG TO_APPROX_COUNT_DISTINCT APPROX_MEDIAN APPROX_PERCENTILE APPROX_PERCENTILE_DETAIL APPROX_PERCENTILE_AGG TO_APPROX_PERCENTILE According to Oracle […]

Community : Discussing the Meetup Format

I spent a bit of time with Liron Amitzi today brainstorming ideas about user group meetups and putting him in touch with a potential sponsor.

Since his move to Vancouver, Liron’s been involved with the user group there and he was asking for ideas about how to help promote it. I don’t claim to know much about this stuff, but I do see what others like PythianOracle Midlands and RedStackTech (#ClubOracle) have done (more...)

Oracle OpenWorld 2016 : Tuesday – Day 2

Day 2 started a little late for me. I was up early, but I logged in to work and had to do a few things. Once I had got through that I headed down to the conference…

On the way there I bumped into Ronald Bradford and we hit the exhibition hall together. We stopped by the SolarWinds stand and noticed a “Deploy Faster” sticker. Part of the promotion for the Girls Who Code Foundation. If you see one, take (more...)