Oracle Installation process example from 2000

Wednesday March 15, 2000
--------------------------------------------------------
Subject: orasrv03 setup and  Oracle install process
======================================================
note: this configuration was developed with an inexperienced Oracle DBA. 
The installation of Oracle requires spreading it across multiple spindles to 
assist I/O performance, and to protect the log files by having them on separate disks.

SWAP SETUP:
============
Swap is now mirrored on the two lower internal 4.3gig drives, 
I used 256M extent size.  

FILESYSTEMS CREATED:
====================
ORACLE ONLY SYSTEMS ON THE RAID:
------------------------------------
created:	 vgorabase, vgoracle_1, vgoracle_2, and vgoracle_3 
created:     lvorabase, lvoracle_1, lvoracle_2, and lvoracle_3
		(used physical volumes, names:  pvora...)

Mount points:  /orabase, /oracle_1, /oracle_2, oracle_3

I mirrored these groups across a second set of disks.
	lvextend -m 1 /dev/vgorabase /dev/dsk/c0t6d0
	lvextend -m 1 /dev/vgoracle_1 /dev/dsk/c0t2d0
	lvextend -m 1 /dev/vgoracle_2 /dev/dsk/c0t3d0
	lvextend -m 1 /dev/vgoracle_3 /dev/dsk/c0t4d0

Oracle 7.4.3 Install on orasrv03
==================================
PREP FOR PFS_FSTAB:
--------------------
	create /etc/pfs_fstab
	vi /etc/pfs_fstab
	     entry:    /dev/dsk/c1t2d0 /SD_CDROM pfs-rrip xlat=unix 0	

MOUNT CDROM:
--------------------
	nohup /usr/sbin/pfs_mountd & 
	nohup /usr/sbin/pfsd & 
	/usr/sbin/pfs_mount /SD_CDROM

INSTALL ORACLE:
------------------
	cd /SD_CDROM/orainst
	./orainst

ORACLE VALUES:  
---------------
Oracle BASE: /orabase ???
Oracle HOME: ???  tbd
Oracle SID:  WU2000

ORACLE accounts:
------------------
(unix) oracle  / 0rac1e
oracle: system / manager
oracle: sys    / orasys
oracle: mdsys  / mdsys
oracle: ctxsys / ctxsys


UNMOUNT CDROM AFTER INSTALL:
------------------------------
/usr/sbin/pfs_umount /SD_CDROM

SERVER CONFIGURATION:
=======================
orasrv03 has the following filesystem configuration:

>--> more disk-info
                                             Total   Mirror   Mount       
Logical Volume   Volume Group   Use         Mbytes   Copies   Directory   
lvol1            vg00           HFS             60   1        /stand      
lvol2            vg00           Swap/Dump      512   1                    
lvol3            vg00           VxFS           512   1        /           
lvol4            vg00           VxFS          1472   1        /opt        
lvol5            vg00           VxFS           512   1        /tmp        
lvol6            vg00           VxFS           512   1        /usr        
lvol7            vg00           VxFS           512   1        /var        
lvorabase        vgorabase      HFS           4092   1        /orabase    
lvoracle_1       vgoracle_1     HFS           4092   1        /oracle_1   
lvoracle_2       vgoracle_2     HFS           4092   1        /oracle_2   
lvoracle_3       vgoracle_3     HFS           4092   0        /oracle_3   
lvswap           vgswap         Swap          3840   1                    

 -----------------------------------------------------

>--> more vg-info

             Mbytes           Physical   Logical   
Name         Available         Volumes   Volumes   
vg00             0 of  8184          2         7   
vgswap           0 of  7680          2         1   
vgorabase        0 of  8184          2         1   
vgoracle_1       0 of  8184          2         1   
vgoracle_2       0 of  8184          2         1   
vgoracle_3       0 of  8184          2         1   

 -----------------------------------------------------

>--> more lv-info
                                             Total   Mirror   Mount       
Logical Volume   Volume Group   Use         Mbytes   Copies   Directory   
lvol1            vg00           HFS             60   1        /stand      
lvol2            vg00           Swap/Dump      512   1                    
lvol3            vg00           VxFS           512   1        /           
lvol4            vg00           VxFS          1472   1        /opt        
lvol5            vg00           VxFS           512   1        /tmp        
lvol6            vg00           VxFS           512   1        /usr        
lvol7            vg00           VxFS           512   1        /var        
lvorabase        vgorabase      HFS           4092   1        /orabase    
lvoracle_1       vgoracle_1     HFS           4092   1        /oracle_1   
lvoracle_2       vgoracle_2     HFS           4092   1        /oracle_2   
lvoracle_3       vgoracle_3     HFS           4092   1        /oracle_3   
lvswap           vgswap         Swap          3840   1                    

 -----------------------------------------------------

The directories at the root file system look like this:
---------------------------------------------------------

drwxr-xr-x   3 oracle     dba             44 Mar 15 19:58 orabase
drwxr-xr-x   3 oracle     dba             44 Mar 15 20:02 oracle_1
drwxr-xr-x   3 oracle     dba             44 Mar 15 20:27 oracle_2
drwxr-xr-x   3 oracle     dba             44 Mar 15 20:41 oracle_3

INTERNAL DRIVES:
==================
vg00 - operating system, WorkManager - mirrored across two 4.3 gig drives internal
vgswap - striped across two 4.3 gig drives internal 

RAID DRIVE SETUP  (all drives dedicated to Oracle):
========================================================
vgorabase  - /orabase - basic oracle system  - mirrored across two 4.3 RAID drives
vgoracle_1 - /oracle_1 - oracle temp and data  - mirrored across two 4.3 RAID drives
vgoracle_2 - /oracle_2 - oracle rollback and index - mirrored across 2-4.3 RAID drives
vgoracle_3 - /oracle_3 - oracle system, tools and users stuff - "
============================================================================


ebook:
Full Size
Jeep Buyer's
Guide
ebook:
Practical Suggestions
for Microsoft
Windows
Linux Tackles Microsoft
12 hour Video Course by john:
The Art of Linux System Administration
published by O'Reilly Media
Study Guide for the LPIC-2 Certification Exams
search for:
on the internet, or:
JohnMeister.com-fotos
LinuxMeister-Linux
BibleTech-
Bible overview


An overview of Biblical history:
"Promises and Prophets"

Wagoneers

FULL SIZE JEEPS

JeepMeister
"Jeep is America's
only real sports car."
-Enzo Ferrari


MeisterTech
Diesels +

One Page Overview of Linux Commands

click for an image of the 5 essential Linux commands

An Intro to Linux
AMSOIL product guide,
or, AMSOIL web, or 1-800-956-5695,
use customer #283461

Amsoil dealer since 1983
purchase AMSOIL
at Midway Auto on SR9 in Snohomish,
or at Northland Diesel in Bellingham, WA


SJ - 1962-1991

XJ - 1984-2001

WJ - 1999-2004

KJ - 2002-2007

WK - 2005-2010

Find the recommended
AMSOIL synthetics
for your Jeep

CJ-10A - 1984-1986

Jeepsters

MJ - 1984-1992

Willys - 1946-1965

Other Jeeps (FC)