Re: moving oracle database server into a new server

From: Glen A Stromquist <glen_stromquist_at_no_spam_yahoo.com>
Date: Mon, 01 Mar 2004 20:39:56 GMT
Message-ID: <wcN0c.115094$Hy3.24175@edtnps89>

Hans Forbrich wrote:

> Teresa wrote:
>

>> Thanks
>> But I was not planning to install oracle again, and create a database,
>> I was thinking in  just shutdown oracle on source server then the
>> entire source server is going to be copyed over into target then just
>> start oracle etc.  I though of just update tnsnames. sqlnet etc. Also
>> both servers resize on the same disk array
>> Thanks
>> Teresa

>
>
> This is possible, and I have done this in the past. Usually with some
> minor disaster waiting for me about 3 months later.
>
> You should be aware of ALL the possible places that Oracle may scribble,
> including /tmp, /var/tmp, /opt, /usr/local and (lately Linux) /etc and
> you need to watch your file ownerships & permissions, especially in the
> $ORACLE_BASE subdirectories. Especially if you are using some of the
> less frequented options and capabilities such as BFILE, external tables,
> etc.
>
> If yo8u insist on doing this, it's worth your while to do a full system
> scan for anything owned by oracle or the ORADBA group.
>
> I've found that a simple install, followed by a copy of the actual
> database files (including the [s]pfile, control, database, etc.) is by
> far the safest.
>
> YMMV.
> /Hans

Hans - isn't "minor disaster" a tad oxymoron*ish? ;-)

but then again, I guess it could be the same as a "major glitch" , another term one hears from time to time.... Received on Mon Mar 01 2004 - 14:39:56 CST