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 ./adpreclone.pl dbTier.

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

e. run perl ./adpreclone.pl 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 ./adcfgclone.pl 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 ./adcfgclone.pl 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 wdbsvr.app file located in $IAS_ORACLE/Apache/modplsql/cfg


24. Update schema passwords


25. delete all production logfiles came while refresh

Oracle DBA - 9.2.0.8 Database Upgradation from 9.2.0.5

How do you know whether you Current Oracle Database is 64-Bit or 34-Bit?

solution: cd $ORACLE_HOME\binfile oracle or file ora*

How do you know your HP Unix Version?

Solution: uname -a

Procedure to upgrade database
:
1. Download upgrade patch for your OS and DB compatible. For Example if your current database is 64-bit and your OS is HP unix.Then download 4547809Hp1164bit.zip from Metalink download

2. unzip the patch file. Disk1 directory will get extracted.

3. set display of your unix environment to enable GUI.

4. Open X-Manager or Reflection X, and note down port number and frame number

5. export DISPALY=192.168.0.1:1.0

6. Test GUI by typing xclock.

7. Shut down database and listener.

8. Goto Disk1 directory you will find, runinstaller executable.

9. Invoke OUI(Oracle Universal Installer), by executing ./runInstaller

10. Choose Oracle Home/Name and click next

11. In the middle of the installation, it will ask you to execute root.sh by root user. Do the same

12. After installation completes, close the OUI

13. start the database in migration mode i.e startup migrate

14. Execute catpatch.sql located in ORACLE_HOME/rdmbs/admin. i.e in sql prompt: sql> ?/rdbms/admin/catpatch.sql

15. It will take some time, after that execute utlrp.sql to compile invalid objects i .e sql>?/rdbms/admin/utlrp.sql

16. Shutdown the database and startup in normal mode. i.e shut immediate and startup

17. Start the listener and release the instance