|
Stuff
you have to download before installing:
*Note:
You will need to sign up for a
free OTN account,
and agree to the
"Oracle Technology Network Developer License
Terms".
The Oracle files
Go to
technet.oracle.com
and download
linux817ee.tar and
glibc-2.1.3-stubs.tar.gz (or
click
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.
Java SDK
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
link.
1)
Login as root and use a web browser
to go to
blackdown.org
2) Click on the
downloads link.
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
to /usr/local.
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
commands:
7)
That's all there is to it!
(Top of Page)
Oracle
Pre-Install:
Note: Be
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
oracle software..
Set up Oracle account and
group
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.
3)
In the terminal window, create your groups.
oinstall
is used to install the
software, while
dba
will be your database administrators group
and
oper
will be your management group.
-
groupadd
oinstall
-
groupadd
dba
-
groupadd
oper
4)
Create the oracle user with
oinstall
as the primary
group and
dba
and
oper
as the secondary groups.
5) If you didn't make mount points
with disk partitioning, make a directory for
oracle, such as
/u01.
-
mkdir
/u01.
(You can also fake the OFA-compliancy by
mkdir /u01, /u02, /u03
and
/u04
and
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
[RAID]...)
6) Change owner and
group permissions on these mount points.
-
chown
oracle.dba /u01
(run same command for /u02, /u03 and /u04
if you have them)
-
chmod
775 /u01
(run
same command for /u02, /u03 and /u04 if
you have them)
7) Log out.
-------------------------------------------
Setting
up the oracle user's environment
1) Log in as
oracle.
2) If you don't have a
terminal window open, open one now.
3)
Verify
umask
is 022
by typing
umask
[enter]. If it
is, great. If not, you'll need to put it in
.bash_profile,
which we edit in the next
step.
4) Use
your favorite editor (vi, pico, gedit, kedit,
etc) to edit the
.bash_profile
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
here)
ORACLE_BASE=/u01/app/oracle; export
ORACLE_BASE
ORACLE_HOME=/u01/app/oracle/product/8.1.7;
export ORACLE_HOME
ORACLE_SID=ora1;
export ORACLE_SID
PATH=$PATH:/u01/app/oracle/product/8.1.7/bin;
export PATH
CLASSPATH=.:/u01/app/oracle/product/8.1.7/jdbc/lib/classes111.zip;
export CLASSPATH
LD_LIBRARY_PATH=/u01/app/oracle/product/8.1.7/lib;
export LD_LIBRARY_PATH
(optional)
umask 022
(only
if umask does not default to 022)
View a sample .bash_profile file
6)
Log out, then back in as
oracle. Open a terminal window again if one
isn't open and type
env
to see if all the above variables now appear
in your environment.
7) Also
make sure all the following paths are in
your path statement, in addition to the
Oracle path you specified above:
/bin,
/usr/bin,
/usr/local/bin.
8)
If everything isn't there, double-check
your spelling, etc. in your
.bash_profile.
If everything is there, great! We're ready
to move on.
(Top of Page)
Oracle Install:
After all that setup, it's
finally time to install software!
1)
Make sure your
logged in as
oracle.
2) In a terminal
window, change to the directory
containing the Oracle software.
Type:
cd
/usr/src/Disk1
2) Start the
installer:
Type:
./runInstaller
3) A GUI window
appears. Welcome to the Java-based Oracle
installer.
4) Click the Next
button.
5)
Verify that the Source path says
/usr/src/Disk1/stage/products.jar
6) The
Destination path should be the same
as your $ORACLE_HOME environment
variable in your
.bash_profile.
7) Click Next.
8) At
the Unix Group Name window, enter
"oinstall" as the group, then click
Next.
When
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.
9) A
window will now pop up asking you to run the
orainstRoot.sh
script. Here is how to do
that:
-
Open a new terminal window
-
su root
(enter your
password)
-
cd
$ORACLE_HOME
-
./orainstRoot.sh
-
Leave this window open and at the root
level.
10) Go back to that popup window that
appeared and click the Retry button.
11) You will now get
the Available Products screen. Select
Oracle 8i
Enterprise Edition 8.1.7.0.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
/u01.
Enter
/u01
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
installing.
19)
After files have been copied and linked, you
will get another pop-up asking you to run
the
root.sh
script.
-
Go back to the terminal
window that is running at the root level.
-
cd $ORACLE_HOME
-
./root.sh
-
Just hit Enter when it
asks for the Path to your local bin
directory
-
exit
(to exit superuser privileges)
-
exit
(to exit the terminal
window)
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
Exit.
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:
sys -
change_on_install
system - manager
(Top of Page)
Oracle
post-install (optional):
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
installer.
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:
-
svrmgrl
-
connect
internal
-
startup
-
quit
4)
If
you want to set up the sample tables for
user
scott/tiger,
you can do it this way:
5) Now
start SQLPlus and login as user
scott
and password
tiger.
Do a
select * from
emp
and you should get some
records back. Everything is up and running!
(Top of Page) |
