tag:blogger.com,1999:blog-3349757598813902860Thu, 09 Feb 2012 01:19:57 +0000Core ScriptsOracle APPS - CloningStandby DatabaseBackup and RecoveryDatabase CloningOracle ArchitectureTraining ProgramPatch10g RACDBupgradeBackup_Recovery_OLDManaging DatabaseOracle APPS - CM10G New FeatureSolarisOracle APPS – ManagingOracle-InstallationTrick and TipsApps Performance IssueApps Related IssueOPatchASMHi, 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)Blogger262125http://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-6977489914831892642Mon, 30 Jan 2012 20:30:00 +00002012-01-31T02:00:01.013+05:30 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-01-31T14:02:24.373+05:30 Database Upgrade Problem & Solution List: 1.  Error is related to timezone file (When upgrading 9i to 11g) 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-01-13T12:11:00.082+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 Applicationhttp://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-01-12T11:56:00.399+05:301. About Application Patches 2. ADPATCH Optionshttp://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 +00002011-11-08T12:51:58.787+05:30Trick and TipsImportant Query List: 1. How to know total archive generated each houershttp://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 +00002011-07-29T16:17:55.427+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 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)1<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.htmltag:blogger.com,1999:blog-3349757598813902860.post-8061076457456486316Sun, 03 Jul 2011 07:30:00 +00002011-06-14T13:06:57.513+05:3010g RACSection: B (Install Solaris 10 OS on first Virtual Machine) 1. Double Click on CD-ROM Devices. Select Use ISO image when you planning to install OS through ISO image otherwise Use physical drive. 2. Click on Start the Virtual Machine. 3. Select Solaris Interactive (Default) installation 4. Configure keyboard Layout screen appear (press F2) 5 Select a language English 6 welcome screens appearhttp://feedproxy.google.com/~r/Indiandba/~3/5Wiry1r3ClQ/install-solaris-10-os-on-first-virtual.htmlnoreply@blogger.com (Anup Kumar Srivastav)0<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=5Wiry1r3ClQ:lXZSFCZrptE:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=5Wiry1r3ClQ:lXZSFCZrptE: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=5Wiry1r3ClQ:lXZSFCZrptE: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/5Wiry1r3ClQ" height="1" width="1"/>http://indiandba.blogspot.com/2011/06/install-solaris-10-os-on-first-virtual.htmltag:blogger.com,1999:blog-3349757598813902860.post-3722678095261983926Sat, 02 Jul 2011 07:22:00 +00002011-07-02T12:52:00.115+05:3010g RACEach component in the CRS stack has its respective directories created under the CRS home: • The Cluster Ready Services Daemon (crsd) Log Files $CRS home/log/hostname/crsd • Oracle Cluster Registry (OCR) Log Files $CRS Home/log/hostname/client • Cluster Synchronization Services (CSS) Log Files $CRS Home/log/hostname/cssd • Event Manager (EVM) Log Files $CRS Home/log/hostname/evmd • RACG Loghttp://feedproxy.google.com/~r/Indiandba/~3/gsCyyzY8ylQ/oracle-rac-log-directory.htmlnoreply@blogger.com (Anup Kumar Srivastav)0<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=gsCyyzY8ylQ:wZ6OheS1KGM:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=gsCyyzY8ylQ:wZ6OheS1KGM: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=gsCyyzY8ylQ:wZ6OheS1KGM: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/gsCyyzY8ylQ" height="1" width="1"/>http://indiandba.blogspot.com/2011/07/oracle-rac-log-directory.htmltag:blogger.com,1999:blog-3349757598813902860.post-8316320047233645828Fri, 01 Jul 2011 07:27:00 +00002011-07-01T12:57:00.600+05:3010g RACSection: A (Create first Virtual Machine) 1. Create the windows folders to house the first virtual machines and the shared storage. F:\>mkdir RAC1 F:\>mkdir SHARED-STORAGE 2. Open VMWARE Console and Click on New Virtual Machine and click next. 3. Select Virtual Machine Configurations: Custom 4. Select Gust Operation System: Sun Solaris and version solaris10 5. Type virtual Machine Name (RAC1http://feedproxy.google.com/~r/Indiandba/~3/hxG4FJXZ7j0/create-first-virtual-machine.htmlnoreply@blogger.com (Anup Kumar Srivastav)0<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=hxG4FJXZ7j0:Dj-5G63uMuc:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=hxG4FJXZ7j0:Dj-5G63uMuc: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=hxG4FJXZ7j0:Dj-5G63uMuc: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/hxG4FJXZ7j0" height="1" width="1"/>http://indiandba.blogspot.com/2011/07/create-first-virtual-machine.htmltag:blogger.com,1999:blog-3349757598813902860.post-8885291705375359916Sat, 25 Jun 2011 08:57:00 +00002011-06-25T14:27:00.399+05:3010g RACMethod: “Manually” Task 1 (Create First Virtual Machine) Task 2 (Create Shared Storage and Configure) Task 3 (Create and Configure the Second Virtual Machine) Task 4 (Add Ether Net Adapter for Private Network in Both Machine) Task 5 (Prepare Disk for OCR, Voting and ASM Storage) Task 6 (Install Oracle Clusterware) Task 7 (Install Oracle 10gR12 Software/binary) Task 8 (Configure Oracle http://feedproxy.google.com/~r/Indiandba/~3/H6xgqERae5s/convert-stand-alone-database-to-oracle_25.htmlnoreply@blogger.com (Anup Kumar Srivastav)0<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=H6xgqERae5s:uwc1u_qnsBQ:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=H6xgqERae5s:uwc1u_qnsBQ: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=H6xgqERae5s:uwc1u_qnsBQ: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/H6xgqERae5s" height="1" width="1"/>http://indiandba.blogspot.com/2011/06/convert-stand-alone-database-to-oracle_25.htmltag:blogger.com,1999:blog-3349757598813902860.post-5345630115812102609Sat, 18 Jun 2011 06:28:00 +00002011-06-18T11:58:00.503+05:3010g RACMethod: “DBCA” We can use DBCA to convert from single-instance Oracle databases to RAC. DBCA automates the configuration of the control file attributes, creates the undo tablespaces and the redo logs, and makes the initialization parameter file entries for cluster-enabled environments. It also configures Oracle Net Services, Oracle Clusterware resources, and the configuration for RAC database http://feedproxy.google.com/~r/Indiandba/~3/rrfKYkqxdFM/convert-stand-alone-database-to-oracle.htmlnoreply@blogger.com (Anup Kumar Srivastav)0<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=rrfKYkqxdFM:ysOCpqpXq8c:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=rrfKYkqxdFM:ysOCpqpXq8c: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=rrfKYkqxdFM:ysOCpqpXq8c: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/rrfKYkqxdFM" height="1" width="1"/>http://indiandba.blogspot.com/2011/06/convert-stand-alone-database-to-oracle.htmltag:blogger.com,1999:blog-3349757598813902860.post-2827287187599791051Sat, 11 Jun 2011 11:37:00 +00002011-07-23T16:03:13.582+05:3010g RAC1. Introduction 2. Implement Oracle RAC on Solaris Task 1: Prepare System for Oracle RAC Section: A Create first Virtual Machine Section: B Install Solaris 10 OS on first Virtual Machine Section: C Create Shared Storage and Configure Section: D Create and Configure the Second Virtual Machine Section: E Add Ether Net Adapter for Private Network in Both Machine Section: F Prepare Disk for http://feedproxy.google.com/~r/Indiandba/~3/Wh8W-1NqU8g/oracle-10g-rac-document-list.htmlnoreply@blogger.com (Anup Kumar Srivastav)0<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=Wh8W-1NqU8g:EPVQus6aBVE:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Indiandba?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Indiandba?a=Wh8W-1NqU8g:EPVQus6aBVE: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=Wh8W-1NqU8g:EPVQus6aBVE: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/Wh8W-1NqU8g" height="1" width="1"/>http://indiandba.blogspot.com/2011/06/oracle-10g-rac-document-list.html