Go to primary content
Agile Product Lifecycle Management Database Installation and Management Guide
Release 9.3.6
E71162-01
  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 at: http://edelivery.oracle.com, and for a Patchset/Minipack, from Oracle Support at: https://support.oracle.com. Download instructions for each Oracle version/operating system are provided in 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 are installed on all nodes. These products include some files that required to successfully create the Agile schema.

For detailed instructions on installing a specific version of the Oracle Database Server, refer to the applicable version of the Installation Guide in Oracle Documentation at: http://www.oracle.com/technetwork/documentation/index.htm.


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 at: http://www.oracle.com/technetwork/documentation/index.html.

Agile has made every effort 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 is 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 you plan to install Oracle.


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 Checking Network Settings

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

3.2.1.1 Confirming the Computer Name and the 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 verify the computer name for Windows environments:

  1. On the Desktop, right-click the My Computer icon and choose Properties in the shortcut menu.

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

  3. Check the name in the Full Computer Name field.


    Note:

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

3.2.2 Confirming the Server Date

It is important to adjust the server's date and time fields. The date and time must 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 as well.


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.3 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 type of the file system:

  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 that you want to reformat and select 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.4 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 and 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 is:

    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 device name Microsoft Loopback Adapter. This connection is usually the 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.