AMIS, Data Driven Blog – Oracle & Microsoft Azure
Getting value from IoT, Integration and Data Analytics
Everything that is Oracle related.
preparation for migrating data to Oracle Virtual Private Database Introduction Recently I was part of a team involved in the preparation of migration data belonging to multiple business units into a single Oracle 19c database with Virtual Private Database (VPD). The VPD solution is used for the virtual separation […]
0 
0 Since we provide support for several clients in OCI, we regularly need to login into different OCI-tenancies. How nice would it be to have Single Sign-On (SSO) functionality between these different customer environments. Just 1 credential for all environments, granting and revoking access a lot easier. Also no need to […]
0 0 Oracle VM is end-of-life and is, since March 2021, in extended support1. In looking for a replacement hypervisor AMIS has turned to KVM. Oracle itself also uses KVM, albeit its own brand of KVM, OLKVM, in Oracle Cloud and on the new versions of its Oracle Database Appliance. Topped with […]
0 0 I hear this aspiration from a growing number of organizations. Sometimes as a quite literal question. This however is merely half of a wish. Apparently, organizations want to quite with one thing — but have not yet stipulated what they desire instead. What is the objective that is pursued here? […]
0 0 Oracle has two main pillars on which its (future) business rests – dixit Larry Ellison: Oracle Cloud Infrastructure (including the Autonomous Database) and SaaS. In this article, I will relate some of the key announcement from Oracle regarding the business applications. It is useful to realize that Oracle’s portfolio of […]
0 0 July 2018 saw another edition of the Oracle Developers’ tour through India, called Yatra. In just over two weeks, seven cities participated in this tour – with each city hosting a one day mini-conference (three of four parallel tracks). Organized by many volunteers from the local chapters of the All […]
0 0 The answer to using Java Management Extensions(JMX) within Oracle Enterprise Manager Cloud Control is using Metric Extensions. Metric extensions provide you with the ability to extend Oracle’s monitoring capabilities. I will show you how to create an extension to monitor a WebLogic Messaging Bridge. You can use other methods to […]
0 0 Recapitulation on how to install the Oracle Integration Cloud on premises connectivity agent Recently (april 2018) I gained access to the new Oracle Integration Cloud (OIC), version 18.1.3.180112.1616-762, and wanted to make an integration connection to an on-premise database. For this purpose, an on premise connectivity agent needs to be […]
0 0 Upgrading to Dbvisit Standby 8.0.x Dbvisit provides upgrade documentation which is detailed and in principle correct but only describes the upgrade process from the viewpoint of an installation on a single host. I upgraded Dbvisit Standby at a customer’s site with Dbvisit Standby in a running configuration with several hosts […]
0 0 or If you want to get rid of stuff, you can always do a good spring-cleaning. Or you can do what I do. Move. – Ellen DeGeneres In order to prepare for a network reorganization we needed to move our current Oracle Enterprise Manager machine into another network segment. So […]
0 0 Watch Keynotes on YouTube using these links: Larry Ellison (Sunday Oct 1st) – https://www.youtube.com/watch?v=HEupUSSSEBo Dave Donatelli (Tuesday Oct 3rd) – https://www.youtube.com/watch?v=irvNYpCopA8 Thomas Kurian (Tuesday Oct 3rd) – https://www.youtube.com/watch?v=cef7C2uiDTM Larry Ellison (Tuesday Oct 3rd) – https://www.youtube.com/watch?v=faKWViY6zEk&t=6s SuiteConnect – Evan Goldberg (Wednesday Oct 4th) – https://www.youtube.com/watch?v=pURoDocJW1Y JavaOne Keynote (Monday Oct 2nd) – […]
0 0 I always like to know what is installed in the servers that I need to use for databases or Weblogic installs. Whether it is in the Oracle Cloud or in any other Cloud. One way to know is to build your own image that will be used to start your […]
0 0 While I prefer a “loosely coupled architecture” for replication between Oracle and SQL Server, sometimes a direct (database) link cannot be avoided. By using DBMS_HS_PASSTHROUGH for data extraction the 2 other ETL processes (transformation and load) can be configured and administered with more flexibility, providing an almost acceptable level of […]
0 0 At a recent customer install, I was faced with configuring Oracle Traffic Director (OTD) 12.2.1.2.0 Webgate with Oracle Access Manager. Deploying Webgate on OD 12c is very well described in the documentation. See A Configuring OAM Agent (WebGate) for Oracle Traffic Director 12.2.1.2 There is however a flaw in the […]
0 0 Recently, while migrating AIX 11gR2 Databases to Oracle Linux 12cR1 on an ODA X5-2, our setup of Sequence Replication by Oracle Golden Gate appeared to be faulty. The target side sequences were not automatically incremented. The problem came to light during the migration of acceptance databases, and under some time […]
0 0 So here it is Oracle announces a license audit, some urgency kicks in and this familiar but also really serious question comes down from management: “Are we using any unlicensed database features“. The seriousness is quite understandable, because if so, the company can look forward to some negotiations with Oracle […]
0 0 If you are anything like me you will have multiple virtualboxes running on your system. Sometimes you might want to run a copy of a virtualbox for different purposes. Like running an Oracle 11 Devdays instance as test environment but also running the same vbox for customer testing. If you […]
0 0 This is how I dump data from an Oracle Database (tested on 8i,9i,10g,11g,12c) to a delimited ascii file: Next to the query and the generated filename the Dump_Delimited function takes another 6 parameters, each one with a default value. Check out the PL/SQL, and BTW… the basics for this code […]
0 0 Oracle dbms_datapump provides a parallel option for exports and imports, but some objects cannot be processed in this mode. In a migration project from AIX 11gR2 to ODA X5-2 ( OL 5.9 ) 12c that included an initial load for Golden Gate, I had to deal with one of those […]
0 0 THREADED_EXECUTION Threaded_Execution is an Oracle Database 12c feature aiming to reduce the number of Oracle processes on LINUX. After setting parameter THREADED_EXECUTION on TRUE and a database bounce, most of the background processes are threads within just 6 Oracle processes, where more than 60 processes existed before the bounce. And […]
0 0 Creating or modifying an Oracle Database user password can be done by using any standard password generator you can find on the WEB. But I wanted a password to comply to “ora12c_strong_verify_function”, and this isn’t as easy to generate as you might expect. Though most generators provide options to include […]
0 0 Recently (October 2016) I had the opportunity to attend an Oracle Compute Cloud workshop that was very interesting. As a side effect I got access to the Cloud for a month thus I could experiment with the Cloud outside the workshop as well. I’ve had some experience with Amazon EC2 […]
0 0 Building up a public cloud is quite a challenge. Oracle has faced and overcome many challenges – and it has built up tremendous momentum to tackle the current challenge. It is stretching the company – threatening to make it spread its resources thinly. The goal is clear, the focus is […]
0 0 Apache Spark made numerous appearances in many different sessions during Oracle OpenWorld 2016. It is clear that Oracle is very much embracing and leveraging and endorsing Spark at various levels. Apache Spark is “a fast and general engine for large-scale data processing”. Spark has taken over from Hadoop MapReduce as […]
0 0 Topic of this blog is a nice new feature in 12c, not the plsql package I built that’s using it. So here’s the story.. For one of our customers we needed to have a simple schema comparison tool that would be able to check, as part of application deployment activity, […]
0 0 Maarten wrote a post on Virtual Columns in the oracle database. I read a blogpost on preventing people issuing SELECT * on a table. This was done in a different database, so I decided to try it out in my Oracle Database. First I create a simple table: and I […]
0 0 Some time ago I was asked to assist in fixing or at least finding the cause of a performance problem. The application ran fine until the Virtual Private Database (VPD) policy was applied. Oracle claims there should be near zero impact on your application when you implement VPD, then how […]
0 0 In my previous post Network considerations on an ODA X5-2 I described a solution where I created a private network to optimize network performance between the components running on an Oracle Database Appliance. I am talking about a Virtualized setup in this article, and rebuilding the second pair of public […]
0 0 When you buy an Oracle Database Appliance (ODA) X5-2 off the shelve, you will get a machine with four times 10Gb copper Ethernet (bonded into two interfaces) for public communication and two 40Gb InfiniBand (bonded into one interface) for interconnect communication between the two ODA_BASE’s. You would think that should […]
0 0 This article is about experimenting configuration, connection and deployment from one cloud instance to the other using the basic installation, connections and features like on a local network. I will demonstrate how to deploy a Java application on the Oracle Java Cloud Service (JCS) using XL Deploy (running on AWS EC2). […]
0 0 In this series of blogs about Continuous Delivery and the Oracle database, I describe how to automate deployments (installations). In the previous two Blogs I have described the tools and techniques used to create and install migration scripts. In this Blog I will describe the ‘(un)happy flow’ for a database […]
0 0 In the previous Blog I have described how to implement CD for an Oracle database by using migration scripts. In this Blog I will describe how to create migration scripts (automagically). DML scripts This is the more simple case because you need them less often. There are various data compare […]
0 0 In this Blog I will explore the possibilities to apply Continuous Delivery (CD) for the Oracle database. What is Continuous Delivery? The introduction on Wikipedia Continuous Delivery says: “Continuous delivery (CD) is a software engineering approach in which teams produce software in short cycles, ensuring that the software can be […]
0 0 Als Oracle gebruiker ziet u de mogelijkheden van de Oracle Cloud. De grote flexibiliteit, de mogelijkheid om capaciteit bij en af te schalen, instant diensten en het maandelijkse verrekenmodel. Alleen al de korte doorlooptijd voor (tijdelijke) omgevingen en de verminderde beheerinspanning kunnen leiden tot een flinke verbetering in efficiëntie. Zo bent u minder bezig met de dagelijkse operatie van […]
0 0 The Oracle OpenWorld 2015 conference in the last week of October 2015 was full to the brim with announcements, demonstrations, brainstorms, roadmaps, visions and other Oracle technology related activities. The main theme clearly was the cloud. Every other session revolved around the cloud and virtually every Oracle product is headed […]
0 0 Summarizing Oracle OpenWorld 2015 in a few headlines and key announcement is not easy. Because of the vast scope of the Oracle product portfolio (over 3000 products), the enormous variation in detail of the announcements (some very high over, some minutely detailed) and the contrast in tangibility, from generally available […]
0 0 Javascript is the most popular programming language* and its usage has grown 25% in the past year**. It’s widely used and so it stands to reason that Oracle now released a brand new JavaScript toolkit called Oracle JET (JavaScript Extension Toolkit). Oracle says “Oracle JET is targeted at intermediate to […]
0 0 For me the 2015 Oracle OpenWorld was a pleasant surprise. The surprise was not the announcement of an additional set of cloud products like the Identity Cloud or the Application Builder Cloud Service. The biggest surprise was the different tone of voice during the conference. In the past you could […]
0 0 Being at Oracle Open World you get a chance to learn about Oracle’s vision and strategy directly. In this blog I’ll summarize some of the things I learned about Oracle’s vision on API Management from Oracle Product Management. API management API Management is becoming more and more important. Major drivers for […]
0 0 Natuurlijk organiseren we ook dit jaar weer een Oracle OpenWorld Preview event. AMIS vaardigt 10 collega’s af naar de 2015 editie van Oracle OpenWorld. Een aantal van hen geeft daar ook een presentatie. Die presentaties krijg je tijdens dit preview event alvast te horen, evenals een aantal presentaties van andere […]
0 0 
