3. Installation of Database


***************** Index of Pages on the topic…. ****************************
1. preparing os and system for SAP installation
2. installation of sap central instance.
3. installation of database
4. post-installation tasks
******************************************************************************

Fortunately I am back into completing this writing. I stopped on central instance installation, which in the midway of its installation will ask to install database, in my case this is Oracle. SAP does the ground work for the installation by creating the stage area, the user name, user home directory, enviorment setting etc.

So you need to login in as the user ora<SID> in the system. The best option is to login in the console or take a VNC session.

Before proceeding run xclock from a terminal window. If xclock is working, you will see a java clock applet is appearing otherwise you need to set the terminal and then check once again. Remember, the console you are using to install the database must be configured correctly before going further and xclock helps you to understand whether it is correct or not.

During the installation of SAP centeral instance only the Oracle stage , ora<SID> user is , group is created/prepared/set. Once you login into the system as ora<SID> you need to know go to the oracle stage directory. In the stage directory (/oracle/stage/102_64/) you will find following directories. you need to go database and then install subdirectory. As shown from a list of my case.

<Start List>
HSSAMUMS011:orahe6 61> ls -lt
total 0
drwxr-xr-x  7 orahe6 dba 232 2005-11-03 16:12 database
drwxrwxr-x  6 orahe6 dba 208 2005-10-24 01:13 client
drwxrwxr-x  6 orahe6 dba 208 2005-10-24 01:10 companion
drwxr-xr-x 10 orahe6 dba 304 2005-10-23 13:25 clusterware
drwxr-xr-x  5 orahe6 dba 152 2005-10-23 13:20 gateways
HSSAMUMS011:orahe6 62> ls -lt database
total 18
drwxr-xr-x 5 orahe6 dba  368 2008-04-29 22:52 install
drwxr-xr-x 2 orahe6 dba  384 2006-02-22 20:01 SAP
drwxr-xr-x 2 orahe6 dba  224 2005-10-23 13:19 response
-rwxr-xr-x 1 orahe6 dba 1326 2005-10-23 13:19 runInstaller
drwxrwxr-x 9 orahe6 dba 5744 2005-10-23 13:19 stage
drwxrwxr-x 9 orahe6 dba  312 2005-10-20 06:33 doc
-rw-rw-r– 1 orahe6 dba 5416 2005-10-20 01:37 welcome.html
HSSAMUMS011:orahe6 63> ls -lt database/install
total 176
-rwxr-xr-x 1 orahe6 dba   2395 2008-04-29 22:52 oraparam.ini
-rwxr-xr-x 1 orahe6 dba     28 2005-10-23 13:19 addLangs.sh
-rwxr-xr-x 1 orahe6 dba     76 2005-10-23 13:19 addNode.sh
drwxr-xr-x 2 orahe6 dba    304 2005-10-23 13:19 images
-rwxr-xr-x 1 orahe6 dba  46448 2005-10-23 13:19 lsnodes
-rwxr-xr-x 1 orahe6 dba   2268 2005-10-23 13:19 oneclick.properties
-rwxr-xr-x 1 orahe6 dba   6428 2005-10-23 13:19 oraparamsilent.ini
drwxr-xr-x 2 orahe6 dba    360 2005-10-23 13:19 resource
drwxr-xr-x 2 orahe6 dba    120 2005-10-23 13:19 response
-rwxr-xr-x 1 orahe6 dba 102612 2005-10-23 13:19 unzip
<End>

Here we do need to modify the oraparam.ini file, this is the first step other wise installtion will not start, saying that your OS (SLES 10 SP1) is not supported. Open oraparam.ini file in VI and search for the section and lines as below

[Certified Versions]
Linux=redhat-3,SuSE-9,redhat-4,UnitedLinux-1.0,asianux-1,asianux-2

See here you will not find any reference for your version of OS. This where you need to play a bit. Just add the entry SuSE10 in this line and save. This particular line then should look like below and you passed the exam.

[Certified Versions]
Linux=redhat-3,SuSE-9,SuSE-10,redhat-4,UnitedLinux-1.0,asianux-1,asianux-2

Now you need to change your directory to

 listing for path /oracle/stage/102_64/database
total 18
-rw-rw-r– 1 orahe6 dba 5416 2005-10-20 01:37 welcome.html
drwxrwxr-x 9 orahe6 dba  312 2005-10-20 06:33 doc
drwxrwxr-x 9 orahe6 dba 5744 2005-10-23 13:19 stage
-rwxr-xr-x 1 orahe6 dba 1326 2005-10-23 13:19 runInstaller
drwxr-xr-x 2 orahe6 dba  224 2005-10-23 13:19 response
drwxr-xr-x 2 orahe6 dba  384 2006-02-22 20:01 SAP
drwxr-xr-x 5 orahe6 dba  368 2008-04-29 22:52 install

-rwxr-xr-x 1 orahe6 dba  12943 2005-11-03 16:14 RUNINSTALLER
-rwxr-xr-x 1 orahe6 dba   2454 2006-02-22 19:59 SAP.SQL
-rwxr-xr-x 1 orahe6 dba   2448 2006-02-22 19:59 SAPI.SQL
-rwxr-xr-x 1 orahe6 dba    233 2006-02-22 19:59 PREMIG.SQL
-rwxr-xr-x 1 orahe6 dba   2735 2006-02-22 19:59 POST_UPGRADE.SQL
-rwxr-xr-x 1 orahe6 dba    226 2006-02-22 19:59 POSTMIG.SQL
-rwxr-xr-x 1 orahe6 dba    227 2006-02-22 19:59 MIG3264.SQL
-rwxr-xr-x 1 orahe6 dba   2507 2006-02-22 19:59 CHECKS.SQL
-rwxr-xr-x 1 orahe6 dba 123806 2006-02-22 19:59 utlu102i.sql
-rwxr-xr-x 1 orahe6 dba   1634 2006-02-22 19:59 sapconn_role.sql
-rwxr-xr-x 1 orahe6 dba  38114 2006-02-22 20:00 SVRCUSTOM.RSP
<>

and then execute the program RUNINSTALLER.
As you see there is a runInstaller also available in the /oracle/stage/102_64/database directory, but you should not run this. you have to goto /oracle/stage/102_64/database/SAP directory and run RUNINSTALLER instead, which created by SAP for the specific database. Ultimately Oracle universal installer starts and you only need to do Next button and at the end you need to run root.sh in the prescribed directory as a root. Executing the root.sh script copies some files to a location outside $ORACLE_HOME and sets the permissions on several files inside and outside $ORACLE_HOME. Once the root.sh script executes successfully, click OK to continue the installation. Finally you will see that “End of Installation page”  – you are done. Press exit to come out of this OUI.

And hence the installation is finished, and you need to say continue on the SAP installtion screen to finish creation of database, schema and import the SAP exports.

***************** Index of Pages on the topic…. ****************************
1. preparing os and system for SAP installation
2. installation of sap central instance.
3. installation of database
4. post-installation tasks
******************************************************************************
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s