Sunday, January 12, 2014

Oracle Database Installation for SAP

Oracle Database Installation for SAP


When Oracle Database software is installed, a starter database should not be created, because the SAP install process will create a database for the application and will load data into the tables
During the course of the SAP installation, the sapinst program will stop as shown in figure below and ask the administrator to perform the Oracle install.



When installing the Oracle software, the Oracle Universal Installer tool must be used. The following procedure should be followed before the Oracle Universal Installer tool is started.

*************************************************************************************************************
1.      Open another X term and set the DISPLAY variable for user ora<sid> (example: oradb1)
Setenv DISPLAY <IP Address:0.0>
Setenv ORACLE_HOME /oracle/DB1/102_64
Setenv ORACLE_SID DB1
cd to /oracle/stage/102_64/database/SAP

*************************************************************************************************************
Shows the initial screen of the Oracle Universal Installer


2
Select the components as shown and then click the Next button to continue with the install. This will bring up the prerequisite check screen


3
Verify the identified prerequisites, and click the Next button once these are met. This will display the summary screen

4
Verify the summary screen and then click the Install button. This will start the Oracle software installation with a status indicator indicating the progress. After progressing through the different installation steps, the Oracle Universal Installer will stop at the screen and ask the administrator to execute a script as root user.

5
open another terminal window, log in as root, and execute the root.sh script. The execution details of the root.sh script are as follows:

***************************************************************************************************
[sapdb1] /oracle/DB1/102_64 #./root.sh
Running Oracle10 root.sh script...
The following environment variables are set as:
ORACLE_OWNER= oradb1
ORACLE_HOME= /oracle/DB1/102_64
*****************************************************************************************************

6
Enter the full pathname of the local bin directory: [/usr/local/bin]:
*****************************************************************************************************

The file "dbhome" already exists in /usr/local/bin. Overwrite it?
(y/n) [n]: y
Copying dbhome to /usr/local/bin ...
The file "oraenv" already exists in /usr/local/bin. Overwrite it?
(y/n) [n]: y
Copying oraenv to /usr/local/bin ...
The file "coraenv" already exists in /usr/local/bin. Overwrite it?
(y/n) [n]: y
Copying coraenv to /usr/local/bin ...
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.
*******************************************************************************************************
7
Click the OK button after the root.sh script is executed successfully. This will complete the Oracle Database software installation successfully

No comments:

Post a Comment