Home5. Installing Oracle 8.1.7 

 Installing Oracle 8.1.7 - ADU style

Table of Contents
5.1. Acquire Oracle 8.1.7 Enterprise Edition
5.2. Things to Keep in Mind
5.3. Pre-Installation Tasks
5.4. Installing Oracle 8.1.7 Server
5.5. Creating the First Database
5.6. Acceptance Test
5.7. Automating Startup & Shutdown
5.8. Troubleshooting Oracle Dates
5.9. Useful Procedures
5.10. Defaults
NOTE: This document was written based on Oracle, version 8.1.6, with some updates for 8.1.7 and ADU specific steps.

Throughout this document, a '[bob@localhost]$' shell prompt indicates a normal user (and after you create the oracle user, '[oracle@localhost]$' will indicate that you are the oracle user).  A '[root@localhost]#' for a prompt indicates that you are operating as root.  Text preceded by a ';' is a comment by the authors of this document about what should be happening at that point.

5.1. Acquire Oracle 8.1.7 Enterprise Edition

You have two choices for obtaining the 8.1.7 "tarball".  Regardless of whether you copy the file from the CD or copy it over the network, you will want to save it in /opt, rather than your home directory (because the file is very large, saving it into your home directory will quickly fill up our fileserver, and installation will be quicker if the file is on your local hard drive).  In order to save the tarrball onto your local machine, though, you will want to alter the permissions on /opt:

To temporarily "become" root, we use the 'su' command (setuser).

[bob@localhost]$ cd /opt
[bob@localhost]$ su
Password:   ; enter the root password obtained from a TA
[root@localhost]# chmod 777 /opt
[root@localhost]# exit

1. Get a tarball of the installer by either:

    [bob@localhost]$ cd /opt
    [bob@localhost]$ scp ./
    ; It may ask some convoluted security question.  Answer 'yes'
    <userid>@'s password:  ; enter your password
    ; wait for 20 minutes or so...

[bob@localhost]$ cd /opt
[bob@localhost]$ cp /mnt/cdrom/linux81701.tar .

2. After the download is complete, untar the file to a convenient location. To do this, you will need to login and cd to the directory where the archive is.  

[bob@localhost]$ cd /opt
[bob@localhost] $ tar -xvf

5.2. Things to Keep in Mind

Throughout these instructions, we will refer to a number of configurable settings and advise certain defaults. With the exception of passwords, we advise you to follow these defaults unless you know what you are doing. Subsequent documents will expect that you used the defaults, so a change made here will necessitate further changes later. For a guide to the defaults, please see Section 5.10..

5.3. Pre-Installation Tasks

Though Oracle 8.1.7 has an automated installer, we still need to perform several manual, administrative tasks before we can launch it. You must perform all of these steps as the root user. We recommend doing a 'su -' to become root, but only when it
is necessary. This command gives you full root access.

5.4. Installing Oracle 8.1.7 Server

Congratulations, you have just installed Oracle 8.1.7 Server! However, you still need to create a database which can take about an hour of non-interactive time, so don't quit yet.

5.5. Creating the First Database

This step will take you through the steps of creating a customized database. Be warned that this process takes about an hour on a Pentium II with 128 MB of RAM. It also takes a huge chunk of diskspace, so you may want to delete your Oracle tarball before creating the database (using the command 'rm /opt/linux81701.tar').

5.6. Acceptance Test

For this step, open up a terminal and su to oracle as usual. You should be running X and Netscape for this phase.

5.7. Automating Startup & Shutdown

You will want to automate the database startup and shutdown process. It's probably best to have Oracle spring to life when you boot up your machine.
Congratulations, your installation of Oracle 8.1.7 is complete.

5.8. Troubleshooting Oracle Dates

Oracle has an internal representation for storing the data based on the number of seconds elapsed since some date. However, for the purposes of inputing dates into Oracle and getting them back out, Oracle needs to be told to use a specific date format. By default, it uses an Oracle-specific format which isn't copacetic. You want Oracle to use the ANSI-compliant date format which is of form 'YYYY-MM-DD'.

To fix this, you should include the following line in $ORACLE_HOME/dbs/initSID.ora or for the default case, $ORACLE_HOME/dbs/initora8.ora

nls_date_format =    "YYYY-MM-DD"
You test whether this solved the problem by firing up sqlplus and typing:
SQL> select sysdate from dual;
You should see back a date like 2000-06-02. If some of the date is chopped off, i.e. like 2000-06-0, everything is still fine. The problem here is that sqlplus is simply truncating the output. You can fix this by typing:
SQL> column sysdate format a15
SQL> select sysdate from dual;
If the date does not conform to this format, double-check that you included the necessary line in the init scripts. If it still isn't working, make sure that you have restarted the database since adding the line if you didn't do it prior to database creation.

If you're sure that you have restarted the database since adding the line, check your initialization scripts. Make sure that the following line is not included:

export nls_lang =       american
Setting this environment variable will override the date setting. Either delete this line and login again or add the following entry to your login scripts after the nls_lang line:
export nls_date_format =       'YYYY-MM-DD'
Log back in again. If adding the nls_date_format line doesn't help, you can ask for advice in our web/db forum.

5.9. Useful Procedures

For more information on Oracle, please consult the documentation.

5.10. Defaults

We used the following defaults while installing Oracle.

Variable Value Reason
ORACLE_HOME /opt/ora8/m01/app/oracle/product/8.1.7 This is the default Oracle installation directory.
ORACLE_SERVICE ora8 The service name is a domain-qualified identifier for your Oracle server.
ORACLE_SID ora8 This is an identifier for your Oracle server.
ORACLE_OWNER oracle The user who owns all of the oracle files.
ORACLE_GROUP dba The special oracle group. Users in the dba group are authorized to do a connect internal within svrmgrl to gain full system access to the Oracle system.
($Id: oracle.xml,v 2001/02/20 19:52:53 claus Exp $)