oracle xe question

[Jerry Feldman]

On 02/11/2011 08:44 AM, Matt Shields wrote:
> On Fri, Feb 11, 2011 at 8:37 AM, Jerry Feldman <gaf-mNDKBlG2WHs at public.gmane.org
> <mailto:gaf-mNDKBlG2WHs at public.gmane.org>> wrote:
>
>     We use oracle XE for some of our products. Normally, when XE is
>     installed everything is installed in /usr/lib/oracle/xe. I want to =
be
>     able to move the physical database (/usr/lib/oracle/xe/oradata/) to=

>     another HD. Certainly one way to do this is to simply move the enti=
re
>     directory and symlink oradata to the new location or simply move th=
e
>     entire xe tree.
>
>     Another quick question, is there a limitation to the size of the
>     database.
>
>
> Why not move the entire directory to a new drive (local, iscsi, or
> san) then mount that new drive as /usr/lib/oracle/xe/oradata.  I've
> done the same thing with MySQL for years.  Default install for MySQL
> data dir is /var/lib/mysql on RedHat/CentOS.  I've always wanted to
> keep my DB's separate from the OS, so I've just mounted another volume
> to that path.  Works great for external volumes because if the server
> ever dies, you just reattach the volume to another server and startup
> mysql.
>
We think alike. I just set up a RAID1 for the 2 SCSI drives, and mounted
it on /usr/lib/oracle, so when I install XE, it will install on the new
drives. I don't know why I didn't think of it when I asked the stupid
question.

--=20
Jerry Feldman <gaf-mNDKBlG2WHs at public.gmane.org>
Boston Linux and Unix
PGP key id: 537C5846
PGP Key fingerprint: 3D1B 8377 A3C0 A5F2 ECBB  CA3B 4607 4319 537C 5846



_______________________________________________
Discuss mailing list
Discuss-mNDKBlG2WHs at public.gmane.org
http://lists.blu.org/mailman/listinfo/discuss