Glen A Stromquist <glen_stromquist_at_no_spam_yahoo.com> wrote in message news:<vuK%b.15508$A12.8242_at_edtnps84>...
> Teresa wrote:
>
> > Hi all
> >
> > I will be moving oracle from one Solaris server into another Solaris
> > server, the IP address and box name will be changed. Oracle version is
> > 8.1.7 and O/S is 5.8 on both servers ( just different O/S patch).
> > Does any one know what I need to do in order to get oracle up and
> > running again on the new server. I know that I will need to change the
> > tnsnames.ora and listner.ora, but is there anything else that I need
> > to do?
> >
> > Thanks
> > Teresa
> When I do this with windows boxes I either:
>
> #1 Install oracle on the new box, create a new database and
> export/import from old db to new db
>
> #2 Copy datafiles, init, sqlnet, tns.. etc over from coldbackup or
> shutdown old_database, startup nomount and recreate the controlfile to
> fit new environment.
>
> #3 Restore from online backup of old_database and apply redo logs, again
> recreating the controlfile to fit the new env. (I usually only do this
> for "practice" and for creating a development copy of a prod db)
>
> #2 is usually the "easiest" / fastest, but since your OS's are at
> different patch levels I'd think #1 is the best for you.
>
> I'm sure I'll be corrected here in short order if others think
> differently however
>
> hth
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
Received on Fri Feb 27 2004 - 20:55:36 CST
