Oracle® Database

1 Review Information About this Guide

This guide describes how to complete a default installation of Oracle Client in a new Oracle home directory. It describes how to perform one of the following installation types:

• Administrator: Enables applications to connect to an Oracle database on the local system or on a remote system. It also provides tools that allow you to administer an Oracle database.

• Runtime: Enables applications to connect to an Oracle database on the local system or on a remote system.

• Instant Client: Enables you to install only the shared libraries required by Oracle Call Interface applications that use the Instant Client feature. This installation type requires much less disk space than the other Oracle Client installation types.

For more detailed information about installing Oracle Client, see the Oracle Database Client Installation Guide for UNIX Systems.

This guide is available on the product disc. To access it, use a Web browser to open the welcome.htm file, either in the top-level directory of the CD-ROM or in the client directory on the DVD-ROM, then select the Documentation tab.

2 Log In to the System as root

Before you install the Oracle software, you must complete several tasks as the root user. To log in as the root user, complete one of the following procedures:

• If you are installing the software from an X Window System workstation or X terminal:

  1. Start a local terminal session, for example, an X terminal (xterm).

  2. If you are not installing the software on the local system, enter the following command to enable remote hosts to display X applications on the local X server:

     $ xhost +
     
     

  3. If you want to install the software on a remote system, enter a command similar to the following to connect to that system:

     $ telnet remote_host
     
     

  4. If you are not logged in as the root user, enter the following command to switch user to root:

     $ su - root
     password:
     #
     
     

• If you are installing the software from a PC or other system with X server software installed:

  
  

  Note: If necessary, see your X server documentation for more information about completing this procedure. Depending on the X server software that you are using, you may need to complete the tasks in a different order.

  
  

  1. Start the X server software.

  2. Configure the security settings of the X server software to permit remote hosts to display X applications on the local system.

  3. Connect to the remote system where you want to install the software and start a terminal session on that system, for example, an X terminal (xterm).

  4. If you are not logged in as the root user on the remote system, enter the following command to switch user to root:

     $ su - root
     password:
     #
     
     

3 Check the Hardware Requirements

The system must meet the following minimum hardware requirements:

To ensure that the system meets these requirements, follow these steps:

1. To determine the physical RAM size, enter the following command:

   # /usr/sbin/lsattr -E -1 sysO -a realmem
   
   

   If the size of the physical RAM installed in the system is less than 256 MB, you must install more memory before continuing.

2. To determine the size of the configured swap space, enter the following command:

   # /usr/sbin/lsps -a
   
   

   If necessary, see your operating system documentation for information about how to configure additional swap space.

3. To determine the amount of free disk space available in the /tmp directory, enter the following command:

   # df -k /tmp
   
   

   If there is less than 400 MB of disk space available in the /tmp directory, complete one of the following steps:

   • Delete unnecessary files from the /tmp directory to achieve the required disk space.

   • Set the TEMP and TMPDIR environment variables when setting the oracle user’s environment (described later).

   • Extend the file system that contains the /tmp directory. If necessary, contact your system administrator for information about extending file systems.

4. To determine the amount of free disk space available on the system, enter the following command:

   # df -k
   
   

   This command displays the disk space usage on all mounted file systems. To complete the installation, identify a file system with sufficient disk space.

5. To determine whether the system architecture is 64-bit, enter the following command:

   # /usr/bin/getconf HARDWARE_BITMODE
   
   

   This command should return the following output. If you do not see the expected output, you cannot install the software on this system.

   64
   
   

4 Check the Software Requirements

The system must meet the following minimum software requirements:

• The version of AIX must be AIX 5L version 5.2 maintenance level 1 or higher.

• The following filesets must be installed and committed:

  bos.adt.base
  bos.adt.lib
  bos.adt.libm
  bos.perf.libperfstat
  bos.perf.perfstat
  bos.perf.proctools
  
  

• The following Authorized Problem Analysis Reports (APARs) must be installed:

  • IY43980: libperfstat.h not ANSI-compliant

  • IY44810: DSI IN BMRECYCLE

  • IY45462: Definition of isnan() in math.h incorrect

  • IY45707: J2 READAAHEAD/CIO INTERACTION

  • IY46214: dropping partial connections leaves them on so_q0

  • IY46605: exec of 32 bit application can fail on 64 bit kernel

  • IY48525: SDK 1.4.1 32-BIT SR1: CA141-20030930

  • IY51801: race condition in aio_nwait_timeout

To ensure that the system meets these requirements, follow these steps:

1. To determine which version of AIX is installed, enter the following command:

   # oslevel -r
   5200-01
   
   

   If the operating system version is lower than AIX 5.2.0.0 Maintenance Level 1 (5200-01), upgrade your operating system to this level or higher. AIX maintenance packages are available from the following IBM Web site:

   https://techsupport.services.ibm.com/server/aix.fdc
   
   

2. To determine whether the required filesets are installed and committed, enter the following command:

   # lslpp -l bos.adt.base bos.adt.lib bos.adt.libm bos.perf.perfstat \
   bos.perf.libperfstat bos.perf.proctools
   
   

   If a fileset is not installed and committed, then install if from the operating system CD-ROM. See your operating system or software documentation for information on installing filesets.

3. To determine whether an APAR is installed, enter a command similar to the following:

   # /usr/sbin/instfix -i -k "IY43980 IY44810 IY45462 IY45707 IY46214 \  
     IY46605 IY48525 IY51801"
   
   

   If an APAR is not installed, download it from the following Web site and install it:

   https://techsupport.services.ibm.com/server/aix.fdc
   
   

5 Create Required UNIX Group and User

The following local UNIX group and user must exist on the system:

• The oinstall group (the Oracle Inventory group)

• The oracle user (the Oracle software owner)

To create this user and group, follow these steps:

1. Enter the following command:

   # smit security
   
   

2. Choose the appropriate menu items to create the oinstall group.

3. Choose the appropriate menu items to create the oracle user, specifying the following information:

   • In the Primary GROUP field, specify oinstall.

   • In the Group SET field, specify any optional secondary groups, for example dba.

4. After you have added the user and group, press F10 to exit.

5. Set the password of the oracle user:

   # passwd oracle
   
   

6 Create an Oracle Base Directory

Create an Oracle base directory with a name similar to the following and specify the correct owner, group, and permissions for it:

/u01/app/oracle

The Oracle base directory must have between 150 MB (153600 KB) and 1.9 GB (1992295 KB) of free space depending on the installation type you choose:

To determine where to create this directory, follow these steps:

1. Enter the following command to display information about all mounted file systems:

   # df -k
   
   

   This command displays information about all of the file systems mounted on the system, including:

   • The physical device name

   • The total amount, used amount, and available amount of disk space, in kilobytes

   • The mount point directory for that file system

2. From the display, identify a file system that has sufficient disk space.

3. Note the name of the mount point directory for the file system that you identified.

   In the following examples, /u01 is the mount point directory used for the software. You must specify the appropriate mount point directory for the file system on your system.

To create the required directory and specify the correct owner, group, and permissions for it, follow these steps:

1. Enter the following command to create subdirectories in the mount point directory that you identified for the Oracle base directory:

   # mkdir -p /u01/app/oracle
   
   

2. Change the owner and group of the directory that you created to the oracle user and the oinstall group:

   # chown -R oracle:oinstall /u01/app/oracle
   
   

3. Change the permissions on the directory that you created to 775:

   # chmod -R 775 /u01/app/oracle
   
   

7 Mount the Product Disc

The Oracle Client software is available on both CD-ROM and DVD-ROM. These discs are in ISO 9660 format with Rockridge extensions.

To mount the product disc, follow these steps:

1. If necessary, enter a command similar to following to unmount the currently mounted disc, then remove it from the drive:

   # umount /cdrom
   
   

   In this example, /cdrom is the mount point directory for the CD-ROM drive.

2. Insert the disc into the CD-ROM or DVD-ROM drive.

3. To mount the disc, enter a command similar to the following:

   # /usr/sbin/mount -rv cdrfs /dev/cd0 /cdrom
   
   

8 Log In as the oracle User and Configure the oracle User’s Environment

You run the Installer from the oracle account. However, before you start the Installer you must configure the environment of the oracle user. To configure the environment, you must:

• Set the default file mode creation mask (umask) to 022 in the shell startup file.

• Set the DISPLAY and ORACLE_BASE environment variables.

To set the oracle user’s environment, follow these steps:

1. Start another terminal session.

2. Enter the following command to ensure that X Window applications can display on this system:

   $ xhost +
   
   

3. Complete one of the following steps:

   • If the terminal session is not connected to the system where you want to install the software, log in to that system as the oracle user.

   • If the terminal session is connected to the system where you want to install the software, switch user to oracle:

     $ su - oracle
     
     

4. To determine the default shell for the oracle user, enter the following command:

   $ echo $SHELL
   
   

5. Open the oracle user’s shell startup file in any text editor:

   • Bourne shell (bsh), Bash shell (bash), or Korn shell (sh or ksh):

     $ vi .profile
     
     

   • C shell (csh or tcsh):

     % vi .login
     
     

6. Enter or edit the following line in the shell startup file, specifying a value of 022 for the default file creation mask:

   umask 022
   
   

7. Save the file and exit from the editor.

8. To run the shell startup script, enter the following command:

   • Bourne, Bash, or Korn shell:

     $ . ./.profile
     
     

   • C shell:

     % source ./.login
     
     

9. If you determined that the /tmp directory had insufficient free disk space when checking the hardware requirements, enter the following commands to set the TEMP and TMPDIR environment variables. Specify a directory on a file system with sufficient free disk space.

   • Bourne, Bash, or Korn shell:

     $ TEMP=/directory
     $ TMPDIR=/directory
     $ export TEMP TMPDIR
     
     

   • C shell:

     % setenv TEMP /directory
     % setenv TMPDIR /directory
     
     

10. If you are not installing the software on the local system, enter the following command to direct X applications to display on the local system:

    • Bourne, Bash, or Korn shell:

      $ DISPLAY=local_host:0.0 ; export DISPLAY
      
      

    • C shell:

      % setenv DISPLAY local_host:0.0
      
      

    In this example, local_host is the host name or IP address of the system you want to use to display the Installer (your workstation or PC).

11. Enter commands similar to the following to set the ORACLE_BASE environment variable:

    • Bourne, Bash, or Korn shell:

      $ ORACLE_BASE=/u01/app/oracle
      $ export ORACLE_BASE
      
      

    • C shell:

      % setenv ORACLE_BASE /u01/app/oracle
      
      

    In these examples, /u01/app/oracle is the Oracle base directory that you created earlier.

12. Enter the following commands to ensure that the ORACLE_HOME and TNS_ADMIN environment variables are not set:

    • Bourne, Bash, or Korn shell:

      $ unset ORACLE_HOME
      $ unset TNS_ADMIN
      
      

    • C shell:

      % unsetenv ORACLE_HOME
      % unsetenv TNS_ADMIN
      
      

13. To verify that the environment has been set correctly, enter the following commands:

    $ umask
    $ env | more
    
    

    Verify that the umask command displays a value of 022 and the environment variables that you set in this section have the correct values.

9 Install Oracle Client

After configuring the oracle user’s environment, start the Installer and install the Oracle software, as follows:

$ /mount_point/client/runInstaller

1. To start the Installer, enter the following commands:

   $ cd /tmp
   $ /cdrom/runInstaller
   
   

   If the Installer does not appear, see the Oracle Database Client Installation Guide for UNIX Systems for information about how to troubleshoot X display problems.

2. Use the following guidelines to complete the installation:

   • The following table describes the recommended action for each Installer screen.

     
     

     Note: If you have completed the tasks listed previously, you can complete the installation by choosing the default values on most screens.

     
     

   • If you need more assistance, or if you want to choose an option that is not a default, click Help for additional information.

   • If you encounter errors while installing or linking the software, see the Oracle Database Client Installation Guide for UNIX Systems for information about troubleshooting.

   Screen	Recommended Action
   Welcome	Click Next.
   Specify Inventory Directory and Credentials	Note: This screen appears only during the first installation of Oracle products on a system. Specify the following information, then click Next: Enter the full path of the inventory directory Verify that the path is similar to the following, where oracle_base is the value that you specified for the ORACLE_BASE environment variable: oracle_base/oraInventory Specify operating system group name Verify that the group specified is the Oracle Inventory group: oinstall
   Run orainstRoot.sh	If prompted, run the following script in a separate terminal window as the root user: oracle_base/oraInventory/orainstRoot.sh
   Specify File Locations	In the Destination section, verify that the Path value for the Oracle home directory is similar to the following, then click Next: oracle_base/product/10.1.0/client_1
   Select Installation Type	Select InstantClient, Administrator, or Runtime, then click Next.
   Summary	Review the information displayed, then click Install.
   Install	The Install screen displays status information while the product is being installed.
   Configuration Assistants	Note: This screen appears only during an Administrator or Runtime installation. The Configuration Assistants screen displays status information for the Oracle Net Configuration Assistant that configures Oracle Net.
   Oracle Net Configuration Assistant: Welcome	Review the information on the screen, then click Next. The Oracle Net Configuration Assistant configures the easy connect naming method. For more information about this naming method, click Help.
   Oracle Net Configuration Assistant: Done	Click Finish to continue.
   Setup Privileges	Note: This screen appears only during an Administrator or Runtime installation. If prompted, run the following script in a separate terminal window as the root user: oracle_home/root.sh In this example, oracle_home is the directory where you installed the software. The correct path is displayed on the screen. Press Return to accept the default values for each prompt displayed by the script. When the script finishes, click OK.
   End of Installation	To exit from the Installer, click Exit, then click Yes.

   
   

10 What to Do Next

After you have successfully installed Oracle Client, see Chapter 4 in the Oracle Database Client Installation Guide for UNIX Systems for information about required and optional post-installation steps.

11 Documentation Accessibility

Our goal is to make Oracle products, services, and supporting documentation accessible, with good usability, to the disabled community. To that end, our documentation includes features that make information available to users of assistive technology. This documentation is available in HTML format, and contains markup to facilitate access by the disabled community. Standards will continue to evolve over time, and Oracle is actively engaged with other market-leading technology vendors to address technical obstacles so that our documentation can be accessible to all of our customers. For additional information, visit the Oracle Accessibility Program Web site at

http://www.oracle.com/accessibility/

JAWS, a Windows screen reader, may not always correctly read the code examples in this document. The conventions for writing code require that closing braces should appear on an otherwise empty line; however, JAWS may not always read a line of text that consists solely of a bracket or brace.

This documentation may contain links to Web sites of other companies or organizations that Oracle does not own or control. Oracle neither evaluates nor makes any representations regarding the accessibility of these Web sites.

Oracle provides dedicated Text Telephone (TTY) access to Oracle Support Services within the United States of America 24 hours a day, seven days a week:

• For technical questions, call 1.800.446.2398

• For non-technical questions, call 1.800.464.2330