Installing Oracle10g

Installing Oracle10g on a Remote Linux Server

If you don't install Oracle on your local system but on a remote server, then you need to relink X to your local desktop. The easiest way to do this is to use the "X11 forwarding" feature of ssh. This means that you don't have to run xhost and set the DISPLAY environment variable.

Here is an example how to make use of the "X11 forward" feature of ssh. Simply run the following command from your local desktop:

$ ssh -X oracle@oracle_remote_server_name

Now when you try to run any GUI tool on the remote server, it will automatically be relinked to your local desktop. If this is not working, verify that the ForwardX11 setting is not set to "no" in /etc/ssh/ssh_config on the remote server:

su - root
# grep ForwardX11 /etc/ssh/ssh_config | grep -v "^#"
       ForwardX11 yes
#

If you are using telnet, however, you will have to set DISPLAY manually, see my other article Starting runInstaller for more information.


Starting Oracle Universal Installer

Insert the Oracle CD that contains the image of the downloaded file ship.db.lnx32.cpio, or change to the directory that contains the image directory Disk1.

If you install Oracle10g from a CD, mount the CD by running the following commands in another terminal:

su - root
mount /mnt/cdrom

For RHEL AS 4, RHEL AS 3, and FC3 you have to execute:

su - root
mount /media/cdrom

Before you execute runInstaller, make sure the Oracle environment variables are set, see Setting Oracle Environments. You can verify the settings by running the set command:

su - oracle
oracle$ set

To execute runInstaller from the mounted CD, run the following command as the oracle user:

oracle$ /mnt/cdrom/runInstaller

On RHEL AS 4, RHEL AS 3, and FC3 run the following command:

oracle$ /media/cdrom/runInstaller

Using Oracle Universal Installer (OUI)

The following example shows how to install x86 Oracle 10g Release 1 Database Software and a "General Purpose" database:
(Note, the screens and questions will look different if you install 10g R2 or 64-bit 10g R1 database)

 - Welcome Screen:
                    - Basic Installation:       Checked it which is the default
                    - Oracle Home Location:     Use default: /u01/app/oracle/product/10.1.0/db_1
                    - Installation Type:        I used the default: Enterprise Edition
                    - UNIX DBA Group:           Use default: dba
                    - Create Starter Databases: I checked it for this example which is the default
                      - Global Database Name:     orcl
                      - Database password:        Type in the password for SYS, SYSTEM, SYSMAN, and DBSNMP accounts
                    - Advanced Installation:    For this article I did not check it
                    Click Next

- Specify Inventory directory and credentials:
                    - Full path of the inventory directory: Use default: /u01/app/oracle/oraInventory
                    - Specify Operating System group name:  Use default: oinstall
                    Click Next

- A window pops up to run the orainstRoot.sh script:
                    Run the script in another terminal:
                      su - root
                      # /u01/app/oracle/oraInventory/orainstRoot.sh
                      Creating the Oracle inventory pointer file (/etc/oraInst.loc)
                      Changing groupname of /u01/app/oracle/oraInventory to oinstall.
                      #
                    Click Continue

- Product-specific Prerequisite Checks:
                    Verify that all checks have been passed.
                    Make sure that the status of each Check is set to "Succeeded".
                    On RHEL AS 4 ignore the warnings for binutils, gcc, and openmotif and proceed.
                    If a check failed, see Oracle10g Installation Errors on Linux.
                    Note that the "Retry" button doesn't work after you fixed one of the failed checks.
                    Click Next

- Select Database Configuration:
                    I selected "General Purpose".
                    Click Next

- Specify Database Configuration Options:
                    - Global Database Name: I used "orcl".
                    - SID: I used "orcl".
                    Click Next

- Select Database Management Option:
                    I selected "Use Database Control for Database Management".
                    Click Next

- Specify Database File Storage Option:
                    I selected "File System".
                    - File System
                      - Specify Database file location: /u01/app/oracle/oradata/
                          If you want to comply with OFA, you might want to select another mount point
                          than '/u01', e.g. /u02/oradata.
                    Click Next

- Specify Backup and Recovery Options:
                    For my test installation I selected "Do no enable Automated Backups".
                    Click Next

- Specify Database Schema Passwords:
                    Make sure that the password(s) don't start with a digit number! Otherwise you
                    will later get error message(s) like "ORA-00988 missing or invalid password".
                    Click Next

- Summary:          Click Install

                    If Enterprise manager configuration fails due to port allocation problems,
                    check out Oracle10g/Linux Errors and Problems.


                    When a window pops up to run the root.sh script, execute the script
                    in another terminal as root:

                      su - root
                      # /u01/app/oracle/product/10.1.0/db_1/root.sh
                      Running Oracle10 root.sh script...
                      \nThe following environment variables are set as:
                          ORACLE_OWNER= oracle
                          ORACLE_HOME=  /u01/app/oracle/product/10.1.0/db_1

                      Enter the full pathname of the local bin directory: [/usr/local/bin]:
                         Copying dbhome to /usr/local/bin ...
                         Copying oraenv to /usr/local/bin ...
                         Copying coraenv to /usr/local/bin ...

                      \nCreating /etc/oratab file...
                      Adding entry to /etc/oratab file...
                      Entries will be added to the /etc/oratab file as needed by
                      Database Configuration Assistant when a database is created
                      Finished running generic part of root.sh script.
                      Now product-specific root actions will be performed.
                      /var/opt/oracle does not exist. Creating it now.
                      /etc/oracle does not exist. Creating it now.
                      Successfully accumulated necessary OCR keys.
                      Creating OCR keys for user 'root', privgrp 'root'..
                      Operation successful.
                      Oracle Cluster Registry for cluster has been initialized

                      Adding to inittab
                      Checking the status of Oracle init process...
                      Expecting the CRS daemons to be up within 600 seconds.
                      CSS is active on these nodes.
                              mars
                      CSS is active on all nodes.
                      Oracle CSS service is installed and running under init(1M)
                      #

                    Click OK

- End of Installation:
                    Click Exit

Updates after Running Oracle Universal Installer

After Oracle10g has been installed, make sure that ORACLE_HOME, PATH, and LD_LIBRARY_PATH are set for the oracle account.

Note that the path for ORACLE_HOME might be different on your system!
Also note that LD_LIBRARY_PATH is needed for some Oracle binaries such as sysresv!

For 10g R1 (10.1.0.3) I added the following lines to the ~oracle/.bash_profile file:

export ORACLE_HOME=$ORACLE_BASE/product/10.1.0/db_1
export PATH=$PATH:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib

For 10g R2 (10.2.0.1.0) I added the following lines to the ~oracle/.bash_profile file:

export ORACLE_HOME=$ORACLE_BASE/oracle/product/10.2.0/db_1
export PATH=$PATH:$ORACLE_HOME/bin

YOU CAN USE QUICK SEARCH ENGINE IN THE TOP FOR MORE DOWNLOADS OR DETAILS.
export LD_LIBRARY_PATH=$ORACLE_HOME/lib

After that run the following command to set all environment variables in ~oracle/.bash_profile:

$ . ~oracle/.bash_profile

This commmand will add the environment variables to the ~oracle/.profile and source in the file for the current shell by executing ". ~oracle/.bash_profile".