test

Sun N1 Service Provisioning System User's Guide and Release Notes for the Oracle Database Plug-In 2.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 Sun N1 SPS software. Plug-ins are packaged in JavaTM Archive (JAR) files. The plug-in files for the Oracle Database solution are available from the Sun N1 Service Provisioning System Supplement CD or from the Sun Download Center.

The Oracle Database Plug-In is available for import from two different JAR files. Choose the correct file depending on your situation.

Adding the Oracle Database Plug-In to Sun N1 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 Sun N1 SPS product, you need to import the plug-in to the Master Server. If you have already imported previous versions of the Oracle Database Plug-In you need to upgrade to the new plug-ins.

ProcedureHow to Import the Oracle Database Plug-In Using the Browser Interface

To import or upgrade a plug-in, follow these steps as explained in detail in Chapter 5, Plug-In Administration, in Sun N1 Service Provisioning System 5.1 System Administration Guide

Steps

  1. In the Administrative section of the browser interface 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 JAR file.

    • Oracle 9i Database Plug-In

      • If you are importing the Oracle 9i Database Plug-In for the first time, select the com.sun.oracle9i_DB_2.0.jar file.

      • If you have already imported a previous version of the Oracle 9i Database Plug-In, select the com.sun.oracle9i_DB_1.0_2.0.jar file.

    • Oracle 10g Database Plug-In

      • If you are importing the Oracle 10g Database Plug-In for the first time, select the com.sun.oracle10g_DB_2.0.jar file.

      • If you have already imported a previous version of the Oracle 10g Database Plug-In, select the com.sun.oracle10g_DB_1.0_2.0.jar file.

  4. Click the Continue to Import button.

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

ProcedureHow to Import the Oracle Database Plug-In using the CLI

You can also import a plug-in by using the command line.

Step

    To import a plug-in file from the CLI, type:


    % cr_cli -cmd plg.p.add -path plugin-filename -u username -p password

    • Oracle 9i Database Plug-In

      • If you are importing the Oracle 9i Database Plug-In for the first time, plugin-filename is com.sun.oracle9i_DB_2.0.jar.

      • If you have already imported a previous version of the Oracle 9i Database Plug-In, plugin-filename is com.sun.oracle9i_DB_1.0_2.0.jar.

    • Oracle 10g Database Plug-In

      • If you are importing the Oracle 10g Database Plug-In for the first time, plugin-filename is com.sun.oracle10g_DB_2.0.jar.

      • If you have already imported a previous version of the Oracle 10g Database Plug-In, plugin-filename is com.sun.oracle10g_DB_1.0_2.0.jar.

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.