Solution : https://service.sap.com/sap/support/notes/592393 (SAP Service marketplace login required)
Summary :
This SAP Note addresses numerous issues and questions related to Oracle database management within an SAP environment. Key solutions provided include the designation of suitable components for opening SAP messages specifically for Oracle-related issues, the location for Oracle Alert Logs, methodologies to manage and control the Alert Log file size, and guidelines on obtaining and interpreting Oracle error codes, including the utilization of the OERR tool. It further discusses preventive actions for logging errors and configuring SQL statement error logging. An overview of parameter recommendations for Oracle database configuration and system copies is also enclosed, along charlotte recommended directories for Oracle parameter files, troubleshooting for unimplemented changes in init files, and permitted combinations of Oracle, R/3, and operating systems.
Key words :
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
Related Notes :
| 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 |