Installing Oracle Weblogic Server 11g Release 1 (10.3.3.0) on Linux

This documents will detail the installation of Oracle Weblogic Server 11g Release 1 (10.3.3.0) on Oracle Enterprise Linux 5.5. The 32bit version of Oracle Weblogic Server was used in this installation.

Building OCI and OCCI applications in NetBeans 6.8

This document will detail the configuration options needed in order to compile OCI and OCCI applications using NetBeans 6.8.

Introduction to Users in Oracle TimesTen-In Memory Database

Many of the user management features in Oracle TimesTen-In Memory Database will be familiar to people experienced with Oracle Database. This guide will provide a quick introduction to users and user management in Oracle TimesTen-In […]

Automating Oracle TimesTen Data Manager Daemon Startup/Shutdown on Server Startup/Shutdown

This document will detail the steps to automate the startup/shutdown of the Oracle TimesTen Data Manager Daemon on server startup/shutdown. If you would like to know how to shutdown the daemon manually see the post […]

Manually Starting and Stopping the Oracle TimesTen Data Manager Daemon

This document will detail starting and stopping the Oracle TimesTen Data Manager Daemon. The document will also detail some of the TimesTen processes and tools that can be used to monitor and manage TimesTen daemon […]

Oracle TimesTen In-Memory Database Installation Linux

Oracle TimesTen In-Memory Database is a memory resident relational database management system that allows applications to access, capture or modify information faster than traditional database products. This document will detail the installation steps for Oracle […]

Mount NTFS file systems with NTFS 3G

Tuxera provides a stable read/write NTFS driver for Linux though their NTFS 3G. The driver provides the ability to mount Windows XP, Windows Server 2003, Windows 2000, Windows Vista, Windows Server 2008 and Windows 7 […]

SET AUTOTRACE fails with error SP2-0618

Problem: You attempt to set autotrace and receive the following error message. Solution: The user executing AUTOTRACE needs to have the PLUSTRACE role. By default the PLUSTRACE role does not exist and can be created […]

Deferred Segment Creation

Starting with Oracle Database 11gR2 when you create an empty heap organized table in locally managed tablespace segment creation is deferred until the time in which the first row is inserted. Segment creation is also […]

Restore database to another host using RMAN

This document will detail the steps to restore a database on a new host using RMAN. For this demonstration we will be using Oracle Database 11gR2 on Linux and disk based backup.

Recover from a corrupt or missing control file

This document will detail recovery scenarios dealing with missing or corrupted control files using RMAN disk based backups.

Multiplexing Control Files

This document will detail multiplexing of control files. Having multiple control files reduces the risk of control file loss due to corruption or accidental removal. In the case of corruption or loss recovery is no […]

Error: cannot restore segment prot after reloc: Permission Denied

When attempting to use SQL*Plus or other OCI based programs on either Red Hat Enterprise Linux or Oracle Enterprise Linux 5.0 or greater you receive errors such as the following.

Create and mount VirtualBox shared folders

VirtualBox is an Open Source x86 and AMD64/Intel64 virtualization product. Using VirtualBox you can install many x86 32bit and 64bit operation systems in a virtual machine. The computer that you install VirtualBox on is commonly […]

Block Media Recovery with RMAN

This document will detail a block media recovery scenario using a RMAN disk based backup. If you need a document for configuring RMAN see the post Setting up RMAN for backup and recovery using Database […]

Multiplexing the Redo Log Files

To protect against failure of the redo logs, Oracle allows redo logs to be multiplexed. With multiplexed redo logs two or more identical copies can be placed in separate locations. The log writer process (LGWR) […]