Deployment of Exadata requires you to generate configuration using Oracle Exadata Deployment Assistant (OEDA). Within the same the default ASM disk groups names are DBFS_DG, RECOC1 and DATAC1. I usually change those to RECO01 and DATA01 as others doesn’t make sense to me and the only place where I find the default ones is on Exadata.
I had an incident last year where the Exadata deployed half way through and names were left by default (more...)
Oracle WebCenter Suite
is an integrated suite of Fusion Middleware 11gR1 tools used to create
web sites and portals using service-oriented architecture (SOA). Applications adapters are also available.
WebCenter Portal 188.8.131.52 is now certified with
Oracle E-Business Suite Release 12.2. WebCenter Portal 184.108.40.206 is part of Oracle Fusion Middleware 11g Release 1
Version 220.127.116.11.0, also known as FMW 11gR1 Patchset 8.
Tonight was Oracle Midlands Event #12 with Bryn Llewellyn and Neil Chandler.
Bryn very kindly stepped in for Tom Freyer who unfortunately couldn’t make it. Bryn’s presentation was called Why use PL/SQL?, which was based on his whitepaper of the same name. I’ve written about a number of the topics he raised, including a piece on My Utopian Development Environment, but his talk and his whitepaper put forward a much more consistent and compelling argument. Definitely worth checking (more...)
Recently a customer asked if it was possible to promote unmanaged targets automatically without any interaction. They were already using auto-discovery.
The answer is yes, and of course as soon as you see words like “without any interaction” you know there’s going to be scripting involved. In the Enterprise Manager world, scripting is handled by the EM Command Line Interface, better known as EMCLI. I’ve posted some example scripts of using EMCLI a while back (more...)
The whole Sangam15 experience is over for me now!
Here are the posts I put out during the trip.
I did my thank you messages in the Day 2 post, but once again I would like to say a big thank you to AIOUG for inviting me, to the Oracle ACE Program for getting (more...)
The night before a morning flight is always a little tricky for me. I lie in bed thinking, “What if I oversleep?”, which winds me up and makes it really hard to relax and drop off. I dozed on and off, but eventually gave up, turned the TV on and watched some films for a few hours.
I grabbed a quick breakfast and got the taxi to the airport. The hotel staff advised leaving (more...)
I’ve often found that while I’m investigating one Oracle feature I get waylaid by noticing anomalies in other parts of the code. I was caught by one of these events a little while ago while experimenting with the new (18.104.22.168) Inmemory Columnar Store. After reading a posting by Martin Bach I asked the question:
“If you have a partitioned table with a local index and one of the table partitions has (more...)
Last week, I gave presentations at DOAG (German Oracle User Group) conference and BGOUG (Bulgarian Oracle User Group) autumn conference about Oracle Enterprise Manager Command Line Interface. It was my first time at these conferences, and both of them were wonderful.
Before each session at DOAG Conference, there was a video showing “how they prepared the last year’s DOAG conference”. What a professionalism! What a great team work! You know Germany is known for their (more...)
I have created a new youtube channel – and have uploaded some videos there already! Bookmark & Subscribe here:
More stuff is coming over the next weeks & months :-)
NB! After a 1.5 year break, this year’s only Advanced Oracle Troubleshooting training class (updated with Oracle 12c content) takes place on 16-20 November & 14-18 December 2015, so sign up now if you plan to attend this year!
iAdvise presented the APEX 5.0 roadshows in the first half of 2015. Besides the presentation about the new features, we provided 3 tutorials which helped the visitors to explore Oracle Application Express 5.0. Now we offer these tutorials through our blog. In this article the second tutorial is presented.
This tutorial helps you step by step through the process of migrating an application to the Universal Theme
of Oracle Application Express 5.0
. In this tutorial we talk about (more...)
I wanted to add an append hint to some code but realised that there are known restrictions when either triggers or referential integrity are involved.
That does make sense as potentially rows would be inserted that either did not fire a trigger or broke RI constraints.
I decided to produce a test case to prove that the restrictions did work and were still in place.
Test append with trigger created
set lines 240
set pages (more...)
My session on Day 2 started at 11:10, where I spoke about running Oracle Databases in the Cloud. This included a quick run through of the Oracle DBaaS offering and AWS RDS for Oracle amongst other things.
The session generated a lot of interest. In fact, I spent the next 5 hours answering questions and taking photos with people. It sounds kind-of crazy, but it was really good fun. As a result, I didn’t get to (more...)
I was up at about 04:00 on Saturday and waiting for breakfast to open at 06:30. Pretty much as soon as I ate something I felt really tired again. That after a day of sleeping…
I headed on down to the conference and instantly saw a bunch of friendly faces, including lots of people I had met on the OTN Yathra 2014 Tour.
After the keynotes, I got to have a quick chat about User Groups (more...)
So, some of you may have noticed that I took “real” job this week. I am now the Senior Technical Evangelist for a cool startup company called Snowflake Computing. Basically we provide a data warehouse database as a service in the cloud. Pretty cool stuff. (If you want to know more, check out our site […]
I previously blogged about using the IBM Bluemix Secure Gateway Service as followshttp://theblasfrompas.blogspot.com.au/2015/11/ibm-bluemix-secure-gateway-service-step.html
I decided I would extend on this and Connect a Spring Boot Application to Oracle and consume Oracle data using the Secure Gateway Service.
The full demo is as followshttps://dl.dropboxusercontent.com/u/15829935/bluemix-docs/secure-gateway-oracle/index.html
The day started pretty early. I was packing at 00:00 and the alarm went off at 05:00. Nothing like last minute packing to focus the mind.
The taxi to the airport was good. The driver was interesting, speaking to me about his visits to India and Pakistan. It certainly helps pass the time when the driver is chatty.
I wasn’t able to check-in online, but there was no queue at the check-in desk, so that was quick. (more...)
Some references on extents dealing with extent trimming, initial extent for parallel load, tablespace fragmentation, etc…
ASM AU Size And LMT AUTOALLOCATE
Parallel Load: Uniform or AutoAllocate extents?
Tom Kyte covers this problem in great details in his post Loading and Extents
Initial Extent Size of a Partition Changed to 8MB from 64KB After Upgrade to 22.214.171.124 or Later (Doc ID (more...)