SAP Landscape Management 3.0, Enterprise Edition

Setting Up an Oracle Database on Windows

You use this procedure to install the Oracle database software on a local disk on each additional database host, and to relocate only the disk with the database files such as data, log, archive, and BR*Tools.

Prerequisites

  • The SAP Host Agent is installed on each host.

  • A sapacosprep storage library provided by an SAP technology partner is required to relocate disk drives on Windows. Check the sapacosprep partner library contacts available on SAP Developer Network.

  • You have performed a distributed SAP installation to assign each component a dedicated virtual host name.

  • You have performed an SAP domain installation for all components, to create the operating system users and groups centrally on the domain controller(s).

  • Minimum required Oracle release is 10.2

  • You have configured Windows NT native authentication as an Oracle authentication method (default).

  • Each database instance has its own dedicated Oracle home. This implies that multiple Oracle home setup is required in case you want to start multiple database instances on the same host.

    For more information, see the SAP on Oracle installation guides.

  • Each database instance is set up with a dedicated Oracle Listener from the same Oracle home as the database instance. Carefully plan the Listener Port that should be used by each Listener to avoid conflicts in case you want to start multiple database instances, and hence multiple Listeners, on the same host.

  • The Dynamic Service Configuration (DSC) feature to configure the database instance's Listener is not supported. Static Listener configuration via the listener.ora file is required.

Windows access control list (ACL) inheritance is by design based on volumes and not working across junctions. Ensure that the file permissions and ownership of your file system structure below a mount point or link junction is correctly set.

  • In the Microsoft TechNet library, see Configuring Roaming User Profiles.

Procedure

  1. Prepare and attach the movable disks that are to be used for housing the database files.

    For more information, see your storage technology partner's documentation.

    The same rules apply for the distribution of database files to disks as for a regular SAP on Oracle installation.

    For more information, see the installation guide.

    A minimal setup could look as follows:

    Database Component

    File System and Mount Point

    Notes

    Database software

    (ORACLE_HOME)

    \oracle\<DBSID><VERSION>

    Can be located on any local disk

    Database files

    \oracle\<DBSID>

    Must be located on a movable disk, and for security reasons protected by a fault tolerant RAID level

    <VERSION> denotes the first three digits of the Oracle release number without the dots. For example: 102 for a 10.2.0.2.0 release.

  2. Install the database software in the (nondefault) directory \oracle\<DBSID><VERSION> by entering the following in a command prompt:

    <RDBMS DVD>:\NT\ <platform>\database\install\oui.exe-responseFile <RDBMS DVD>:\NT\ <platform>\sap\SAPServer.rsp ORACLE_HOME_NAME= <DBSID> <VERSION>ORACLE_HOME= <drive>:\oracle\ <DBSID> <VERSION>

  3. Activate the virtual IP addresses that you want to assign to the database instance. Use the sapacosprep command line tool that comes with the SAP Host Agent. Proceed as follows:

    1. In a command prompt, change to the directory %ProgramFiles%\SAP\hostctrl\exe.

    2. Enter the following:

      sapacosprep -a ifup -i <network interface name>-h <virtual hostname>[-n <network mask>] [-b <broadcast addresse>]

  4. Perform the general preparation tasks for a database installation of a distributed system described in the SAP installation guide.
  5. Install the database software and patches. For more information, see Setting Up Multiple Oracle Homes in the installation guide.
  6. Use the software provisioning manager to install the database instance. Do not start the software provisioning manager by double-clicking on the executable in the Windows Explorer, but proceed as follows:

    1. In a command prompt, change to the directory <Installation Master DVD>:\IM_WINDOWS_ <platform>.

    2. Enter sapinst.exe SAPINST_USE_HOSTNAME= <virtual hostname of the database instance>.

  7. After you have finished the installation, change the startup type of the Oracle instance service (OracleService <DBSID>) and the Oracle Listener (Oracle<Oracle home name>TNSListener) from Automatic to Manual.
  8. Put the database under the control of SAP Landscape Management.
  9. Follow the description provided by your storage technology partner for configuring the database's storage data in SAP Landscape Management.

Results

Now you can monitor, stop, unprepare, prepare, and start the database instance with SAP Landscape Management on this installation host.

Next Steps

For more information about downloading the Microsoft Windows 2003 Server Resource Kit, see https://www.sdn.sap.com/irj/sdn/adaptiveInformation published on SAP site.

Related Information