EM Configuration issue. $ORACLE_HOME/odprimary_PRIDB not found
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.
Read more »
Installing Oracle Enterprise Manager Cloud Control 12c Release 1
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.
Read more »
Removing Database Control (dbconsole) from a database
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 database.
Read more »
Preparing Drives for ASM using ASMLib
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.
Read more »
PRVF-5439: NTP daemon does not have slewing option “-x” set on node
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.
Read more »
Quick Manual Database Creation
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.
Read more »
Changing the HOSTNAME on Oracle Enterprise Linux
Either due to cloning or corporate naming standards, you may find the need to change the hostname of an Oracle Enterprise Linux System.
ORA-00354 corrupt redo log block header
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.
Cloning a VirtualBox VM in VirtualBox 4.1
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 image to new virtual machine.
Read more »
Cloning an Oracle Database Home
Starting with Oracle Database 10g you are able to easily clone an existing Oracle Home. Why would you want to be able to do this? For one it is faster to clone an existing Oracle install than to install fresh. The clone includes all patches that might have been installed thus removing the problem of missing patches when building a new server.
Read more »
Numerous m000 trace files in which KEWROCISTMTEXEC encountered ORA-12899
While clearing up some space in diag/trace directory, I noticed numerous trace files were being generated by the Memory Monitor slave process (m000). These trace files were being generated at regular intervals. Read more »
Creating Shared Drives in Oracle VM VirtualBox
If you would like to experiment with Oracle RAC and ASM/ACFS in your Oracle VirtualBox environments you will need to create drives that can be read and written to by multiple VMs concurrently. VirtualBox 4.0 supports the creation of shared drives.
Read more »
Cloning a VirtualBox VM
I make frequent use of virtualized environments for testing and proof of concept work. One of the many great features of virtualized environments is that I do not have to start from scratch every time. I build base systems with the configured OS and any necessary software. Using these base systems I can spin up a new machine and get to the interesting work quickly.
Read more »
ORA-04020 When Dropping Materialized View with a Spatial Index
While upgrading our GIS development database from 11gR1 to 11gR2 we found that we were getting deadlocks when dropping materialized views that had spatial indexes. The deadlock always occurred on the first attempt to drop the view and any further attempt to drop the view would report success. However; an attempt to recreate the materialized view would result in an ORA-00955.
Read more »
Flashback Data Archive (Oracle Total Recall)
Have you ever had to to perform a tablespace point in time recovery to retrieve data that was erroneously deleted? How many triggers have you had to create/troubleshoot in order to meet data retention or change control requirements?
Read more »
Installing MySQL 5.1 Community Server on Windows
MySQL is the most popular Open Source relational database. As part of the LAMP stack, MySQL is integral in many Open Source projects such Nagios, Bugzilla and WordPress to name a few. Companies such as McAfee, Novell and UPS use MySQL database in their environments not to mention some large scale web sits such as Google and Facebook.
Read more »
User Managed Online Backups (Hot Backup)
While Recovery Manager (RMAN) is highly recommended for database backup and recovery operations your organization may require you to perform backups using a custom process or you might have an interest in knowing what is required to perform a user managed backup.
Read more »
Read–Only Tables in Oracle Database 11g
Prior to Oracle Database 11gR1 in order to create a read only table you had to employ clever uses of triggers, constraints or other methods to prevent the data from being changed. In many of those cases only INSERT, UPDATE, and DELETE operations were prevented while many DDL operations were not. Oracle Database 11gR1 provides the ability to create read only tables with a simple ALTER TABLE statement.
Read more »
Remove a Database from a RMAN Recovery Catalog
There will come a time that you will need to remove a database from the recovery catalog. Removing a database from the recovery catalog removes all metadata for the database from the catalog.
Read more »