How to install SAP Database Instance

After you finish SAP Oracle Database Instance installation and SAP Central Instance installation, now you’re ready to continue to the core installation of R/3 system, that is SAP Database Instance installation.

Before you do the installation you have to make your server meet SAP Hardware Requirement. Detail about system requirements for SAP installation is provided in SAP installation guide (you can find in http://service.sap.com/instguides, user and password is required)

Please prepare the following SAP software CD’s before doing the installation:
1. SAP Installation Master
2. SAP Kernel
3. SAP Oracle Client
4. SAP Database Export CDs.

Don’t forget to read your SAP installation guide as your main guidance.

PREREQUISITE:
Set your JAVA_HOME first in your environment, point to your Java Directory.
Example: JAVA_HOME = C:\java

STEP:
1. Put your SAP Installation Master CD in CDROM/DVDROM Drive and run sap installer program SAPINST (usually in folder DRIVE:\IM\SAPINST\NT\, wait until the initial screen comes out.

2. Choose “Database Instance Installation” –> Depend on your database and Unicode/Non-Unicode, in this example I use SAP R/3 4.7 Ext2 SR1 on Database Oracle with Non-Unicode. (The installation step for newer version such ERP ECC 6.0 is quite the same, but there’s additional question Solman Key, I’ll show you on next article).

How to install SAP database instance
How to install SAP Database Instance – pic 1

3. on next screen you’ll be asked for
your SAP System ID 

How to install SAP Database Instance – pic 2

4. Since it’s the first SAP system installation in your host choose Standard Installation.

How to install SAP Database Instance – pic 3

5. If it’s the first SAP installation you choose install the first SAP system in the database.

How to install SAP Database Instance – pic 4

6. Enter your Database SID (you set Database SID in SAP Oracle Database Instance installation)

How to install SAP Database Instance – pic 5

7. Enter you System Number and Instance Host of you SAP Central Instance.

How to install SAP Database Instance – pic 6

8. Now you’re asked about memory configuration
HINTS:
– if you’re using the server alone for your DB/CI server, you can use 80% memory.
– Choose “Installation in Domain of current user” if your SAP CI using clustering technology and/or
your SAP system Landscape using domain authentication for SAP Admin user.

How to install SAP Database Instance – pic 7

9. Choose “NO LDAP” if you’re not using LDAP

How to install SAP Database Instance – pic 8

10.  Choose
Locate executable on central instance host
Fill hostname of your transport directory

Locate SAP Host with Transport Directory

11. You’ll be asked:
Database Home: It’s the Home Base of your Oracle Installation.
Database Server Version: The Oracle Software version that you install.
Database Client Version: your Oracle Client version
Database Schema: (Usually SAP)
Drive for Server Directories:  Drive for your SAP Oracle base like saptrace, sapreorg
Drive for Redo Log Archive: Your Oraarch folder.

Setting of Database Schema and the location of archivelog files.

12. Choose Next to go to next process.

13. You’ll be asked for SAP Admin user and Password. Enter with the username and correct password for adm.

User and password for sidadm

14. Enter username and password of SAPService

User and password for SAPServiceSID

15. Enter the location of your CD SAP Kernel

SAP Kernel CD Location

16. Enter the location of your CD Oracle Client

SAP Oracle Client CD Location

17. Enter port number of your listener (from your Oracle Database)
usually located in (ORACLE_HOME\network\admin) to see listener configuration

Listener Name and Listener Port

18. Click Option if you want to change Parameters, or leave it unchecked to make it default.

Database Creation Parameter

19. Enter specific information,
MaxLogFiles: maximum number of LogFiles
MaxLogMembers: maximum member of you LogFiles
MaxLogHistory: the history of redolog switching.
MaxInstances: specifies that instances can have this database mounted and open
MaxDataFiles: specifies the maximum number of datafiles that can be opened in your database. This number affects the initial sizing of you control file.
MaxControlFileSize: maximum size of your control file.
Reuse Control Files: reuse existing control files identified by the initialization parameter CONTROL_FILES
Number of Redo Log Groups: specify how many redolog groups you want to have in your system
Mirror Redo Log Files: Click this option if you want to make mirroring to your redo log files.
Size of Redo Log Files: Specify the size of your redo log files.
Reuse Redo Log Files: Click this option if you want to reuse your redo log files.

Database instance creation parameters.

20. Enter the location of your redo log files, for better performance, you put in different drive your redolog file and the corresponding mirroring files..

The location of your redo log files.

21. Enter the location of your CD Export.

Your CD Export Location

22. You now Enter the placement of your tablespaces in your Drive.
Click the option below if you want to change Tablespace creation

 

23. Now choose your drive letter for your sapdata. If you have more drive you can separate it to different letter.

Drive for sapdata

24. Now you are asked for tablespace creation parameters.

Tablespace creation parameters

25. Enter your Tablespace General Storage Parameters.

Tablespace General Storage Parameters

26. Enter Tablespace Default Storage Parameters.

Tablespace Default Storage Parameters.

27. Enter Tablespace Extended Management Parameters.

Tablespace Extended Management Parameters.

28. Enter the complete location of your Export CD

Location of your export CD

29. Choose option for Load Strategy –> it’s better to Load by Data File Size (Largest First)
Enter Number of Parallel Jobs (depends on you DB CPU core)
Choose Advance Configuration of Packages if you want to change Load Import parameter (keep it default).

Load import parameters.

30. Enter password for your database users.

Password for your database users

31. Now review your all input, if you need to change it press back button. Click Next to Installation process.

Summary of your input

32. Installation process is running.

33. You can monitor your database load in .TSK in installation directory.

Database load progress.

34. After Database load finished you’ll be asked to set your DDIC & SAP* password.

Set your DDIC password
Set your SAP* password

35. Now you’ve finished your SAP Database Instance installation.

Installation is finished.

You can now login to your SAP System, make sure your SAP Service is started. You can add additional SAP Dialog Instances to serve as SAP Application Servers.

Leave a Reply