Oracle Technical References

Featured Readings of the week

The team at OracleRef wishes you a very Nice New Reading ! Oracle Magazine May – June 2012   Oracle Database 11g Release 2 Upgrade Quick Start Guide for the VirtualBox Template for Oracle VM Manager Oracle University Technology Newsletter Winter 2011- 2012 How Dell Migrated from SUSE Linux to Oracle Linux Converting 32-bit Applications […]

Installing Oracle Database 11g Release 2 on Linux x86 (RHEL and OEL 5 covered)

1. Overview For the purpose of education and evaluation only, we provide a walkthrough of installing Oracle Database 11g Release 2 on Linux. We take the approach of using minimum number of steps for accomplishing this installation. Note that this guide does not cover the installation of the Linux operating system. This guide assumes a […]

TOP 5 Resources

TOP 5 Resources Learning Oracle Database Learning Oracle Database 11g Release 1 New Features Installing Oracle Database 10g Software Installing Oracle Database 11g Software Using Oracle Init.ora Parameters Creating Oracle Database RMANing Oracle Database Upgrading / Migrating Oracle Databases Data Guarding Oracle Databases “RACking” Oracle Databases Deploying Oracle Database High Availability Environment Using Oracle Database […]

TOP 5 Resources: Learning Oracle Database

Oracle Database 11g Central Place Learning Oracle Online Oracle DBA Tips for Development Oracle Information Oracle Database 10g & 11g Basic Articles

TOP 5 Resources: Learning Oracle Database 11g Release 1 New Features

Oracle Database 11g Features for Administrators Oracle Database 11g New Features Summary Step by step Description of Oracle Database 11g New Features Oracle Database 11g Top New Feature for DBAs Oracle Database 11g New features

TOP 5 Resources: Installing Oracle Database 10g Software

Step-by-step Installing Oracle Database 10g Release 2 on Linux (CentOS) Installing Oracle Database 10g Release 2 on Linux – (RHEL 5) Installing Oracle Database 10g Release 2 on SLES10 for i386 Step-by-Step Installation of Oracle database 10g on RHEL 5 Installing Grid Control 10g on Unbreakable Linux 5.3 (VMware)

TOP 5 Resources: Installing Oracle Database 11g Software

Installing Oracle Database 11g Release 1 on Ubuntu 8.10 Installing Oracle Database 11g Release 1 on Debian sid HOWTO Installing Oracle Database 11g Release 1 on Linux – (RHEL 5) Installing Oracle Database 11g Release 1 on Linux Oracle Database 11g: Installation and Configuration On Redhat Enterprise Linux

TOP 5 Resources: Using Oracle Init.ora Parameters

Oracle Database Server Initialization Parameters Oracle Database 11g Init.Ora & SPFile Oracle Dtabase 11g Startup Parameters Server Parameters for Oracle 9i and 10g Database Oracle Database 11g Initilization Parameters

TOP 5 Resources: Creating Oracle Database

Step by Step Process of Creating Oracle 10g Database using filesystem Step by Step Process of Creating Oracle 11g Database using ASM Step by Step Process of Creating Oracle 10g Database Manually on Linux Step by Step Process of Creating Oracle 10g Database Manually by scripting Newbie Guide to Oracle 11g Database Common Problems – […]

TOP 5 Resources: RMANing Oracle Database

RMAN Duplicate Database Feature in 11G Backing up RAC 11g with RMAN with CATALOG Creating an Oracle 11g Dataguard on VWware using rman “duplicate target database for standby from active database” Oracle RMAN Backups: Pushing the “Easy” Button Archive for RMAN

TOP 5 Resources: Upgrading / Migrating Oracle Databases

Step-by-step advice for Oracle 11g upgrade Upgrading Process to Oracle Database 11g Upgrading to Oracle Database 11g Detailed Upgrading to Oracle RAC 11g on Oracle Enterprise Linux Migrating to Oracle Database 11g Using Transportable Tablespaces

TOP 5 Resources: Data Guarding Oracle Databases

The Basics about Oracle Database 10gR2 Data Guard for Backup & Recovery Creating a Physical Standby Database by Example Oracle 10g Data Guard and High Availability Physical Standby Database configuration Step-by-step Instructions for Creating Logical Standby Database Quick step-by-step Oracle Database 11g Data Guard switchover/failover guide

TOP 5 Resources: “RACking” Oracle Databases

Installing Oracle Database 11g RAC on virtual servers using VMware Step-by-step Instructions on Installing Oracle Database 11g RAC on CentOS Installing Oracle Database 10g with RAC on Red Hat Enterprise Linux Advanced Server 3 Oracle Database 10g RAC – Clusterware Installation Overview Convert a Single Instance Database to Oracle RAC 10g on RHEL3

TOP 5 Resources: Deploying Oracle Database High Availability Environment

Deploying Oracle Database RAC 11g R1 on RHEL 5 or SLES 10 with Oracle ASM Deploying Oracle RAC 10g and 11g with ASM on Red Hat Enterprise Linux Deploying Oracle RAC 11g Release 1 with ASM on AIX 6.1 Building an Oracle Database RAC 11g Release 1 on Linux Building an Oracle Database 11g Release […]

TOP 5 Resources: Using Oracle Database Hints

Oracle Hints Version 11g Optimizer Hints in Oracle 11g Oracle SQL hints New Oracle10g SQL optimizer hints How to use hints in Oracle sql for performance

TOP 5 Resources: Optimizing Oracle Databases

Oracle Performance Tuning – Part 1 & Part 2 Gathering and Publishing Statistics in Oracle Database 11g Optimising Oracle Database Performance by Design Performance Tuning Enhancements in Oracle Database 10g Oracle Initialization Parameters that Affect the CBO

TOP 5 Resources: Learning Ux4Oracle Database

Useful Unix commands for DBAs UNIX Commands for DBAs UNIX shell scripts for DBAs vi Reference Bourne/Bash shell scripting Reference

TOP 5 Resources: Searching ORA- Errors

Oracle Database Error Code Oracle Database Server – ORA Errors Oracle error search Oracle Database 11g Errors Messages Oracle Database 10g Error Messages