Damage Control

I faced the following error while configuring database when cloning apps 11i with 10g database and it happens directly after entering the path of the third data_top (by the way the script will always assume you have 4 data_tops even if you have more/less data_tops)StackTrace:java.lang.NullPointerExceptionat oracle.apps.ad.context.CloneContext.createContextFileForDbhomes(CloneContext.java:2816)at oracle.apps.ad.context.CloneContext.getInputFromUsers(CloneContext.java:1485)at oracle.apps.ad.context.CloneContext.doClone(CloneContext.java:627)at oracle.apps.ad.context.CloneContext.main(CloneContext.java:6085)On metalink there was the solution on Note:427981.1 Subject:RC-50004 When Specifying DATA_TOPS While Cloning a 10.2 DatabaseAnd the solution is to apply a patch with a version of CloneContext.java above 115.203. the following are possibilities patchesPatch 5473292, Patch 5732291, Patch 5604818, Patch 5456078, Patch 5474116Well I did not do that because this means that I have to apply the patch and recopy the database, which take time. So I recreate the database manually using control file. And when try to open the database I issued SQL>alter database open resetlogs;It failed with the followingalter database open resetlogs*ERROR at line 1:ORA-01113: file 1 needs media recoveryORA-01110: data file 1: '/ora_dev/data/system01.dbf'Even though the database
http://oracle-magic.blogspot.com/2008/03/cloning-11i-with-10g-database-you-may.html