The neo-MUD tunnel for OBIEE 11g RPD deployment

Ok call me a geek for writing it on new year's eve, I dont care :-P. I can tell you that this blog is totally worth it. Let's get right into it.
We know that EM can be used for deployment but we had a requirement to maintain a log every time a deployment is done so that we can keep a track of the changes been done to the RPD.
I developed the  Multi (more...)

Happy New Year

Wish every one a Happy New Year.

The Future of Forms – DOAG Forms Day in Berlin, 18.01.2017

Today, and it's the last day of the old year, I had to announce, that the German Oracle User Group (DOAG) will have a whole day of forms-talks:

DOAG Forms-Day 2017

Come and share your Forms 12c experience with the community.



I wish all of you a good start in the new year
Gerd



Happy New Year 2017

Wishing everyone a very happy and prosperous 2017. May all your dreams come true and …..

motivational-quotes-2

Work Hard, Stay Positive !!

Cheers !!


Filed under: Oracle

"ORA-16047 – DGID mismatch between destination setting and target database" while configuring dataguard.

While setting up dataguard configuration you may encounter ORA-16047 - DGID mismatch between destination setting and target database.

From alert.log on primary database:

******************************************************************
LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_2
******************************************************************
Sat Dec 31 08:29:30 2016
FAL[server, ARC3]: Error 16047 creating remote archivelog file 'sauxmes'
FAL[server, ARC3]: FAL archive failed, see trace file.
ARCH: FAL archive failed. Archiver continuing
ORACLE Instance auxmes - Archival Error. Archiver continuing.
Error 16047 for archive log file (more...)

SLOB 2.3 Data Loading Failed? Here’s a Quick Diagnosis Tip.

The upcoming SLOB 2.4 release will bring improved data loading error handling. While still using SLOB 2.3, users can suffer data loading failures that may appear–on the surface–to be difficult to diagnose.

Before I continue, I should point out that the most common data loading failure with SLOB in pre-2.4 releases is the concurrent data loading phase suffering lack of sort space in TEMP. To that end, here is an example of (more...)

Fixing Popular Posts Margin on Blogger

I use the Blogger platform for this blog, and I recently added the "Popular Posts" widget to the sidebar. Unfortunately it did not display correctly, with the first character or two of each blog post title being lost and chopped off, as if the whole thing had been shifted to the left for some reason. Here is how I fixed it to display properly.

After a lot of reading up on HTML and (more...)

DOAG.tv Interviews (German)

In den letzten Wochen sind zwei Interviews veröffentlicht worden, die die DOAG mit mir im Rahmen der jährlichen DOAG Konferenz in Nürnberg durchgeführt hat.

Das erste stammt noch von der DOAG Konferenz 2015 und bezieht sich auf meinen damaligen Vortrag über die neuen Parallel Execution Features von Oracle 12c:

DOAG.tv Interview 2015

Das zweite ist von der diesjährigen DOAG Konferenz und bezieht sich auf meine Performance-Tests der Oracle Database Cloud und dem dazugehörigen Vortrag:

(more...)

“U” entries in MLOG$

Recently in a discussion with colleague, on what entries do MLOG$ have, the following was agreed to :-

1. “I” for insert
2. “D” for delete
3. “D” + “I” for update.

Along with the above entries, you might notice “U” also. The “U” entry is for update. But then, on what condition do we get “U” and when do we get “D” and “I” entries.

I have used “EMP” table as master table in (more...)

Enabling Flashback – Be Cautions

Enabling flashback on 11.2.0.4 database can take minutes and cause multiple database wait events degrading database performance.

On a quite busy system, during the low peak hours, I tried to enable flashback on 11.2.0.4.6 version database and multiple sessions waited on

1. buffer exterminate
2. enq: SQ – contention
3. latch: cbc contention
4. SGA: allocation forcing component growth

PRAKANAN_DBA@:1> show parameter sga_target
 
NAME                           TYPE        VALUE
------------------------------ -----------  (more...)

Primary Storage, Snapshots, Databases, Backup, and Archival.

Data in the enterprise comes in many forms. Simple flat files, transactional databases, scratch files, complex binary blobs, encrypted files, and whole block devices, and filesystem metadata. Simple flat files, such as documents, images, application and operating system files are by far the easiest to manage. These files can simply be scanned for access time to be sorted and managed for backup and archival. Some systems can even transparently symlink these files to other locations (more...)

Dealing with a global increase in CPU usage

Imagine the following situation: you are supporting an application with many different components and a busy release cycle. One a Monday morning you find that quite a few processes in the database now run slower. Very soon, you find out that the slowdown is due to increased CPU time, but where to move from there? There is no evidence that CPU is too stressed, causing CPU queuing. You cannot isolate the problem to any specific PL/SQL (more...)

Oracle Apex 5.1 is here

Uncategorized
| Dec 21, 2016
Oracle Apex 5.1 is now production and available for download.

eProseed Oracle Open World 2016 debrief – Oracle Database & Oracle Management Cloud

For people interested, here the slide desks used internally to debrief my colleagues regarding Oracle…

Oracle Database 12.2.0.1 – JSON and the In-Memory Database

Here the presentation slide deck (100+) used during the oGH Dutch Usergroup session and (partially…

Oracle SOA Suite 12c, Unable to get Metadata Manager for DVM

Little reminder :

folder_structure

bpel file uses the next :

<from>ora:doXSLTransformForDoc("../Transformations/transfBewaarNotificatie.xsl", $inputVariable.notificatie)</from>

xsl file used to be using the next :

<xsl:variable name="dossier" select="dvm:lookupValue ('../Dvm/actie.dvm', 'sourceActie', /ns0:notificatie/ns0:entiteit, 'targetActie', 'ongeldige actie mapping' )"/>

this will fail (the location of the dvm file isn’t relative to both the .bpel file and the .xsl file), correct path to the dvm file will be

<xsl:variable name="dossier" select="dvm:lookupValue ('Dvm/actie.dvm', 'sourceActie', /ns0:notificatie/ns0:actie, 'targetActie', 'ongeldige actie mapping'  (more...)

SVG in APEX: Best Practices

In the last 8 month I was working on a new version of my SVG (Raphaël) example application. Of course I have a job (freelancer) and I have children. So the time to spend was diminished on only a few hours per week mostly on my way to work.
Some of the results were presented at the Swedish Oracle meetup in Summer '16. But the final application was made for DOAG 2016.

What leads me (more...)

No, being wary doesn’t hurt Java. A comment about Java licensing.

Screenshot from the Oracle Website (source)
So. Oracle want's to make money from Java. And The Register published a very polarising piece with a super catchy title about it. According to their sources, "Oracle is massively ramping up audits of Java customers it claims are in breach of its licences". While the Twitter-verse went ballistic about people criticising Oracle's behaviour, I want to take a minute to recap, why I am against this (more...)

Oracle Mediator, the-always-give-response-pattern by using the Echo-reply

In my usecase i subscribed to an eventbus solution (rabbitmq with some custom code to be able to publish to consumers based on the soap protocol).

The backend system which generated the notications can generate the next type of events :

— employeename got changed

<nce:notification xmlns:nce="http://my.notifications" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
	<nce:entity>EMPLOYEE</nce:entity>
	<nce:subentity>EMPLOYEE</nce:subentity>
</nce:notification>

— employee contactaddress got changed

<nce:notification xmlns:nce="http://my.notifications" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
	<nce:entity>EMPLOYEE</nce:entity>
	<nce:subentity>ADDRESS</nce:subentity>
</nce:notification>

The current subscription mechanism only allows me (more...)

Creating a RAC cluster using Ansible (part 2)

In my previous 2 blogposts i explained how to setup a Vagrantfile that deploys 2 virtualbox machines that can be used as a basis for a RAC cluster and how you could use Ansible to deploy RAC on those VM’s. In this post i want to dive a bit deeper into how i setup Ansible and why, keep in mind that this just one way of doing this.

The Github repository containing all the files (more...)