Free Downloads
Oracle SAP Administration

SAP is the leading vendor of enterprise resource planning (ERP) systems in the world. (The name SAP is an acronym for the German "Systemanalyse und Programmentwicklung", which roughly translates to "Systems, Applications, and Products in Data Processing".) Developed and marketed by SAP-AG, a Germany company that was founded in 1972 by IBM application developers, SAP has historically sold to the European market. During the 1990s, the company has increasingly dominated the U.S. market as well among large Fortune 500 companies. Nearly half the SAP user base is now in the U.S. Now that SAP-AG is beginning to penetrate the small to medium-size companies, client/server sales are accelerating.The SAP system performs a wide range of business functions, from manufacturing, sales, and distribution to accounting and human resources. By linking together these business functions, SAP helps the entire enterprise run more smoothly. The system can be used with virtually any hardware or operating system and with most database systems. Oracle is the dominant DBMS - about 80% of SAP systems use Oracle. Conversely, about 20% of large Oracle sites run SAP -- and the numbers are growing. Although overall SAP numbers are tightly guarded, it appears that there are about 20,000 SAP sites, in 90 countries. SAP-AG's 1998 sales were approximately 8.47 billion.Although there is voluminous documentation on using SAP and using Oracle, until now there has been no book that described the intersection between the two systems. Experienced Oracle administrators have a lot to learn when their organizations start using SAP. Oracle SAP administration differs from traditional Oracle administration in many ways. SAP provides its own tools for Oracle administration; Oracle DBAs need to learn how to use these tools -- and need to learn when the tools are not the best way to accomplish a task. There are special settings for initialization (INIT.ORA) parameters, special monitoring and tuning guidelines, and a variety of other special situations.This concise book is aimed at experienced Oracle database administrators, system administrators, and developers who are using either Oracle8 or Oracle7. It emphasizes the differences between traditional Oracle administration and Oracle/SAP administration, and it supplements the Oracle and SAP documentation. The book covers the most useful administration tools, SAPDBA and SAPGUI. It provides recommendations for the most efficient placement of data files; monitoring databases; reorganizing tables, tablespaces, and indexes; backing up and recoving databases; and tuning Oracle/SAP databases for best performance. There are chapters on special issues for parallel processing and for very large SAP databases and a summary of additional resources for the Oracle/SAP administrator. The tried-and-true tips and techniques contained in this book should save you hundreds of hours of aggravation while you adapt to using Oracle and SAP in combination.

Paperback: 210 pages

Publisher: O'Reilly Media; 1 edition (September 11, 1999)

Language: English

ISBN-10: 156592696X

ISBN-13: 978-1565926967

Product Dimensions: 7 x 0.6 x 9.2 inches

Shipping Weight: 15.2 ounces

Average Customer Review: 3.7 out of 5 stars  See all reviews (15 customer reviews)

Best Sellers Rank: #4,201,201 in Books (See Top 100 in Books) #17 in Books > Computers & Technology > Networking & Cloud Computing > Data in the Enterprise > SAP R3 #520 in Books > Computers & Technology > Hardware & DIY > Maintenance, Repair & Upgrading #873 in Books > Computers & Technology > Hardware & DIY > Personal Computers > Macs

This is a much-needed book in the SAP marketplace, but in its current form, this edition isn't it. As an experienced R/3 administrator, hoping to expand my understanding of the R/3 - Oracle integration points, I bought this book with high hopes. The author lost a great deal of credibility in my eyes with the number of glaring errors when discussing R/3. It is obvious that no R/3 Basis Administrator was asked to review the text for accuracy. Based on the number of errors I discovered in the first few chapters on R/3, I couldn't trust that the remainder of the text would be correct, as the subject matter advanced to topics I had less expertise on (i.e. Oracle). I do not question the authors expertise with Oracle. I do question his ability to write a book that creeps outside his area of expertise without outside assistance.I understand that this book is targeted towards Oracle DBAs who are pushed into an SAP environment where the world as they know it turns upside down, and not necessarily for SAP Basis Administrators looking to learn more Oracle skills. Still, I think this book could have been so much more for the author and SAP administrators worldwide.It is still a much needed book in the SAP market, and I reluctantly recommend buying it, but only after visiting OReilly's web site for the errata.

The author has definately tried take advantage of the fact that SAP System Admin Documentation is not so thorough and extensive.It is clear that he has never worked with SAP before. The book is full of mistakes that even a Basis Administrator with 6 months experience would know. For example, the author says that the SAP SID must be 3 characters long, must start with the letter S followed by any other 2 characters, with SAP being the exception, like we all know this is a load of hogwash. Save your money, because in my opinion the author's only intention is to make some money out of you, despite his dismal inexperience in SAP. I will never buy another book written by the author.

I read this book primarily for its reorganization and tuning aspects. There were good ideas that nudged me in the right direction, but there was an unacceptable amount of technical incorrectness. The descriptions of how SAP stores data, many of the Oracle commands were in error. CLEAN IT UP!

This book is a great supplement to the SAP documentation. The best part of this book is that it doesn't waste pages discussing the Oracle or SAP basics. It was very useful for me on my first SAP implementation. The scripts are also very useful. Overall, an outstanding book.

Very focused, well written book. In depth view of Oracle RDBMS and SAP integration and administration. These days who has the time to read manual after manual to find answers. A must have if you are an Oracle DBA supporting SAP or wanting to learn how to support SAP R/3. Highly recommend.

If you are a knowledgeable Oracle DBA and you need to understand some more about R/3 running on Oracle then I totally recommend this book. If you are an experience R/3 basis consultant looking for some great tuning tips and advice on running an Oracle database on R/3 then again I recommend this book. If you neither know Oracle nor R/3 then don't buy it, it's not for beginners, have a look around are some bigger more weightier beginner volumes more suited to your needs.After reading this book it is clearly obvious that the author Donald K. Burlenson, has a fantastic understanding of Oracle and Database Management, not just from a high level perspective but from someone who has real experience with countless real-life production systems. After reading this book you will definitely have a much better understanding of how to configure your Oracle system for best performance for R/3 ( thus avoiding trouble latter). Another strong point of this book, is the scripts and tools to monitor and identify problems, these are not so much simple tips and checks but the basics of a oracle management framework you can use implement to manage your real-life R/3 production system. After all, clear and controlled management (who, what, where, when) that identifies a true professional from the mediocre.For criticism, Burlenson does not understand R/3 basis an well as well as he knows Oracle resulting in naEe statements about R/3 and some missed opportunities to deliver performance improvement for Oracle DB's particular with customized reporting (a area of BIG problems). Another chapter focussing on customizing ABAP (native SQL etc) for best oracle performance would be a worthy addition to this book. That's my opinion anyway!Overall a great book well worth the cover price, easy and quick to read, offering real help and understanding. If you manage R/3 on Oracle, a great buy!

If you are the DBA or the person responsible for supporting SAP on an ORACLE database, this is a must read book. The book is filled with information that will help you hit the ground running. This book goes beyond the topic of SAP and covers Oracle concepts such as free lists that provide a foundation to better understand performance and tuning considerations. The examples provide sufficient implementation detail. The authors style of writing transforms the technical jargon into easy reading without losing the technical content. An easy to read reference manual.

Oracle Essbase & Oracle OLAP: The Guide to Oracle's Multidimensional Solution (Oracle Press) Oracle SAP Administration ALE, EDI, & IDoc Technologies for SAP, 2nd Edition (Prima Tech's SAP Book Series) Supply Chain Management Based on SAP Systems: Architecture and Planning Processes (SAP Excellence) Beginning Oracle Database 11g Administration: From Novice to Professional (Expert's Voice in Oracle) Oracle Solaris 11.2 System Administration Handbook (Oracle Press) Oracle Solaris Cluster Essentials (Oracle Solaris System Administration Series) Solaris 10 System Administration Essentials (Oracle Solaris System Administration Series) Oracle Database 11g & MySQL 5.6 Developer Handbook (Oracle Press) OCA/OCP Oracle Database 11g All-in-One Exam Guide with CD-ROM: Exams 1Z0-051, 1Z0-052, 1Z0-053 (Oracle Press) Oracle Database 12c The Complete Reference (Oracle Press) Oracle Database 12c DBA Handbook (Oracle Press) Effective Oracle by Design (Osborne ORACLE Press Series) Introduction to Oracle: Basic Skills for Any Oracle User Oracle Big Data Handbook (Oracle Press) Oracle E-Business Suite Development & Extensibility Handbook (Oracle Press) Oracle Cloud Pocket Solutions Guide: Real Life Solutions for Oracle Cloud Oracle Database 12c Oracle RMAN Backup and Recovery OCA Oracle Database 12c SQL Fundamentals I Exam Guide (Exam 1Z0-061) (Oracle Press) Easy HTML-DB Oracle Application Express: Create Dynamic Web Pages with OAE (Easy Oracle Series)