Fastest way to a Virtual Machine with JDeveloper 12.1.3 and Oracle Database XE 11gR2 – on Ubuntu Linux 64 bit

In a previous article I have explained in quite a bit of detail how to create the Vagrant and Puppet scripts for stamping out a Virtual Box VM with Oracle Database XE 11gR2 and JDeveloper 12.1.3 (with ADF 12.1.3) on top of Ubuntu (64bit Linux): http://technology.amis.nl/2014/07/29/creating-automated-jdeveloper-12-1-3-oracle-xe-11gr2-environment-provisioning-using-vagrant-and-puppet/. If you want to learn a little more about Vagrant and Puppet, that might be an interesting read. However, if you do not (more...)

コピペで作る Yum のローカルリポジトリ

はじめに

Oracle Linux 7 のインストールされたマシンがインターネットに接続されていない場合、OS の ISO イメージから Yum のリポジトリを作成することができます。
ソフトウェアのアップデートが必要ないマシン(検証機など)でお使いください。

必要な物

https://edelivery.oracle.com/linux からダウンロードした Oracle Linux 7 の ISO イメージ(V46135-01.iso というファイル名になっていると思います)が必要です

手順

ダウンロードした ISO イメージの中身をローカルディスクにコピーし、/etc/yum.repos.d にリポジトリの定義ファイルを作成することで、ローカルリポジトリを作成できます

# mkdir -p /var/OL/7.0
# mount -o loop,ro ${PWD}/V46135-01.iso /mnt
# ls /mnt
EFI   Extras  LiveOS    RPM-GPG-KEY         TRANS.TBL  images    repodata
EULA  GPL     Packages  RPM-GPG-KEY-oracle  addons     isolinux
# cp -Rp /mnt/ /var/OL/7.0/
# umount /mnt
# vi /etc/yum.repos.d/ol7.repo
 (more...)

Creating automated JDeveloper 12.1.3 & Oracle XE 11gR2 environment provisioning – using Vagrant and Puppet

Standing on the shoulders of many smart and persistent friends, peers and colleagues, I was able to fairly quickly concoct the Vagrant and Puppet configuration that allows automated provisioning of a VirtualBox VM that runs Ubuntu (64bit Linux) with Oracle Database XE 11gR2 and JDeveloper 12.1.3 (with ADF 12.1.3). With a few command line actions, the creation of a clean and preconfigured VM is done in the background. image

This article gives (more...)

Oracle 12.1.0.2 ASM Filter Driver: First Impressions

This is a very quick post, because I’m about to log off and take an extended summer holiday (or vacation as my crazy American friends call it… but then they call football  “soccer” too). Before I go, I wanted to document my initial findings with the new ASM Filter Driver feature introduced in this week’s 12.1.o.2 patchset.

Currently a Linux-only feature, the ASM Filter Driver (or AFD) is a replacement for ASMLib (more...)

Oracle Linux 7 がリリースされました

Oracle Linux 7 が リリースされました ので早速インストールしてみました。

# uname -a
Linux x3-2-03.jp.oracle.com 3.8.13-35.3.1.el7uek.x86_64 #2 SMP Wed Jun 25 15:27:43 PDT 2014 x86_64 x86_64 x86_64 GNU/Linux
# cat /etc/system-release
Oracle Linux Server release 7.0
# cat /etc/os-release 
NAME="Oracle Linux Server"
VERSION="7.0"
ID="ol"
VERSION_ID="7.0"
PRETTY_NAME="Oracle Linux Server 7.0"
ANSI_COLOR="0;31"
CPE_NAME="cpe:/o:oracle:oracle_linux:7.0:GA:server"
HOME_URL="https://linux.oracle.com/"
BUG_REPORT_URL="https://bugzilla.oracle.com/"

ORACLE_BUGZILLA_PRODUCT="Oracle Linux 7"
ORACLE_BUGZILLA_PRODUCT_VERSION=7.0
ORACLE_SUPPORT_PRODUCT="Oracle Linux"
REDHAT_SUPPORT_PRODUCT_VERSION=7. (more...)

Implications of threaded_execution = true in 12c

I had an interesting discussion as part of my latest presentation at the UKOUG RAC CIA & Database Combined SIG. Part of my talk was about the implications of the new threaded execution model in Oracle.

Since “we do not use Windows” (except for gaming) I can’t compare the Windows thread model to the new 12c implementation on UNIX. There are however interesting implications when switching to the new model, some of which I’d like (more...)

Setting up Direct NFS on Oracle 12c

Direct NFS is a great feature that I have finally had the time to investigate further. Since I always forget how to set it up and I didn’t find blog posts about this subject elsewhere I decided to put something together.

In this configuration I am using a virtual machine named server1 to export a directory to server2. Oracle is not as lenient as myself and may have certain support requirements when it comes to (more...)

Oracle Linux and MySQL : Progress

A few months ago I wrote about some MySQL on Oracle Linux migrations we were working through. It’s been a long time coming, but last weekend was the go-live for this batch of migrations. So far so good! :)

Most of the elapsed time since my last post on this subject has been spent with the developers and users testing the migrations.

The process has taken a bit longer than some people would have liked. Rather (more...)

Fedora VMWare Upgrade

New update of VMWare came out, and it is time to upgrade VMWare Tools. Here’s an update on the instructions for upgrading VMWare Tools:

  1. Navigate to the VMWare Menu, choose Virtual Machine and in the drop down menu Install VMWare Tools. This will mount a virtual CD in the Oracle Unbreakable Linux virtual machine and it launches the following dialog box:
VMware962

  1. Open a terminal session by right clicking anywhere in the desktop, and then choose (more...)

Why does the Optimiser not respect my qb_name() hint?

I recently was involved in an investigation on a slow-running report on an Exadata system. This was rather interesting, the raw text file with the query was 33kb in size, and SQL Developer formatted the query to > 1000 lines. There were lots of interesting constructs in the query and the optimiser did its best to make sense of the inline views and various joins.

This almost lead to a different post about the importance (more...)

Getting the database parameters from a spfile

There’s been some debate about how to get the parameters from a spfile. A spfile is a binary version of the parameter file of the Oracle database.

I added to the debate that my experience is that there are is some weirdness with using the strings command on the spfile. The discussion was on twitter, I didn’t add that doing that it most of the time meant it costed more time than I saved from (more...)

SampleApp v406 – Automatic startup of OBIEE

Last week Oracle released v406 of SampleApp. SampleApp is a one-stop-shop for a demonstration of pretty much any conceivable thing that OBIEE is capable of, and then some more on top of it. It is a VirtualBox appliance with everything on the one machine (Database, OBIEE, Endeca, TimesTen, Essbase, etc), and demonstrates basic analysis building techniques through to dashboarding, Mobile App Designer, analysis visualisations with D3, ADF, JavaScript, backend hackery with undocumented NQS calls (hi (more...)

RAC 12c enhancements: adding an additional SCAN-part 4

This is going to be the last part of this series, however long it might end up being in the end. In the previous articles you read how to create a physical standby database from a RAC One database.

Networks (refresher)

To make it easier to follow without going back to the previous articles, here are the networks I’m using, listed for your convenience.

  • 192.168.100/24: Client network
  • 192.168.102/24: Dedicated Data Guard (more...)

Using git for revision control for Oracle DBAs

This post is aimed at people working with code, scripts and/or any other means of textual files. I try to give my point of view on revision control and git as revision control system in particular.

The first thing you should ask yourself is: why using revision control in the first place? I think that’s a good and fair question. A lot of people I talk to see revision control as something that’s for developers (more...)

Mounting VMWare-Volumes/Disks with Debian

Some time ago a vmware server did not recognize any more a data disk. This disk was formatted with vmfs v3 (enter the vmware server via ssh and type mount..). First thing i did, was creating an image of this disk, to play around without any danger of data loss.

There is a good article how to mount vmfs, but on debian i had to install the package otherosfs.

After i installed this (more...)

How Exadata smartscans work

I guess everybody who is working with Oracle databases and has been involved with Oracle Exadata in any way knows about smartscans. It is the smartscan who makes the magic happen of full segment scans with sometimes enormously reduced scan times. The Oracle database does smartscans which something that is referred to as ‘offloading’. This is all general known information.

But how does that work? I assume more people are like me, and are anxious (more...)

What the heck are the /dev/shm/JOXSHM_EXT_x files on Linux?

There was an interesting question in Oracle-L about the JOXSHM_EXT_* files in /dev/shm directory on Linux. Basically something like this:

$ ls -l /dev/shm/* | head
-rwxrwx--- 1 oracle dba 4096 Apr 18 10:16 /dev/shm/JOXSHM_EXT_0_LIN112_1409029
-rwxrwx--- 1 oracle dba 4096 Apr 18 10:16 /dev/shm/JOXSHM_EXT_100_LIN112_1409029
-rwxrwx--- 1 oracle dba 4096 Apr 18 10:16 /dev/shm/JOXSHM_EXT_101_LIN112_1409029
-rwxrwx--- 1 oracle dba 4096 Apr 18 10:23 /dev/shm/JOXSHM_EXT_102_LIN112_1409029
-rwxrwx--- 1 oracle dba 4096 Apr 18 10:23 /dev/shm/JOXSHM_EXT_103_LIN112_1409029
-rwxrwx--- 1  (more...)

RAC 12c enhancements: adding an additional SCAN-part 3

Travel time can be writing time and while sitting in the departure lounge waiting for my flight I use the opportunity to add part 3 of the series. In the previous two parts you could read how to add a second SCAN and the necessary infrastructure to the cluster. Now it is time to create the standby database. It is assumed that a RAC One Node database has already been created on the primary cluster (more...)

RAC 12c enhancements: adding an additional SCAN-part 2

In the first part of this article you could read how to add an additional network resource, additional VIPs and SCAN to an 12.1.0.1.2 cluster. In this part I hope to show you the next steps such as adding the SCAN listeners and other resources.

New SCAN listener

With the second SCAN added it is time to add the next set of SCAN listeners. This is really simple, and here is (more...)

Systemtap revisited

Some time back, I investigated the options to do profiling of processes in Linux. One of the things I investigated was systemtap. After careful investigation I came to the conclusion that systemtap was not really useful for my investigations, because it only worked in kernelspace, only very limited in userspace. The limitation of working in userspace was that you had to define your own markers in the source code of the program you wanted to (more...)