tag:blogger.com,1999:blog-3349757598813902860Sat, 02 Jun 2012 16:12:24 +0000Oracle APPS - CloningStandby DatabaseBackup and RecoveryDatabase CloningOracle ArchitectureTraining ProgramPatch10g RACDBupgradeBackup_Recovery_OLDManaging DatabaseOracle APPS - CM10G New FeatureSolarisOracle APPS – ManagingOracle-InstallationTrick and TipsApps Performance IssueApps Related IssueDBupgrade Problem and SolutionOPatchASMHi, Welcome to the home page of Anup Srivastav -IndianDBA Blog. To introduce myself briefly, I am a Oracle Certified Professional (OCP) in 9i &amp; Sun Cretified System Administrator. I have setup this Blog to share my experience &amp; knowledge on Oracle technologies (Database, APPS and SUN OS) which I sincerely believe will be useful to you.http://indiandba.blogspot.com/noreply@blogger.com (Anup Kumar Srivastav)Blogger268125http://creativecommons.org/licenses/by-nc-nd/2.0/http://creativecommons.org/licenses/by-nc-nd/2.0/http://creativecommons.org/images/public/somerights20.gifIndiandbahttp://feedburner.google.comSubscribe with My Yahoo!Subscribe with NewsGatorSubscribe with My AOLSubscribe with BloglinesSubscribe with NetvibesSubscribe with GoogleSubscribe with Pageflakestag:blogger.com,1999:blog-3349757598813902860.post-8834273177255468407Tue, 29 May 2012 03:37:00 +00002012-05-29T09:07:22.417+05:30DBupgrade Problem and Solution Issue:ORA-24247: network access denied by access control list (ACL) error accorded after db upgrade to 11gr2 from 9.2.0.8 in EBS Environment. Error:ORA-24247: network access denied by access control list (ACL) Impact:Unable to sent mail through database. Reason:I had ignored pre-upgrade tool report warning:-WARNING: --> Database contains schemas with objects dependent on DBMS_LDAP package..... http://feedproxy.google.com/~r/Indiandba/~3/G_mpN8ios1M/ora-24247-network-access-denied-by.htmlnoreply@blogger.com (Anup Kumar Srivastav)0<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=G_mpN8ios1M:le4dMcfH_zw:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=G_mpN8ios1M:le4dMcfH_zw:63t7Ie-LG7Y"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=63t7Ie-LG7Y" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=G_mpN8ios1M:le4dMcfH_zw:l6gmwiTKsz0"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=l6gmwiTKsz0" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Indiandba/~4/G_mpN8ios1M" height="1" width="1"/>http://indiandba.blogspot.com/2012/05/ora-24247-network-access-denied-by.htmltag:blogger.com,1999:blog-3349757598813902860.post-5928178776849064133Mon, 23 Apr 2012 07:33:00 +00002012-04-23T13:09:16.642+05:30Backup and RecoveryNote: 1. This Shell Script create system date directory and move old rman backup set into. 2. Then it will call bkp.sql script ################bkp.sh################################## cd /home/oravis/rman_backup/datafile mkdir `date '+%d%m%y'` mv * /home/oravis/rman_backup/datafile/`date '+%d%m%y'` cd /d01/oravis/db/tech_st/11.1.0 . VIS_aflnoida.env rman target / @/home/oravis/bkp.sql EOFhttp://feedproxy.google.com/~r/Indiandba/~3/R_txUTl1SVc/simple-shell-script-for-scheduling-rman.htmlnoreply@blogger.com (Anup Kumar Srivastav)0<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=R_txUTl1SVc:KUTEghJNRyY:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=R_txUTl1SVc:KUTEghJNRyY:63t7Ie-LG7Y"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=63t7Ie-LG7Y" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=R_txUTl1SVc:KUTEghJNRyY:l6gmwiTKsz0"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=l6gmwiTKsz0" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Indiandba/~4/R_txUTl1SVc" height="1" width="1"/>http://indiandba.blogspot.com/2012/04/simple-shell-script-for-scheduling-rman.htmltag:blogger.com,1999:blog-3349757598813902860.post-5288029482856581451Mon, 23 Apr 2012 07:18:00 +00002012-04-23T12:48:31.451+05:30Backup and RecoveryNote:  1. Script will take only disk based backup 2. It will not backup archive log files ################RMAN Backup Scripts for Non-Rac Database#################### run { allocate channel d1 type disk MAXPIECESIZE 5G; allocate channel d2 type disk MAXPIECESIZE 5G; backup full tag full_db format '/home/oravis/rman_backup/datafile/db_%t_%s_p%p' (database); release channel d1; release channel d2http://feedproxy.google.com/~r/Indiandba/~3/yHKzQBva5F0/rman-backup-scripts-for-non-rac.htmlnoreply@blogger.com (Anup Kumar Srivastav)0<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=yHKzQBva5F0:L9Fyg67Rop8:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=yHKzQBva5F0:L9Fyg67Rop8:63t7Ie-LG7Y"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=63t7Ie-LG7Y" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=yHKzQBva5F0:L9Fyg67Rop8:l6gmwiTKsz0"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=l6gmwiTKsz0" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Indiandba/~4/yHKzQBva5F0" height="1" width="1"/>http://indiandba.blogspot.com/2012/04/rman-backup-scripts-for-non-rac.htmltag:blogger.com,1999:blog-3349757598813902860.post-7866571896095322950Mon, 09 Apr 2012 10:04:00 +00002012-04-09T15:34:54.785+05:30Patch Patch impact analysis is a method to generate a report about what patch entirely will do before apply on system. For example: - What will be adding, modify or ignore by particular patch. Methods: General Method: We should read the readme file in the patch directory and note all prerequisite patch if required then check prerequisite patch has been applied or not, if not applied http://feedproxy.google.com/~r/Indiandba/~3/TDTEhe9j5mY/how-to-analysis-patch-impact.htmlnoreply@blogger.com (Anup Kumar Srivastav)0<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=TDTEhe9j5mY:HTiA33KPJqY:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=TDTEhe9j5mY:HTiA33KPJqY:63t7Ie-LG7Y"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=63t7Ie-LG7Y" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=TDTEhe9j5mY:HTiA33KPJqY:l6gmwiTKsz0"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=l6gmwiTKsz0" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Indiandba/~4/TDTEhe9j5mY" height="1" width="1"/>http://indiandba.blogspot.com/2012/04/how-to-analysis-patch-impact.htmltag:blogger.com,1999:blog-3349757598813902860.post-4790578828199624274Thu, 05 Apr 2012 13:20:00 +00002012-04-05T18:50:25.059+05:30OPatch What is CPU (Critical Patch Updates/Cumulative Patch Updates) Patch? Oracle release Critical Patch Updates (CPU) every quarter to fix bug (issue) in existing release (ie: 10.2.0.4). We use opatch utility to apply CPU patches. We can rollback CPU patches. It can be call one-off patch. What is PSU (Patch Set Update) Patch? PSU patch are consist of CPU patch. This content of all previous CPU http://feedproxy.google.com/~r/Indiandba/~3/nlw1wcevy3U/what-is-cpu-psu-and-patch-set.htmlnoreply@blogger.com (Anup Kumar Srivastav)1<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=nlw1wcevy3U:lkoa2H0owZY:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=nlw1wcevy3U:lkoa2H0owZY:63t7Ie-LG7Y"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=63t7Ie-LG7Y" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=nlw1wcevy3U:lkoa2H0owZY:l6gmwiTKsz0"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=l6gmwiTKsz0" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Indiandba/~4/nlw1wcevy3U" height="1" width="1"/>http://indiandba.blogspot.com/2012/04/what-is-cpu-psu-and-patch-set.htmltag:blogger.com,1999:blog-3349757598813902860.post-8983924893944219745Wed, 04 Apr 2012 11:15:00 +00002012-04-04T17:44:01.535+05:30Oracle Architecture1. HOW ORACLE WORKS?2. Basics of Oracle Architecture3. Starting up a database4. Shutdown the database5. Managing an Oracle Instance6. Oracle Background Processeshttp://feedproxy.google.com/~r/Indiandba/~3/H1TUa2Sno0Y/oracle-architecture-document-list.htmlnoreply@blogger.com (Anup Kumar Srivastav)0<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=H1TUa2Sno0Y:TjdY6K5VUCs:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=H1TUa2Sno0Y:TjdY6K5VUCs:63t7Ie-LG7Y"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=63t7Ie-LG7Y" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=H1TUa2Sno0Y:TjdY6K5VUCs:l6gmwiTKsz0"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=l6gmwiTKsz0" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Indiandba/~4/H1TUa2Sno0Y" height="1" width="1"/>http://indiandba.blogspot.com/2012/04/oracle-architecture-document-list.htmltag:blogger.com,1999:blog-3349757598813902860.post-6977489914831892642Mon, 30 Jan 2012 20:30:00 +00002012-04-04T16:11:40.989+05:30DBupgrade Problem and Solution I started database in upgrade mode and fired catupgrd.sql : SQL> startup upgradeORACLE instance started. Total System Global Area 6413680640 bytesFixed Size                  2160112 bytesVariable Size            1946159632 bytesDatabase Buffers         4429185024 bytesRedo Buffers               36175872 bytesDatabase mounted.Database opened.SQL> @catupgrd.sqlDOC>#############################http://feedproxy.google.com/~r/Indiandba/~3/VCLRK1gPouc/error-is-related-to-timezone-file.htmlnoreply@blogger.com (Anup Kumar Srivastav)0<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=VCLRK1gPouc:egS5Bl3FXt8:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=VCLRK1gPouc:egS5Bl3FXt8:63t7Ie-LG7Y"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=63t7Ie-LG7Y" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=VCLRK1gPouc:egS5Bl3FXt8:l6gmwiTKsz0"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=l6gmwiTKsz0" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Indiandba/~4/VCLRK1gPouc" height="1" width="1"/>http://indiandba.blogspot.com/2012/01/error-is-related-to-timezone-file.htmltag:blogger.com,1999:blog-3349757598813902860.post-3678166077774383755Mon, 30 Jan 2012 19:30:00 +00002012-05-29T09:10:05.733+05:30DBupgrade Problem and SolutionDatabase Upgrade Problem & Solution List: 1.  Error is related to timezone file (When upgrading 9i to 11g)  2.  ORA-24247: network access denied by access control list (ACL)http://feedproxy.google.com/~r/Indiandba/~3/cMIjVSpyZfc/database-upgrade-problem-solution-list.htmlnoreply@blogger.com (Anup Kumar Srivastav)0<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=cMIjVSpyZfc:yvwCuWOnjLo:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=cMIjVSpyZfc:yvwCuWOnjLo:63t7Ie-LG7Y"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=63t7Ie-LG7Y" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=cMIjVSpyZfc:yvwCuWOnjLo:l6gmwiTKsz0"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=l6gmwiTKsz0" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Indiandba/~4/cMIjVSpyZfc" height="1" width="1"/>http://indiandba.blogspot.com/2012/01/database-upgrade-problem-solution-list.htmltag:blogger.com,1999:blog-3349757598813902860.post-5953152563224104674Mon, 30 Jan 2012 05:56:00 +00002012-01-30T18:06:25.089+05:30 What are the patches required for indian Localization in Release 12? In Release 12, India Localization functionality is included in Base rollup patches itself (For example RUP04, RUP05 etc.,). Hence there is no need to apply separate patches for India Localization as in Release 11i. As an DBA, We need to Enable all the localisation triggers. By default all will be in disabled stage http://feedproxy.google.com/~r/Indiandba/~3/bRGxQl5xim0/working-with-india-localization-after.htmlnoreply@blogger.com (Anup Kumar Srivastav)0<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=bRGxQl5xim0:iQUIz3DcP04:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=bRGxQl5xim0:iQUIz3DcP04:63t7Ie-LG7Y"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=63t7Ie-LG7Y" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=bRGxQl5xim0:iQUIz3DcP04:l6gmwiTKsz0"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=l6gmwiTKsz0" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Indiandba/~4/bRGxQl5xim0" height="1" width="1"/>http://indiandba.blogspot.com/2012/01/working-with-india-localization-after.htmltag:blogger.com,1999:blog-3349757598813902860.post-5329230110775579204Fri, 27 Jan 2012 10:59:00 +00002012-01-27T16:29:08.775+05:301. 11i Cloning Basic 2. 11i Cloning Steps 3. Apps Cloning FAQhttp://feedproxy.google.com/~r/Indiandba/~3/NNdUiWksezk/oracle-apps-cloning-document-list.htmlnoreply@blogger.com (Anup Kumar Srivastav)0<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=NNdUiWksezk:u56tNR3DMsk:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=NNdUiWksezk:u56tNR3DMsk:63t7Ie-LG7Y"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=63t7Ie-LG7Y" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=NNdUiWksezk:u56tNR3DMsk:l6gmwiTKsz0"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=l6gmwiTKsz0" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Indiandba/~4/NNdUiWksezk" height="1" width="1"/>http://indiandba.blogspot.com/2012/01/oracle-apps-cloning-document-list.htmltag:blogger.com,1999:blog-3349757598813902860.post-1472823396914404477Fri, 13 Jan 2012 06:41:00 +00002012-04-05T12:56:20.917+05:301. How to Gather Statistics for Oracle Apps 11i 2. Managing Invalid Objects in Apps 3. Managing Printer in Apps 4. How to Manually Change the APPS, APPLSYS and APPSSYSBUB Password in Oracle Application 5. How to Compile JSP files in Oracle Application (11i) 6. Change Oracle Apps Database Users, Product Schema and End User Password http://feedproxy.google.com/~r/Indiandba/~3/2fc_RvldOfM/oracle-apps-managing-document-list.htmlnoreply@blogger.com (Anup Kumar Srivastav)0<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=2fc_RvldOfM:3HiqvPRjo5E:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=2fc_RvldOfM:3HiqvPRjo5E:63t7Ie-LG7Y"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=63t7Ie-LG7Y" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=2fc_RvldOfM:3HiqvPRjo5E:l6gmwiTKsz0"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=l6gmwiTKsz0" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Indiandba/~4/2fc_RvldOfM" height="1" width="1"/>http://indiandba.blogspot.com/2012/01/oracle-apps-managing-document-list.htmltag:blogger.com,1999:blog-3349757598813902860.post-5056022813622847640Thu, 12 Jan 2012 06:26:00 +00002012-04-09T15:37:13.427+05:301. About Application Patches 2. ADPATCH Options 3. How to apply Patch when already running 4. Adpatch Error: unable to find job when reading existing jobs 5. How to analysis the patch impact http://feedproxy.google.com/~r/Indiandba/~3/rzO3VUN0TLs/oracle-apps-patching-document-list.htmlnoreply@blogger.com (Anup Kumar Srivastav)0<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=rzO3VUN0TLs:cJdCtjh_H4A:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=rzO3VUN0TLs:cJdCtjh_H4A:63t7Ie-LG7Y"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=63t7Ie-LG7Y" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=rzO3VUN0TLs:cJdCtjh_H4A:l6gmwiTKsz0"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=l6gmwiTKsz0" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Indiandba/~4/rzO3VUN0TLs" height="1" width="1"/>http://indiandba.blogspot.com/2012/01/oracle-apps-patching-document-list.htmltag:blogger.com,1999:blog-3349757598813902860.post-6568817913161536132Wed, 11 Jan 2012 09:18:00 +00002012-01-11T14:48:00.331+05:301. Implement physical Standby database in Apps Environment 2. Switch-Over in Apps Environment 3. Fail-Over in Apps Environment 4. Applying Patches in Standby Environment http://feedproxy.google.com/~r/Indiandba/~3/8oaRaauVx5M/implement-manage-dr-in-apps-enviroment.htmlnoreply@blogger.com (Anup Kumar Srivastav)0<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=8oaRaauVx5M:s4l7diLcyns:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=8oaRaauVx5M:s4l7diLcyns:63t7Ie-LG7Y"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=63t7Ie-LG7Y" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=8oaRaauVx5M:s4l7diLcyns:l6gmwiTKsz0"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=l6gmwiTKsz0" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Indiandba/~4/8oaRaauVx5M" height="1" width="1"/>http://indiandba.blogspot.com/2012/01/implement-manage-dr-in-apps-enviroment.htmltag:blogger.com,1999:blog-3349757598813902860.post-3681790609149728916Tue, 10 Jan 2012 09:14:00 +00002012-01-30T11:29:24.040+05:30 1. Upgrade Oracle Apps 11.5.10 to 11.5.10.2 2. Upgrade Oracle Apps 11.5.10.2 to R12 (12.0.4) 3. Working with India Localization after upgrade to R12http://feedproxy.google.com/~r/Indiandba/~3/3ffPhhgxz_o/oracle-apps-upgrade-document-list.htmlnoreply@blogger.com (Anup Kumar Srivastav)0<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=3ffPhhgxz_o:GKwk5_C8hmo:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=3ffPhhgxz_o:GKwk5_C8hmo:63t7Ie-LG7Y"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=63t7Ie-LG7Y" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=3ffPhhgxz_o:GKwk5_C8hmo:l6gmwiTKsz0"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=l6gmwiTKsz0" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Indiandba/~4/3ffPhhgxz_o" height="1" width="1"/>http://indiandba.blogspot.com/2012/01/oracle-apps-upgrade-document-list.htmltag:blogger.com,1999:blog-3349757598813902860.post-3746970211168210498Mon, 09 Jan 2012 07:28:00 +00002012-01-09T12:58:19.987+05:301. Oracle Apps 11.5.10 Installation on REHL4http://feedproxy.google.com/~r/Indiandba/~3/ROiEWEii5wM/oracle-apps-installation-document-list.htmlnoreply@blogger.com (Anup Kumar Srivastav)0<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=ROiEWEii5wM:6WCBqnileC0:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=ROiEWEii5wM:6WCBqnileC0:63t7Ie-LG7Y"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=63t7Ie-LG7Y" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=ROiEWEii5wM:6WCBqnileC0:l6gmwiTKsz0"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=l6gmwiTKsz0" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Indiandba/~4/ROiEWEii5wM" height="1" width="1"/>http://indiandba.blogspot.com/2012/01/oracle-apps-installation-document-list.htmltag:blogger.com,1999:blog-3349757598813902860.post-2177273323894350800Tue, 08 Nov 2011 07:20:00 +00002011-11-08T12:50:21.902+05:30Trick and Tips SELECT TO_CHAR(FIRST_TIME,'YYYY-MM-DD') DAY, TO_CHAR(FIRST_TIME,'HH24') HOUR, COUNT(*) TOTAL FROM V$LOG_HISTORY GROUP BY TO_CHAR(FIRST_TIME,'YYYY-MM-DD'),TO_CHAR(FIRST_TIME,'HH24') ORDER BY TO_CHAR(FIRST_TIME,'YYYY-MM-DD'),TO_CHAR(FIRST_TIME,'HH24') ASC / http://feedproxy.google.com/~r/Indiandba/~3/0EGG6MO4hMI/find-log-history-per-hours.htmlnoreply@blogger.com (Anup Kumar Srivastav)0<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=0EGG6MO4hMI:3KhxxeI5598:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=0EGG6MO4hMI:3KhxxeI5598:63t7Ie-LG7Y"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=63t7Ie-LG7Y" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=0EGG6MO4hMI:3KhxxeI5598:l6gmwiTKsz0"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=l6gmwiTKsz0" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Indiandba/~4/0EGG6MO4hMI" height="1" width="1"/>http://indiandba.blogspot.com/2011/11/find-log-history-per-hours.htmltag:blogger.com,1999:blog-3349757598813902860.post-3500527911840976798Tue, 08 Nov 2011 07:17:00 +00002012-04-04T17:37:19.968+05:30Trick and TipsTrick and Tips List: 1. How to know total archive generated each houers 2. Find log history per hours 3. How to Change DBID and DBNAME? 4. How to find Operating Systems and Utilities version 5. How to find Oracle Database Components version 6. How to Find Oracle Applications version 7. Sharing Windows File/Folder with Linux 8. Generate Create Tablespace Script http://feedproxy.google.com/~r/Indiandba/~3/lJfRpPR3om0/important-query-list.htmlnoreply@blogger.com (Anup Kumar Srivastav)0<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=lJfRpPR3om0:2f_oOfRuzNo:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=lJfRpPR3om0:2f_oOfRuzNo:63t7Ie-LG7Y"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=63t7Ie-LG7Y" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=lJfRpPR3om0:2f_oOfRuzNo:l6gmwiTKsz0"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=l6gmwiTKsz0" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Indiandba/~4/lJfRpPR3om0" height="1" width="1"/>http://indiandba.blogspot.com/2011/11/important-query-list.htmltag:blogger.com,1999:blog-3349757598813902860.post-8048892166401678623Fri, 05 Aug 2011 06:08:00 +00002011-08-05T11:38:31.835+05:30DBupgrade (From Windows-32 bit to Solaris x86) Source System Details: Platform: Windows – 32 bitDB Version: 10.2.0.2DB NAME: INDIANDB Location: D: /INDIAN/ Target System Details: Platform: Solaris x86DB Version: 10.2.0.2DB NAME: INDIANDB Location: /oracle/INDIAN/Temporary Location: /oracle/win ------ Location will be use for Temporary Work Limitation/ Restriction: Source and destination platform musthttp://feedproxy.google.com/~r/Indiandba/~3/b9lyOvlvrB0/project-cross-platform-migration-by.htmlnoreply@blogger.com (Anup Kumar Srivastav)0<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=b9lyOvlvrB0:UKPBPkJ40g0:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=b9lyOvlvrB0:UKPBPkJ40g0:63t7Ie-LG7Y"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=63t7Ie-LG7Y" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=b9lyOvlvrB0:UKPBPkJ40g0:l6gmwiTKsz0"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=l6gmwiTKsz0" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Indiandba/~4/b9lyOvlvrB0" height="1" width="1"/>http://indiandba.blogspot.com/2011/08/project-cross-platform-migration-by.htmltag:blogger.com,1999:blog-3349757598813902860.post-4011955598215688044Fri, 29 Jul 2011 10:54:00 +00002011-07-29T16:24:17.957+05:30Oracle APPS - CMExecute following SQL: UPDATE fnd_concurrent_requests SET phase_code = 'C', status_code = 'X'  WHERE request_id = '';  commit;http://feedproxy.google.com/~r/Indiandba/~3/d_o4Ryt7KdA/how-to-cancel-concurrent-request-stuck.htmlnoreply@blogger.com (Anup Kumar Srivastav)0<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=d_o4Ryt7KdA:f3Yf38fttTM:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=d_o4Ryt7KdA:f3Yf38fttTM:63t7Ie-LG7Y"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=63t7Ie-LG7Y" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=d_o4Ryt7KdA:f3Yf38fttTM:l6gmwiTKsz0"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=l6gmwiTKsz0" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Indiandba/~4/d_o4Ryt7KdA" height="1" width="1"/>http://indiandba.blogspot.com/2011/07/how-to-cancel-concurrent-request-stuck.htmltag:blogger.com,1999:blog-3349757598813902860.post-3995162935058587621Fri, 29 Jul 2011 10:47:00 +00002012-04-05T13:03:49.326+05:30Oracle APPS - CM Basic, Startup,shutdown and Log file location Tuning, Purging and Analyzing Monitoring Pending Request How to about CM Problems and Solutions Helpful Diagnostic Scripts How can you find concurrent program schedule details How to cancel a concurrent request stuck in the queue? http://feedproxy.google.com/~r/Indiandba/~3/CP1fN7Vt9p4/oracle-apps-concurrent-manager-document.htmlnoreply@blogger.com (Anup Kumar Srivastav)0<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=CP1fN7Vt9p4:BXmF3OjQiwI:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=CP1fN7Vt9p4:BXmF3OjQiwI:63t7Ie-LG7Y"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=63t7Ie-LG7Y" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=CP1fN7Vt9p4:BXmF3OjQiwI:l6gmwiTKsz0"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=l6gmwiTKsz0" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Indiandba/~4/CP1fN7Vt9p4" height="1" width="1"/>http://indiandba.blogspot.com/2011/07/oracle-apps-concurrent-manager-document.htmltag:blogger.com,1999:blog-3349757598813902860.post-3685895048827498569Sat, 23 Jul 2011 09:37:00 +00002011-07-23T15:07:00.118+05:3010g RAC In the oracle RAC Environment, each instance store transaction undo data in its dedicated undo Tablespace. We can set the undo Tablespace for each instance by setting the undo_tablespace parameter and undo_management to be the same across all the instances. Example: .undo_tablespace=undo_tbs1.undo_tablesapce=undo_tbs2 Managing Temporary Tablespace In an RAC environment, a user will always use http://feedproxy.google.com/~r/Indiandba/~3/V7Sco2wcMfk/managing-undo-temporary-and-redo-logs.htmlnoreply@blogger.com (Anup Kumar Srivastav)0<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=V7Sco2wcMfk:J6JACqj608c:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=V7Sco2wcMfk:J6JACqj608c:63t7Ie-LG7Y"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=63t7Ie-LG7Y" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=V7Sco2wcMfk:J6JACqj608c:l6gmwiTKsz0"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=l6gmwiTKsz0" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Indiandba/~4/V7Sco2wcMfk" height="1" width="1"/>http://indiandba.blogspot.com/2011/07/managing-undo-temporary-and-redo-logs.htmltag:blogger.com,1999:blog-3349757598813902860.post-3336412589456690692Fri, 22 Jul 2011 09:35:00 +00002011-07-22T15:05:00.245+05:3010g RAC The following tools are available for administrating services. DBCAOEMDBMS_SERVICEServer Control Utility Here we will discuss only about Server Control Utility (SRVCTL). We can use SRVCTL to Add, start, stop, and Enable, Disable and remove instances and services. Command Syntax: Srvctl addThe SRVCTL add command add configuration in the OCR. Add Database: - srvctl add database -d -o Add http://feedproxy.google.com/~r/Indiandba/~3/lCHKMq3Z5uE/administrating-services.htmlnoreply@blogger.com (Anup Kumar Srivastav)0<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=lCHKMq3Z5uE:Mbo6xCeE3tA:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=lCHKMq3Z5uE:Mbo6xCeE3tA:63t7Ie-LG7Y"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=63t7Ie-LG7Y" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=lCHKMq3Z5uE:Mbo6xCeE3tA:l6gmwiTKsz0"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=l6gmwiTKsz0" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Indiandba/~4/lCHKMq3Z5uE" height="1" width="1"/>http://indiandba.blogspot.com/2011/07/administrating-services.htmltag:blogger.com,1999:blog-3349757598813902860.post-1175528351872850156Wed, 20 Jul 2011 07:42:00 +00002011-07-21T14:45:36.097+05:3010g RACWe use Cluster Control Utility “CRSCTL” to perform administrative operation of oracle clusterware. It is located in $CRS_HOME/bin and must be executed by the “root” user. 1. To check the current state of all oracle clusterware daemon: $ ./crsctl check crs CSS appears healthy CRS appears healthy EVM appears healthy 2. You can also check the state of individual oracle clusterware daemon: $ ./http://feedproxy.google.com/~r/Indiandba/~3/QLu6WiYnSd8/administering-cluster-ready-services.htmlnoreply@blogger.com (Anup Kumar Srivastav)0<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=QLu6WiYnSd8:QRZefBz06sg:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=QLu6WiYnSd8:QRZefBz06sg:63t7Ie-LG7Y"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=63t7Ie-LG7Y" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=QLu6WiYnSd8:QRZefBz06sg:l6gmwiTKsz0"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=l6gmwiTKsz0" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Indiandba/~4/QLu6WiYnSd8" height="1" width="1"/>http://indiandba.blogspot.com/2011/07/administering-cluster-ready-services.htmltag:blogger.com,1999:blog-3349757598813902860.post-1160121824200312328Tue, 19 Jul 2011 07:39:00 +00002011-07-19T13:09:03.651+05:3010g RACOCR: Oracle Cluster registry (OCR) store the cluster configuration information and database configuration information like cluster node list, cluster database instance to node mapping and CRS application resource profile. OCR location is specified during CRS installation. OCR.loc file indicate the OCR device location. OCR.loc file located in /etc/oracle on linux system and /var/opt/oracle on http://feedproxy.google.com/~r/Indiandba/~3/gpuLdzbtgCI/managing-ocr-and-voting-disk.htmlnoreply@blogger.com (Anup Kumar Srivastav)0<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=gpuLdzbtgCI:_ZOTJo8Ykjg:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=gpuLdzbtgCI:_ZOTJo8Ykjg:63t7Ie-LG7Y"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=63t7Ie-LG7Y" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=gpuLdzbtgCI:_ZOTJo8Ykjg:l6gmwiTKsz0"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=l6gmwiTKsz0" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Indiandba/~4/gpuLdzbtgCI" height="1" width="1"/>http://indiandba.blogspot.com/2011/07/managing-ocr-and-voting-disk.html