http://sapbasis.wordpress.com SAP Basis Cafe - Exploring SAP R/3 Basis World Mon, 28 May 2012 06:59:44 +0000 en hourly 1 http://wordpress.com/ http://s2.wp.com/i/buttonw-com.png http://sapbasis.wordpress.com Subscribe with My Yahoo!Subscribe with NewsGatorSubscribe with My AOLSubscribe with BloglinesSubscribe with NetvibesSubscribe with GoogleSubscribe with Pageflakes http://feedproxy.google.com/~r/SapBasis/~3/3yu00mK84u8/ http://sapbasis.wordpress.com/2012/02/07/nice-ebooks-from-sap-data-management-guide-for-sap-business-suite/#comments Tue, 07 Feb 2012 03:06:52 +0000 ardhian http://sapbasis.wordpress.com/?p=244 Hi folks, I got this nice ebooks from SAP website. You can download from my ziddu account here (http://www.ziddu.com/download/18524440/DataManagementGuideforSAPBusinessSuite.pdf.html) It&#8217;s great books and every SAP Functional, Basis and Consultant should have it. Tagged: ebooks, functional basis, great books, SAP Basis<img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=sapbasis.wordpress.com&#038;blog=1517934&#038;post=244&#038;subd=sapbasis&#038;ref=&#038;feed=1" width="1" height="1" /> <p><a href="http://feedads.g.doubleclick.net/~a/Te3Ojg30NUfvCW3dJ8YPEc5p01o/0/da"><img src="http://feedads.g.doubleclick.net/~a/Te3Ojg30NUfvCW3dJ8YPEc5p01o/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/Te3Ojg30NUfvCW3dJ8YPEc5p01o/1/da"><img src="http://feedads.g.doubleclick.net/~a/Te3Ojg30NUfvCW3dJ8YPEc5p01o/1/di" border="0" ismap="true"></img></a></p> http://sapbasis.wordpress.com/2012/02/07/nice-ebooks-from-sap-data-management-guide-for-sap-business-suite/feed/ 3 ardhian http://sapbasis.wordpress.com/2012/02/07/nice-ebooks-from-sap-data-management-guide-for-sap-business-suite/ http://feedproxy.google.com/~r/SapBasis/~3/5BJxwRU5YvY/ http://sapbasis.wordpress.com/2012/01/21/how-to-reset-spam-queue/#comments Sat, 21 Jan 2012 03:11:53 +0000 ardhian http://sapbasis.wordpress.com/?p=241 Sometimes when you are upload and implement Support Package, its jammed. Then you need to reset SPAM queue. Here is the step how to reset SPAM queue : Go to Tx SE37 select program name : OCS_RESET_QUEUE test/execute (f8) give the value for import parameters IV_tool : SPAM IV_FORCE : X Execute (f8) there after [...]<img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=sapbasis.wordpress.com&#038;blog=1517934&#038;post=241&#038;subd=sapbasis&#038;ref=&#038;feed=1" width="1" height="1" /> <p><a href="http://feedads.g.doubleclick.net/~a/Ge1cb9i3HtU15lnl6rJK2MiTl_E/0/da"><img src="http://feedads.g.doubleclick.net/~a/Ge1cb9i3HtU15lnl6rJK2MiTl_E/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/Ge1cb9i3HtU15lnl6rJK2MiTl_E/1/da"><img src="http://feedads.g.doubleclick.net/~a/Ge1cb9i3HtU15lnl6rJK2MiTl_E/1/di" border="0" ismap="true"></img></a></p> http://sapbasis.wordpress.com/2012/01/21/how-to-reset-spam-queue/feed/ 0 ardhian http://sapbasis.wordpress.com/2012/01/21/how-to-reset-spam-queue/ http://feedproxy.google.com/~r/SapBasis/~3/A6vFEs4dceQ/ http://sapbasis.wordpress.com/2012/01/13/brtools-720-for-oracle-10g-and-11g/#comments Fri, 13 Jan 2012 07:20:14 +0000 ardhian http://sapbasis.wordpress.com/?p=239 You can download Brtools 7.20 is available on the servicemarket place at the following link http://service.sap.com/swdc Download Support Packages and Patches &#8211; Entry by Application Group Additional Components SAP Kernel SAP Kernel 64bit Choose your OS Choose Oracle DBATL720O10_1-20005243.SAR DBATOOLS Package for Oracle 10g and 11g The oss note 12741 is also useful for download [...]<img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=sapbasis.wordpress.com&#038;blog=1517934&#038;post=239&#038;subd=sapbasis&#038;ref=&#038;feed=1" width="1" height="1" /> <p><a href="http://feedads.g.doubleclick.net/~a/NQcE9bDykyK6E1n6ddi-LenI-As/0/da"><img src="http://feedads.g.doubleclick.net/~a/NQcE9bDykyK6E1n6ddi-LenI-As/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/NQcE9bDykyK6E1n6ddi-LenI-As/1/da"><img src="http://feedads.g.doubleclick.net/~a/NQcE9bDykyK6E1n6ddi-LenI-As/1/di" border="0" ismap="true"></img></a></p> http://sapbasis.wordpress.com/2012/01/13/brtools-720-for-oracle-10g-and-11g/feed/ 0 ardhian http://sapbasis.wordpress.com/2012/01/13/brtools-720-for-oracle-10g-and-11g/ http://feedproxy.google.com/~r/SapBasis/~3/Xt8sI3gR7w4/ http://sapbasis.wordpress.com/2011/11/10/how-to-find-indexes-which-are-candidate-for-rebuild/#comments Thu, 10 Nov 2011 04:54:47 +0000 ardhian http://sapbasis.wordpress.com/?p=235 I know it’s a very arguable question, but let me put my words and then you can comment. I follow different approaches to find out indexes for rebuild - Find out indexes having height(blevel+1) &#62; 4 i.e. Indexes having BLEVEL &#62; 3 How: SQL&#62; select owner,index_name,table_name,blevel from dba_indexes where BLEVEL&#62;3 - Analyze indexes and find [...]<img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=sapbasis.wordpress.com&#038;blog=1517934&#038;post=235&#038;subd=sapbasis&#038;ref=&#038;feed=1" width="1" height="1" /> <p><a href="http://feedads.g.doubleclick.net/~a/2bNSYV7FemmzlY-yh-b3Z7OQtSI/0/da"><img src="http://feedads.g.doubleclick.net/~a/2bNSYV7FemmzlY-yh-b3Z7OQtSI/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/2bNSYV7FemmzlY-yh-b3Z7OQtSI/1/da"><img src="http://feedads.g.doubleclick.net/~a/2bNSYV7FemmzlY-yh-b3Z7OQtSI/1/di" border="0" ismap="true"></img></a></p> http://sapbasis.wordpress.com/2011/11/10/how-to-find-indexes-which-are-candidate-for-rebuild/feed/ 0 ardhian http://sapbasis.wordpress.com/2011/11/10/how-to-find-indexes-which-are-candidate-for-rebuild/ http://feedproxy.google.com/~r/SapBasis/~3/5R9ud1Rz-uo/ http://sapbasis.wordpress.com/2011/10/26/just-for-refresh-steps-to-upgrade-oracle-from-11-1-0-6-0-to-11-1-0-7-0/#comments Wed, 26 Oct 2011 05:51:43 +0000 ardhian http://sapbasis.wordpress.com/?p=229 steps to upgrade 11.1.0.6.0 to 11.1.0.7.0 Step1: using winSCP or anyother tool copy the patch file p6890831_111070_Linux-x86-64.zip to the environment from the machine where you are having patch file. Step2: login : oracle password: Uncompress the binary source $unzip p6890831_111070_Linux-x86-64.zip Example:- After unzipping , you can find the below folder Disk1 c111ptqhdd009: /home/oracle $ cd [...]<img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=sapbasis.wordpress.com&#038;blog=1517934&#038;post=229&#038;subd=sapbasis&#038;ref=&#038;feed=1" width="1" height="1" /> <p><a href="http://feedads.g.doubleclick.net/~a/0fXRtsVXtMDRjzMOgBZCGIuHEgw/0/da"><img src="http://feedads.g.doubleclick.net/~a/0fXRtsVXtMDRjzMOgBZCGIuHEgw/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/0fXRtsVXtMDRjzMOgBZCGIuHEgw/1/da"><img src="http://feedads.g.doubleclick.net/~a/0fXRtsVXtMDRjzMOgBZCGIuHEgw/1/di" border="0" ismap="true"></img></a></p> http://sapbasis.wordpress.com/2011/10/26/just-for-refresh-steps-to-upgrade-oracle-from-11-1-0-6-0-to-11-1-0-7-0/feed/ 0 ardhian http://sapbasis.wordpress.com/2011/10/26/just-for-refresh-steps-to-upgrade-oracle-from-11-1-0-6-0-to-11-1-0-7-0/