Re: Windows, Oracle, Registry and Services

Take a look at cloning databases. It's a pretty involved process so I won't go into detail here. To learn how it works, take a close look at the Oracle Database Creation Assistant and learn what it has to do to clone a database when you choose to create an OLTP database (for example) including datafiles using the DBCA. Oracle provides thorough documentation online regarding the registry entries that they create.

http://download-west.oracle.com/docs/cd/B10501_01/win.920/a95490/registry.htm#1006540

I use Oracle 9.2.0.3. The process does work with Oracle 8.1.7 as I have tested that as well. What I found was that I could create a database on one computer, zip it up along with the registry entries, move it to another computer, unzip the necessary datafiles and rebuild the registry. This is great if you want to get a database from your customer but don't want to perform an export and import.

joel-garry_at_home.com (Joel Garry) wrote in message news:<91884734.0409080545.77767d0d_at_posting.google.com>...
> Saeed <sr_ng_at_goawaynms-sys-lts.demon.co.uk> wrote in message news:<A+WyUFBeLKPBFwFO_at_nms-sys-ltd.demon.co.uk>...
> > Anyone ever "installed" Oracle on a Win 2000 host by simply copying all
> > the ORACLE_HOMES (for IAS, Dev6i and 8i RDBMS) and datafiles from one
> > host to another?
> >
> > You might well question the wisdom of doing this, but leaving that to
> > one side, has anybody done this successfully? Remember it's just the
> > database side, but the developer side too, with all the registry and
> > services stuff as well.
> >
> > One other thing - having done this, anyone then tried changing the
> > hostname too so that the HTTP stuff can be used?
> >
> > Kind regards,
> >
> > Saeed
> >
> > sr_ng 786
>
> Ghost works ok. Except when it doesn't, which is probably "user error
> on device." I'm intent on trying it for backing up OAS10G.
>
> Changing hostnames is version dependent, and I think there may be
> serious problems with the versions implied in your post - you should
> always post exact version info. The issues involved in multiple hosts
> with the same hostname is left as an execise for the stupid.
>
> http://metalink.oracle.com/metalink/plsql/ml2_documents.showFrameDocument?p_database_id=NOT&p_id=209927.1
>
> jg
Received on Tue Sep 21 2004 - 00:58:31 CDT