Following are the steps to Clone Base OFSLL Environment.

1. Copy x* packages and so from production to test after patch up of test schema. (some of these objects in production are newer versions than ones in upgrade patches.)
2. Perform export from production schema.
3. Confirm that CMN_SERVER_HOME path is identical between test and production servers.
4. Run alter table and alter index scripts against production schema.
5. Run compare schema scripts between the production and test schemas. Reconcile differences.
6. Perform export (no data) from test (upgraded) schema.
7. Perform import (ignore=yes) on production schema from step five’s export. Confirm that packages, views, and types are correct versions.
8. Perform export from test (upgraded) schema of setup tables (LESS producers tables!).
9. Copy schema specific system parameters values from production schema
10. Truncate setup tables on production schema.
11. Perform import on production schema from step seven’s export.
12. Overlay system parameters value from step 8
13. Create backup copies of folders in the CMN_SERVER_HOME tree on production app server.
14. Copy CMN_SERVER_HOME tree from test to production app servers. Consider results of step two.
15. Copy any other patch objects (.so’s, etc.) into production environment. (If step 1 is done, we can copy without risk of overwriting newer versions in prod)
16. Restore any X* packages necessary. (if step 1 is done, we can copy without risk of overwriting newer versions in prod).