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 - "
============================================================================
|
