Database System Configuration 

Purpose

During database installation, which is not covered in this documentation, you need to change the initial database user passwords and initialize SAP connect.

1. You set up archiving, making sure that the database runs in ARCHIVELOG mode and with automatic archival enabled.

See Setting Up Archiving and Setting Archive and Database Mode with SAPDBA.

2. You mirror the control files on separate disks.

See Mirroring the Control File.

3. You mirror the online redo log files on separate disks (at operating system level and/or using Oracle resources). With Oracle support, you can set this up when you install the database system.

See Mirroring Online Redo Log Files.

4. You install online redo log files, offline redo logs files (that is, online redo log files saved to the archive directory), and data files to separate disks.

See Organizing Disk Storage.

5. You make sure that the block sizes of the database system and the operating system are the same for security and performance reasons. The block size of the operating system is reformatted to 8K during the installation of the SAP System.

The AIX operating system is an exception, because the block size of the database system must be 8 KB and the block size of the operating system must be 4 KB.

6. You familiarize yourself with the tablespace structure of the SAP System, being sure to monitor the critical tablespaces.

See SAP Naming Conventions for Tablespaces and Data Files and the graphic below.

Structure of Oracle database



7. You familiarize yourself with environment variables and set them as required. Refer to:

• Environment Variables (UNIX)
• Environment Variables (Windows NT)

8. You familiarize yourself with the directory structure. Refer to:

• Directory Structure (UNIX)
• Directory Structure (Windows NT)