RDA, or the Remote Diagnostics Agent, has been around for a little while. Over the time, and with the growing number of Oracle’s acquisitions it has become, shall we say, a little more difficult to handle. It appears to me as if every one of them will have its diagnostics handled by RDA making it hard to focus on something specific, like for example the database.
I won’t go into very detail of the Remote (more...)
Today I wanted to pass an old disk in a usb-case to my son. It was from an old Windows Laptop and even though I'm administrator, I wasn't able to read the documents in an other user's folder.
So I thought, let's do it from an Oracle Linux 7 VM, as root. But it turns out that Oracle linux did not support NTFS by default.
But with the trick in this link
I managed to (more...)
25 years of ground-breaking innovation
When Linus Torvalds sent his first email on August 25, 1991 announcing a project to create a new operating system, who could have imagined the impact it would have on the technology industry and how it would propel the concept of open source software development. Today, open source and Linux are used across the globe in almost every data center, powering trading platforms, processing millions of transactions each day and (more...)
I’ve been playing a bit lately with Oracle VM on a few different platforms (ODA, Exalytics, Private Cloud Appliance) and was tasked with creating a good Oracle VM template image for Oracle Linux 7. Oracle makes templates available on eDelivery (https://edelivery.oracle.com) that present you with VM configuration questions on first boot, but those VM templates have a few limitations that make them hard to use:
- The templates have a minimal Linux installation, and are (more...)
OBIEE 12c (and 11g and 10g before it) supports three primary ways of connecting to data sources:
- Native Gateway, such as OCI for Oracle. This is always the preferred option as it gives the greatest support and performance.
- Data Direct ODBC Drivers, a set of which are bundled with OBIEE for enabling connectivity to sources such as SQL Server, MySQL, Hive, and Impala. The configuration of these is documented in the OBIEE manuals (more...)
As I want later build Oracle docker images, some of this need a swapfile.
Per default my used Vagrantbox, does not have one, so later steps will fail.
As in the last blog I use a Vagrant shell provider.
# add swapfile to the box
config.vm.provision :shell, :path => "add_swap.sh"
This calls the script add_swap.sh in the created VirtualBox machine.
Make sure, that you create your swapfile on a supported (more...)
Recently, there has been discussion about using rlwrap for Goldengate on Twitter feed.
Truthfully, I did not know there was RPM for this and I did not even know it was already installed.
It just worked, when I had set it up.
A very nice cheat sheet for using yum.
Yum Command Cheat Sheet for Red Hat Enterprise Linux
I started to investigate how was rlwrap installed on the system.
$ cat /etc/issue
Due to security hardening, telnet is not available.
$ rpm -q --whatprovides nc
$ yum list nc
Loaded plugins: refresh-packagekit, security
epel/metalink | 11 kB 00:00
epel | 4.3 kB 00:00
epel/primary_db | 5.9 MB 00:03
public_ol6_UEKR3_latest | 1.2 kB 00:00
public_ol6_latest | 1.4 kB 00:00
nc.x86_64 1.84-24.el6 @public_ol6_latest
$ nc -v -z -w 3 stackoverflow.com 80; echo $?
Connection to stackoverflow.com 80 port [tcp/http] succeeded!
Happy Monday everyone,
As we start our countdown to Oracle OpenWorld which will take place in San Francisco on September 18-22, 2016 we want to highlight keynotes and our general sessions in this second blog.
General Session: Oracle Linux, Virtualization, and Networking Power the Cloud
Next-generation cloud data centers require robust, secure, and flexible infrastructure to support a huge variety of cloud applications and use cases, and developers need cutting-edge tools (more...)
As I want later build docker images and run docker containers I have to provide enough disk space for this.
Per default the Vagrantboxes have vmdk disks, these have a static size and are to small for my purposes.
Therefore I convert the disk, which comes with the box, via Vagrant VirtualBox provider from vmdk to vdi, so that it allocate only the used disk space in the host system.
Additional I add a second (more...)
As I want to decouple my development server from my computer as much as possible I want to create first a virtual machine with linux.
Because I have used Oracle Virtualbox in the past successfully, I will use it here too.
As I want have later a reproducible environment via Infrastructure as code, I give Vagrant a try for this. As source code management system I use GIT, my remote repository is located at CloudForge.
While preparing for a virtualized Exalytics upgrade, I was testing the various connection methods that would be needed. Last on the list was to validate that I could connect to the ILOM’s web interface, launch the java console, and mount an ISO file from my laptop to the machine. This is necessary because the Oracle VM server upgrade for a virtualized Exalytics requires you to boot from a specific ISO file in order to patch (more...)
This is a blogpost about how I setup my test virtual machines. The seasoned sysadmin and DBA will notice that the techniques used here are perfectly usable for real production environments. The most important thing is there is no need to download or stage any software for installing the virtual machine, everything is downloaded when needed during installation. Obviously this works best when you have got reasonable bandwidth available for connecting to the internet.
Some time ago I wrote a post about using OSWatcher for system analysis. Neil Chandler (@ChandlerDBA) rightfully pointed out that although OSWatcher was cool, TFA was the way to go. TFA can include OSWatcher, but more importantly it adds a lot of value over and above what OSWatcher does.
I guess it depends on what you want to do-I still think that OSWatcher is a good starting point and enough for most problems on single (more...)
I have already written about the use of Connection Manager 11.2 to govern access to a database. While researching this piece I have updated the original post so that it’s relevant for 12c as well.
Although the idea of using Connection Manager is tempting, the obvious first question is about high availability of the process. After all, if the gatekeeper to your database environment fails, you are effectively closed for business. One option would (more...)
This blogpost is about using the linux ftrace kernel facility. If you are familiar with ftrace and specifically the function_graph tracer, you might already be aware of this functionality. This is Linux specific, and this facility is at least available in kernel 2.6.39 (Oracle’s UEK2 kernel).
What is a ‘kernel dive’? Whenever a process is running, it should mostly be in ‘user mode’, executing the program it is supposed to run. However, during (more...)
The need to monitor and control the system performances is not new. What is new is the trend of clever, lightweight, easy to setup, open source metric collectors in the market, along with timeseries databases to store these metrics, and user friendly front ends through which to display and analyse the data.
In this post I will compare Telegraf, Collectl and Topbeat as lightweight metric collectors. All of them do a great job of collecting variety (more...)
In the first part of this little series I explained how a missing (default) tablespace in a PDB can have an impact when opening it. In this instalment I’ll add another common cause for PDBs not opening in read-write mode: different patch levels between the PDB to be plugged in and the CDB.
Assume for a moment that you upgraded Oracle binaries from 188.8.131.52.5 to 184.108.40.206.160419. (more...)