ORACLE - DBA Tips Corner

DBA Tips Archive for Oracle

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

by Jeff Hunter, Sr. Database Administrator

Contents

Overview
Swap Space Considerations
Install the Java Development Kit (JDK)
Create Oracle Account and Directories
Downloading / Unpacking the Oracle9i Installation Files
Run the Oracle Installer
Errors during the Relink Phase of the Install
Creating an Oracle9i Database on RAW Devices
Configuration Files / Scripts

Overview

This article is a comprehensive guide for installing Oracle9i Release 2 on the Redhat Linux 8.0 operating environment. The database will be created using RAW devices.
Keep in mind the following assumptions throughout this article:

The Linux install will be Red Hat Professional 8.0.

When installing Linux, I will install ALL software components. (Everything). This makes it easier than trying to troubleshoot missing software components.

The ORACLE_SID of the database to be created is O920DB.

The Linux server will be configured as follows:

Pentium IV Computer
1.8GHz Pentium IV
512MB RAM
40GB Internal HD (Master /dev/hda)
40GB Internal HD (Slave /dev/hdb)
32MB AGP Video Card
CDROM and Floppy

The Linux server will contain two internal IDE hard drives:

/dev/hda - This HD will contain the Linux operating system and Oracle9i database software.
/dev/hdb - This HD will contain the RAW devices where all Oracle database files (data files, control files, online redo logs) will exist. We will be using LVM to create the partitions on this drive.

For the /dev/hdb hard drive, we will be using Logical Volume Manager (LVM) to create all of the partitions. It should be assumed that NO partitions exist on this drive. Instructions will be provided to remove any partitions that may already exist on this hard drive.

Swap Space Considerations

Installing Oracle9i requires a minimum of 512MB of memory.
(An inadequate amount of swap during the installation will cause the Oracle Universal Installer to either "hang" or "die")
To check the amount of memory / swap you have allocated, type either:
# free
- OR -
# cat /proc/swaps
- OR -
# cat /proc/meminfo | grep MemTotal
If you have less than 512MB of memory (between your RAM and SWAP), you can add temporary swap space by creating a temporary swap file. This way you do not have to use a raw device or even more drastic, rebuild your system.
As root, make a file that will act as additional swap space, let's say about 300MB:
# dd if=/dev/zero of=tempswap bs=1k count=300000
Now we should change the file permissions:
# chmod 600 tempswap
Finally we format the "partition" as swap and add it to the swap space:
# mke2fs tempswap # mkswap tempswap # swapon tempswap

Install the Java Development Kit (JDK)

In order to use Oracle's HTTP [Apache] Server, you will need to download the appropiate SDK from Sun.
As per the JDK documentation, install JDK under /usr/local.
Then create a symbolic link to the JDK under /usr/local/java.

Sun's SDK 1.4.1
Download from: http://java.sun.com/j2se/1.4.1/download.html
Download the "Linux self-extracting file / SDK" option. (I still don't trust or use RPMs).
Install as root:

# cp j2sdk-1_4_1_01-linux-i586.bin /usr/local # cd /usr/local # chmod 755 j2sdk-1_4_1_01-linux-i586.bin # ./j2sdk-1_4_1_01-linux-i586.bin # ln -s /usr/local/j2sdk1.4.1_01 /usr/local/java # rm j2sdk-1_4_1_01-linux-i586.bin

Create Oracle Account and Directories

Create Oracle User Account:
# groupadd -g 115 dba # useradd -u 173 -c "Oracle Software Owner" -d /u01/app/oracle -g "dba" -m -s /bin/bash oracle # passwd oracle
Create Oracle Directories:
# mkdir /u01 # mkdir /u01/app # mkdir /u01/app/oracle # mkdir /u01/app/oracle/admin # mkdir /u01/app/oracle/admin/O920DB # mkdir /u01/app/oracle/admin/O920DB/adhoc # mkdir /u01/app/oracle/admin/O920DB/adump # mkdir /u01/app/oracle/admin/O920DB/arch # mkdir /u01/app/oracle/admin/O920DB/backups # mkdir /u01/app/oracle/admin/O920DB/bdump # mkdir /u01/app/oracle/admin/O920DB/cdump # mkdir /u01/app/oracle/admin/O920DB/create # mkdir /u01/app/oracle/admin/O920DB/dba # mkdir /u01/app/oracle/admin/O920DB/exp # mkdir /u01/app/oracle/admin/O920DB/logbook # mkdir /u01/app/oracle/admin/O920DB/pfile # mkdir /u01/app/oracle/admin/O920DB/release # mkdir /u01/app/oracle/admin/O920DB/report # mkdir /u01/app/oracle/admin/O920DB/tuning # mkdir /u01/app/oracle/admin/O920DB/udump # mkdir /u01/app/oracle/product # chown -R oracle:dba /u01/app/oracle
# mkdir /opt/bin # chown oracle:dba /opt/bin
Oracle Environment Variable Settings:
An example ".bash_profile" is provided in the Configuration Files / Scripts section below.
Ensure to set the environment variable: LD_ASSUME_KERNEL=2.2.5
NOTE: Failing to set the LD_ASSUME_KERNEL parameter will cause the Oracle Universal Installer to hang!

Downloading / Unpacking the Oracle9i Installation Files

Login as the newly created "oracle" user account. (su - oracle). Most of the actions throughout the rest of this document should be done as the "oracle" user account unless otherwise noted.

Download Oracle9i from Oracle's OTN Site.
(If you do not currently have an account with Oracle OTN, you will need to create one. This is a FREE account!)
http://otn.oracle.com/software/products/oracle9i/htdocs/linuxsoft.html
Download the following files to a temporary directory:
- lnx_920_disk1.cpio.gz (553,607,967 bytes)
- lnx_920_disk2.cpio.gz (588,817,480 bytes)
- lnx_920_disk3.cpio.gz (442,135,815 bytes)
Directions to extract the files.
1. Run "gunzip <filename>" on all the files.
  Eg. gunzip lnx_920_disk1.cpio.gz
2. Extract the cpio archives with the command: "cpio -idmv < <filename>"
  Eg. cpio -idmv < lnx_920_disk1.cpio
  Important Note: Some browsers will uncompress the files but leave the extension the same (gz) when downloading. If the above steps do not work for you, try skipping step 1 and go directly to step 2 without changing the filename.
  Eg. "cpio -idmv < lnx_920_disk1.cpio.gz"
You should now have three directories called "Disk1, Disk2 and Disk3" containing the Oracle9i Installation files:
/Disk1 /Disk2 /Disk3

Run the Oracle Installer

As the "oracle" user account:

Set your DISPLAY variable to a valid X Windows display.
% DISPLAY=<Any X-Windows Host>:0.0 % export DISPLAY
NOTE: If you forgot to set the DISPLAY environment variable and you get the following error:
Xlib: connection to ":0.0" refused by server Xlib: Client is not authorized to connect to Server
you will then need to execute the following command to get "runInstaller" working again:
% rm -rf /tmp/OraInstall
If you don't do this, the Installer will hang without giving any error messages. Also make sure that "runInstaller" has stopped running in the background. If not, kill it.

Change directory to the Oracle installation files you downloaded and extracted. Then run: runInstaller.
% cd <your temp directory>/Disk1 % ./runInstaller

During the installation, DO NOT choose to "Create A Database". This how I answered the questions:

Inventory Location: /u01/app/oracle/oraInventory

UNIX Group Name: dba
You will be prompted to run /tmp/orainstRoot.sh as the "root" user account. After performing this action, continue the install by hitting the "Continue" button in the installer.
Destination:

Name: OraHome920
Path: /u01/app/oracle/product/9.2.0

Available Products: Oracle9i Database 9.2.0.1.0
Installation Types: Enterprise Edition (2.04GB)
Database Configuration: Software Only

Errors during the "Link" phase
About 84% into the Link phase of the install, you will get an error when invoking the target of "install" in makefile: /u01/app/oracle/product/9.2.0/ctx/lib/ins_ctx.mk. Leave this error message up and refer to the next section, Errors during the Relink Phase of the Install , on how to resolve and continue from this error. You will come back to this error dialog box after modify the $ORACLE_HOME/ctx/lib/env_ctx.mk file.

Continuing with the "Link" phase
The "Link" phase will now successfully continue to 100% complete. When the "Link" phase is complete, you will be prompted to run the $ORACLE_HOME/root.sh script as the "root" user account. Go ahead and perform this action. When prompted for the "local bin directory", I generally choose to put the files in /opt/bin keeping with by old conventions of Solaris. You may choose to use the default of /usr/local/bin if you would like. Just make sure that whatever directory you choose that it is in the PATH environment variable of the "oracle" user account.

Completing the Installation
After running the root.sh script in the above step, you have successfully installed the Oracle9i database software. At the "End of Installation" screen, simply hit the "Exit" button. A few seconds after hitting the "Exit" button will bring up "Oracle Enterprise Manager" (OEM). I generally exit from the OEM application as I keep a central repository for all nodes and databases.
From here, it is time to create the O920DB Oracle database. In the Configuration Files / Scripts section of this document, I put together an example initO920DB.ora instance parameter file along with a set of CREATE DATABASE... scripts in an archive named create_database920.tar.
Good Luck!

Errors during the Relink Phase of the Install

During the "Link Phase" of the install, you will get an error while trying to make/install CTX. (The same issue exists in 9.0.1 on RedHat Linux).
The following errors will exist in $ORACLE_HOME/install/make.log
/lib/libdl.so.2: undefined reference to `__ctype_b_loc@GLIBC_2.3' /lib/libdl.so.2: undefined reference to `_dl_addr@GLIBC_PRIVATE' /lib/libdl.so.2: undefined reference to `_dl_open@GLIBC_PRIVATE' /lib/libdl.so.2: undefined reference to `_dl_close@GLIBC_PRIVATE' /lib/libdl.so.2: undefined reference to `_dl_sym@GLIBC_PRIVATE' /lib/libdl.so.2: undefined reference to `_dl_vsym@GLIBC_PRIVATE' collect2: ld returned 1 exit status make: *** [ctxhx] Error 1
This error occurs when the following is executed:
/usr/bin/make -f ins_ctx.mk install ORACLE_HOME=/u01/app/oracle/product/9.2.0
Solution
The solution is to edit the file $ORACLE_HOME/ctx/lib/env_ctx.mk and go to "INSO_LINK =", add a "$(LDLIBFLAG)dl" to the line and save it.
Here is the full line with the added "$(LDLIBFLAG)dl" flag:
INSO_LINK = -L$(CTXLIB) $(LDLIBFLAG)m $(LDLIBFLAG)dl $(LDLIBFLAG)sc_ca $(LDLIBFLAG)sc_fa $(LDLIBFLAG)sc_ex $(LDLIBFLAG)sc_da $(LDLIBFLAG)sc_ut $(LDLIBFLAG)sc_ch $(LDLIBFLAG)sc_fi $(LLIBCTXHX) $(LDLIBFLAG)c -Wl,-rpath,$(CTXHOME)lib $(CORELIBS) $(COMPEOBJS)
Set LD_ASSUME_KERNEL
You will also need to enter LD_ASSUME_KERNEL=2.2.5 in your .profile (or .bash_profile if you are using BASH) for the "oracle" user account so that they you can run programs like "dbssist" and "netca".
Return and Retry
After making the above change, return to the popup error dialog box and hit "Retry". It should continue from here with no errors.

Creating an Oracle9i Database on RAW Devices

Now to the heart of this document, and that is how to create a database using RAW devices instead of using files on a file system. So far, all of the action has taken place on the master IDE drive, /dev/hda. It is now time to work with that second hard drive in our system, /dev/hdb. As I mentioned in the first section of this document, the Linux operating system and the Oracle database software will be installed on /dev/hda, while we will be creating a database named O920DB on RAW devices on the /dev/hdb disk. Here is a short overview of how we will be accomplishing this:

We will be using the entire /dev/hdb hard drive for the Oracle database. There should be no partition tables on this disk. I will show how to remove any parition tables from the disk.

We will then create an LVM Physical Volume called /dev/pv1 for the entire /dev/hdb hard drive.

The demonstration will then continue by creating an LVM Volume Group and including the previously created LVM Physical Volume.

After creating the LVM Volume Group, we then continue by creating an LVM Logical Volume for each datafile, controlfile, and online redo log file for our new database. All together, we will be creating 24 Logical Volumes.

Use the raw command to bind RAW devices to our Logical Volumes created in the previous task.

We complete this section with a sample SQL script that creates a database named O920DB that utilizes our RAW deivces.

Removing Any Partitions On Second IDE Internal Hard Drive
I decided to use my second IDE 40GB hard drive as the one to store the Oracle database files. The device was recognized on my system as: /dev/hdb. Lets assume for the purpose of this document that the entire hard drive should be dedicated to Oracle database files and that no partitions will exist. If there are partitions on the /dev/hdb hard disk, there are several ways to remove them. The first way is to use the Linux fdisk utility. Using fdisk, you can simply walk through any of the primary / extended partitions and use the proper commands to remove them. Once you have removed all of the partitions, use the p command within fdisk to verify that no further partitions exist. When you are sure they are all removed, use the w command within fdisk to write your changes to the hard disk's partition table.
Another way to remove any entries in the hard disk's partition table is to use the dd command:

The following commands will destroy the partition table on the disk being operated on. Be very sure it is the correct disk before continuing!

# dd if=/dev/zero of=/dev/hdb bs=1K count=1 1+0 records in 1+0 records out # blockdev --rereadpt /dev/hdb
At this point, you should have a hard drive recognized as /dev/hdb with no partitions.

Create the LVM Physical Volume
In this step, we will create an LVM Physical Volume called /dev/pv1 for the entire hard disk /dev/hdb.
Before continuing with the syntax for creating the LVM Physical Volume, I want to mention that within the Configuration Files / Scripts section of this document, I included a shell script named create_hdb_lvm.sh that contains all of the commands to create the LVM Physical Volume, LVM Volume Group, and LVM Logical Volumes for the /dev/hdb hard drive. Create an LVM Physical Volume named /dev/pv1 for the entire /dev/hdb hard drive using the following command:
# pvcreate /dev/hdb pvcreate -- physical volume "/dev/hdb" successfully created

Create the LVM Volume Group
In this step, we will create an LVM Volume Group that will contain the LVM Physical Volume /dev/pv1.
Like mentioned in the previous section, all commands for creating the LVM Logical Volumes are contained in the script create_hdb_lvm.sh. Create an LVM Volume Group named that contains the LVM Physical Volume /dev/pv1.
# vgcreate -l 256 -p 256 -s 128k /dev/pv1 /dev/hdb
vgcreate -- INFO: maximum logical volume size is 8 Gigabyte
vgcreate -- doing automatic backup of volume group "pv1"
vgcreate -- volume group "pv1" successfully created and activated
Create All LVM Logical Volumes
Now that we have a LVM Volume Group that contains the block device /dev/hdb, it is time to create all of the LVM Logical Volumes that will be used to house all of the Oracle database files.
Like mentioned in the previous section, all commands for creating the LVM Logical Volumes are contained in the script create_hdb_lvm.sh. Create all required LVM Logical Volumes as determined by the number of Oracle database files you will need for the database. In our example, we will need to create 24 LVM Logical Volumes in order to store the 24 Oracle database files for our O920DB database.
# lvcreate -L 900m /dev/pv1     # SYSTEM Tablespace - (800m)
lvcreate -- doing automatic backup of "pv1"
lvcreate -- logical volume "/dev/pv1/lvol1" successfully created

# lvcreate -L 120m /dev/pv1     # Control File 1 - (110m)
lvcreate -- doing automatic backup of "pv1"
lvcreate -- logical volume "/dev/pv1/lvol2" successfully created

# lvcreate -L 120m /dev/pv1     # Control File 2 - (110m)
lvcreate -- doing automatic backup of "pv1"
lvcreate -- logical volume "/dev/pv1/lvol3" successfully created

# lvcreate -L 120m /dev/pv1     # Control File 3 - (110m)
lvcreate -- doing automatic backup of "pv1"
lvcreate -- logical volume "/dev/pv1/lvol4" successfully created

# lvcreate -L 60m  /dev/pv1     # redo_g01a.log - (50m)
lvcreate -- doing automatic backup of "pv1"
lvcreate -- logical volume "/dev/pv1/lvol5" successfully created

# lvcreate -L 60m  /dev/pv1     # redo_g01b.log  - (50m)
lvcreate -- doing automatic backup of "pv1"
lvcreate -- logical volume "/dev/pv1/lvol6" successfully created

# lvcreate -L 60m  /dev/pv1     # redo_g01c.log - (50m)
lvcreate -- doing automatic backup of "pv1"
lvcreate -- logical volume "/dev/pv1/lvol7" successfully created

# lvcreate -L 60m  /dev/pv1     # redo_g02a.log - (50m)
lvcreate -- doing automatic backup of "pv1"
lvcreate -- logical volume "/dev/pv1/lvol8" successfully created

# lvcreate -L 60m  /dev/pv1     # redo_g02b.log - (50m)
lvcreate -- doing automatic backup of "pv1"
lvcreate -- logical volume "/dev/pv1/lvol9" successfully created

# lvcreate -L 60m  /dev/pv1     # redo_g02c.log - (50m)
lvcreate -- doing automatic backup of "pv1"
lvcreate -- logical volume "/dev/pv1/lvol10" successfully created

# lvcreate -L 60m  /dev/pv1     # redo_g03a.log - (50m)
lvcreate -- doing automatic backup of "pv1"
lvcreate -- logical volume "/dev/pv1/lvol11" successfully created

# lvcreate -L 60m  /dev/pv1     # redo_g03b.log - (50m)
lvcreate -- doing automatic backup of "pv1"
lvcreate -- logical volume "/dev/pv1/lvol12" successfully created

# lvcreate -L 60m  /dev/pv1     # redo_g03c.log - (50m)
lvcreate -- doing automatic backup of "pv1"
lvcreate -- logical volume "/dev/pv1/lvol13" successfully created

# lvcreate -L 250m /dev/pv1     # UNDOTBS Tablespace - (200m)
lvcreate -- doing automatic backup of "pv1"
lvcreate -- logical volume "/dev/pv1/lvol14" successfully created

# lvcreate -L 250m /dev/pv1     # TEMP Tablespace - (200m)
lvcreate -- doing automatic backup of "pv1"
lvcreate -- logical volume "/dev/pv1/lvol15" successfully created

# lvcreate -L 60m  /dev/pv1     # DRSYS Tablespace - (50m)
lvcreate -- doing automatic backup of "pv1"
lvcreate -- logical volume "/dev/pv1/lvol16" successfully created

# lvcreate -L 60m  /dev/pv1     # CWMLITE Tablespace - (50m)
lvcreate -- doing automatic backup of "pv1"
lvcreate -- logical volume "/dev/pv1/lvol17" successfully created

# lvcreate -L 200m /dev/pv1     # EXAMPLE Tablespace - (150m)
lvcreate -- doing automatic backup of "pv1"
lvcreate -- logical volume "/dev/pv1/lvol18" successfully created

# lvcreate -L 300m /dev/pv1     # PERFSTAT Tablespace - (250m)
lvcreate -- doing automatic backup of "pv1"
lvcreate -- logical volume "/dev/pv1/lvol19" successfully created

# lvcreate -L 60m  /dev/pv1     # ODM Tablespace -  (50m)
lvcreate -- doing automatic backup of "pv1"
lvcreate -- logical volume "/dev/pv1/lvol20" successfully created

# lvcreate -L 60m  /dev/pv1     # XDB Tablespace - (50m)
lvcreate -- doing automatic backup of "pv1"
lvcreate -- logical volume "/dev/pv1/lvol21" successfully created

# lvcreate -L 150m /dev/pv1     # USERS Tablespace - (100m)
lvcreate -- doing automatic backup of "pv1"
lvcreate -- logical volume "/dev/pv1/lvol22" successfully created

# lvcreate -L 150m /dev/pv1     # INDX Tablespace - (100m)
lvcreate -- doing automatic backup of "pv1"
lvcreate -- logical volume "/dev/pv1/lvol23" successfully created

# lvcreate -L 100m /dev/pv1     # TOOLS Tablespace - (50m)
lvcreate -- doing automatic backup of "pv1"
lvcreate -- logical volume "/dev/pv1/lvol24" successfully created
Create RAW Bindings
In this step, we will create (or edit) a script called /etc/init.d/dbora that contains all of the commands that will bind the volumes to RAW devices. Also included are the commands to change the ownership of the raw devices for use by the Oracle database user "oracle".
I put these commands in script since they will need to be executed on each machine startup. Keep in mind that in most cases, the commands to start and stop the database are included in the /etc/init.d/dbora file. You can simply put the commands to bind the volumes to raw and chown commands in the start) portion of your script.
A sample script named dbora is include in the Configuration Files / Scripts section of this document.
# vgchange -a y /dev/pv1
vgchange -- volume group "pv1" successfully activated

# /usr/bin/raw /dev/raw/raw1 /dev/pv1/lvol1      # SYSTEM Tablespace 
/dev/raw/raw1:  bound to major 58, minor 0

# /usr/bin/raw /dev/raw/raw2 /dev/pv1/lvol2      # Control File 1
/dev/raw/raw2:  bound to major 58, minor 1

# /usr/bin/raw /dev/raw/raw3 /dev/pv1/lvol3      # Control File 2
/dev/raw/raw3:  bound to major 58, minor 2

# /usr/bin/raw /dev/raw/raw4 /dev/pv1/lvol4      # Control File 3
/dev/raw/raw4:  bound to major 58, minor 3

# /usr/bin/raw /dev/raw/raw5 /dev/pv1/lvol5      # redo_g01a.log
/dev/raw/raw5:  bound to major 58, minor 4

# /usr/bin/raw /dev/raw/raw6 /dev/pv1/lvol6      # redo_g01b.log
/dev/raw/raw6:  bound to major 58, minor 5

# /usr/bin/raw /dev/raw/raw7 /dev/pv1/lvol7      # redo_g01c.log
/dev/raw/raw7:  bound to major 58, minor 6

# /usr/bin/raw /dev/raw/raw8 /dev/pv1/lvol8      # redo_g02a.log
/dev/raw/raw8:  bound to major 58, minor 7

# /usr/bin/raw /dev/raw/raw9 /dev/pv1/lvol9      # redo_g02b.log
/dev/raw/raw9:  bound to major 58, minor 8

# /usr/bin/raw /dev/raw/raw10 /dev/pv1/lvol10    # redo_g02c.log
/dev/raw/raw10:  bound to major 58, minor 9

# /usr/bin/raw /dev/raw/raw11 /dev/pv1/lvol11    # redo_g03a.log
/dev/raw/raw11:  bound to major 58, minor 10

# /usr/bin/raw /dev/raw/raw12 /dev/pv1/lvol12    # redo_g03b.log
/dev/raw/raw12:  bound to major 58, minor 11

# /usr/bin/raw /dev/raw/raw13 /dev/pv1/lvol13    # redo_g03c.log
/dev/raw/raw13:  bound to major 58, minor 12

# /usr/bin/raw /dev/raw/raw14 /dev/pv1/lvol14    # UNDOTBS Tablespace
/dev/raw/raw14:  bound to major 58, minor 13

# /usr/bin/raw /dev/raw/raw15 /dev/pv1/lvol15    # TEMP Tablespace
/dev/raw/raw15:  bound to major 58, minor 14

# /usr/bin/raw /dev/raw/raw16 /dev/pv1/lvol16    # DRSYS Tablespace
/dev/raw/raw16:  bound to major 58, minor 15

# /usr/bin/raw /dev/raw/raw17 /dev/pv1/lvol17    # CWMLITE Tablespace
/dev/raw/raw17:  bound to major 58, minor 16

# /usr/bin/raw /dev/raw/raw18 /dev/pv1/lvol18    # EXAMPLE Tablespace
/dev/raw/raw18:  bound to major 58, minor 17

# /usr/bin/raw /dev/raw/raw19 /dev/pv1/lvol19    # PERFSTAT Tablespace
/dev/raw/raw19:  bound to major 58, minor 18

# /usr/bin/raw /dev/raw/raw20 /dev/pv1/lvol20    # ODM Tablespace
/dev/raw/raw20:  bound to major 58, minor 19

# /usr/bin/raw /dev/raw/raw21 /dev/pv1/lvol21    # XDB Tablespace
/dev/raw/raw21:  bound to major 58, minor 20

# /usr/bin/raw /dev/raw/raw22 /dev/pv1/lvol22    # USERS Tablespace
/dev/raw/raw22:  bound to major 58, minor 21

# /usr/bin/raw /dev/raw/raw23 /dev/pv1/lvol23    # INDX Tablespace
/dev/raw/raw23:  bound to major 58, minor 22

# /usr/bin/raw /dev/raw/raw24 /dev/pv1/lvol24    # TOOLS Tablespace
/dev/raw/raw24:  bound to major 58, minor 23

# /bin/chmod 600 /dev/raw/raw1
# /bin/chmod 600 /dev/raw/raw2
# /bin/chmod 600 /dev/raw/raw3
# /bin/chmod 600 /dev/raw/raw4
# /bin/chmod 600 /dev/raw/raw5
# /bin/chmod 600 /dev/raw/raw6
# /bin/chmod 600 /dev/raw/raw7
# /bin/chmod 600 /dev/raw/raw8
# /bin/chmod 600 /dev/raw/raw9
# /bin/chmod 600 /dev/raw/raw10
# /bin/chmod 600 /dev/raw/raw11
# /bin/chmod 600 /dev/raw/raw12
# /bin/chmod 600 /dev/raw/raw13
# /bin/chmod 600 /dev/raw/raw14
# /bin/chmod 600 /dev/raw/raw15
# /bin/chmod 600 /dev/raw/raw16
# /bin/chmod 600 /dev/raw/raw17
# /bin/chmod 600 /dev/raw/raw18
# /bin/chmod 600 /dev/raw/raw19
# /bin/chmod 600 /dev/raw/raw20
# /bin/chmod 600 /dev/raw/raw21
# /bin/chmod 600 /dev/raw/raw22
# /bin/chmod 600 /dev/raw/raw23
# /bin/chmod 600 /dev/raw/raw24

# /bin/chown oracle:dba /dev/raw/raw1
# /bin/chown oracle:dba /dev/raw/raw2
# /bin/chown oracle:dba /dev/raw/raw3
# /bin/chown oracle:dba /dev/raw/raw4
# /bin/chown oracle:dba /dev/raw/raw5
# /bin/chown oracle:dba /dev/raw/raw6
# /bin/chown oracle:dba /dev/raw/raw7
# /bin/chown oracle:dba /dev/raw/raw8
# /bin/chown oracle:dba /dev/raw/raw9
# /bin/chown oracle:dba /dev/raw/raw10
# /bin/chown oracle:dba /dev/raw/raw11
# /bin/chown oracle:dba /dev/raw/raw12
# /bin/chown oracle:dba /dev/raw/raw13
# /bin/chown oracle:dba /dev/raw/raw14
# /bin/chown oracle:dba /dev/raw/raw15
# /bin/chown oracle:dba /dev/raw/raw16
# /bin/chown oracle:dba /dev/raw/raw17
# /bin/chown oracle:dba /dev/raw/raw18
# /bin/chown oracle:dba /dev/raw/raw19
# /bin/chown oracle:dba /dev/raw/raw20
# /bin/chown oracle:dba /dev/raw/raw21
# /bin/chown oracle:dba /dev/raw/raw22
# /bin/chown oracle:dba /dev/raw/raw23
# /bin/chown oracle:dba /dev/raw/raw24
Create the Oracle9i Database O920DB
If you have successfully made it to this point, you are almost done. The only part left now, is to create the O920DB database. I put together an example initO920DB.ora instance parameter file along with a set of CREATE DATABASE... scripts in an archive create_database920.tar in the Configuration Files / Scripts section of this document.

Configuration Files / Scripts

Example:

.bash_profile
$HOME/.bash_profile for the "oracle" user account.
create_hdb_lvm.sh
An example shell script to create all Physical Volumes, Volume Groups, and Logical Volumes for supporting the O920DB database.
dbora
An example shell script that binds all volumes to RAW devices on each machine startup.
initO920DB.ora
Sample instance parameter script for Oracle9i. Place this file in ~oracle/admin/O920DB/pfile before running the RUN_CRDB.sh script below.
create_database920.tar
An example "create database" set of scripts. Untar the file to ~oracle/admin/O920DB/create. If you decide to change the name of the ORACLE_SID, here are the files that need to be changed:

crdb.sh

create_database.sql

The main script to run is: RUN_CRDB.sh.

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.

Last modified on
Monday, 02-Jan-2012 15:08:55 EST
Page Count: 14865