Re: moving a "development"database to a "production" server.

Thnaks for the help. I got everything to work, but i used export/import of the complete database. Now I have both servers up, now I am looking at doing incremental export/import to keep the databases current. Again, thanks for all the help. For anyone who wants to see a Tomcat java webserver working with Oracle8i checkout www.stablegate.com. All the pages are .jsp.

Harry
www.stablegate.com

"Sudip Sarkar" <sudip_sarkar_at_123india.com> wrote in message news:spa2ogbfn4t135_at_corp.supernews.com...
> I did the database moving from one hp unix server to another. Follwing is
> the steps I followed
> 1) take the statistics of all datafiles, controfiles, logfiles from the
> V$datafiles table from the database.
> 2) Shutdown the database
> 3) Copy the datafiles, logfiles, controlfiles, and init.ora to the
> destination server. I maintained the same directory structure in the
> source database. Otherwise if the destination directory structure is
> different the database has to be loaded in mount mode and then an alter
> database rename datafile command wil serve yr purpose.
> 4) If you need to change the name of yr databse then create controlfile
> command needs to be fired. Be very careful in firing this command.
> Hope this info helps you out.
> Regards
> Sudip
> fro_doe wrote:
> >
> >
> > Given that the OSes and the Oracle software are the same, you can
> > shutdown the database, then rcp or backup/restore the datafiles,
> > logfiles, controlfiles, and init.ora to the new server. You
> > should be able to open the database without any additional
> > changes.
> >
> > There may be some Net8 files (tnsnames.ora, listener.ora) that
> > need to be modified for the new host.
> >
> > I wouldn't recommend copying the entire filesystem. OUI with 8i
> > uses an inventory to store/determine the installed products on
> > the system. It is a binary file that is, for all intents and
> > purposes, uneditable. So, if this inventory file becomes
> > mismatched with the software you have on the system (because,
> > say, the stuff in ORACLE_HOME was copied from one
> > system/filesystem to another), the only way to get things in
> > order again is to reinstall the software. This is not something
> > you want to do in a production environment. Why is it a problem
> > having software that is not reflected in the inventory? For one,
> > upgrades (including patchsets) use the inventory to determine the
> > installed version. So, you can not upgrade to the latest
> > patchset if the inventory knows nothing about your ORACLE_HOME.
> > Resolution - reinstall the software. The one thing I'm not sure
> > of is whether or not the inventory associates a hostname with
> > installed software as well. If not, given you have identical
> > directory structures, copying the entire tree, including
> > inventory, may work, but I wouldn't take the chance.
> >
> > Another suggestion is to make sure the software on the new
> > production server can run a default database before moving the
> > development database over. There may be some config issue (e.g.
> > kernel parameters) that will prevent any database from running.
> > It's nice to find those things before it's go time.
> >
> > Good luck, Doug.
> >
> >
> > -----------------------------------------------------------
> >
> > Got questions? Get answers over the phone at Keen.com.
> > Up to 100 minutes free!
> > http://www.keen.com
> >
>
>
> --
> Posted via CNET Help.com
> http://www.help.com/
Received on Fri Aug 18 2000 - 12:14:38 CDT