OEM 12c installation fails if parallel_max_servers too high

Just a quick post regarding OEM 12c installation where recently I had to install OEM 12c and during the repository configuration step the installation fails with error:

ORA-12801: error signaled in parallel query server P151

This was caused by a known bug which requires decreasing the number of parallel queries of the repository databases and start over the installation. The database had cpu_count set to 64 and parallel_max_servers to 270. After setting the parallel_max_servers to (more...)

RMAN fails to allocate channel with Tivoli Storage Manager

I was recently configuring backup on the customers Exadata with IBM TSM Data Protection for Oracle and run into weird RMAN error. The configuration was Oracle Database 11.2, TSM client version 6.1 and TSM Server version 5.5 and this was the error:

[oracle@oraexa01 ~]$ rman target /

Recovery Manager: Release 11.2.0.3.0 - Production on Wed Jan 29 16:41:54 2014

Copyright (c) 1982, 2011, Oracle and/or its affiliates.   (more...)

How to Add Disk Storage to Oracle VirtualBox with Linux Guest OS?

Are you looking to install Oracle software on your VirtualBox but are running low on disk space? Learn how to add disk storage to Oracle VirtualBox with Linux Guest OS.

The post How to Add Disk Storage to Oracle VirtualBox with Linux Guest OS? appeared first on VitalSoftTech.

Oracle Database 11gR2 (11.2.0.4) installation on Oracle Linux 6.4

In this post, I’m installing the Oracle Database 11g Release 2 (11.2.0.4) software on Oracle Linux 6.4, along with optional instructions on how to apply the latest Patch Set Update (PSU) to your new Oracle home. First and foremost, before you start, make sure your Linux server meets the minimum hardware requirements: 1GB of RAM (plus

Read More...

Internet Access with VirtualBox & Host-only Networks (on OS X Mavericks)

Introduction

When creating VMs on my laptop I like to configure the minimum number network interfaces. I also tend to end up with environments where I want multiple VMs to be able to see each other, see the internet and see my physical host. It seems many people using VirtualBox use the approach of having a “Host-only Adapter” interface and a “NAT” interface. The only reason I have for not liking this is that it (more...)

Oracle GI 12.1 error when using NFS

I had quite an interesting case recently where I had to build stretch cluster for a customer using Oracle GI 12.1 and placing quorum voting disk on NFS. There is a document at OTN regarding the stretch clusters and using NFS as a third location for voting disk but it has information for 11.2 only as of the moment. Assuming there is no difference in the NFS parameters I used the Linux parameters (more...)

November/December Highlights

In the Oracle technical universe, it seems that the end of the calendar year is always eventful. First there’s OpenWorld: obviously significant for official announcements and insight into Oracle’s strategy. It’s also the week when many top engineers around the world meet up in San Francisco to catch up over (more...)

Info about Exadata’s imageinfo and rpm’s

Recently we noticed that imageinfo was displaying the following information at a customers site. Imageinfo was not displaying data i suspected, so a quick little blogpost about what was going on there.

[root@dm01db01 ~]# dcli -g /opt/oracle.SupportTools/onecommand/dbs_group -l root "imageinfo | grep 'Image version'"
dm01db01: Image version: 11.2. (more...)

Sudo Keystoke Optimisation

If like me, and a couple of others I’ve spoken to recently, you were not previously aware of “sudo -s” then you might be interested to know that you can save yourself two keystokes by switching from:

sudo su -

To:

sudo -s

From the man page:

The -s (shell) (more...)

Drill Down the I/O stack at UKOUG Tech13

It's just under a week to go before the doors open for the UKOUG Tech13 conference and the adjoining OakTable World UK 2013 sessions, so I thought I would write a very short blog post about what I will be doing there, where I'll be, and what I'm looking forward (more...)

Oracle Direct NFS (and Linux Routing) … for Dummies!

When I started my current role a few months ago, I was very interested to learn that direction had been set to migrate away from ASM and onto NFS storage that had some read flash cache in front of it. I'm not the world's biggest fan of ASM and the (more...)

Tools that I use – nmap

For medium to large size projects the network setup can be quite complex, especially if it involves several external partners or third-party networks (VPN, MPLS etc).

Normally network changes are done by network engineers that do not have access to the servers and therefore cannot verify the changes they make.

When I have to verify a network change, firewall opening, NATing etc, I have in the past often used telnet.

This is very simple and (more...)

WebLogic Server and entropy

After input from Jacco H. Landlust and Edwin Biemond I have rewritten my post about entropy.

Overview

Entropy pool

In computing you often need random numbers. They are used for encrypting stuff but also for lots of other things.

For Linux servers random numbers are default provided by the /dev/random device. /dev/random is a pool of random bits (more...)

Bash script for installing WebLogic Server PSU patches via BSU

Patching WebLogic is necessary but not fun. To help out I have created a simple Bash script for installing CPU/PSU patches.

For information about CPU, PSU and SPU patches check this post.

The script is using BEA Smart Update so it is for WebLogic Server 12.1.1 and older. WebLogic Server 12.1.2 has switched from BSU to OPatch.

#!/bin/bash
# ---------------------------------------------------------------------------
# cpuPatch.sh
# Peter Lorenzen
# Version 0.9
 (more...)

IPython at Ohio LinuxFest 2013

Are you signed up yet for Ohio LinuxFest on Sep. 13-15? I'll be there to present

IPython for non-Pythonistas

Break out of your (bash) shell! IPython and the IPython Notebook have swept over the Python programming community, but they're not just for Python programmers - they make for high-powered shell (more...)

Configuring ODBC to MySQL from Oracle

Sometimes people want to connect to MySQL from Oracle and copy table data between the databases.  You can do that with Oracle Hetrogenous Services via ODBC.  This post will show how to create an odbc connection to your MySQL database which is the first part of this.

For my example, (more...)

oratop from MOS

This is just a pointer post to a tool which I discovered today. It is ORATOP, to monitor databases real time like top of unix flavours. It is pretty much like MOATS   (tool from Tanel Poder and Adrian Billington and RAC version by  Jagjeet Singh),   with a bit better output (more...)

Analyzing page allocation failures on Exadata

I have seen several clients who are struggling to decode page allocation failures on Exadata, in this post i will try to explain how to read the backtrace. The following is an anonymized client case where page allocation failures are leading up to a node reboot.

Jan 1 11:58:02 dm01db01  (more...)

Playing with VirtualBox, Oracle 12c (12.1.0.1) and OEL 6.4 – Part 2

We will complete our lab by installing the Oracle Database software, create a Pluggable database and take a look in the Oracle Enterprise Manager Database Express.

The steps to install and create an Oracle Database 12c are:

1 – Go to the database directory created when unzipped the 2 Oracle (more...)

Dual-Boot on UEFI PCs: Booting Ubuntu only works randomly

In my posting about using ubuntu on a Windows 9 laptop, i ended with:
But now rebooting works like expected (with Ubuntu and Windows 8).
After some more reboots and trying to start ubuntu, booting ubuntu only works randomly. Sometimes it worked after walking through BIOS/UEFI. Sometime it did (more...)