2 Oracle Database Companion CD Requirements

2.1.1.1 Requirements Overview

Table 2-1 summarizes the requirements for each Oracle HTML DB installation option. For details on each requirement, refer to the remaining topics in this section.

2.1.1.2 Disk Space Requirements

The following disk space sizes apply to Oracle HTML DB and Oracle HTTP Server only. They do not include the sizes in an existing Oracle Database installation.

Disk space requirements for Oracle HTML DB only:

• TEMP space: 110 MB

• SYSTEM_DRIVE:\Program Files\Oracle directory: 0.13 MB

• SYSTEM_DRIVE:\ORACLE_BASE\ORACLE_HOME directory: 342 MB

• SYSTEM_DRIVE:\ORACLE_BASE\oradata directory: 230 MB (datafiles)

• Total: 682.13 MB

Disk space requirements for Oracle HTML DB and Oracle HTTP Server together:

• TEMP space: 110 MB

• SYSTEM_DRIVE:\Program Files\Oracle directory: 1.12 MB

• SYSTEM_DRIVE:\ORACLE_BASE\ORACLE_HOME directory: 715 MB

• SYSTEM_DRIVE:\ORACLE_BASE\oradata directory: 230 MB (datafiles)

• Total: 1.03 GB

2.1.1.3 Browser Requirements

To view or develop Oracle HTML DB applications, Web browsers must support JavaScript and the HTML 4.0 and CSS 1.0 standards. The following browsers meet this requirement:

• Netscape Communicator 7.0 or higher

• Microsoft Internet Explorer 6.0 or higher (Windows only)

• Mozilla 1.2 or higher

• Firefox 1.0.4

2.1.1.4 Oracle Database Requirement

Oracle HTML DB requires an Oracle database that is release 9.2.0.3 or higher. You need to install Oracle HTML DB into an Oracle home that contains Oracle HTTP Server. This Oracle home can be on a different physical server from the Oracle Database home, as long as Oracle HTML DB can access this database with Oracle*Net.

For example, if Oracle Database has been installed in OraDB10g_home1, when you run Oracle Universal Installer to install Oracle HTML DB and are prompted for an Oracle database, you can specify the Oracle Database in that home, but you need to install Oracle HTML DB into its own home that contains Oracle HTTP Server, for example, OraDB10g_home2.

2.1.1.5 Oracle HTTP Server Requirement

Oracle HTML DB must have access to Oracle HTTP Server and mod_plsql in order to run. The Oracle HTML DB installation option that you choose determines the available versions of Oracle HTTP Server that meet this requirement:

• Oracle HTML DB Only: If you plan to select the Oracle HTML DB Only installation option, you need to install it into an existing Oracle HTTP Server home. Oracle9i release 2 (9.2) or higher will meet this requirement.

  Oracle HTTP Server has the following minimum operating system and service pack requirements:

  • Windows 2000 with Service Pack 3 or higher

    Windows 2000 includes: Window 2000 Professional, Windows 2000 Server, Windows 2000 Advanced Server, Windows 2000 Datacenter Server, and Terminal Services

  • Windows 2003

  • Windows XP Professional

  Note:

  Windows Multilingual User Interface Pack is supported on Windows 2003 and Windows XP.

  If the system does not meet these requirements, select the Oracle HTML DB and Oracle HTTP Server installation option instead of Oracle HTML DB Only.

• Oracle HTML DB and Oracle HTTP Server: If you plan to install the version of Oracle HTTP Server that is included in the Oracle Database 10g Companion Products release, see "Using the Oracle HTTP Server Provided with the Companion Products" for its requirements.

2.1.1.6 Oracle XML DB Requirement

Oracle XML DB first must be installed in the Oracle database that you want to use for Oracle HTML DB. If you are using a preconfigured database created either during an installation or by Database Configuration Assistant (DBCA), Oracle XML DB is already installed and configured.

2.1.1.7 Oracle Text Requirement

Oracle Text must be installed so that you can use the searchable online help in Oracle HTML DB. By default, Oracle Text is installed as part of Oracle Database.

In addition, make sure that the default language preferences for Oracle Text have been installed. To install the Oracle Text default language, log into the Oracle database where you plan to install Oracle HTML DB and run the appropriate drdeflang.sql script, which by default is located in ORACLE_BASE\ORACLE_HOME\ctx\admin\defaults. For example, to run the language preferences script for US English, drdefus.sql:

c:\> sqlplus sys/SYS_password as sysdba
SQL> @c:\oracle\product\10.2.0\db_1\ctx\admin\defaults\drdefus.sql

2.3.5.1 Using the Oracle HTTP Server Provided with the Companion Products

If you plan to use the version of Oracle HTTP Server available with Oracle Database 10g Companion Products, you can install this version of Oracle HTTP Server, along with the Companion Products, into their own Oracle HTTP Server home. If you plan to choose this option, ensure that you have the following requirements in place:

• Requirements Overview

• Disk Space Requirements

• Operating System and Service Pack Requirements

• Oracle Database Requirement

Requirements Overview

Table 2-4 summarizes the requirements for an Oracle HTTP Server installation. For details on each requirement, refer to the remaining topics in this section.

Disk Space Requirements

The disk space requirements for Oracle HTTP Server are as follows:

• TEMP space: 90 MB

• SYSTEM_DRIVE:\Program Files\Oracle directory: 1.1 MB

• SYSTEM_DRIVE:\ORACLE_BASE\ORACLE_HOME directory: 372 MB

• Total: 463.1 MB

Operating System and Service Pack Requirements

Oracle HTTP Server has the following minimum operating system and service pack requirements:

• Windows 2000 with Service Pack 3 or higher

  Windows 2000 includes: Window 2000 Professional, Windows 2000 Server, Windows 2000 Advanced Server, Windows 2000 Datacenter Server, and Terminal Services

• Windows 2003

• Windows XP Professional

Oracle Database Requirement

Oracle HTTP Server must have access to Oracle9i release 9.2.0.3 or higher in order to run. Oracle Database can be on a separate system from Oracle HTTP Server, as long as it is accessible by Oracle*Net. However, Oracle HTTP Server must be in its own home.

For example, if Oracle Database has been installed in OraDB10g_home1, when you run Oracle Universal Installer to install Oracle HTTP Server, you can specify the Oracle Database in that home, but you need to install Oracle HTTP Server into its own home, for example, OraDB10g_home2, along with the Oracle Database 10g Companion Products.

2.3.5.2 Using an Existing Oracle HTTP Server Installation

If you plan to install the Oracle Database 10g Companion Products into an existing Oracle HTTP Server home, make sure that this version of Oracle HTTP Server has mod_plsql. Oracle 9i release 2 (9.2) or higher will meet this requirement.

2.5.4.1 Checking if a Loopback Adapter Is Installed on Your Computer

To check if a loopback adapter is installed on your computer, run the ipconfig /all command:

SYSTEM_DRIVE:\> ipconfig /all

If there is a loopback adapter installed, you would see a section that lists the values for the loopback adapter. For example:

Ethernet adapter Local Area Connection 2:
  Connection-specific DNS Suffix  . :
  Description . . . . . . . . . . . : Microsoft Loopback Adapter
  Physical Address. . . . . . . . . : 02-00-4C-4F-4F-50
  DHCP Enabled. . . . . . . . . . . : Yes
  Autoconfiguration Enabled . . . . : Yes
  Autoconfiguration IP Address. . . : 169.254.25.129
  Subnet Mask . . . . . . . . . . . : 255.255.0.0

2.5.4.2 Installing a Loopback Adapter on Windows 2000

Windows 2000 reports on the last network adapter installed. This means that if you install additional network adapters after you install the loopback adapter, you need to remove and reinstall the loopback adapter. The loopback adapter must be the last network adapter installed on the computer.

To install a loopback adapter on Windows 2000:

1. From the Start menu, select Settings, then Control Panel.

2. Double-click Add/Remove Hardware to start the Add/Remove Hardware wizard.

3. In the Welcome window, click Next.

4. In the Choose a Hardware Task window, select Add/Troubleshoot a device, and click Next.

5. In the Choose a Hardware Device window, select Add a new device, and click Next.

6. In the Find New Hardware window, select No, I want to select the hardware from a list, and click Next.

7. In the Hardware Type window, select Network adapters, and click Next.

8. In the Select Network Adapter window, do the following:

   1. Manufacturers: Select Microsoft.

   2. Network Adapter: Select Microsoft Loopback Adapter.

   3. Click Next.

9. In the Start Hardware Installation window, click Next.

10. In the Completing the Add/Remove Hardware Wizard window, click Finish.

11. Right-click My Network Places on the desktop and select Properties. This displays the Network and Dial-up Connections control panel.

12. Right-click the connection that was just created. This is usually "Local Area Connection 2". Select Properties.

13. On the General tab, select Internet Protocol (TCP/IP), and click Properties.

14. In the Properties dialog box, click Use the following IP address and do the following:

    1. IP Address: Enter a non-routable IP for the loopback adapter. Oracle recommends the following non-routable addresses:

       • 192.168.x.x (x is any value between 0 and 255)

       • 10.10.10.10

    2. Subnet mask: Enter 255.255.255.0.

    3. Record the values you entered, which you will need later in this procedure.

    4. Leave all other fields empty.

    5. Click OK.

15. Close the Network Connections window.

16. Restart the computer.

17. Add a line to the SYSTEM_DRIVE:\WINNT\system32\drivers\etc\hosts file with the following format, right after the localhost line:

    IP_address   hostname.domainname   hostname
    
    

    where:

    • IP_address is the non-routable IP address you entered in step 14.

    • hostname is the name of the computer.

    • domainname is the name of the domain.

    For example:

    10.10.10.10   mycomputer.mydomain.com   mycomputer
    
    

18. Check the network configuration:

    1. Open System in the Control Panel, and select the Network Identification tab.

       In Full computer name, make sure you see the host name and the domain name, for example, sales.us.mycompany.com.

    2. Click Properties.

       In Computer name, you should see the host name, and in Full computer name, you should see the host name and domain name. Using the previous example, the host name would be sales and the domain would be us.mycompany.com.

    3. Click More. In Primary DNS suffix of this computer, the domain name, for example, us.mycompany.com, should appear.

    4. Exit the System in the Control Panel.

2.5.4.3 Installing a Loopback Adapter on Windows 2003 or Windows XP

To install a loopback adapter on Windows 2003 or Windows XP:

1. Open the Windows Control Panel.

2. Double-click Add Hardware to start the Add Hardware wizard.

3. In the Welcome window, click Next.

4. In the Is the hardware connected? window, select Yes, I have already connected the hardware, and click Next.

5. In the The following hardware is already installed on your computer window, in the list of installed hardware, select Add a new hardware device, and click Next.

6. In the The wizard can help you install other hardware window, select Install the hardware that I manually select from a list, and click Next.

7. From the list of hardware types, select the type of hardware you are installing window, select Network adapters, and click Next.

8. In the Select Network Adapter window, make the following selections:

   • Manufacturer: Select Microsoft.

   • Network Adapter: Select Microsoft Loopback Adapter.

9. Click Next.

10. In the The wizard is ready to install your hardware window, click Next.

11. In the Completing the Add Hardware Wizard window, click Finish.

12. If you are using Windows 2003, restart your computer.

13. Right-click My Network Places on the desktop and choose Properties. This displays the Network Connections control panel.

14. Right-click the connection that was just created. This is usually named "Local Area Connection 2". Choose Properties.

15. On the General tab, select Internet Protocol (TCP/IP), and click Properties.

16. In the Properties dialog box, click Use the following IP address and do the following:

    1. IP Address: Enter a non-routable IP for the loopback adapter. Oracle recommends the following non-routable addresses:

       • 192.168.x.x (x is any value between 0 and 255)

       • 10.10.10.10

    2. Subnet mask: Enter 255.255.255.0.

    3. Record the values you entered, which you will need later in this procedure.

    4. Leave all other fields empty.

    5. Click OK.

17. Click OK.

18. Close Network Connections.

19. Restart the computer.

20. Add a line to the SYSTEM_DRIVE:\WINDOWS\system32\drivers\etc\hosts file with the following format, after the localhost line:

    IP_address   hostname.domainname   hostname
    
    

    where:

    • IP_address is the non-routable IP address you entered in step 16.

    • hostname is the name of the computer.

    • domainname is the name of the domain.

    For example:

    10.10.10.10   mycomputer.mydomain.com   mycomputer
    
    

21. Check the network configuration:

    1. Open System in the Control Panel, and select the Computer Name tab. In Full computer name, make sure you see the host name and the domain name, for example, sales.us.mycompany.com.

    2. Click Change. In Computer name, you should see the hostname, and in Full computer name, you should see the host name and domain name. Using the previous example, the host name would be sales and the domain would be us.mycompany.com.

    3. Click More. In Primary DNS suffix of this computer, you should see the domain name, for example, us.mycompany.com.

2.5.4.4 Removing a Loopback Adapter

To remove a loopback adapter:

1. Display System in the Windows Control Panel.

2. In the Hardware tab, click Device Manager.

3. In the Device Manager window, expand Network adapters. You should see Microsoft Loopback Adapter.

4. Right-click Microsoft Loopback Adapter and select Uninstall.

5. Click OK.