Database System Configuration

This section tells you how to configure your Oracle database system.

During database installation, which is not covered in this documentation, you need to change the initial database user passwords. You can use BRCONNECT -f chpass to do this at any time.

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

2. You mirror the control files on separate disks.

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.

4. You organize disk storage by installing 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.

5. You check the database parameters. 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 follow the SAP Naming Conventions for Tablespaces and familiarize yourself with the tablespace structure of the SAP System, being sure to monitor the critical tablespaces, as shown in the graphic below.

   

   Figure 1: Structure of the Oracle database

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

   • Environment Variables (UNIX)

   • Environment Variables (Windows)

8. You familiarize yourself with the directory structure:

   • Directory Structure (UNIX)

   • Directory Structure (Windows)

9. You familiarize yourself with users and roles.