AMIS, Data Driven Blog – Oracle & Microsoft Azure
Getting value from IoT, Integration and Data Analytics
Everything that is Oracle related.
A client of mine was busy correcting one of his development streets and therefore the NLS charactersets of about 10 11.2.0.4 EE databases had to be changed. Most of the databases were originally configured with WE8ISO8859P15, others with WE8ISO8859P1 and all of them had to get WE8MSWIN1252. Some of them […]
0 
0 Recently we added a great new feature to the ADF Performance Monitor: network and browser load time information. Now you know exactly every end-user experience of your ADF application, in real-time. You can quickly resolve any performance bottlenecks with this end-to-end visibility. You can even drill down into an individual user to […]
0 0 Deleting some rows or tens of millions of rows from an Oracle database should be treated in a completely different fashion. Though the delete itself is technically the same, maintaining indexes and validating constraints may have such a time and resource consuming influence that a vast amount of undo and […]
0 0 Question: We have customers who want to work with different database schemas and we want to determine dynamically – depending on a choice during or after login – which database schema the application in a given session should use. Is it possible to set this up in the database? Answer: […]
0 0 or A closer look on database hosts The last couple of years quite a few organizations had a difficult time and internal costs where a main focal point was to save money. License costs was one thing where many IT-managers put their question marks and so often the decision was […]
0 0 Lately several people asked me how they should go about with upgrading their OVM 3.2.x environment to 3.3.x They have the backend repository running on an Oracle Database, which is no longer supported. In release 3.3, only MySQL is supported as a backend repository database. They were wondering how the […]
0 0 Recently I found myself in the unique position of having access to the beta version of the Oracle Cloud to get a glimpse at the future as Oracle sees it. This blog describes my personal experience and does not necessarily reflect Oracle’s point of view. That said, the cooperation with […]
0 0 Recently I came across the situation where I knew for a fact that my sessions to the database were dead because I pulled the power plug out of my application server for a failover test. But the sessions stayed visible in the database and kept their locks therefore the failover failed. Now how […]
0 0 On Friday, December 19, AMIS organises a special XMas-terclass on SOA Suite 12. SOA Suite 12c (June 2014) was a major release for Oracle’s flagship integration product. This release introduces new functionality, higher developer productivity, more robust run-time scalability and performance. 12c brings together development and administration of Service Bus and […]
0 0 Images are heavily used in Mobile apps. For instance a list that contains employees usually shows the images of these employees. This works well when you have a WIFI connection, but what if you are using slower connections ? If you look at a mobile twitter app you will see […]
0 0 When Oracle Exalogic is delivered in you data center and you implemented Exalogic as a virtual platform, the Exalogic Guest Base Template (EGBT) is based on Oracle Linux 5.8. On Exalogic you can update the template to Oracle Linux 5.10. As of 21 october the new Exalogic base template is […]
0 0 One of the new announcements on OpenWorld 2014 is the generic Alta UI. The Oracle product teams have worked hard to apply this new UI to all their products. This new interface theme is the result of Oracles efforts towards a more usable and comprehensible User Experience by the Oracle […]
0 0 This article does not necessarily discuss the big themes and major stories of Oracle OpenWorld 2014. It does mention a number of facts that I discovered, overheard, observed or otherwise found out about during last week’s conference. They are not necessarily from formal Oracle sources, they have have been part […]
0 0 Oracle OpenWorld 2014 is over. Just under a week, full to the brim with information, events, people, energy, plans, hopes and expectations. I have learned many, many things. Small things, important facts, huge insights and many great people. In this article, I will attempt to sum up the largest themes […]
0 0 Doing a FTP-job with PL/SQL is not difficult. A basic implementation of RFC 959 can be written in a few hundred lines. See for instance ORACLE-BASE, How to FTP with Oracle PL/SQL or Oracle FAQ’s But what if you want to secure your FTP transmission. Google doesn’t find any pure […]
0 0 Datum donderdag 16 oktober Tijd 16.30 – 21.00 Kosten gratis AMIS organiseert voor het negende achtereenvolgende jaar de Oracle OpenWorld & JavaOne Review bijeenkomst, waarin uitgebreid verslag wordt gedaan van deze conferenties, die van 28 september tot en met 4 oktober […]
0 0 A couple of months ago one of my customers had a failed data ware house report. There was a ORA-12592 (TNS) error message generated. I turned out not to be the only TNS error. During a couple of weeks similar TNS-errors were generated. Not only the ORA-12592 error but also […]
0 0 In those old days when there was the exp utility we made a time consistent export dump by using the consistent=y parameter. But today, in fact a couple of years already, we mostly use the expdp datapump utility. How should we make a time consistent export using datapump? For that […]
0 0 In this article I will try to explain how to monitor your Dell Raid Controller with Cloud Control when running Oracle Virtual server 3.x (OVS3.x). Some time ago a physical drive broke down on one of our Dell PowerEdge Servers. Not causing any problem because it was configured in a […]
0 0 Once you are able to show the xml version of the alert log as data in database table Alert_XML, it would be nice to checkout the errors with accompanying timestamps from within view Alert_XML_Errors. Like this, with the help of 2 types and a pipelined function. And checkout the errors […]
0 0 By mapping an external table to some text file, you can view the file contents as if it were data in a database table. External tables are available since Oracle 9i Database, and from Oracle 11gR2 Database on, it is even possible to do some inline preprocessing on the file. […]
0 0 A TNS error at night… Sometime ago my data warehouse colleague came to me with a TNS error. At night times he runs his batch jobs in order to update his data warehouse. That night one of his jobs did not run properly and generated an ORA-12592 error. He had […]
0 0 Have you ever wondered why it takes a century to completely refresh your materialized view? I did, so I did some testing. Recently I was asked to support a customer whose database was extremely slow. As it turned out, some indexes had been created on a materialized view and that […]
0 0 Vanaf 28 september vindt in San Francisco de Oracle OpenWorld (OOW) conferentie plaats: hét evenement waar Oracle haar productstrategie uit de doeken doet en waar Oracle specialisten van over de hele wereld ervaringen uitwisselen. Tegelijk met Oracle OpenWorld wordt ook de JavaOne conferentie georganiseerd, het trefpunt voor de wereldwijde Java […]
0 0 In my recent post I already mentioned it a little bit: Integrating your manual Data Guard Broker configuration in OEM Cloud Control can become a sort of climbing a Mountain. And it doesn’t have to be. But first a short description of the situation. I have a working Data Guard broker […]
0 0 Vanaf 28 september vindt in San Francisco de Oracle OpenWorld (OOW) conferentie plaats: hét evenement waar Oracle haar productstrategie uit de doeken doet en waar Oracle specialisten van over de hele wereld ervaringen uitwisselen. Tegelijk met Oracle OpenWorld wordt ook de JavaOne conferentie georganiseerd, het trefpunt voor de wereldwijde Java […]
0 0 If your company is preferring Microsoft Active Directory as a source of truth (or at least you´re trying to) you should be using the AD as source for the user accounts in Cloud Control. The advantages are obvious: Control the validity of accounts in one single place, no different login’s […]
0 0 I am currently attending the OUGF 2014 Harmony Conference in a beautiful setting on a Finnish lakeside. This conference has a great line up in terms of speakers and sessions – truly impressive. It is a two day event with 6 parallel tracks – complemented with sauna, camping and pretty […]
0 0 One of my customers ( Oracle Database 11gR2 on LINUX ) never noticed the Oracle software LUN filling up until a “df -h” reported 97% used, wondered why, and of course wanted it to be solved asap. Well, after some investigation I found the adump directory to be the problem. […]
0 0 Overview of table functions Table functions are functions that produce a collection or rows (either a nested table or a varray) that can be queried like a physical database table. You use a table function like the name of a database table, in the FROM clause of a query. The […]
0 0 On Friday 7th of March, Bob Rubart interviewed both Jeremy Ashley and Lucas Jellema about trends in User Experience, the consequences of these trends – both in terms of opportunities as well as challenges – and the reasons why the UX Expo event on March 18th at AMIS HQ (Nieuwegein, […]
0 0 In a recent post I have introduced the key concepts in Adaptive Case Management (ACM). In the article you are reading now, I want to show an example of a specific case. This example should provide some clarity on exactly how the core aspects of a case are specified and […]
0 0 My introduction into the world of adaptive case management (ACM) feels like a huge relief. Without having to give up the benefits from structure and organization, ACM allows me to cater for the reality of the world in terms of exceptions, variations and the responsibility of experts to make decisions. […]
0 0 Few days ago I had to install Oracle Enterprise Manager 12 on a fresh installed Oracle Linux 64 bit environment. OS was installed from Oracle supplied template, so this should be an easy going, not….? After checking package dependencies from the installation manual (all confirmed) we started the installer. I […]
0 0 This article is contributed by our guest writer Vivek Acharya. Vivek is an Oracle Consultant working as a Professional Freelancer. He has been in the Design, Development, consulting and Architect world for approximately seven years working in Oracle Practice at IBM,HP,Zensar. He is an Oracle Certified Expert as Oracle Fusion-SOA […]
0 0 This post is intended to be a dummy guide, best practices, or whatever you call it… about setting up a network while working with virtual boxes on a desk- or laptop. I was setting up a virtual box environment with several Virtual Boxes on my laptop, and as I’m not […]
0 0 During one of the bi-weekly ADF knowledge sessions I organized at a customer one of the questions that popped up was how the inputparameters on taskflows worked. People got really confused with what to enter and where. In this blog post I’d like to outline the basics of what to […]
0 0 Oracle wants to lead in User Experience. Plain and simple. To that end, it has established the Applications User Experience team (back in 2007) – a relatively independent team within Oracle that explores all kinds of UX options, conceptual and technology wise, and translates them into guidelines, templates, buildings blocks […]
0 0 In the past few hours, Douwe Pieter van den Bos released the second issue of OTech Magazine to the world. This magazine contains 17 articles from expert authors around the [Oracle] world, covering a wide range of topics. The table of contents includes articles, BPM and Case Management, WebCenter, Access […]
0 0 The UK Oracle User group (UKOUG) held their technology conference 2013 in Manchester. Wilfred van der Deijl and Richard Olrichs had a very interesting presentation about extending the standard audit framework build in JDeveloper. The standard audit framework build in JDeveloper is a powerfull tool for you to check your […]
0 0 
