Symptom:When generating, enhancing or reorganizing tablespaces with data files, SAP database administration tools (for example, br* tools and sapdba) report the non-adherence to SAP conventions for names, directories or symbolic links to database files.
Other termsFile name, directory, symbolic link, SAP convention, convention
Reason and PrerequisitesYou entered a directory name or file name that does not correspond to the SAP conventions, or you failed to adhere to the SAP conventions when you manually enhanced or reorganized tablespaces.
SolutionThe following rules describe the naming conventions for R/3 database files, that is, the file names and path names in the database (V$DATAFILE, DBA_DATA_FILES) must be defined in accordance with these rules.
SAP conventions for ORACLE database files:
===========================================
For UNIX:
---------
Main directory:
For FSys: $SAPDATA_HOME/sapdata[n]
For RawD: $SAPDATA_HOME/sapraw
Data file:
For FSys: $SAPDATA_HOME/sapdata[n]/[tsp]_[m]/[tsp].data[m]
For RawD: $SAPDATA_HOME/sapraw/[tsp]_[m]
Symbolic link:
[tsp]_[m] may (for FSys) or must (for RawB) be a symbolic link:
For FSys: $SAPDATA_HOME/sapdata[n]/[tsp]_[m] -> target_directory
For RawD: $SAPDATA_HOME/sapraw/[tsp]_[m] -> /dev/rdsk/[db][tsp_m]
For Windows NT:
---------------
[D]:%SAPDATA_HOME%\sapdata[n]\[tsp]_[m]\[tsp].data[m]
Notes:
--------------
In UNIX, pay attention to upper and lower case (the SID in the path is generally in upper case and everything else is in lower case).
FSys = Database files in the file system
RawD = Database files on raw device (only possible in UNIX)
In Windows, no distinction is made between upper case and lower case in file names and path names. You can enter the names in either upper or lower case.
[D]:
Disk drive ID (for Windows only):
Exactly 1 letter (A ... Z), followed by a colon ':'.
$SAPDATA_HOME:
Directory for all sapdata[n] or rawdev.
$ORACLE_HOME is the default value for $SAPDATA_HOME.
For information about the environment variables, see Note 96858 (UNIX) or 94801 (Windows NT).
sapdata{n]:
Main directory in FSys.
The name must contain the string "sapdata" and any natural number n>=1 without preceding zeros. Other characters are not allowed.
For example: "sapdata12"
In Windows, sapdata[n] must be a directory (not a link)!
In UNIX, sapdata[n] can be a symbolic link to any other directory (but not a link to another link to a directory, that is, no chained links), but sapdata[n] are usually mount points, not symbolic links.
sapraw:
Main directory in RawD.
When you use raw devices (UNIX only), you must use the "sapraw" directory instead of sapdata[n]. No other name is permitted. "sapraw" cannot be a link itself. It only contains the symbolic links [tsp]_[m] to the raw devices.
[tsp]_[m]:
Subdirectory of sapdata[n] for the data file or the link to the data file directory or link in sapraw to the raw device.
Chained links (multiple links) are not permitted.
[tsp] is actually any name. However, it should always be a unique, shortened form of the tablespace name.
m is the consecutive number within the tablespace. This is any natural number, m>=1, without preceding zeros.
[tsp] and [m] must (except in the case of RawD) be identical to the corresponding values in the subsequent file name [tsp].data[m].
Example for tablespace "PSAPBTABD": "btabd_10"
[tsp].data[m]:
File name (only in the case of file systems). Links are not permitted.
[tsp] and [m] are identical to the corresponding values in the name [tsp]_[m].
Example for tablespace "PSAPBTABD": "btabd.data10"
target_directory:
Any target directory of a symbolic link (only UNIX with FSys). It cannot be a link itself and it contains one or more data files for a database.
The name of the target_directory cannot contain the string "sapraw" and it cannot start with "/dev/".
For example: "/data"
"/dev/rdsk/[db][tsp]_[m]":
Example for a raw device name (entire path, UNIX only). (depending on the UNIX-BS, '/dev/rdsk' might have a different name)
The raw device is always the target of a symbolic link "$SAPDATA_HOME/sapraw/[tsp]_[m]".
[db] is the name of the database.
[tsp]_[m] in the raw device name (link target) and the link name are identical.
The link target must not contain the string "sapraw".
For example: "/oracle/C11/sapraw/btabd_10" -> "/dev/rdsk/c11btabd_10"
Caution:
--------
You are allowed to page out temporary tablespaces in separate file systems that are mounted under the directories saptemp[n] (n = 1...99), for example $SAPDATA_HOME/saptemp1/temp_1/temp.data1.
This allows you to manage and monitor sparse files, which are used by temporary tablespaces.
These configurations are supported by BR*Tools 7.00 as of Patch 20.