Installing Oracle 9i Release 2 on Linux (Cheat Sheet)

Posted at Thursday, October 27, 2005
Here is a step-by-step document that I use to install Oracle 9i Release 2 - specifically 9.2.0.6 - on Linux - specifically Red Hat Enterprise 4.0. The steps in general, however, should apply to most distributions; you will just have to do a little more research if you are using a different distribution.

Installing Oracle 9i Release 2 on Red Hat Enterprise 4.0

Labels: ,

Standby Database Process Flows

Posted at Friday, July 08, 2005

Point-in-Time Duplication - 9i

Posted at Wednesday, June 01, 2005
Every so often, I find myself in a situation in which a user loses data, I need to recover it - from an RMAN tape backup - and only the production host has access to the tape device. In situations such as these, I opt for a Point-In-Time Duplication of the database in question:

Here are the basics:

  • You need to build an instance with a new name for the database you are about to duplicate, including: copy & edit init.ora file (make sure to set db_filename_convert and log_file_name_convert parameters and make sure remote_login_passwordfile is set to something other than 'NONE'!); create necessary file systems; modify listener.ora and tnsnames.ora to include this new instance; create passwordfile, etc.

  • Next modify and execute this script. Be sure to configure any of the necessary RMAN channels, etc.

For additional information you can refer to: Metalink article 228257.1 and/or Oracle 9i RMAN Backup and Recovery by Robert G. Freeman (ISBN# 0072226625).

Feel free to contact me with and questions, comments, experiences, etc.....



Labels: ,

How to Install 9i Release 2 (Windows)

Posted at Sunday, June 06, 2004