Sun N1 Service Provisioning System User's Guide for SAP Plug-In 1.0

Creating and Managing Oracle Databases

The Tasks page of the SAP plug-in enables you to create and manage Oracle databases.

This section describes the following tasks:

How to Create the Oracle Database

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

Note –

This task is a markOnly task.

Steps

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

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

Click Run.

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.

Select a target host or target host set.

Click the Run Plan (Includes Preflight) button.

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

How to Delete the Oracle Database

This task deletes the Oracle database component. This does not delete anything at the OS level.

Note –

This task is a markOnly task.

Steps

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

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

Click Run.

Select a target host or target host set.

Provide the plan variable.

Install path of the Oracle component

This is a required field. If you do not know the install path, return to the SAP Tasks page and click the View All link.

Click the Run Plan (Includes Preflight) button.

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

How to Start the Oracle Database

Prior to starting the Oracle database, the plug-in does not check any dependencies. After the startup, the plug-in verifies that the main processes are running. The main processes for the Oracle database are:

At least one oracleSID process
ora_pmon_SID process

Steps

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

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

Click Run.

Select a target host or target host set.

Provide the plan variables.

Install path of the Oracle component to start

This is a required field. If you do not know the install path, return to the SAP Tasks page and click the View All link.

Force start the Oracle database

This option is required when the target host does not meet the SAPS requirement to start the SAP instance. See the SAP installation guide for minimum requirements for starting the SAP instance.

Note –
This option is only applicable in the SAP AC environment.

Click the Run Plan (Includes Preflight) button.

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

How to Stop the Oracle Database

If the SAP Oracle component is offline, the plan will successfully complete without any further action. If the SAP Oracle component is not offline, the plan stops the SAP component. If a normal stop fails and you have selected the Force Stop option, the plan will perform a hard stop by killing the main process. The plan then verifies that the SAP Oracle component is offline. If it is, the plan successfully completes. If the SAP component is not offline, the plan fails. The processes used to determine the status are:

At least one oracleSID process
ora_pmon_SID process

Steps

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

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

Click Run.

Select a target host or target host set.

Provide the plan variables.

Install path of the Oracle component to stop

This is a required field. If you do not know the install path, return to the SAP Tasks page and click the View All link.

Shutdown mode

Some valid shutdown modes are: normal, immediate, and abort. Default value: immediate.

Click the Run Plan (Includes Preflight) button.

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

How to View All Oracle Databases

Steps

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

In the Oracle Database section of the SAP Tasks page, click View All.

The Hosts Where Installed table is displayed.

How to Check the Online Status of an Oracle Database

If the main processes are present on the system, the resource is considered online. If any of the main processes are not present on the system, the plug-in identifies the resource as offline.

The main processes are:

At least one oracleSID process
ora_pmon_SID process

This task checks the online status of Oracle databases.

Steps

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

In the Oracle Database section of the SAP Tasks page, click Online Status.

Click Run.

Select a target host or target host set.

Provide the plan variable.

Install path of the Oracle component

This is a required field. If you do not know the install path, return to the SAP Tasks page and click the View All link.

Click the Run Plan (Includes Preflight) button.

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

How to Check the Offline Status of an Oracle Database

If the main processes are present on the system, the resource is considered online. If any of the main processes are not present on the system, the plug-in identifies the resource as offline.

The main processes are:

At least one oracleSID process
ora_pmon_SID process

This task checks the offline status of Oracle databases.

Steps

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

In the Oracle Database section of the SAP Tasks page, click Offline Status.

Click Run.

Select a target host or target host set.

Provide the plan variable.

Install path of the Oracle component

This is a required field. If you do not know the install path, return to the SAP Tasks page and click the View All link.

Click the Run Plan (Includes Preflight) button.

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