From a time long ago – https://mdinh.wordpress.com/2016/12/04/toys-for-when-you-i-are-bored/
With help from oravirt, I was able to install RAC VMs.
At this point, only the servers have been created and nothing has been installed; that’s coming up at some point.
Some clarification for
setup=standard vagrant provision
setup=standard (shell environment variable)
vagrant provision (executable)
This is where the confusion was at first.
falcon@falconidae MINGW64 /e/racattack-ansible-oracle (master) $ setup=standard vagrant provision collabn2 eth1 lanip :192.168.78. (more...)
As many of you know, eDB360 is a free tool that provides a 360-degree view of an Oracle database without any installation. A new version is available like once per month, but occasionally a large number of enhancements are implemented at once. This new release v1708 (March 25, 2017) includes several new features requested recently by some users of the tool, thus the need to blog about what is new:
- Reducing the scope of eDB360 is (more...)
If anyone has successfully configured RAC Attack using Vagrant, I really would love to know how you did it.
First, instructions are all over the place and I finally followed the one below.
Does anyone know what the vagrant password is?
E:\vagrantfile\OracleLinux\racattack12cR1>vagrant up collabn2 eth1 lanip :192.168.78.52 collabn2 eth2 privip :172.16.100.52 collabn2 dns server role is slave on first boot shared disks will be created, this (more...)
My starting point of installing Vagrant on Windows:
If you are attempting to use Vagrant with VirtualBox, you may encountered issues with mounting shared folders.
Update VirtualBox to 5.1.18r114002
Installed Version: 1.9.3 Latest Version: 1.9.3 You're running an up-to-date version of Vagrant!
E:\Vagrant\sitepoint>vagrant init ubuntu/trusty64
A `Vagrantfile` has been placed in this directory. You are now ready to `vagrant up` (more...)
I guess four blog posts and 3 videos over a two day period is a little excessive, but this is the closing post to make it five.
Here are the posts I put out during the event. I’ve added in some videos I finished editing today.
- OUG Ireland 2017 : The Journey Begins
- OUG Ireland 2017 : Day 2
- OUG Ireland 2017 : Day 2
- OUG Ireland 2017 : The Journey Home
This is the first time (more...)
- If you install and manage Oracle database in cloud by yourself, then you are using it on IaaS.
- If you are just using it in cloud without installing or managing it, then it's PaaS.
- If you are configuring the database instance and have access to it through SQL*Net, then its DBaaS.
- SaaS not really relevant when it comes to Oracle (more...)
I left the hotel bar with Martin, Chris and Neil and after an abortive attempt to get an airbus, we got a taxi to the airport.
I was convinced Dublin Airport was one of the few airports that don’t want you to unpack your laptops from your bag so I didn’t and my bag got flagged. I have no idea where I got that idea from, but I felt like a dick.
We then went (more...)
I got up a little after 08:30, which was a bit of a surprise, and headed down for breakfast, where a met a bunch of other speakers.
By the time I got showered, changed and checked out of the hotel I had missed the first session of the day (sorry). The first session I went to was the wife presenting “PaaS4SaaS”. I know what you are thinking, and yes I could do this presentation as (more...)
“Enough already with the DHCP complaints!” It’s Friday, so it means soon, we can stop worrying about such stuff and can get onto better things…
Until then, I’m sure other folks will be working with an AWS instance, go to log in after setting it up the initial time and want to know why the ssh connection that worked fine the day before is now hanging. In (more...)
It is a great pleasure to announce the next Performance Days! This year the event will take place the 13-14 September in Zurich.
Given that detailed information about the event as well as online subscription are available at https://trivadis.com/performance-days-2017, in this short post I limit myself to thanking and pointing out who the speakers that accepted my invitation are:
I arrived at the Gresham Hotel, registered and went straight down to the first session of the day…
First up was Maria Colgan presenting, “What to Expect from Oracle Database 12c”, a quick romp through the cool features in Oracle 12c (12.1 and 12.2). The room was full so I had to listen form the corridor, with my head occasionally popping round the door to see the screen. Maria’s sessions are always great (more...)
Create a backup of 11G GI HOME as root user:
. oraenv <<< +ASM
sudo su -
tar -cvf backup_GI.tar /u01/grid/product/188.8.131.52
tar -cvf backup_inventory.tar /var/opt/ora/oraInventory/
Stop all DB instances and listener
run the GI 12c runInstaller in silent mode (more...)
There is something about early starts that get me so nervous I can’t sleep properly. As a result I was awake before my 05:00 alarm, which gave me plenty of time to get ready. That was good because I hadn’t packed up laptop bag, which was also acting as my overnight bag.
The taxi ride to the airport was pretty standard, but I did have a conversation about Roza Bal in Kashmir.
I only had hand (more...)
A question came up on the OTN database forum a little while ago about a very simple query that was taking different execution paths on two databases with the same table and index definitions and similar data. In one database the plan used the “index full scan (min/max)” operation while the other database used a brute force “index fast full scan” operation.
In most circumstances the starting point to address a question like this is (more...)
In moving some more code from an 11gR2 database to a 12cR2 database, I found another change where a piece of code that works in 11gR2 doesn’t compile in 12cR2.
In this instance a view was being created with a projected date column which used the ANSI DATE syntax. Here is a simplified test script:
CREATE OR REPLACE VIEW test1 AS SELECT date '0000-01-01' date_col FROM dual / DROP VIEW test / CREATE OR REPLACE (more...)
The best part of playing poker is misreading the hand and won.
Well, today this applied to help troubleshoot a Goldengate issue.
Granted it might not be the root cause but it did solve the issue for the time being.
1. Goldengate version 10.4 2. mgr process started with uid vs username $ id -a uid=19208(ggsuser) gid=1601(dba) groups=1601(dba) $ ps -ef|grep ./mgr 19208 18576 1 0 16:05 ? 00:00:00 ./mgr 3. dirdat is (more...)
I’m working on upgrading a very buggy unpatched 184.108.40.206 Oracle database to a fully patched 220.127.116.11 version. I’m using Delphix to support the upgrade and it has been a big help so far. This is on the HP-UX 11.31 Itanium platform.
The great thing about using Delphix to support an upgrade is that my very first pass through the upgrade scripts was with a full-sized clone of production. In (more...)
Since its release in 10gR1, Oracle have consistently added neat functionality to the “new” scheduler with every database release. Yes, I still call it the new scheduler and you would be surprised how many people still insist on using DBMS_JOB rather than switching to DBMS_SCHEDULER.
Oracle Database 12c Release 2 (12.2) is no exception to this pattern, as once again we have some new stuff to play with.
I ended up speaking at two events this last week. Now if timezones and flights weren’t enough to confuse someone, I was speaking at both an Oracle AND a SQL Server event- yeah, that’s how I roll these days.