test

Sun N1 Service Provisioning System User's Guide for Oracle Database Plug-In 3.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

Acquiring the Oracle Database plug-in is a two-step process. First, you must add the package file that contains the Oracle Database plug-in JAR file to your system. Then you must import the Oracle Database plug-in JAR file.

The Oracle Database plug-in is packaged as a plug-in to the Sun N1 Service Provisioning System software. The plug-in files for the Oracle Database plug-in are available from the Sun N1 Service Provisioning System 5.2 DVD or from the Sun Download Center.

Once the package file is added to your system, the Oracle Database Plug-In is available for import from two different JAR files. Choose the correct file depending on your situation.

  1. Add the file containing the JAR file:

  2. Import the JAR file - Adding the Oracle Database Plug-In to N1 SPS.

Adding the Oracle Database Plug-In for Solaris

The Oracle Database plug-in is contained in two different packages.

Select the package for the version of the Oracle database that you want to provision.

ProcedureTo Add the Oracle Database Plug-In Package for Solaris

Steps

  1. In a terminal window, become superuser.

  2. Move to the directory containing the plug-in package.

  3. Type the following command and press Return.

    # pkgadd -d package_directory package_name

    The standalone JAR file is in either the /opt/SUNWn1sps/plugins/com.sun.oracle9i_DB or the /opt/SUNWn1sps/plugins/com.sun.oracle10g_DB directory. The upgrade JAR file is in either the /opt/SUNWn1sps/plugins/com.sun.oracle9i_DB/Upgrade or the /opt/SUNWn1sps/plugins/com.sun.oracle10g_DB/Upgrade directory.

Adding the Oracle Database Plug-In for Linux

The Oracle Database plug-in is contained in two different packages.

Select the package for the version of the Oracle database that you want to provision.

ProcedureTo Add the Oracle Database Plug-In Package for Linux

Steps

  1. In a terminal window, become superuser.

  2. Move to the directory containing the plug-in package.

  3. Type the following command and press Return.

    # rpm -i package_directory package_name

    The standalone JAR file is in either the /opt/sun/N1_Service_Provisioning_System/plugins/com.sun.oracle9i_DB or the /opt/sun/N1_Service_Provisioning_System/plugins/com.sun.oracle10g_DB directory. The upgrade JAR file is in either the /opt/sun/N1_Service_Provisioning_System/plugins/com.sun.oracle9i_DB/Upgrade or the /opt/sun/N1_Service_Provisioning_System/plugins/com.sun.oracle10g_DB/Upgrade directory.

Adding the Oracle Database Plug-In for Windows

The Oracle Database plug-in is contained in two different Microsoft Installer (MSI) package files.

Select the package for the version of the Oracle database that you want to provision.

ProcedureTo Add the Oracle Database Plug-In MSI File for Windows

Steps

  1. Move to the directory containing the plug-in package file.

  2. Double-click the appropriate msi file.

    • To install the Oracle 9i database plug-in, double-click the sun-spsond-3.0.msi file.

    • To install the Oracle 10g database plug-in, double-click the sun-spsotd-3.0.msi file.

    The Installer GUI starts. The standalone JAR file is in either the C:\Program Files\N1 Service Provisioning System\plugins\com.sun.oracle9i_DB or the C:\Program Files\N1 Service Provisioning System\plugins\plugins\com.sun.oracle10g_DB directory. The upgrade JAR file is in either the C:\Program Files\N1 Service Provisioning System\plugins\com.sun.oracle9i_DB\Upgrade or the C:\Program Files\N1 Service Provisioning System\plugins\com.sun.oracle10g_DB\Upgrade directory.

Adding the Oracle Database Plug-In to N1 SPS

To make a given plug-in known to the 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.2 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_3.0.jar file.

      • If you have already imported a previous version of the Oracle 9i Database Plug-In, select the com.sun.oracle9i_DB_2.0_3.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_3.0.jar file.

      • If you have already imported a previous version of the Oracle 10g Database Plug-In, select the com.sun.oracle10g_DB_2.0_3.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_3.0.jar.

      • If you have already imported a previous version of the Oracle 9i Database Plug-In, plugin-filename is com.sun.oracle9i_DB_2.0_3.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_3.0.jar.

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

Enabling New Oracle Database Plug-In Features After Upgrading

If you upgrade to Oracle Database Plug-In version 3.0, you need to perform additional steps in order to enable new plug-in features. Performing these additional steps allows you to perform the following tasks on your existing Oracle database instances.

ProcedureHow to Enable New Oracle Database Plug-In Features After Upgrading

Steps

  1. In the Common Tasks section of the N1 SPS browser interface, select the appropriate Oracle database entry.

  2. On the Oracle Database Common Tasks page, click Install.

  3. On the Plans Details page, click Run.

  4. Choose variables to use for the Oracle support scripts.

    For more information about how to set these variables, see Oracle Single-Instance Software.

  5. Choose variables to use for the single-instance software.

    For more information about how to set these variables, see Oracle Single-Instance Software.

  6. To select the target host, click Select from List next to the Target Host field on the Plans Details Run page.

  7. In the Plan Variables section, select the check box next to markOnly installation on the Plan Details Run page.

  8. To fully upgrade the plug-in functionality on the target host, click Run Plan (includes preflight).

Customizing the Solution for Your Environment

Remote Agent Requirements

Before you provision the Oracle database software, you must perform the following additional tasks on the remote agents.

Setting the User Role on Remote Agents

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.

Preparing Solaris Remote Agents to Run the Oracle Database Software

If you want to run the Oracle database software on a RA that is running the Solaris 8 OS, you must ensure that the system has the Xvfb virtual frame buffer installed. In the Solaris 9 and Solaris 10 OS, the Xvfb frame buffer is included in the SUNWxwsrv package. To check that the Xvfb frame buffer is installed on your Solaris 9 or Solaris 10 system, verify that the SUNWxwsrv package is installed on your system by typing the following command.


# pkginfo -l SUNWxwsrv
   PKGINST:  SUNWxwsrv
      NAME:  X Window System Virtual Servers
  CATEGORY:  system
      ARCH:  sparc
   VERSION:  6.6.2.7400,REV=0.2004.12.15
   BASEDIR:  /usr
    VENDOR:  Sun Microsystems, Inc.
      DESC:  X Window System Xvfb & Xnest Virtual Display Servers
    PSTAMP:  x10s20041215212124
  INSTDATE:  Nov 18 2005 17:24
   HOTLINE:  Please contact your local service provider
    STATUS:  completely installed
     FILES:        4 installed pathnames
                   2 shared pathnames
                   2 directories
                   2 executables
                3259 blocks used (approx)

The Xvfb frame buffer is not included in the Solaris 8 operating environment. To enable a Solaris 8 remote agent to run the Oracle database software, you must acquire a third-party Xvfb binary and install it on your system. The following procedure describes how to configure the Xvfb binary on your Solaris 8 remote agent.

ProcedureHow to Configure the Xvfb Binary on a Solaris 8 Remote Agent

Steps

  1. Acquire an Xvfb binary from a third party.

    You can download Xvfb binaries from several different online third parties. These binaries are not provided, tested, or supported by Sun Microsystems, Inc. All usage of Xvfb binaries is subject to the license terms and support agreements of the binary provider.

  2. Install the Xvfb binary on your Solaris 8 remote agent.

    Follow the procedures that are provided by the provider to install the Xvfb binary.

  3. Go to the /usr/X11R6/bin directory on the remote agent.


    # cd /usr/X11R6/bin

  4. Create a symbolic link to the Xvfb binary in the /usr/openwin/bin directory.


    # ln -s Xvfb /usr/openwin/bin

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 as specified in the Oracle database documentation. You should set these values, then reboot the system, before you install the Oracle database software. For more information ,see the Oracle installation documentation at http://www.oracle.com for recommended system tuning parameters .

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 and patch revision levels 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.

Patching the Oracle Database Plug-In

Check the SunSolve site for available patches for the Oracle Database Plug-In. To apply the patch, follow the instructions in the patch README file.