Skip Headers
Agile Product Lifecycle Management Database Install Guide
Release 9.3.3
E39281-02
  Go To Table Of Contents
Contents

Previous
Previous
 
Next
Next
 

3 Installing Oracle Database Server

Before you install the Agile database, you must install the Oracle Database Server. You can download the Oracle Database Server Installer for major releases from Oracle Software Delivery Cloud (http://edelivery.oracle.com), and for a Patchset/Minipack, you can download from Oracle Support (https://support.oracle.com). Download instructions for each Oracle version/operating system are provided on the download page.


Note:

After you install Oracle Database Server, you must install the Example products into your ORACLE_HOME, available at the download location. In an Oracle RAC environment, these products should be installed on all nodes. These products include some files required to create the Agile schema successfully.

For detailed instructions on how to install a particular Oracle Database Server version, refer to the appropriate Installation Guides listed in the Oracle Documentation (http://www.oracle.com/technetwork/documentation/index.html) web page.


Note:

Make sure you select the database binaries that are compatible with the hardware you are using.

3.1 Related Documentation

Before you begin, it is important to be familiar with all the information about installing the Oracle database on different operating systems, and with the Optimal Flexible Architecture (OFA) reference material for administrators. You can review the information pertaining to your Oracle database server version at Oracle Documentation (http://www.oracle.com/technetwork/documentation/index.html).

Agile has made every attempt to be OFA-compliant. Any deviations from OFA guidelines are noted.

3.2 Before Installing Oracle Database Server on Windows

Before installing Oracle, you must:

  • Verify that Windows has been configured correctly.

  • Check to see that the Microsoft NTFS file system is used instead of FAT or FAT32, and convert the file system if necessary. See "Checking the Windows File System" for directions.

  • Determine the name of the Windows computer where Oracle is to be installed.


Note:

It is recommended that the computer on which you are installing the Oracle database have at least two physical drives or two partitions. This enables you to place the operating system on the C drive and use the D drive for Oracle components. The examples in this chapter use a C and D drive.

  • Be sure that you have Administrator privileges within Windows on the computers where you are installing Oracle and Agile PLM.

  • Disable disk compression, if you are using it.

  • Disable virus protection, if you are using it. Components used in the installer can be falsely identified as being infected and lock up the installation. You can turn the virus protection on after the installation is complete.

The following sections provide more information about these procedures.

3.2.1 Network Check

Before proceeding, it is important to confirm two settings to prevent difficulties from occurring.

3.2.2 Confirming Computer Name and Host Name

The computer where Oracle is installed must use the same value as both its computer name and its DNS host name. You can use the following procedures to identify the current values.

To determine the computer name for Windows:

  1. Right-click the My Computer icon on the desktop, and choose Properties in the shortcut menu.

  2. In the System Properties dialog box, click the Computer Name tab.

  3. Note the name listed in the Full Computer Name field.


    Note:

    Windows uses the same name for the computer name and DNS host name.

3.2.3 Confirming the Server Date

It is important to adjust the date and time of the computer. The date and time need to be correct when you work with your production data.

To confirm the date and time, click the Date/Time icon in the Windows Control Panel. Be sure to verify the Time Zone setting, too.


Caution:

If you change the date or time after Agile PLM has been installed and started, you need to stop and restart the server immediately after the change.

3.2.4 Checking the Windows File System

Agile recommends that servers use NTFS (NT File System) rather than FAT or FAT32 (File Allocation Table), as NTFS is more robust.

To determine the file system type:

  1. Check the file system used on the computer. Choose Start > Administrative Tools > Computer Management. Under Computer Management in the left pane, expand Storage and select Disk Management.

    The Disk Administration window opens.

    There must be at least two partitions or hard drives. If your computer uses NTFS, proceed with the Oracle installation. If your computer uses a FAT or FAT32 file system, Agile recommends converting it to NTFS before proceeding.


    Important:

    Converting the file system deletes all current files on the drive. Backup all necessary files before converting the file system to NTFS.

  2. Right-click the drive you want to reformat and choose Format in the shortcut menu.

  3. In the File System field, change the file system type to NTFS.

  4. Click Start.

    The process takes several minutes. On completion, restart the system. You can proceed with the Oracle installation.

3.2.5 For Servers Configured with DHCP

If your server is configured with DHCP (Dynamic Host Configuration Protocol), there is a known issue with the Oracle Database Server installation. The installation fails and a warning message displays.

There are two possible solutions:

  • Copy the Oracle Database Server installation software to your local disk and perform an off-network installation.

  • Install the Microsoft Loopback adapter on the DHCP server, then add one entry to the hosts file.

To install the Microsoft Loopback adapter:

  1. Click Start > Control Panel > Add Hardware.

    The Add Hardware wizard appears.

  2. Click Next.

  3. Choose Install the hardware that I manually select from a list (Advanced), and then click Next.

  4. In the Common Hardware Types list, select Network adapters, then click Next.

  5. In the Manufacturers list, select Microsoft.

  6. In the Network Adapter list, select Microsoft Loopback Adapter, and then click Next.

  7. Click Next to install the adapter.

  8. Click Finish.

To configure the hosts file:

  1. Open the hosts file, located at C:\Windows\System32\drivers\etc.

  2. Add the following entry to the hosts file: 10.10.10.10 <host name>.<domain host name>

    For example, if the full system name of your database server is db1.agile.agilesoft.com, the entry in the hosts file would be:

    10.10.10.10 db1.agile.agilesoft.com db1

  3. Save the file.

To configure the loopback IP address on the network:

  1. On the database server, right-click the My Network Places icon.

  2. Choose Properties to display the Network and Dial-up Connections window.

  3. Locate a connection with the device name of Microsoft Loopback Adapter. This connection is usually Local Area Connection 2.

  4. Right-click this connection icon.

  5. Choose Properties to display the Local Area Connection 2 Properties dialog box.

  6. On the General tab, select Internet Protocol (TCP/IP), then click Properties to display the Internet Protocol (TCP/IP) properties dialog box.

  7. On the General tab, choose Use the following IP Address.

  8. Enter the following values:

    IP address: 10.10.10.10

    Subnet mask: 255.255.255.0

  9. Click OK.

  10. Click Close.

On completion, restart the system. You can proceed with the Oracle installation.