Re: Migrating Oracle Applications Data to another instance

Actually, this is commonly done. If you are using Oracle App 10.7, please see chapter A-20 for step-by-step instructions.

What oracle says not to do is to copy file system for $APPL_TOP and expect it to work. The only approved way is to reinstall the apps fresh and apply patches.

provided you didn't set some profile options that you are not supposed to know (or use) like "database_instance", you should be fine. Information about instance is kept in environment variables. concurrent manager may have problem with past data because the location of the /out and /log files are hardcoded in fnd_concurrent_processes table. but you can just clean this up if you are concerned. there is another profile option called "node_name" (I think....) that is a memo entry. This is used to display the node name when you are in 10sc and do help > about Oracle Applications and look at node. This is only a memo entry.

Does this help?

In article <35FDDF92.5F86A4D5_at_shaw.wave.ca>, hows_at_shaw.wave.ca says...
>
>I've been asked to determine how to migrate data from one instance of
>Oracle
>Financial Applications on NT 4.0 to a second instance on the same
>machine.
>Most of us will think of Export and Import; however, Oracle embeds
>information
>concerning the instance in the Oracle Applications tables. Importing
>this
>information into a second instance reeks havoc with the instance (which
>is the reason Oracle says not to try it).
>
>If anyone has experience with this, please reply by email.
>I'll post a summary.
>
>Thanks folks.
>
>Howard
>hows_at_shaw.wave.ca
>
Received on Wed Sep 16 1998 - 18:42:31 CDT