Re: Procedure to move one oracle database to another machine

If the reason for the move is to allow the user on the other machine to access the database, then just install the SQL*NET client on the other machine rather than move/clone the database. This will allow them to access the one copy of the database across the network.

In article <357dbace.69500015_at_isappp>,
  gedau_at_pobox.com (George Dau) wrote:
>
> Praba Dorai <praba_at_pluto1.engr.sgi.com> wrote:
>
> ] What are the procedures to move one oracle database to
> ]another machine ? This oracle db should be accessed by
> ]user who is working in another machine by network?
> ]
> ]Is it necessary to create a file system for oracle as NFS ?
>
> No, don't use NFS. It's slow and there are often locking problems.
> Clone the database to the other machine.
>
> (Assuming OFA layout)
> On the first machine, go to $ORACLE_BASE/admin/SID or wherever the
> top of the tree is for that SID. Then make a tar file of everything
> under there (you'll need to put the tar file somewhere where there is
> enough space, this may be a tape). If the database is running in archivelog
> mode, it is not necessary to shut down the database while doing this - I've
> done it several times with active, running, databases.
>
> Now take you tar file to the new machine, and untar it to the same place,
> so the tar creates the SID directory and everything under it.
>
> Create the link in $ORACLE_HOME/dbs to $ORACLE_BASE/admin/SID/pfile or where
> ever your pfile is, and create the entry in /etc/oratab (or wherever your oratab
> is).
>
> Startup the new database! It'll do some recovery and away you go.
>
> --
> ,-,_|\ George Dau, __
> / * \ Unix (Solaris, DEC Unix, Linux), Oracle, Internet. (OO)
> \_,--\_/ Home: gedau_at_pobox.com Work: gedau_at_isa.mim.com.au ( \/ )
> v WWW: http://pobox.com/~gedau W--W
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Wed Jun 10 1998 - 08:50:36 CDT