Wednesday, September 03, 2008

Oracle Apps DBA - Cloning

Oracle Apps DBA - Simple Clonig Steps

How do you Clone your Oracle Apps System with Rapid Clone?

Let us say:

source is Prod and destination is Test

1. Make sure Test Server is ready

a. Remove existing apps systems and file systems in Test

b. That is look for all mount points sames as Prod

c. Look for the same file structures of the prod.

d. Make sure that same users should be there in test such as oracle and applmgr.

e. make sure that all the mount points and required file systems in test has required permissions.

2. Make Sure everything is ready in Prod.

a. Apply Rapid clone patch.

b. login oracle user, Goto $ORACLE_HOME/appsutil/clone/bin.

c. run perl ./ dbTier.

d. login applmgr user, Goto $COMMON_TOP/clone/bin.

e. run perl ./ appsTier.

3. Copy everything(Restore everthing) from Prod to test using some tool (Data protector) or manually, including database

4. After successfull restore from Prod backup/Prod source to Test, Go to Test system, rename all root directories and change ownership to respective users to test directories

Example : mv /y23/data/PRD /y23/data/TEST

mv /z24/data/PRD /z24/data/TEST

chown soracle:dba /y23/data/TEST

chown sapplmgr:dba /y23/data/TEST

5. Check correct oraInst.loc is there in your Test envirnoment

6. Statrt DBTier cloning program , go to soracle user, goto $ORACLE_HOME/appsutil/clone/bin. run the command
perl ./ dbTier

7. After running the script, it will ask inputs like
Target System Name, Target System Domain name, Target system Oracle Home, Number of Data Tops and its locations, Target System Display. Give all appropriate values

8. Then actual database cloning part starts. Mean while open other session of putty/telnet/x-manager. tail the logfile of cloning ex: tail -f $ORACLE_HOME/appsutil/clone/bin/CloneContext_032832939.log

9 . Open another session and user TOP command for CPU usage

10 .After completioin of script check log files for any errors

11. Important thing.. Update fnd_concurrent_requests.. Means cancel all existing requests. (change thes status of concurrent requests to completed)

12. Goto sapplmgr user, goto $COMMON_TOP/clone/bin execute the script as perl ./ appsTier

13. After executing script it will ask different inputs to enter such as apps password(prod password),Target System Database SID, Target Databse Server node, Target system domain name, Target systems APPL_TOP,COMMON_TOP, ORACLE_HOME, IAS_ORACLE_HOME, Target system Display, Locatino of JDK, UTL_FILE_DIR location. Give all appropriate values. Then scripst starts actual cloning process

14. Open another session of putty/telnet/X-Managers. Tail the logfile as tail -f $COMMON_TOP/clone/bin/CloneContext_06666724.log

15. Open another session of putty/telnet/X-Manager. See the CPU usage using top command

16. Hope appscloning completed successfully. Stop all apps services going $COMMON_TOP/admin/scripts/ContextName/adstpall apps/appspwd

17. Remove temporary files located in $COMMON_TOP/temp/*.t and *.tmp

18. If you have any customizations update init.ora as per your needs. You better to get initprod.ora from the PROD and change it as per your needs

19. Goto database drop production database links and create the database links needed in the test env

20. change the passwords of some users which can be used in test environment

21. Goto $APPL_TOP. update APPSORA.env with test database sid, test server name bothe in small letters and capital letters

22. Update profile options ICX Session Time out for site value

23. Change apps password in file located in $IAS_ORACLE/Apache/modplsql/cfg

24. Update schema passwords

25. delete all production logfiles came while refresh
Post a Comment

Autoconfig post 12C upgrade from 11g failed with "ORA-01804: failure to initialize timezone information"

Autoconfig post 12C upgrade from 11g failed with "ORA-01804: failure to initialize timezone information" Error DB Autoconfig ...