How to Create the Oracle Database

This task creates the Oracle database component. This does not create anything at the OS level.

This task is a markOnly task.

Steps

1. In the Common Tasks section of the N1 SPS browser interface, click SAP.

2. In the Oracle Database section of the SAP Tasks page, click Create.

3. Click Run.

4. In the Plan Parameters table, select the variable settings for the Oracle component.

   • If the variable settings have been created for this component, select the appropriate settings from the drop-down menu.

   • If the variable settings are not available from the drop-down menu:

     1. Click Select From List.

        The Select Variable Settings From List window displays.

        • To create a new variable settings set, click Create Set and type a Set Name.

          The following list provides commonly updated variables for the Oracle component. To create a value for the component variable, click the check box in the component variable's row.

          ---

          Note –

          For information about component variables ending in UserExit, see User Exits.

          ---

          groupName

          This is a required field.

          ---

          Note –

          In the Sun Cluster environment, the groupName must equal the Sun Cluster resource group name.

          ---

          groupDescription

          A description of the group.

          resourceName

          Required for the Sun Cluster environment. The resourceName must equal the Sun Cluster Oracle Server resource name for the Sun Cluster envType.

          envType

          Identifies whether this component will be deployed to a default, Sun Cluster, or SAP AC environment. Value can be : ac, sc, or default. Default value: default.

          createdBy

          Identifies the installer of the component.

          dbLhName

          Required for the default environment. Logical host name for the database.

          oracleSid

          Required for the default environment. System ID (SID) for the database.

          oracleEnvFile

          Required for the default environment. Absolute path of the Oracle environment file. For example, /oracle/SID.dbenv_host.sh.

          listenerName

          Required for the Sun Cluster environment. Oracle listener name. Default value: LISTENER.

          listenerResourceName

          The listenerResourceName must equal the Sun Cluster Oracle Listener resource name for the Sun Cluster envType

          accServiceID

          Required for the SAP AC environment. The service ID of the Oracle instance (only applicable in the SAP AC environment.)

          srmProject

          The Solaris Resource Management (SRM) project name. Default value: default.

     2. Click Save.

   • To use component variables from another component, click Import Set.

     For more information about importing variable sets, see How to Run a Plan in Sun N1 Service Provisioning System 5.2 Operation and Provisioning Guide.

5. Select a target host or target host set.

6. Click the Run Plan (Includes Preflight) button.

   The Deployment Results page is displayed. If the plan fails, error messages are displayed.