How many hard drives? EASY!
root# format
select the disk you want to look at or partition/format/or muck with.
EXAMPLE:
# format
Searching for disks...done
AVAILABLE DISK SELECTIONS:
0. c0t0d0 <SUN36G cyl 24620 alt 2 hd 27 sec 107>
/pci@1f,4000/scsi@3/sd@0,0
1. c0t1d0 <SUN36G cyl 24620 alt 2 hd 27 sec 107>
/pci@1f,4000/scsi@3/sd@1,0
2. c0t2d0 <SUN36G cyl 24620 alt 2 hd 27 sec 107>
...
...
<truncated for space>
"^D" to break out. Or select a disk and "q"
(Note, if you are working on a E450, those disk numbers do not correlate to the disk numbers on the chassie. c0 will always be disks 0-3, after that it depends on how the scsi controllers were cabled.)
ADMIN TIP: note the hardware device name on the second line. If a disk goes bad /var/adm/messages will tell you something like:
Dec 31 08:02:57 out009 scsi: [ID 107833 kern.warning] WARNING: /pci@6,4000/scsi@4/sd@3,0 (sd63):
Dec 31 08:02:57 out009 disk not responding to selection
With `format` you can find the bad disk rather easily.
You want to know the disk size?
$ iostat -En
this will give you detailed info on all your disks, including disk size. (I don't think -n is supported in 2.6 so you'll be given the sd# instead of the full c0t0d0 #.)
Installing Oracle: read the install docs first!
You want to make sure you stay within OFA (Optimal Flexable Architecture) guidelines--- even if you have a single disk!
MEANING: Oracle wants you to place everything in a specific hierarchy. You can name it what you want, but the structure is the same. So for almost every Oracle install, you will see a list of directories like /db01, /db02, /db03. "db01" will hold $ORACLE_HOME and be install directory and hold data if you want. The install directory would be in /db01/app/oracle where as your DBF files will be under /db01/oradata/${ORACLE_SID} . In /db02 your DBF files will be under /db02/oradata/${ORACLE_SID} (without a /db02/app/oracle directory), etc. Since your ORACLE_SID is your database, this makes it really easy to divide multiple databases on a single server without installing ORACLE twice.
Examples, my lab database is on multiple disks:
/dev/dsk/c2t0d2s7 10397084 1569483 8723631 16% /u02
/dev/dsk/c2t0d1s7 10397084 2704995 7588119 27% /u01
/dev/dsk/c2t0d3s7 10397084 1569483 8723631 16% /u03
/dev/dsk/c2t0d4s7 10397084 4877952 5415162 48% /u04
"/u01" is where I installed oracle
You can see I have one database:
ahlstrom@markjump:/u02/oradata
$ ls -l
drwxr-xr-x 2 oracle dba 512 Sep 29 16:15 MAHLSTRO
Example of mutliple databases:
stats1ha:oracle:SMTPAUTH:/stt1/ora01/oradata
$ ls
SMTPAUTH STS1R
since this is my install direcotry (ora01) I also have an app/oracle directory
stats1ha:oracle:SMTPAUTH:/stt1/ora01
$ ls -l
total 0
drwxr-xr-x 3 oracle dba 24 Nov 24 1999 app
drwxr-xr-x 4 oracle dba 40 Apr 17 2002 oradata
If you have the disks and space, make sure you give your database enough room. One DBA issue: while running in archivelog mode, if the filesystem housing your archivelogs (arch_dest) fills up, your database will hang /crash because a new achivelog file can not be generated. And then there are performance issues, etc.,etc.