Oracle Distilled

NoCOUG: Celebrating 25 years and 100 conferences

Eric Jenkinson — Tue, 25 Oct 2011 20:38:05 +0000

This year marks the 25th anniversary of the Northern California Oracle Users Group (NoCOUG) and on November 9th 2011 they will hold their 100th conference. If you are in the Northern California area you should consider attending Conference 100 on November 9th. Steven Feuerstein will provide the opening keynote followed by sessions from Craig Shallahamer, [...]

EM Configuration issue. $ORACLE_HOME/odprimary_PRIDB not found

Eric Jenkinson — Mon, 17 Oct 2011 22:20:47 +0000

We noticed that some of our databases monitored in Oracle Enterprise Manager Grid Control were showing a status of Agent Unreachable. When checking the status of the Agent on the server the following error was returned. A common cause for this error is changing the hostname of the server in either /etc/hosts or DNS. In [...]

Installing Oracle Enterprise Manager Cloud Control 12c Release 1

Eric Jenkinson — Wed, 12 Oct 2011 20:38:07 +0000

Oracle Enterprise Manager Cloud Control 12c Release 1 is the next release in the Enterprise Manager Product line. This document will detail the installation steps on Oracle Enterprise Linux 5.5 with an Oracle 11gR2 repository database. The following are the requirements for the repository database SGA_TARGET – 2GB or 2 * PGA_AGGREGATE_TARGET PGA_AGREGATE_TARGET- 1GB PROCESSES- [...]

Removing Database Control (dbconsole) from a database

Eric Jenkinson — Mon, 10 Oct 2011 21:46:42 +0000

Oracle Database 10g introduced Database Control (dbconsole) to aid in day to day administration tasks and monitoring. When building a database for use as a repository for Oracle Enterprise Manager Grid Control or the recently released Oracle Enterprise Manager Cloud Control 12c, you will need to remove Database Control and its associated repository from the [...]

Preparing Drives for ASM using ASMLib

Eric Jenkinson — Fri, 30 Sep 2011 20:53:06 +0000

This document will detail the steps to configure disks for ASM and the installation of ASMLib on Oracle Enterprise Linux 5.5 running in Oracle VM VirtualBox 4.1.2. The drives were created as shared drives. See the post: Creating Shared Drives in Oracle VM VirtualBox for more information on creating shared drives in Oracle VM VirtualBox. [...]

PRVF-5439: NTP daemon does not have slewing option “-x” set on node

Eric Jenkinson — Thu, 29 Sep 2011 23:01:00 +0000

When installing Oracle 11gR2 Grid Infrastructure either the cluster verify utility or the prerequisite checks find that the NTP daemon does not have the slewing option set. What is slewing? The NTP daemon will periodically update the system clock with the time from a reference clock. If the time on the reference clock is behind [...]

Quick Manual Database Creation

Eric Jenkinson — Wed, 28 Sep 2011 23:32:13 +0000

Using Oracle Managed Files you can quickly create a database manually with very little upfront effort. Oracle Managed Files greatly simplifies the database creation process because all that is needed is the location in which to write the database files. Three initialization parameters are used to enable Oracle Managed Files: DB_CREATE_FILE_DEST- The location where the [...]

Changing the HOSTNAME on Oracle Enterprise Linux

Eric Jenkinson — Tue, 27 Sep 2011 22:37:13 +0000

Either due to cloning or corporate naming standards, you may find the need to change the hostname of an Oracle Enterprise Linux System. The current hostname for this machine is odlinux.oracledistilled.com and it will be changed to secondary.oracledistilled.com. The hostname can be changed by editing /etc/sysconfig/network as the root user. After changing the hostname in [...]

ORA-00354 corrupt redo log block header

Eric Jenkinson — Mon, 26 Sep 2011 22:00:08 +0000

I ran in to an issue recently where a database was reporting ORA-00257 archiver error, connect internal only, until freed. However when looking at the system I could not find evidence to support the ORA-00257. After validating that the file system did have space in which to write the archive logs I took a quick [...]

Cloning a VirtualBox VM in VirtualBox 4.1

Eric Jenkinson — Tue, 19 Jul 2011 20:47:33 +0000

With Oracle VirtualBox 4.1 cloning a VM is now available from the user interface making the process much simpler. In prior releases cloning a VM was a multi step process in which you needed to use the command line utility VBoxManage clonehd to create a clone of the virtual device and then attach that new [...]