| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Help on Mount Points
Andrea Peri wrote:
>
> I'm newbye on oracle and have a problem on installing an oracle
> 8.0.5 on my RedHat6.0 Linux.
>
> The system ask me for 3 database mount points and I don't know what are
> these
> mount points.
>
> I have set these environment variables:
>
> ORACLE_HOME=/usr/oracle/8.0.5
> ORACLE_SID=orcl
> ORACLE_TERM=vt100
> ORACLE_OWNER=oracle
> export ORACLE_HOME ORACLE_SID ORACLE_TERM ORACLE_OWNER
> PATH="$PATH:$ORACLE_HOME/bin"
>
> Someone can help me?
yoo:
for understanding the meaning of a mount-point under unix or linux, you have to understand unix and linux, bur not oracle:
(1) your hard-disk has (or should have) been partionned into different
logical pieces, called partitions and containing the real data.
(2) unix and linux is using a virtual file-system, where the hard-disk
and its parts logically does not appear. you see this virtual
file-system as / , /usr, /etc ...
(3) but of course the logical file-system must be connected to the real
hard-disk-system. this is done by connecting the partitions to espcial
directories of the virtual filesystem.
(4) the act of connecting a directory of the virtual file-system to a
real partition is called: to mount a partition at a directory. and that
directory is called a mountpoint, not only by oracle.
(5) if you want to see your mount-point-system have a look at /etc/fstab
(using the vi ;-) )
but for understanding the meaning of a mount-point in the context of oracle(!) you have to understand the concept 'tablespaces':
(1) a table-space is a logical (=abstract) entity containing all tables
etc.
(2) but a table-space naturally must be connected to the real
hard-disk-system which itself will arise as a logical unit under linux
and unix (see above)
(3) on the oracle-level a table-space is ever connected to one or more
data-files in which oracle itself manages the data.
(4) but you should somtimes spread your oracle-table-space-files over
more than one hard-disks or at least over more than one partition for
holding your data physically divided.
conclusion: if oracle asks for three mount-points you must give two
answers in one (and that's the difficulty):
(a) spread the data-base-tablespaces over the folloing three directories
of the linux-file-system: .../d1 .../d2 .../d3. and these directories
we call(!) mount-points.
(b) spread the data-base-tablespaces over the following three hard-disks
or partitions. and we determine theses partitions by the name of the
directories onto they have been mounted. and therefore we are talking
about mountpoints when we are talking about directories.
is this a little help?
ok: here my default-design for suns and linux-machines which have to work with data-bases (= which shall work as data-base-server)
physical partition mounted under containing the data
/dev/hda1 / root-files
/dev/hda2 /usr containing system-binaries and so on
/dev/hda3 /usr/local containing additional software like gnu and so on
/dev/hda4 /db-sys containing all pure rdbs like oracle
/dev/hda5 /db-mount-1 first mountpoint for data
/dev/hda6 /db-mount-2 seceond mountpoint for data
/dev/hda7 /db-mount-3 third mountpoint for data
salut d'Allemagne kr
-----------------------------------
 |
 |