VirtualBox with SOA, BPM, OSB and BAM in 33 minutes by Peter van Nes

clip_image002

The Oracle Quick Start installers for Developers are great for probably many developers, but they are limited. Shutting down (or crashing of) JDeveloper will shutdown the domain and there are separate Quick Start installers for SOA and BPM suite. When installing a SOA or BPM environment for development or research purposes i prefer an environment which is more close to a production configuration. Setting up an new environment can take some time when you have (more...)

Learning, Career Development and Mentoring

glasses-272399_1280-smallYesterday I received pretty much the same question from three different people, or maybe one person pretending to be three people. 🙂 The questions went something like this.

I want to get good at RAC. Will you teach me?

One of the three suggested I might want to use my Sundays teaching them. 🙂

I’m not mad at people for asking this and I don’t want to offend anyone by mentioning this, but it goes back (more...)

New OA Framework 12.2.4 Update 11 Now Available

Web-based content in Oracle E-Business Suite 12 runs on the Oracle Application Framework (OAF or "OA Framework") user interface libraries and infrastructure.   Since the release of Oracle E-Business Suite 12.2 in 2013, we have released several updates to Oracle Application Framework to fix performance, security, and stability issues. 

These updates are provided in cumulative Release Update Packs, and cumulative Bundle Patches that can be applied on top of the Release Update Pack. (more...)

DB_LINK w/o tnsnames.ora

A question popped up, which I thought was interesting. How can you create a DB_LINK in Oracle without the DBA changing the tnsnames.ora file? It’s actually quite easy, especially if the DBA sets the TNS address name the same as the instance’s service name or in older databases SID value.

  1. Do the following with the tnsping utility:
    tnsping mohawk

    It should return this when the server’s hostname is mohawk and domain name is techtinker. (more...)

Why Choose Oracle University for IT Training & Certification?

Career Growth: our training courses are designed to teach you skills that directly align with real-life IT jobs; empower yourself with in demand skills in a competitive job market.

Salary Advancement: Certification magazine found that Oracle Certified Professionals earn higher salaries when compared to other DBA or Developer professionals. Earning this well-respected IT credential could make a positive impact on your wallet.

Expert Instruction: learn Oracle from the same team involved in Oracle product development. (more...)

Mix a Little Pleasure with Business at Oracle OpenWorld

Time-out. Time for me.

A Guest Post By Dr. Patricia Dues, president of the OAUG

With such a jam-packed agenda full of quality sessions at Oracle OpenWorld, it’s hard to imagine having any down time to escape the confines of the convention center and the overload of information assailing your brain. But remember, you are in beautiful San Francisco, and it’s important to take a moment to rejuvenate. Here are three, quick time-outs to (more...)

OPatch 12c: emocmrsp gone missing

Last week, the quarterly PSU came out, and just a few hours later I tried to apply it to a Oracle Restart + DB system under OL 6.7. This would have run smoothly if it wasn’t for the fact that this was the first patch for this system and therefore I needed to create a OCM […]

TLS 1.2 Certified with E-Business Suite 12.1

I'm pleased to announce that Oracle E-Business Suite 12.1 inbound, outbound, and loopback connections are now certified with TLS 1.2, 1.1, and 1.0. If you have not already migrated from SSL to TLS, you should begin planning the migration for your environment. 

For more information on patching and configuration requirements when migrating to TLS 1.2 from TLS 1.0 or SSL or enabling TLS for the first time, (more...)

Integration with new Oracle Integration Cloud Service (ICS) by ec4u

clip_image002Since a few years cloud computing has become more and more popular. The main types of cloud computing are Infrastructure as a Service (IaaS), Platform as a Service (PaaS) and Software as a Service (SaaS). In the past, several subareas have been established in the market and pushed by research companies. One subarea is Integration PaaS (IPaaS)  and a variety of vendors have provided solutions. One advantage of IPaaS solutions is the simplified integration. Furthermore, (more...)

Lost Concatenation

This note models one feature of a problem that came from a client site recently from a system running 12.1.0.2 – a possible bug in the way the optimizer handles a multi-column in-list that can lead to extremely bad cardinality estimates.

The original query was a simple three table join which produced a bad plan with extremely bad cardinality estimates; there was, however, a type-mismatch in one of the predicates (of the (more...)

What’s new in Oracle BPM and Process Cloud Service? SOA & BPM Partner Community Webcast – tormorrow July 26th 2016

image


Attend our July edition of the SOA & BPM Partner Community Webcast live on July 26th 2016 at 16:00 CET.

What’s new in Oracle BPM and Process Cloud Service? Digital Process Apps made Simple

During this session, we will be joined by Sujan Balachandran, Product Manager for Oracle BPM and Process Cloud Service (PCS). The session will cover

· Empower Business User using BPM Composer

· What is Business Architecture? How can it help (more...)

EBS Release 12.x certified with Safari 9 on Apple OS X

Apple logoOracle E-Business Suite Release 12.1.3 and 12.2.4 or higher are now certified with Apple Mac OS X with the following desktop configurations:
  • Mac OS X 10.11 ("El Capitan" version 10.11.5 or later 10.11 updates)
  • Mac OS X 10.10 ("Yosemite" version 10.10.2 or later 10.10 updates)
  • Safari version 9 (9.1.1 or later 9.x updates)
  • Oracle JRE 8 plugin (1.8.0_91 (more...)

ICS Integration Patterns (Part 1 of 3): Map My Data by Antonis Antoniou

clip_image001

Oracle Integration Cloud Service (ICS) is another powerful yet simple Cloud platform offering by Oracle that simplifies the development of cloud and hybrid integrations (applications in the cloud and on premises).
The entire integration development and operational lifecycle is managed through a web based service console offering a point and click integration and monitoring experience without having to write a single line of code.
Furthermore Oracle ICS supports various industry standards like SOAP and REST (more...)

How to Find the Row That Has the Maximum Value for a Column in Oracle

Do you need to find the data for a row which has the maximum value for a specific column in Oracle? Learn how to do it and see some alternative answers in this article. The Table Structure Let’s say you have a table called sales_volume that looks like this: CITY START_DATE SALES El Paso 27/May/15 […]

SOA CS –> API Manager Flavour by Niall Commiskey

clip_image002This is essentially a revamp of a previous post on API Manager,
albeit for the SOA CS environment.
You can read the original post here
I created an API Manager instance on SOA CS -

Let's look at the Fusion Middleware Control -
Here we can create API Manager users.
I have covered this is a previous API Manager post, but to save you time,
here are the screenshots - Read the complete article here.

(more...)

Dot Qualify Everything?

Troubleshooting ORA-02049: timeout: distributed transaction waiting for lock

Controlling Connections Established by Database Links

Tracing can be done using – ALTER SYSTEM SET EVENTS ‘2049 trace name ERRORSTACK level 3’;

Nice note from MOS.

How to Obtain a System State Trace BEFORE the Error ORA-2049 Occurs, While Still Experiencing the Contention (Doc ID 789517.1)

Commit after select from dblink – blocking lock.

Session 1:
++++++++++
04:44:51 ARROW:(DEMO@leo):PRIMARY>
04:45:30 ARROW:(DEMO@leo):PRIMARY> select name from v$pdbs@mdinh_april;

NAME
------------------------------
APRIL

Elapsed: 00:00:00.01
04:45:36 ARROW:(DEMO@leo):PRIMARY> commit;

Commit  (more...)

https://paascommunity.com/2016/07/23/five-ways-cloud-based-integration-is-driving-innovation-whitepaper/

clip_image001With businesses adopting more and more cloud applications, mobile apps, and devices, integration has never been more important. Integrating these apps and tools with the rest of the systems is the key to a connected enterprise— one that supports real-time responsiveness, instant collaboration, and streamlined innovation. To keep up with these new integration demands, a new breed of solution has emerged—cloud-based integration platforms (also called integration platform as a service, or iPaaS for short). For (more...)

Investigating kernel dives using ftrace.

This blogpost is about using the linux ftrace kernel facility. If you are familiar with ftrace and specifically the function_graph tracer, you might already be aware of this functionality. This is Linux specific, and this facility is at least available in kernel 2.6.39 (Oracle’s UEK2 kernel).

What is a ‘kernel dive’? Whenever a process is running, it should mostly be in ‘user mode’, executing the program it is supposed to run. However, during (more...)

VirtualBox 5.1.2

You know a major new release is going to be rapidly followed by a bunch of fixes, so about 9 days after the release of VirtualBox 5.1 we now have VirtualBox 5.1.2.

I have got it running on my Windows 7 desktop and work and it seems fine. I’ll try OSX El Crapitan and Oracle Linux 6 hosts when I get home.

Cheers

Tim…


VirtualBox 5.1.2 was first posted on July (more...)