3 Installing the Oracle Database Companion CD Software

This chapter covers the following topics:

General Steps for Installing Companion CD Products
Accessing the Installation Software
Installing Oracle Database 10g Products
Installing the Latest Patch Set Release
Removing the Oracle Database Companion CD Software

3.1 General Steps for Installing Companion CD Products

After completing the tasks in Chapter 1 and Chapter 2, you will follow these general steps to install the Companion CD products:

Consider the following issues:
- Installing in interactive mode or in silent or noninteractive mode: The instructions in this chapter are written for interactive installations. If you prefer to perform the installation in silent mode noninteractive mode using response files—for example, if your site requires multiple installations—read Appendix A, "Installing Oracle Database Companion CD Using Response Files" for more information.
- Installing in a Different Language: See "Installing and Using Oracle Components in Different Languages" for language considerations.
Use the procedures under "Accessing the Installation Software" if you need to install the software from a hard drive or install remotely.
Follow the instructions under "Installing Oracle Database 10g Products" to install the Oracle Database 10g Products. If you have already installed these products, follow the instructions under "Installing the Latest Patch Set Release" for the latest patch set updates.

3.2 Accessing the Installation Software

The Oracle Database software is available on DVD. Do not use Oracle Universal Installer from an earlier release to install components from this release.

If you need to install the Oracle Database Companion CD products using any of the following scenarios, follow the procedures in this section before continuing to the installation instructions.

Copying Oracle Database Software to Hard Disk
Installing from a Remote DVD Drive
Installing on Remote Computers Through Remote Access Software

3.2.1 Copying Oracle Database Software to Hard Disk

Instead of installing from the Oracle Database Companion CD products DVD, you can copy the contents of the DVD to a hard drive and install from there. This might be easier if you plan to install many instances of the Oracle Database Companion CD products on your network, or if the computers where you want to install the products do not have DVD drives.

To copy the contents of the installation media to a hard disk:

Create a directory on your hard drive. For example:
```
c:\install\companion
```
Copy the contents of the installation media to the directory that you just created.
After you have copied all of the required installation files, you can install the Oracle Database Companion CD products.

3.2.2 Installing from a Remote DVD Drive

If the computer where you want to install the Oracle Database Companion CD products does not have a DVD drive, you can perform the installation from a remote DVD drive. Check the following points:

On the Remote Computer, Share the DVD Drive
On the Local Computer, Map the DVD Drive

3.2.2.1 On the Remote Computer, Share the DVD Drive

The remote DVD drive that you want to use must allow shared access. To set this up, perform these steps on the remote computer that has the DVD drive:

Log in to the remote computer as an Administrator user.
Start Windows Explorer.
Right-click the DVD drive letter and choose Sharing (or Sharing and Security).
Click the Sharing tab and do the following:
1. Select Share this folder.
2. In Share name, give it a share name such as dvd. You will use this name when you map the DVD drive on the local computer. Under "On the Local Computer, Map the DVD Drive" see Step d under Step 1.
3. Click Permissions. You need at least "read" permission for the user who will be accessing it to install Oracle Database.
4. Click OK when you are finished.
Insert the Oracle Database installation media into the DVD drive.

3.2.2.2 On the Local Computer, Map the DVD Drive

Perform these steps on the local computer to map a remote DVD drive and to run Oracle Universal Installer from the mapped drive:

Map the remote DVD drive.
1. Start Windows Explorer on the local computer.
2. From the Tools menu, select Map Network Drive to display the Map Network Drive dialog.
3. Select a drive letter to use for the remote DVD drive.
4. In Folder, enter the location of the remote DVD drive using the following format:
```
\\remote_hostname\share_name
```
  where:
  - remote_hostname is the name of the remote computer with the DVD drive.
  - share_name is the share name that you entered in Step 4 of the previous procedure. For example
```
\\computer2\dvd
```
5. If you need to connect to the remote computer as a different user, Click different user name, and enter the username.
6. Click Finish.
Run Oracle Universal Installer from the mapped DVD drive.

3.2.3 Installing on Remote Computers Through Remote Access Software

If you want to install and run the Oracle Database Companion CD products on a remote computer (that is, the remote computer has the hard drive and will run these components), but you do not have physical access to the computer, you still can perform the installation on the remote computer if it is running remote access software such as VNC or Symantec pcAnywhere. You also need the remote access software running on your local computer.

You can install the Oracle Database Companion CD products on the remote computer in one of two ways:

If you have copied the contents of the Oracle Database Companion CD products DVD to a hard drive, you can install from the hard drive.
You can insert the DVD into a drive on your local computer, and install from the DVD.

3.2.3.1 Installing on Remote Computers from a Hard Drive

If you have copied the contents of the Oracle Database Companion CD products DVD to a hard drive, you can install from the hard drive.

The steps that you have to complete are:

Make sure that the remote access software is installed and running on the remote and local computers.
Share the hard drive that contains the Oracle Database Companion CD products DVD.
On the remote computer, map a drive letter to the shared hard drive. You would use the remote access software to do this on the remote computer.
Through the remote access software, run Oracle Universal Installer on the remote computer. You access Oracle Universal Installer from the shared hard drive.

3.2.3.2 Installing on Remote Computers from a Remote DVD Drive

You can insert the DVD into a drive on your local computer, and install from the DVD. This is similar to the scenario described in "Installing from a Remote DVD Drive".

The steps that you need to complete are:

Make sure that the remote access software is installed and running on the remote and local computers.
On the local computer, share the DVD drive.

On the remote computer, map a drive letter to the shared DVD drive. You would use the remote access software to do this on the remote computer.

These steps are described in "Installing on Remote Computers from a Remote DVD Drive".
Through the remote access software, run Oracle Universal Installer on the remote computer. You access Oracle Universal Installer from the shared DVD drive.

3.3 Installing Oracle Database 10g Prod ucts

This section covers the following topics:

Oracle Home Location for the Oracle Database 10g Products
Procedure for Installing Oracle Database 10g Products

3.3.1 Oracle Home Location for the Oracle Database 10g Products

You need to install Oracle Database 10g Products in an existing Oracle Database 10g release 2 (10.2) Oracle home. These products are:

Oracle JDBC Development Drivers
Oracle SQLJ
Database Examples
Oracle Text Knowledge Base
JAccelerator (NCOMP)
Intermedia Image Accelerator

3.3.1.1 Identifying the Oracle Home Directory Location

Before you install Oracle Database 10g Products into an existing Oracle home, you need to identify the location of this Oracle home. If you do not know the path of the Oracle home directory, you can check it using Oracle Universal Installer.

To check the path of the Oracle home directory:

From the Start menu, choose Programs, then Oracle - HOME_NAME, then Oracle Installation Products, then Universal Installer.
When the Welcome window appears, click Installed Products.

The Inventory window appears, listing all of the Oracle homes on the system and the products installed in each Oracle home.
In the Inventory window, expand each Oracle home and locate Oracle Database 10g 10.2.0.4.0.
Click Close and then Cancel to exit Oracle Universal Installer.
Have the Oracle home name available when you begin installing Oracle Database 10g Products, described next.

3.3.2 Procedure for Installing Oracle Database 10g Products

To install Oracle Database 10g Products:

Log on as a member of the Administrators group to the computer on which to install Oracle components.

If you are installing on a Primary Domain Controller (PDC) or a Backup Domain Controller (BDC), log on as a member of the Domain Administrators group.
Make sure that the Oracle database that you plan to use for Oracle SQLJ, for example, is accessible and running.

You can use the Windows Services utility, located either in the Windows Control Panel or from the Administrative Tools menu (under Start and then Programs), to check that Oracle Database is running. Names of Oracle databases are preceded with OracleService. Right-click the name of the service and from the menu, choose Start.
Delete the ORACLE_HOME environment variable (from the System Control Panel) if it exists.

Refer to your Microsoft online help for more information about deleting environment variables.

Note:
The ORACLE_HOME environment variable is automatically set in the registry. Manually setting this variable prevents installation.
Insert the Oracle Database installation media and navigate to the companion directory. Alternatively, navigate to the directory where you downloaded or copied the installation files.

Use the same installation media to install Oracle Database on all supported Windows platforms.
Double-click setup.exe to start Oracle Universal Installer.
In the Welcome window click Next.
In the Specify Home Details window, do the following:
1. Name: Verify that the Oracle home specified is the Oracle Database Oracle home. (The default Oracle home is offered.)
2. Path: Enter the directory location of the Oracle Database Oracle home where you want to install the Oracle home files. (The directory of the default Oracle home is offered.) Do not enter a directory path that has spaces. After you enter a correct directory path, Oracle Universal Installer creates a new directory for you.
  
  See also:
  "Identifying the Oracle Home Directory Location" for information on finding the correct Oracle home
Click Next.
In the Product-specific Prerequisite Checks window, check for and correct any errors that may have occurred when Oracle Universal Installer checked your system.
Click Next.
In the Summary window, check the list of products that will be installed, and click Install.
When the installation completes, click Exit and then click Yes to exit from Oracle Universal Installer.
Optionally, delete the OraInstalldate_time directory if you want to remove the temporary files that were created during the installation process. The OraInstalldate_time directory holds about 45 MB of files. This directory is created in the location set by the TEMP environment variable setting.

Restarting your computer also removes the OraInstalldate_time directory.

To prepare Oracle Workflow server for the Oracle Workflow middle tier components:

Make sure that the Oracle database that you plan to use for Oracle Workflow is accessible and running.

You can use the Windows Services utility, located either in the Windows Control Panel or from the Administrative Tools menu (under Start and then Programs), to check that Oracle Database is running. Names of Oracle databases are preceded with OracleService. Right-click the name of the service and from the menu, choose Start.
From the Start menu, choose Programs, then Oracle - HOME_NAME, then Configuration and Migration Tools, then Workflow Configuration Assistant.
In the Welcome to Oracle Workflow Configuration Assistant window, enter the following information:
- Install Option - Select either Server Only or Add Language.
  
  If you choose the Server Only option, Workflow Configuration Assistant installs Oracle Workflow into the Oracle database.
  
  Note:
  To upgrade to Oracle Workflow release 2.6.4, make sure that the existing Oracle Workflow server is release 2.6.2 or higher.
  
  If you chose the Add Language installation option, select the language abbreviation for the language that you want to add. You must install Oracle Workflow before you can add a language.
  
  See Also:
  Oracle Database Globalization Support Guide for a list of language abbreviations used by Oracle database
- Workflow Account - Enter the name that you want to use for the Oracle Workflow database account or accept the default name, typically owf_mgr.
  
  The default tablespace for this account is USERS and the temporary tablespace is TEMP. You can change the tablespace if necessary.
  
  Note:
  If you are upgrading an existing installation of Oracle Workflow, enter the name and password for the existing Oracle Workflow database account.
- Workflow Password - Enter a password for the Oracle Workflow account.
- SYS Password - Enter the password for the SYS account of the Oracle Database installation on the system. The password is mandatory for Oracle Workflow Server installations but not if you are adding a language.
- TNS Connect Descriptor - The database connect string in TNS format:
```
(DESCRIPTION =(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST =
host_name)(PORT = port_number))) (CONNECT_DATA = (SERVICE_NAME =
database_service_name)))
```
  The connect string is stored in the tnsnames.ora file, which in a default installation is located in ORACLE_BASE\ORACLE_HOME\network\admin. An easy way to find the connect string in a single-line format is to run the tnsping command at a command prompt, output the results into a text file, and then copy and paste the connect string into the TNS Connect Descriptor box. For example, to get the connect string for a server named mau, you could enter:
```
c:\> tnsping mau > tns.txt
```
If you want to integrate Oracle Internet Directory as the directory repository for Oracle Workflow, select the Enter LDAP Parameters check box and then select Get LDAP Values to display the Workflow LDAP Parameters window.

3.4 Installing the Latest Patch Set Release

Oracle recommends installing the latest patch set release after you have successfully installed the Oracle Companion CD components. Doing so ensures that you have the latest update of Oracle Database Companion CD.

You must register online before using OracleMetaLink. After logging in to OracleMetaLink, select Patches from the left-hand column.

To find and download patches:

Go to the OracleMetaLink Web site
```
https://metalink.oracle.com/
```
Log in to OracleMetaLink.

Note:
If you are not an OracleMetaLink registered user, then click Register for MetaLink! and follow the registration instructions.
On the main OracleMetaLink page, click Patches & Updates.
Select Simple Search.
Specify the following information, then click Go:
- In the Search By field, choose Product or Family, then specify the Companion CD product, such as Oracle SQLJ.
- In the Release field, specify the current release number.
- In the Patch Type field, specify Patchset/Minipack
- In the Platform or Language field, select your platform.
Under Results for Platform, find the latest patch set for Oracle Database using OracleMetaLink.
From the list of available patches, click the number of the patch you want to download.
Click View Readme to review the README before proceeding with the download.

Each patch has a README file with installation requirements and instructions. Some patches install with Oracle Universal Installer; others require special procedures. Oracle recommends that you always read the README before proceeding.
Return to the Patch Set page and click Download to download and save the file on your system.
Use an unzip utility to uncompress the patch zip file.

3.5 Removing the Oracle Database Companion CD Software

The following steps describe how to use Oracle Universal Installer to remove Oracle software:

Note:

Always use Oracle Universal Installer to remove Oracle software. Do not delete any Oracle home directories without first using Oracle Universal Installer to remove the software.

From the Start menu, select Programs, then Oracle - HOME_NAME, then Oracle Installation Products, then Universal Installer.
When the Welcome window appears, click Deinstall Products.

The Inventory window appears, listing all of the Oracle homes on the system and the products installed in each Oracle home.
In the Inventory window, select the Oracle home and the Oracle products that you want to remove.
To delete specific products, select them in the tree window.
Click Remove.

A confirmation window appears asking you to confirm that you want to deinstall the products and their dependent components.
Click Yes.

A progress indicator appears as the software is removed.