Solution : https://service.sap.com/sap/support/notes/592393 (Connexion à SAP Service Marketplace requise)
Résumé :
Cette note SAP aborde de nombreuses questions liées à la gestion de la base de données Oracle dans un environnement SAP. Les solutions clés incluent l'identification des composants appropriés pour ouvrir des messages SAP spécifiquement pour les problèmes liés à Oracle, l'emplacement des journaux d'alerte Oracle, les méthodologies pour gérer et contrôler la taille du fichier journal d'alerte, et les lignes directrices pour obtenir et interpréter les codes d'erreur Oracle, incluant l'utilisation de l'outil OERR. Elle discute également des actions préventives pour la journalisation des erreurs et la configuration de la journalisation des erreurs de déclaration SQL. Un aperçu des recommandations de paramètres pour la configuration de la base de données Oracle et les copies systèmes est également inclus, ainsi que les répertoires recommandés pour les fichiers de paramètres Oracle, le dépannage des changements non implémentés dans les fichiers init, et les combinaisons autorisées d'Oracle, R/3 et systèmes d'exploitation.
Mots Clés :
oracle real application cluster bc-db-ora-sys, dbsl oracle functions bw-sys-db-ora, <sapdata_home>/saptrace/diag/rdbms/<sid>/<sid>/trace, alter tablespace <tsp_name> drop datafile '<path_and_name>', /oracle/<sid>/sapdata1/stabd_1 -> /oradata/stabd_1, oracle area bc-db-ora-ins, database administration bc-db-ora-ccm, oracle database bc-db-ora-rac, alter system set events = '<errorcode> trace, component xx-ser-swfl-ship
Notes associées :
| 1551504 | Cleaning up Oracle audit files |
| 1431798 | Oracle 11.2.0: Database Parameter Settings |
| 1398634 | Oracle database 11g: Integration in SAP environment |
| 1174136 | Oracle: End of Support Dates |
| 1110995 | Extended maintenance for Oracle Version 10.2 |
| 1075118 | SAP on HP-UX: FAQ |
| 1021844 | Oracle 9.2 Extended Support free until July 31, 2008 |
| 1019133 | Impact of 2007 USA daylight saving (DST) changes on Oracle |
| 1017936 | Oracle Database 10g: Upgrade history |
| 1003028 | Enhanced support for database copy in BR*Tools |
| 998675 | Archive log of smaller size than the original redo log |
| 938986 | Oracle Database 9.2: Patches for 9.2.0 |
| 875477 | Avoiding long runtimes with BEGIN BACKUP |
| 871735 | Current patch set for Oracle 10.2.0 |
| 871096 | Oracle 10.2.0: Patches/patch collections for Oracle 10.2.0.2 |
| 863417 | FAQ: Database Archive modes and redo logs |
| 858200 | FSCM-BD Encrypting the payment card data |
| 842240 | FAQ: Backup strategy of large and highly-available databases |
| 834343 | Oracle 9.2 Platform Support for Async IO |
| 830576 | Parameter recommendations for Oracle 10g |
| 828268 | Oracle Database 10g: New functions |
| 825653 | Oracle: Common misconceptions |
| 821627 | Parallel reading CRE PDQ |
| 817253 | FAQ: Open a Database Read only |
| 806554 | FAQ: I/O-intensive database operations |
| 793113 | FAQ: Oracle I/O configuration |
| 786032 | How to trim Oracle Alert log file |
| 766703 | FAQ: Credit card encryption in R/3 systems |
| 758563 | Oracle Metalink access for SAP customers |
| 740897 | Info about the Oracle license scope; Required Oracle options |
| 720886 | Oracle Database 10g: Integration into the SAP environment |
| 668152 | Maintenance for Oracle Version 8.1.7 extended until 12/2004 |
| 651812 | FAQ: BR*TOOLS and SAPDBA |
| 644939 | Maintenance extension for Oracle Version 8.1.7 |
| 635974 | Error when upgrading to Oracle 9.2.X - Windows |
| 620540 | Authentication Troubleshooting Guide |
| 619876 | Oracle9i: Automatic PGA Memory Management |
| 618868 | FAQ: Oracle performance |
| 617444 | Separate SCHEMA ID for database schema and tablespace name |
| 617416 | Oracle9i: Dynamic SGA |
| 614036 | Composite SAP Note: ORA-12631/ORA-12638 |
| 598678 | Oracle 9i: New functions |
| 583861 | UNIX: Errors due to Oracle executable |
| 581312 | Oracle database: licensing restrictions |
| 572060 | Options in the Oracle database during archiving |
| 553854 | Oracle: Problems with file size limit |
| 551542 | FAQ: Oracle inst., upgrade, migration, relinking software |
| 445226 | Multiple ARCx processes are running |
| 407314 | SAP kernel 6/7.x ORACLE: Released operating systems |
| 386413 | Oracle Enterprise Manager (OEM) in the SAP environment |
| 339092 | DB MultiConnect with Oracle as secondary database |
| 323151 | Several DB connections with Native SQL |
| 206916 | Oracle processes run under "incorrect" user |
| 192822 | FAQ: 32-bit/64-bit R/3-oracle |
| 180605 | Oracle database parameter settings for BW |
| 156548 | Released operating systems for SAP kernel 4.6x ORACLE |
| 154193 | SAPDBA: Reorganizations and ABAP-DDIC |
| 139418 | |
| 129439 | Maximum file sizes with Oracle |
| 124361 | Oracle parameterization (R/3 >= 4.x, Oracle 8.x/9.x) |
| 118823 | CC-ADMIN: Size of a client |
| 115224 | |
| 105047 | Support for Oracle functions in the SAP environment |
| 98051 | Database Reconnect: Architecture and function |
| 85838 | Released operating systems for SAP Kernel 4.0x/4.5x ORACLE |
| 27428 | SAPDBA: SAP R/3 naming conventions for DB data files |
| 23875 | Released operating systems for R/3 3.0x/3.1x ORACLE |