N1 Grid Service Provisioning System User's Guide and Release Notes for the Oracle Database Plug-In 1.0

Chapter 3 Installing and Configuring the Oracle Database Plug-In

This chapter explains how to install and configure the Oracle Database plug-in.

The chapter contains the following information:

Acquiring the Oracle Database Plug-In

The Oracle Database solution is packaged as a plug-in to the N1 Grid SPS software. Plug-ins are packaged in JavaTM Archive (JAR) files. The plug-in files for the Oracle Database solution are available from the N1 Grid Service Provisioning System Supplement CD or from the Sun Download Center.

Adding the Oracle Database Plug-In to N1 Grid SPS


Note –

Two separate JAR files support the Oracle 9i and 10g databases. However, several common components are packaged in the Oracle 10g plug-in. As a result, you must install the Oracle 9i and the Oracle 10g plug-ins to support Oracle 9i. To support Oracle 10g, you have to install only the Oracle 10g plug-in JAR file.


To make a given plug-in known to the N1 Grid SPS product, you need to import the plug-in. To import the Oracle plug-in files, follow these steps as explained in detail in Chapter 5, Plug-In Administration, in N1 Grid Service Provisioning System 5.0 System Administration Guide.

  1. In the Administrative section of the main window, click Plug-ins.

  2. In the Action column of the Plug-ins page, click Import.

  3. Browse to the location where you downloaded the com.sun.oracle10g_DB_1.0.jar file.

  4. Click the Continue to Import button.

    When the import completes successfully, a plug-in details page appears that shows you the objects that the plug-in provides.

  5. In the Action column of the Plug-ins page, click Import.

  6. Browse to the location where you downloaded the com.sun.oracle9i_DB_1.0.jar file.

  7. Click the Continue to Import button.

    When the import completes successfully, a plug-in details page appears that shows you the objects that the plug-in provides.

You can also import the plug-in archive files from the command line. Use the following commands:


% cr-cli -cmd plg.p.add -path com.sun.oracle10g_DB_1.0.jar -u username -p password
% cr-cli -cmd plg.p.add -path com.sun.oracle9i_DB_1.0.jar -u username -p password

Customizing the Solution for Your Environment

Remote Agent Requirements

When you install the provisioning software remote agent (RA), be sure to set the RA to run as root. Most of the Oracle installation runs as user oracle; however, some scripts that are generated during the installation process need to run as root.

Shared Memory and Semaphore Settings for Linux Systems

For Linux systems, the following semaphore and shared memory settings apply:


kernel.shmmax = 1073741824
kernel.shmall = 536870912
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 32768 65000

Note –

These values are set during installation. You do not have to set them.

The actual value for kernel.shmmax differs, depending on the amount of memory in the target host. This value adjusts itself dynamically when the OraSpt plan runs.


Shared Memory and Semaphore Settings for Solaris Systems

For Solaris systems, you need to create semaphore and shared memory settings similar to those mentioned above for Linux systems. You should set these values before you install the Oracle database software. See the Oracle documentation for details.

Solaris Patches for Oracle 9i on SPARC Systems

To run Oracle 9i on Solaris SPARC systems, download three Solaris patches from the SunSolve web site and install them on your system:


Note –

The patch list might have changed since the release of this document. Check the Oracle web site and SunSolve for the latest patches that apply to Oracle on Solaris systems.