Hi All,
Today I’m going to share a list of SAP OSS Notes related to Basis. This list of OSS Notes was built based on my technical experience from 2000 – 2015. I noted them down since they’re not just helped me solve problem that I faced at that time, but I think they also contain some useful and important information or basic concepts of SAP Basis that made me learn something out by just reading them.
So for Basis guys, happy reading on these OSS Notes!
| 45619 | Details about languages and character sets in general | |
| 42305 | Initializing table TCP0D (RSCP0020) | |
| 199166 | List of supported printers/device types | |
| 162991 | Generation tools for ABAP programs | |
| 39412 | How many work processes to configure | |
| 333584 | Frequent errors in settings of the SAP Library | |
| 205487 | Own text on SAPGui logon screen (logon text) | |
| 605062 | FAQ: Restore and recovery | |
| 4157 | General flowchart for ORACLE recovery | |
| 491160 | Restore scenarios for lost files of oracle databases | |
| 4160 | Tape management at recovery | |
| 4161 | Complete Recovery | |
| 4162 | Missing “end backup” | |
| 4163 | Defective redo logs | |
| 4165 | Recovery after structure change | |
| 4164 | Incomplete Recovery (“…RECOVER UNTIL… “). | |
| 4190 | Defective rollback segments | |
| 5701 | RESTORE of the database (partial or complete) | |
| 19914 | Subsequent processing after incomplete recovery | |
| 23345 | Consistency check of ORACLE database | |
| 96848 | Disaster recovery for SAP R/3 on ORACLE | |
| 83020 | What is consulting What is support? | |
| 365481 | Corrupt blocks | |
| 434645 | Point-in-time recovery: prevention and effects | |
| 328785 | ORA-00376: File cannot be read at this time | |
| 651812 | FAQ: BR*Tools and SAPDBA | |
| 594601 | Restore table in minimal copy of current database. | |
| 602497 | BRRECOVER – new tool for Oracle Restore and Recovery | |
| 611493 | BrGui – Graphic user interface for BR*Tools | |
| 639986 | crash recovery/instance recovery hangs | |
| 644527 | LogMiner tool to read redolog information | |
| 541538 | FAQ: Reorganizations | |
| 354293 | DBVerify reports corrupt block in storage bin area | |
| 359835 | Design of the temporary tablespace in the BW System | |
| 391 | Archiver Stuck | |
| 164925 | Storage parameter of tablespace PSAPTEMP | |
| 13655 | SAPDBA: Long runtimes: Exp./imp./reorganization | |
| 11369 | ORA-1452 during import after export from other system | |
| 431881 | SAPDBA and BR tools hang on HP-UX 11 64-bit | |
| 84348 | Deadlock, ORA-00060 | |
| 365481 | Corrupt blocks | |
| 23237 | duplicate keys, duplicate rows, duplicate records | |
| 78595 | ORA1575 timeout waiting for space management res. | |
| 335505 | Performance when accessing the Oracle dictionary with 8.1.X | |
| 648753 | Reducing the tablespace size with a reorganization | |
| 651812 | FAQ: BR*Tools and SAPDBA | |
| 592393 | FAQ: Oracle | |
| 611686 | Continuing a cancelled import for reorganizations | |
| 663522 | Where-used list: Space required, DBIF_RSQL_SQL_ERROR | |
| 592393 | FAQ: Oracle | |
| 551542 | FAQ: Oracle inst., upgrade, migration, relinking software | |
| 618868 | FAQ: Oracle performance | |
| 540463 | FAQ: Consistency Checks | |
| 23070 | Backup and Recovery: Basic Concepts | |
| 659946 | FAQ: Temporary tablespaces | |
| 60233 | Oracle rollback segments, more information. | |
| 118823 | CC-ADMIN: Size of a client | |
| 323151 | Several DB connections with Native SQL | |
| 339092 | DB MultiConnect with Oracle as secondary database | |
| 129439 | Maximum file sizes with Oracle | |
| 562863 | FAQ: Logon mechanisms | |
| 521230 | FAQ: Client software on UNIX | |
| 562403 | FAQ: Net8 | |
| 27517 | Installation RFCSDK | |
| 560499 | Global Support Customer Interaction (SAP Contact list) | |
| 508140 | Customer messages – Customer Logon Data | |
| 63930 | Gateway registration of RFC server program | |
| 706478 | Measures against intensively increasing Basis tables | |
| 606359 | FAQ: Oracle National Language Support (NLS), character set, Oracle Globalization Support | |
| 518241 | DB Connect in BW3.0 for an external Oracle database (Oracle DB Link) | |
| 548943 | FAQ: Avoiding disk space problems | |
| 666061 | FAQ: Database objects, segments and extents | |
| 766349 | FAQ: Oracle SQL Optimization | |
| 25383 | Database links, synonyms, remote DB | |
| 619188 | FAQ: Oracle Wait Events | |
| 521264 | Hanging situations | |
| 132861 | CBO: Statistics creation with SAPDBA or BRCONNECT | |
| 588668 | FAQ: Database statistics | |
| BW / Oracle 9.2 | ||
| 721331 & 731332 | Merge Join Cartesian in TEMP table – STAR and FACT hint | For Oracle 9.2: star_transformation_enabled = true events = “10171 trace name context forever, level 1) |
| 632556 | BW Oracle parameter recommendation | for Oracle 9.2: hash_join_enabled = true; log_checkpoint_interval = 0 <delete> optimizer_index_cost_adj |
| 4063 | Old SysLog (system log) entries disappear | See SM21 ->Environment->Display SAPPARAM |
| 805344 | How URLs are generated automatically in BW | |
| 138722 | FAQ: 32-bit/64-bit R/3-oracle | |
| 480266 | Problems with the SYSDBA/SYSOPER/INTERNAL connect | |
| 602843 | Environment settings for R/3/Oracle on UNIX | |
| 8307 | Changing host name on R/3 host: What do you do? | |
| 555223 | FAQ: Microsoft SQL Server | |
| 556232 | Environment settings for R/3/Oracle on Windows | |
| 126973 | SICK messages with MS SQL Server | |
| 421644 | SQL error 9002: The transaction log is full | |
| 62988 | Service Packs for MS SQL Server | |
| 139945 | SAP Database Monitor for MS SQL Server | |
| 159268 | Service Pack installation on SQL Server 7.0 | |
| 151603 | Copying an SQL Server database | |
| 521750 | FAQ: SQL Server I/O performance | |
| 126808 | Configuration parameter for SQL Server 7.0 | |
| 363018 | File management with SQL Server 7 and 2000 | Add/Remove datafile. Shrinking log files |
| 94310 | ORA-01161 for CREATE CONTROLFILE | |
| 118059 | Storage parameter for system copy with R3load | DBEXPORT |
| 2033 | Startup fails, sapstart.sem, startsap, sapstart | run the files kill.sap and shutdown.sap in the SAP System Working-Directory (/usr/sap/<system-name>/<unit name>/work). Ensure that all IPC objects (shared mem, semaphores, …) have been deleted. (showipc <system-no) bzw. cleanipc <system-no>) |
| 400241 | Problems with ops$ or sapr3 connect to Oracle | System copy |
| SAP GUI | ||
| 26417 | SAP GUI Resources: Hardware and software | SAPGUI |
| 147519 | SAP GUI Support | SAPGUI |
| 62418 | Network Load of SAPGUI Frontend Communication | SAPGUI |
| Maintenance | ||
| 52505 | Note 52505 – Support after end of mainstream/extended maintenance | |
| 113747 | Permissions for DBA tools BR*Tools and SAPDBA | |
| 455140 | Configuration of e-mail, fax, paging or SMS using SMTP | |
| Note 1094421 | Note 1094421 – TIME_OUT Job termination DDIC conversion as mass proc. | Support Package error due to rdisp/max_wprun_time. Table conversion triggered in dialog process and timed out even though the process was triggered to run in background. This error is corrected in certain Basis Support Package. |
| 570375 | SAP on Sun Solaris: Swap Space and Paging | Unix memory, swap |
| 153641 | Swap space requirement for R/3 64-bit kernel | |
ROLANDO - MY SHARING BLOG 