you have to download before installing:
You will need to sign up for a
free OTN account,
and agree to the
"Oracle Technology Network Developer License
The Oracle files
here for the patch). That's all you
need from Oracle. It's quite big at 500 mb.
You can also order a CD from oracle with the
same thing on it.
Oracle 8i release 3 requires JDK 1.1.8 to be
installed. It looks for the jdk at /usr/local/java.
We'll put the jdk at /usr/local and create a
Login as root and use a web browser
to go to
2) Click on the
3) Pick an FTP site
that is geographically near you.
4) The file to look
for is jdk118_v3-glibc-2.1.3.tar.bz2.
Do NOT download a newer version as it
may not work.
5) Download this file
6) Open a terminal
window. We'll now extract the file and
create a symbolic link so the Oracle
Installer can find it. Run the following
That's all there is to it!
(Top of Page)
sure that all the necessary Linux OS compat
(-glibc, -libc, -egcs) libraries are
installed...you can find them on the Red Hat
install disks or by downloading the rpms
direct from RedHat.com. The short
answer: These are the libraries that were
current when 8i was 'certified' for Red Hat
6.2. and allows the backwards compatibility
for 8i to run on 7.0+...
In this section,
we create the necessary user groups and
accounts which will ultimately manage the
Set up Oracle account and
Two groups and one account need to be
created to install Oracle.
1) If you are not already
logged in as root, log in now.
2) If you don't have a
terminal window already open, open one.
In the terminal window, create your groups.
is used to install the
will be your database administrators group
will be your management group.
Create the oracle user with
as the primary
as the secondary groups.
5) If you didn't make mount points
with disk partitioning, make a directory for
oracle, such as
(You can also fake the OFA-compliancy by
mkdir /u01, /u02, /u03
use each directory for different db files
(...ideally, these would actually be
separate disks to help isolate
fragmentation, reduce i/o contention, and
provide a basis for backup/recovery
6) Change owner and
group permissions on these mount points.
(run same command for /u02, /u03 and /u04
if you have them)
same command for /u02, /u03 and /u04 if
you have them)
7) Log out.
up the oracle user's environment
1) Log in as
2) If you don't have a
terminal window open, open one now.
[enter]. If it
is, great. If not, you'll need to put it in
which we edit in the next
your favorite editor (vi, pico, gedit, kedit,
etc) to edit the
file in your oracle
account's home directory. Put the
following lines in this file:
(Tip: Keep each entry on one line...with
pico, carriage returns can cause problems
if umask does not default to 022)
View a sample .bash_profile file
Log out, then back in as
oracle. Open a terminal window again if one
isn't open and type
to see if all the above variables now appear
in your environment.
make sure all the following paths are in
your path statement, in addition to the
Oracle path you specified above:
If everything isn't there, double-check
your spelling, etc. in your
If everything is there, great! We're ready
to move on.
(Top of Page)
After all that setup, it's
finally time to install software!
Make sure your
logged in as
2) In a terminal
window, change to the directory
containing the Oracle software.
2) Start the
3) A GUI window
appears. Welcome to the Java-based Oracle
4) Click the Next
Verify that the Source path says
Destination path should be the same
as your $ORACLE_HOME environment
variable in your
7) Click Next.
the Unix Group Name window, enter
"oinstall" as the group, then click
installing, you will also see a screen ( a
little later) asking for "osoper" and "osdba"
user account info. Enter "dba" for
osdba, and "oper" for osoper.
window will now pop up asking you to run the
script. Here is how to do
Open a new terminal window
Leave this window open and at the root
10) Go back to that popup window that
appeared and click the Retry button.
11) You will now get
the Available Products screen. Select
Enterprise Edition 18.104.22.168.0
and click Next.
12) On the next
screen, select Typical, then Next.
13) You will then be
prompted for a global database name.
This usually consists of a name you create,
followed by your domain name. If you're just
a home user, this might be something like
oracle.localdomain. (Author's example:
Since my domain here at work is
fortwayne.com and this will be for web work,
I'll name it oraweb.fortwayne.com.) The
one limit to the global database name is
that the name itself must be eight
characters or less.
14) Verify the
ORACLE_SID is correct, then click Next.
15) The next prompt asks for a db
files location. If you just created one
mount point, this will be
in here and click Next.
16) You will then be
asked for the JDK home directory.
Make sure it says /usr/local/java,
then click Next.
17) Finally, at the
summary window, Click the Install button.
18) The software begins
After files have been copied and linked, you
will get another pop-up asking you to run
Go back to the terminal
window that is running at the root level.
Just hit Enter when it
asks for the Path to your local bin
(to exit superuser privileges)
(to exit the terminal
20) Return to that
pop-up window and hit OK.
21) The Oracle Net8
Configuration now starts. All you need
to do is check the box marked "Perform
typical configuration" and hit Next.
22) The Database
Configuration Assistant now starts.
Nothing to do here except hit OK when it
says the database configuration is complete.
23) When the Database
Configuration Assistant finishes, Oracle
will start the webserver on port 7777.
Again, you don't need to do anything here.
24) You are now at the
End of Installation screen. Hit
25) Confirm that you
want to exit.
26) All the software you need
is now on the machine.
If you want to do the optional post-install
stuff, move on. Otherwise, you're set to go.
IMPORTANT! Default passwords
Oracle installed two accounts off the bat
for administering the database. Here are the
names and passwords for both:
system - manager
(Top of Page)
These steps will get the TNS
listener up and running and will also
install the sample tables. Do them only if
you want or need to.
1) Use the same
terminal window that you used to run the
2) If you want to
access the Oracle server with the GUI
management tools from another PC, you
will need to start the TNS listener.
The default config works for most TCP/IP
installations, but you may need to change
it. It worked for us.
3) The Oracle
Server should be running. If not, you
can start it with the following commands:
you want to set up the sample tables for
you can do it this way:
start SQLPlus and login as user
select * from
and you should get some
records back. Everything is up and running!
(Top of Page)