Advanced Queuing    

  Amazon Web Services    

  Automatic Storage Management    

  Backup and Recovery    

  Data Guard    

  Database Administration    

  Database Resource Manager    

  Enterprise Manager    

  Export / Import    

  Flashback Technology    

  Heterogeneous Services    

  Java    

  LDAP    

  LOBs    

  Linux    

  LogMiner    

  Microsoft Windows    

  Networking    

  OC4J - (Standalone 9.0.3)    

  OCFS2    

  Objects    

  Oracle10g AS    

  Oracle RAC 10g    

  Oracle RAC 11g    

  Oracle9i AS    

  Oracle RAC 9i    

  Oracle Application Express    

  Oracle Secure Backup    

  Oracle Text    

  Oracle Universal Installer    

  PL/SQL    

  Programming    

  RMAN - (Recovery Manager)    

  SQL    

  SQL*Plus    

  Security    

  Standby Database - (Oracle 7.3 - 8i)    

  Sun Solaris    

  Tablespaces    

  Tuning    

  Unix    

  VMware Server 1.0 - (Free)    

  VMware Workstation 4.5    

  VMware Workstation 5.0 / 5.5    

  VMware Workstation 6.0    

  Workspace Manager    

  xmldb    

 

  Advanced Queuing

         Using Oracle's Advanced Queuing with JMS - (AQ-JMS)

 

         Advanced Queuing Working Example - (PL/SQL)

 

         Advanced Queuing Working Example - (PL/SQL Scripts with Detail)

 

         Introducing Oracle Advanced Queuing - (Oracle 8i)

 

 

  Amazon Web Services

         Oracle Database Backup to Amazon Simple Storage Service (Amazon S3) on Linux

 

         Configure Oracle ASM on Amazon EC2

 

         Configure Oracle Database 11g R2 on Amazon EC2

 

 

  Automatic Storage Management

         Using the Oracle ASM Cluster File System (Oracle ACFS) on Linux - (11gR2)

 

         Connecting to ASM through the TNS Listener from a Client Desktop - (10gR2)

 

         Duplicating an SPFILE from an ASM Diskgroup to the Local File System

 

         Moving ASM Database Files from one Diskgroup to Another

 

         Migrating Databases from non-ASM to ASM and Vice-Versa

 

         Duplicate a Database in Flash Recovery Area using ASM to non-ASM Host using RMAN

 

         How to use Files in place of Real Disk Devices for ASM - (10g, Windows)

 

         How to use Files in place of Real Disk Devices for ASM - (10g, Solaris)

 

         How to use Files in place of Real Disk Devices for ASM - (10g, Linux)

 

         Adding / Dropping Disks From a ASM Disk Group

 

         ASM SQL Scripts

 

         Manually Creating an ASM Instance - (10gR2)

 

 

  Backup and Recovery

         Automatic Archiving does not Restart if Disk Space is Full

 

         Copy and Rename an Oracle Database - (without export/import)

 

 

  Data Guard

         Database Rolling Upgrade Using Data Guard Transient Logical Standby - (11g)

 

         Database Rolling Upgrade Using Data Guard SQL Apply - (10g to 11g)

 

         Using RMAN Incremental Backups to Roll Forward a Physical Standby Database - (10g)

 

         Using a Physical Standby Database for Read/Write Testing and Reporting - (10g)

 

         Using Flashback Database After a Failover - (10g)

 

         Activating the Standby Database - (10g, Logical Standby)

 

         Activating the Standby Database - (10g, Physical Standby)

 

         Data Guard Configuration Example - (10g, Logical Standby)

 

         Data Guard Configuration Example - (10g, Physical Standby)

 

         Creating a Standby Database using RMAN - (UNIX / Linux)

 

         Activating the Standby Database - (9i)

 

         Implementing Oracle9i Data Guard

 

         Data Guard Configuration Example - (9i, Physical Standby)

 

         Data Guard Archived Redo Log Repository

 

         Log Gap Detection and Resolution

 

         Data Protection Modes - (9i - 10g)

 

 

  Database Administration

         Change OSDBA and OSOPER Role after Installation

 

         Snapshot Database - (Producing DBA Reports in HTML)

 

         Free IT - Software and Development Magazines!

 

         Configuring RMAN Default Settings

 

         Resetting Initialization Parameters

 

         Resumable Space Management - (Oracle 9i)

 

         Online Data Reorganization and Data Redefinition - (Oracle 9i)

 

         UTL_FILE_DIR init.ora Parameter Obsoleted From Oracle9i R2

 

         Automatic UNDO Management in Oracle9i

 

         External Tables

 

         Change Static Parameters Through the SPFILE

 

         Introduction to Server Parameter Files (SPFILE)

 

         Dropping a column from a table - (Oracle 8i and higher)

 

         Renaming / Moving Data Files, Control Files, and Online Redo Logs

 

         Resizing / Recreating Online Redo Log Files

 

         Creating the Oracle Sample Schema - (Release 9i and 10g)

 

         SQLPATH / ORACLE_PATH on NT

 

         Monitoring Transactions and Rollback

 

         Flushing the Oracle Data Buffer Cache During Performance Testing

 

         Creating Indexes on Foreign Keys

 

         Script to Check for Default Passwords Being Used for Common Usernames

 

         Oracle Created (Default) Database Users

 

         Understanding Maximum Sizes for VARCHAR2 Data

 

         Queries to handle Local Extent Management and Tempfiles

 

         How to efficiently drop a table with many extents

 

         List the details of database growth per month

 

         Inline Views

 

         The BECOME USER System Privilege

 

         Oracle Database Shutdown Stages

 

         How to Drop a Datafile from a Tablespace

 

         Locating duplicate rows when trying to create UNIQUE INDEX

 

         Obsolete Database Parameters

 

         Tracing SQL and Client/Server Events

 

         Deferred Integrity Constraints in Oracle8

 

         Recompiling Invalid Objects

 

         Exploring Hidden Parameters

 

         Resizing Datafiles in Oracle 7.2 and Above

 

         Query the data dictionary to find the current DB_NAME and ORACLE_SID

 

         What is the purpose of the sgadef.dbf file?

 

         Relinking the Oracle Server executables

 

         What is the table DUAL used for?

 

         Dropping a database

 

         Sending messages to the standard alert log file

 

         Creating and Manipulating Views

 

 

  Database Resource Manager

         Introdcution to Database Resource Manager - (Oracle 8i)

 

 

  Enterprise Manager

         Database Control Fails to Start After 31-Dec-2010 - (10.2.0.4/10.2.0.5)

 

         Resolve Duplicate CRS Cluster Name in EM Grid Control - (Grid Control 10g)

 

         Troubleshooting Oracle Enterprise Manager 10g

 

         Installing Grid Control Management Agent (10.2.0.5)

 

         Installing Grid Control (10.2.0.5) on RHEL 5 with 11g Database Repository

 

         How to Recreate the Database Control Repository - (Oracle 10g / 11g)

 

         How to Recreate the Database Control Repository - (Oracle10g R1)

 

         Creating an Oracle Management Server - (OMS Release 9.2.0)

 

         Starting the Oracle9i Intelligent Agent Fails

 

 

  Export / Import

         Monitor Import Speed

 

         Export Files Greater Than 2GB

 

         Faster database exports/imports

 

 

  Flashback Technology

         Flashback Transaction - (11g)

 

         Oracle LogMiner Viewer and Flashback Transaction

 

         Using Flashback Database After a Failover - (10g)

 

 

  Heterogeneous Services

         How to Setup HSODBC (Oracle9i on Solaris) to MySQL on Linux

 

 

  Java

         JDBC Examples

 

         De-support Information - (J2EE & Corba in the Oracle9i Database)

 

         Deploying Java Servlets and JSPs using the Oracle HTTP Server - (Oracle 8i)

 

         JServer / Thin Driver Connection Manager for Oracle

 

         Serializing Java Objects to Oracle

 

         Introduction to Java Stored Procedures - (JServer / Oracle 8i)

 

         Oracle Servlet Engine - (OSE)

 

         Chronology of Java Technologies in Oracle

 

 

  LDAP

         Oracle PL/SQL LDAP API Example

 

         Oracle Database Name Resolution with OpenLDAP

 

         Using LDAP Command-Line Tools

 

 

  LOBs

         Converting LONGS to LOBS in Oracle9i

 

         Reclaiming Unused LOB Space

 

         Unloading LOBS To A File using EXTPROC

 

         CR/LF Added to Binary File When Using UTL_FILE.PUT_RAW

 

         Load Text Files to CLOB then Write Back Out to Disk - (Java)

 

         Load Text Files to CLOB then Write Back Out to Disk - (PL/SQL)

 

         Load Text Files to CLOB / Multi-Byte Characterset DB - (PL/SQL)

 

         Load Text Files to BFILE then Write Back Out to Console - (Java)

 

         Load Binary File to BFILE then Write Back Out to Disk - (PL/SQL)

 

         Load Binary Files to BLOB then Write Back Out to Disk - (Java)

 

         Load Text Data to BLOB then Write Back Out to Console - (PL/SQL)

 

         Load Binary File to BLOB then Write Back Out to Disk - (PL/SQL)

 

         Load Binary File to BLOB then Write Back Out to Disk - (SQL*Loader)

 

         Loading Data to LOBs Using Only SQL - (< 4K)

 

         Temporary LOBs

 

         DDL Commands for LOBs

 

         Introduction to Oracle LOBs

 

 

  Linux

         Disk Space Error While Installing RHEL5

 

         Install Oracle Database 11g R2 on Linux - (RHEL 6)

 

         Install Oracle Database 11g R2 on Linux using Oracle ASM - (OL5)

 

         Install Oracle Database 11g R2 on Linux - (OL5)

 

         Install Oracle Database 11g R1 on Linux - (RHEL 5)

 

         Install Oracle Database 10g R2 on Linux - (RHEL 5)

 

         Install Oracle Database 10g R1 on Linux using ASM - (RHEL 4)

 

         Install Oracle9i R2 on Linux - (Fedora Core 2)

 

         Install Oracle9i R2 on Linux Using RAW Devices - (Red Hat Linux 8.0)

 

         Starting TNS Listener gives "Linux Error: 32: Broken pipe"

 

         Install Oracle9i R2 on Red Hat Linux 7.3 - 8.0

 

         ORA-01041 / ORA-03113 after shutdown/startup - (Oracle 9i)

 

         Install Oracle8i on Red Hat Linux 7.1 - 7.2

 

         Install Oracle9i on Red Hat Linux 7.1 - 7.2

 

 

  LogMiner

         Oracle LogMiner Viewer and Flashback Transaction

 

         Using the CONTINUOUS_MINE Option (Example)

 

         Reading the LogMiner Dictionary From the Current Online Catalog (Example)

 

         Extract LogMiner Dictionary to the Redo Log Files (Example)

 

         Extract LogMiner Dictionary to a Flat File (Example)

 

         LogMiner by Example

 

         Understanding LogMiner

 

 

  Microsoft Windows

         SQORAS32: An unsupported operation was attempted.

 

         Uptime for Windows - (2003, 2000, XP and NT)

 

         Sending and Receiving Email in Windows From Scripts

 

         Configuring SMTP on Windows

 

         QuickSlice

 

         Killing Runaway Oracle Processes on Windows with OraKill

 

 

  Networking

         Recycling the listener.log File

 

         Running MTS on Oracle8i Database with Oracle9i Listener

 

         Multi-Threaded Server Overview

 

 

  OC4J - (Standalone 9.0.3)

         Using OC4J in JDeveloper9i

 

         Data Sources and OC4J

 

         Deploying WAR Files to OC4J

 

         Using Oracle's Advanced Queuing with JMS - (AQ-JMS)

 

         Configuring the Pet Store Web Application Demo for OC4J

 

         Administrative Commands

 

         Starting / Stopping OC4J

 

         Undeploying Applications

 

         Deploying Applications

 

         Installing OC4J

 

         OC4J Documentation / FAQs

 

 

  OCFS2

         Differences in df and du on Oracle Cluster File System (OCFS2) and Orphan Files

 

         Upgrading OCFS2 - 1.4

 

 

  Objects

         SQL Script to Create Oracle Objects

 

 

  Oracle10g AS

         Installing Oracle10gAS Release 2 - (Windows)

 

 

  Oracle RAC 10g

         Recover Corrupt/Missing OCR with No Backup - (Oracle 10g)

 

         OCR File and Voting Disk Administration by Example - (Oracle 10g)

 

         Enabling Archive Logs in a RAC Environment

 

         Controlling the Oracle Clusterware Services (CRS) 10g in UNIX / Linux

 

         Automatically Restarting ONS - (Oracle10g R1)

 

         Remove a Node from an Existing Oracle RAC 10g R2 Cluster on Linux - (RHEL 5.3)

 

         Remove a Node from an Existing Oracle RAC 10g R2 Cluster on Linux - (RHEL 4.5)

 

         Remove a Node from an Existing Oracle RAC 10g R1 Cluster on Linux - (FireWire)

 

         Add a Node to an Existing Oracle RAC 10g R2 Cluster on Linux - (RHEL 5.3)

 

         Add a Node to an Existing Oracle RAC 10g R2 Cluster on Linux - (RHEL 4.5)

 

         Add a Node to an Existing Oracle RAC 10g R1 Cluster on Linux - (FireWire)

 

         Installing Oracle RAC 10g R2 - (Single Node Install on RHEL 3)

 

         Installing Oracle RAC 10g R1 Standard Edition on Windows Server 2003

 

         Create an Oracle RAC 10g R2 using VMware Workstation 5 - (RHEL 4.4)

 

         Building an Inexpensive Oracle RAC 10g R2 on Linux - (RHEL 5.3)

 

         Building an Inexpensive Oracle RAC 10g R2 on Linux - (RHEL 4.5)

 

         Building an Inexpensive Oracle RAC 10g R2 on Linux - (FireWire)

 

         Building an Inexpensive Oracle RAC 10g R1 on Linux - (FireWire)

 

 

  Oracle RAC 11g

         Enabling Archive Logs in a RAC Environment

 

         Remove a Node from an Existing Oracle RAC 11g R2 Cluster on Linux - (RHEL 5)

 

         Add a Node to an Existing Oracle RAC 11g R2 Cluster on Linux - (RHEL 5)

 

         Building an Inexpensive Oracle RAC 11g R2 on Linux - (RHEL 5)

 

         Building an Inexpensive Oracle RAC 11g R1 on Linux - (RHEL 5)

 

 

  Oracle9i AS

         Installing Oracle9iAS Release 2 - (Linux)

 

         Installing Oracle9iAS Release 2 - (Windows)

 

         Installing Oracle9iAS Release 2 - (Solaris)

 

 

  Oracle RAC 9i

         Which instance am I logged in to?

 

         Software Required for Oracle9i RAC

 

         Why does RAC require raw devices?

 

         Determining Which Network Oracle is using for Oracle9i RAC Traffic

 

         Building an Inexpensive Oracle RAC 9i on Linux

 

 

  Oracle Application Express - (formerly HTML DB)

         Managing Workspaces

 

         Installing Oracle Application Express 2.2

 

         Installing Oracle Application Express 2.0

 

 

  Oracle Secure Backup

         Cleaning a Tape Drive using Oracle Secure Backup

 

 

  Oracle Text

         Useful Scripts For Using Oracle Text

 

         Oracle Text Examples

 

         Oracle Text FAQ - (from Oracle OTN)

 

         How Oracle Text (Oracle 9i) Relates To interMedia Text (Oracle 8i)

 

 

  Oracle Universal Installer

         Creating Response File by Recording It During Installation - (Oracle9i R2)

 

 

  PL/SQL

         Using UTL_HTTP and an Oracle Wallet to Establish a Secure URL Connection (SSL)

 

         Changes in Configuring External Procedures in Oracle 9.2 (and higher)

 

         Native Compiled PL/SQL

 

         Oracle Internet Directory PL/SQL API Examples - (Version 9.2.0)

 

         Installing the Oracle Internet Directory PL/SQL API - (Version 9.2.0)

 

         Using JDeveloper for PL/SQL Coding and Debugging

 

         Sending E-Mail in PL/SQL

 

         Creating Random Numbers in PL/SQL

 

         Loading Comma Delimited Data using PL/SQL

 

         Unloading LOBs to a File

 

         Viewing ASCII Data within a BLOB

 

         Build Insert Statements for the Existing Data in Tables

 

         Introduction to DBMS_JOB

 

         How to perform long deletes - (commiting every n number of records)

 

         Debugging PL/SQL with the DBMS_OUTPUT Package

 

         Calling OS Commands from PL/SQL using External Procedures - (extproc)

 

 

  Programming

         Installing DBI / DBD-Oracle with ActivePerl

 

         Oracle Programming with Perl DBI / DBD

 

         Oracle Programming with Tcl & Oratcl

 

 

  RMAN - (Recovery Manager)

         RMAN Recovery Catalog - (11g)

 

         Migrating Databases from non-ASM to ASM and Vice-Versa

 

         Duplicate a Database in Flash Recovery Area using ASM to non-ASM Host using RMAN

 

         How to Restore the controlfile using RMAN

 

         Drop a Target Database using RMAN

 

         A Typical Oracle9i RMAN Setup and Configuration

 

         Creating a Standby Database using RMAN - (UNIX / Linux)

 

         Duplicating a Database using RMAN - (UNIX / Linux)

 

         Duplicating a Database using RMAN - (Windows NT / 2000)

 

         Case Study #3 - (Backup / Recovery / No-Archivelog / Exclude Tablespace)

 

         Case Study #2 - (Backup / Recovery / No-Archivelog / Read-Only Tablespace)

 

         Case Study #1 - (Backup / Recovery / No-Archivelog)

 

         Using the LIST Command

 

         Views and Synonyms

 

         RESTORE / RECOVERY Examples

 

         BACKUP Examples

 

         Configuring RMAN Default Settings

 

         The Recovery Catalog

 

         Creating an RMAN Database User on the Target Database for Backups

 

         Setting the CONTROL_FILE_RECORD_KEEP_TIME Parameter

 

         Introduction to RMAN

 

 

  SQL

         Using Analytic Functions in Oracle9i

 

         Using the MERGE Statement

 

         Scalar Subqueries

 

         Using CASE Statements

 

         ANYDATA Type

 

         Sample Table Scans

 

         Solving Directed Graphs with SQL

 

         Search and Replace with REPLACE Function

 

         Oracle SQL:99 JOIN Syntax in Oracle9i

 

         Using MERGE INTO to upsert Literal Values

 

         Expressing Time with Fractions - (Date Arithmetic)

 

         Fun with SQL

 

         Using ESCAPE with LIKE

 

         Convert Numbers to Words

 

 

  SQL*Plus

         Replace the SQL> Prompt with the Current User Name

 

         Command History and Auto-Completion for SQL*Plus on Unix/Linux

 

         New LOGON Option to SQL*Plus - (Oracle 9i)

 

 

  Security

         Secure Database Passwords in an Oracle Wallet

 

         Oracle OS Authentication

 

         New System Privilege in Oracle9i - GRANT ANY OBJECT PRIVILEGE

 

         Using the REPLACE Keyword with ALTER USER

 

         Privileged Connections in Oracle9i

 

         Example CREATE PROFILE Password Security Script

 

         Preventing Users From Changing Their Password

 

         Disabling Commands Using the Table: PRODUCT_USER_PROFILE

 

 

  Standby Database - (Oracle 7.3 - 8i)

         Activating the Standby Database - (Oracle 8i)

 

         Standby Database Maintenance

 

         Adding Datafiles to the Primary Database

 

         Placing Standby Database in READ ONLY Mode

 

         Placing Standby Database in Managed Recovery Mode

 

         Creating an Oracle Standby Database - (Oracle 8i)

 

 

  Sun Solaris

         Installing Oracle Database 10g R1 (10.1.0) on Solaris 9

 

         Installing Oracle9i R2 (9.2.0) on Solaris 9

 

         Installing Oracle8i R3 (8.1.7) on Solaris 9

 

         Setting Solaris Kernel Parameter for Oracle

 

         Oracle Memory Usage in Sun Solaris

 

         Determine Background Process Size on Solaris using pmap

 

 

  Tablespaces

         Segment Space Management in Locally Managed Tablespaces - (Oracle 9i)

 

         Default Temporary Tablespaces - (Oracle 9i)

 

         Dropping Tablespaces and Datafiles in Oracle9i

 

         Oracle-Managed Files (OMF)

 

         Transportable Tablespaces

 

         Resizing Temporary Tablespace

 

         Managing Extents

 

         Dictionary vs. Locally Managed Tablespaces

 

 

  Tuning

         New FOR UPDATE WAIT Enhancement

 

         New Time Measurement Units in Oracle9i

 

         Skip Scan Index Access

 

         Gather Statistics with DBMS_STATS

 

         PGA / UGA Memory Overview

 

         Virtual Indexes

 

         New Explain Plan Output in Oracle9i

 

         Formatted Explain Plan Output

 

         Using Parallel Query and Other Parallel Features

 

         Data Dictionary Performance Problems After Running DBMS_STATS

 

         Parsing SQL Statements in Oracle

 

         Choosing the Correct Database Block Size

 

         SGA Free Pool Report

 

         Tuning buffer busy waits by file

 

         Tuning the Redo Log Buffer

 

         Sharing SQL Statements - (Oracle 8i)

 

         Automatic EXPLAIN PLANS and TKPROF

 

         Redo Log Switch History

 

         Hit Ratios by System and Session

 

         Tuning the Shared Pool

 

 

  Unix

         Copying Oracle Home Directories using rsync

 

         Crontab Redirect to Log File With Date in Name

 

         Query Installed Oracle Products (UNIX)

 

         Setting Oracle environment variables in UNIX

 

         SELECTing a value from a table into a Unix variable

 

         Determining which instance owns which shared memory & semaphore segments

 

 

  VMware Server 1.0 - (Free)

         Creating a New Virtual Machine - (Solaris 10)

 

         Installing VMware Server 1.0 - (Windows XP)

 

 

  VMware Workstation 4.5

         Using Legacy Emulation Mode with VMware on Linux

 

         Deleting a Virtual Machine

 

         Creating a New Virtual Machine - (Windows XP Professional)

 

         Creating a New Virtual Machine - (Solaris 9)

 

         Creating a New Virtual Machine - (White Box Enterprise Linux)

 

         Installing VMware Workstation 4.5 - (Windows XP)

 

 

  VMware Workstation 5.0 / 5.5

         Create an Oracle RAC 10g R2 using VMware Workstation 5 - (RHEL 4.4)

 

         Deleting a Virtual Machine

 

         Creating a New Virtual Machine - (Solaris 10)

 

         Creating a New Virtual Machine - (CentOS Enterprise Linux 4.2)

 

         Installing VMware Workstation 5.0 / 5.5 - (Windows XP)

 

 

  VMware Workstation 6.0

         Creating a New Virtual Machine - (Solaris 10)

 

         Creating a New Virtual Machine - (CentOS Enterprise Linux 5.0)

 

         Installing VMware Workstation 6.0 - (Windows XP)

 

 

  Workspace Manager

         Introduction to Workspace Management

 

 

  xmldb

         Is XML DB Installed and Configured Correctly?

 

         OEM Console Bug in XML DB Using 9.2.0.3.0 Patchset

 

         Installing and Configuring XML DB

 

         XML DB Port Assignments

 

         Introduction to XML DB

 

 


Copyright (c) 1998-2017 Jeffrey M. Hunter. All rights reserved.

All articles, scripts and material located at the Internet address of http://www.idevelopment.info is the copyright of Jeffrey M. Hunter and is protected under copyright laws of the United States. This document may not be hosted on any other site without my express, prior, written permission. Application to host any of the material elsewhere can be made by contacting me at jhunter@idevelopment.info.

I have made every effort and taken great care in making sure that the material included on my web site is technically accurate, but I disclaim any and all responsibility for any loss, damage or destruction of data or any other property which may arise from relying on it. I will in no case be liable for any monetary damages arising from such loss, damage or destruction.