Oracle file and folder names are standardized in in the SAP systems. During SAP installations, Files and Folders created with the same structure and naming conventions. SAP tools for oracle administration will rely on these naming conventions. About each folder is discussed briefly here under. I have installed SAP ECC 6.0 EHP4 on Wwindows server 2003 based on Oracle database. Oracle database SID – SM1 and SAPSID – SM1. Based on these SIDs following folders are explained.

D:\oracle\SM1\102\database

• The Oracle profile file initSM1.ora or spfileSM1.ora holds the Oracle instance configuration parameters.
• The profile file initSM1.sap holds the configuration parameters for BR*Tools which are used for oracle administration

Data files for Tablespaces located in the following folder:

D:\oracle\SM1\sapdata1- D:\oracle\SM1\sapdata4

Online Redo Log Files located in the following directories

D:\oracle\SM1\origlogA, D:\oracle\SM1\origlogB

Mirrored Redo Log files located in the following folders

C:\oracle\SM1\mirrlogA, C:\oracle\SM1\mirrlogB\

Offline redo log files will be writtern to the oraarch folders and this foloder located in the following directory path

D:\oracle\SM1\oraarch

File example: SM1ARCHARC01010_0757105815.001

The saptrace directory is used to store Oracle dump information. The Oracle alert file alert_<DBSID>.log is written to directory
saptrace/background. Trace files of Oracle shadow processes are written to the directory saptrace/usertrace.

1. D:\oracle\SM1\saptrace\background – The Oracle alert file ‘alert_sm1.log’ file is written to this folder
2. D:\oracle\SM1\saptrace\usertrace – Trace files of oracle shadow processes will be written to this directory

D:\oracle\SM1\saparch

stores logs written by the SAP tool BRARCHIVE.

D:\oracle\SM1\sapbackup – stores logs written by the SAP tools BRBACKUP, BRRESTORE and BRRECOVER.

D:\oracle\SM1\sapreorg -  is used by BRSPACE to store logs of different actions.

D:\oracle\SM1\sapcheck -  is used by BRCONNECT to store logs of different actions

This entry was posted on February 16, 2012 at 1:18 PM. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Posted in SAP Basis Notes by Raj No Comments Yet