SAP Note 592393 - FAQ: Oracle

Composant : Oracle -

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 :

1551504Cleaning up Oracle audit files
1431798Oracle 11.2.0: Database Parameter Settings
1398634Oracle database 11g: Integration in SAP environment
1174136Oracle: End of Support Dates
1110995Extended maintenance for Oracle Version 10.2
1075118SAP on HP-UX: FAQ
1021844Oracle 9.2 Extended Support free until July 31, 2008
1019133Impact of 2007 USA daylight saving (DST) changes on Oracle
1017936Oracle Database 10g: Upgrade history
1003028Enhanced support for database copy in BR*Tools
998675Archive log of smaller size than the original redo log
938986Oracle Database 9.2: Patches for 9.2.0
875477Avoiding long runtimes with BEGIN BACKUP
871735Current patch set for Oracle 10.2.0
871096Oracle 10.2.0: Patches/patch collections for Oracle 10.2.0.2
863417FAQ: Database Archive modes and redo logs
858200FSCM-BD Encrypting the payment card data
842240FAQ: Backup strategy of large and highly-available databases
834343Oracle 9.2 Platform Support for Async IO
830576Parameter recommendations for Oracle 10g
828268Oracle Database 10g: New functions
825653Oracle: Common misconceptions
821627Parallel reading CRE PDQ
817253FAQ: Open a Database Read only
806554FAQ: I/O-intensive database operations
793113FAQ: Oracle I/O configuration
786032How to trim Oracle Alert log file
766703FAQ: Credit card encryption in R/3 systems
758563Oracle Metalink access for SAP customers
740897Info about the Oracle license scope; Required Oracle options
720886Oracle Database 10g: Integration into the SAP environment
668152Maintenance for Oracle Version 8.1.7 extended until 12/2004
651812FAQ: BR*TOOLS and SAPDBA
644939Maintenance extension for Oracle Version 8.1.7
635974Error when upgrading to Oracle 9.2.X - Windows
620540Authentication Troubleshooting Guide
619876Oracle9i: Automatic PGA Memory Management
618868FAQ: Oracle performance
617444Separate SCHEMA ID for database schema and tablespace name
617416Oracle9i: Dynamic SGA
614036Composite SAP Note: ORA-12631/ORA-12638
598678Oracle 9i: New functions
583861UNIX: Errors due to Oracle executable
581312Oracle database: licensing restrictions
572060Options in the Oracle database during archiving
553854Oracle: Problems with file size limit
551542FAQ: Oracle inst., upgrade, migration, relinking software
445226Multiple ARCx processes are running
407314SAP kernel 6/7.x ORACLE: Released operating systems
386413Oracle Enterprise Manager (OEM) in the SAP environment
339092DB MultiConnect with Oracle as secondary database
323151Several DB connections with Native SQL
206916Oracle processes run under "incorrect" user
192822FAQ: 32-bit/64-bit R/3-oracle
180605Oracle database parameter settings for BW
156548Released operating systems for SAP kernel 4.6x ORACLE
154193SAPDBA: Reorganizations and ABAP-DDIC
139418
129439Maximum file sizes with Oracle
124361Oracle parameterization (R/3 >= 4.x, Oracle 8.x/9.x)
118823CC-ADMIN: Size of a client
115224
105047Support for Oracle functions in the SAP environment
98051Database Reconnect: Architecture and function
85838Released operating systems for SAP Kernel 4.0x/4.5x ORACLE
27428SAPDBA: SAP R/3 naming conventions for DB data files
23875Released operating systems for R/3 3.0x/3.1x ORACLE