Adding the Oracle Database Plug-In to N1 Grid SPS

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