How to create a private 10 Gb network on an ODA X5-2
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 …
Category: Oracle
Network considerations on an ODA X5-2
June 24, 2016
ODA, Architecture, Engineered Systems, Oracle, Platform Technology, Technology, Virtualization and Oracle VM
No Comments
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 …
Application deployment to Oracle Java Cloud instance using XL Deploy on AWS EC2
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 …
Continuous Delivery and the Oracle database (III)
April 22, 2016
Continuous Delivery, Agile Scrum, Architecture, Database, Deployment, Oracle, PL/SQL
No Comments
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 …
Continuous Delivery and the Oracle database (II)
April 15, 2016
Technology, Agile Scrum, Continuous Delivery, Database, Deployment, Languages, Oracle, PL/SQL, Software Development
4 Comments
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 …
Continuous Delivery and the Oracle database (I)
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 …
Oracle Cloud en de Europese Privacy regels; waar moeten we op letten?
December 7, 2015
Book reviews and Publications, Cloud, Cyber Security, Oracle, Technology
No Comments
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) …
Reflections after Oracle OpenWorld 2015 – The Complete, Comprehensive and relatively Concise Overview of a Cloud Conference
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. …
Reflections after Oracle OpenWorld 2015 – Announcements, Key Terminology and Roadmaps
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 …
Oracle JavaScript Extension Toolkit (Oracle JET) – announced at OOW15
November 2, 2015
AMIS, Frontend technology, JavaScript, Oracle, Web HTML5 CSS3, Web/Java
No Comments
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 …
Oracle OpenWorld 2015: Finally a real Vision and Mission. A pleasant surprise
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 …
API Management: Oracle’s vision from OOW
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 OpenWorld Preview event – 8 oktober
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 …
A Short Note on Pesky CSSCAN Results Before a Characterset Change
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 …
ADF Performance Monitor: Measuring Network Time to Browser and Browser Load Time
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, …
How-to bulk delete ( or archive ) as fast as possible, using minimal undo, redo and temp
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, …
How-to set the current database schema of an application using a global context
March 9, 2015
Database, Databases, DBA Oracle, Frontend technology, Languages, Oracle, Oracle 12, Oracle Application Development Framework, PL/SQL, SQL, Technology
No Comments
![How-to set the current database schema of an application using a global context]({"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"http:\/\/seattletimes.nwsource.com\/ABPub\/2012\/08\/02\/2018836700.jpg","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"} "How-to set the current database schema of an application using a global context")
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 …
Security Features of Standard Edition (One) – Part 1
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 …
Upgrade OVM 3.2 to 3.3
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 …
Very first experience with oracle Cloud Service
December 29, 2014
Cloud, Digtial Innovation, Oracle, Platform Technology, Virtualization and Oracle VM
2 Comments
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 …
SQL*Plus / SQL*Net Dead Connection Detection
November 28, 2014
Architecture, Database, Databases, DBA Oracle, Oracle, Oracle WebLogic Server, Platform Technology, Virtualization and Oracle VM
No Comments
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 …
Christmas Masterclass Oracle SOA Suite 12c
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 …
MAF 2.0 : Loading Images in a Background Process – Part I
November 18, 2014
Frontend technology, Java, Mobile, Oracle, Oracle Application Development Framework, Software Development, Technology
No Comments
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 …
Guest template Oracle Linux 6.5 available on Exalogic
November 6, 2014
Cloud, Engineered Systems, Oracle, Platform Technology, Virtualization and Oracle VM
No Comments
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. …
Oracle and the new road to User Experience; launch of Alta UI – Oracle OpenWorld 2014
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. …
Oracle OpenWorld 2014: Non-life altering observations (but still interesting and useful)
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 …
Major take-aways from Oracle OpenWorld 2014 – some relevant conclusions
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 …
FTPS with PL/SQL
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 …
Oracle OpenWorld & JavaOne Review bijeenkomst – 16 oktober
Datum donderdag 16 oktober Tijd 16.30 – 21.00 Kosten gratis AMIS organiseert voor het negende achtereenvolgende jaar de Oracle OpenWorld …
Sometimes the cause of a TNS error is ….
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 …
How to make a time consistent export dump using the expdp datapump utility
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 …
Monitor Dell PERC when running on Oracle Virtual Server 3.x
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 …
SQL> Select * From Alert_XML_Errors;
August 29, 2014
Database, Databases, DBA Oracle, Development Tools, Oracle, Software Development, SQL
No Comments
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 …
SQL> Select * From Alert_XML;
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 …
Sqlnet tracing during nightly hours…
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 …
Materialized views: fast refresh, complete refresh or recreate?
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 …
11 september: Oracle OpenWorld Preview sessie
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 …
Cloud Control: How a Camel can make you cross a Data Guard Mountain
July 9, 2014
Cloud, Database, Databases, DBA Oracle, Enterprise Manager, Oracle, Platform Technology
No Comments
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. …
11 september – Oracle OpenWorld Preview sessie 2014
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 …
Cloud Control authentication with Active directory
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 …