8i release 3
dist of Linux will work?
The procedure for RedHat 7.0 is not officially approved by Oracle. If you are putting a mchine into production, I would strongly recommend sticking with RedHat 6.2 instead (and patching the security holes in it). There are other problems with RedHat 7.0 that extend beyond Oracle. Personally, I'm waiting for 7.1 before I think hard about migrating.
machine I used to install Oracle
What's in this doc
Editorial comment about
2) Partition the drive to your preferences. I ignored the OFA-compliance and just made one mount point (/u01). You can also fake OFA by making four directories, but you won't gain any performance from this. You'll gain some performance by creating four distinct partitions (/u01, /u02, /u03, /u04) and you'll gain the most performance by having each of these mount points on four distinct drives, as Oracle recommends. These directions assume only one mount point.
B. X Windows
C. Install options
Make sure you have your kernel source somewhere on your computer.
Kernel memory params
Oracle will run fine without changing any of the kernel parameters.
is because nearly all the parameters are already above Oracle's recommendation.
Here's my take on changing the kernel params: If you're just setting up a personal database so you can develop on it, don't worry about changing the kernel. Everything will work fine for your needs. If, on the other hand, you're putting this into production, consider making the appropriate changes.
The only parameter you MIGHT have to worry about is the SHMMAX setting, and you should only worry about this one if your machine has more than 64 megs RAM, and you are really going to do some heavy database work. If you feel like you MUST change it, here's how:
Changing memory params
0x4000000 = 67108854
0x6000000 = 100663296
0x8000000 = 134217728
0x10000000 = 268435456
0x20000000 = 536870912
3) Save the file.
4) You're now ready to proceed with the process of recompiling the kernel. Recompile it, then continue below.
Stuff you have to download before installing
The Oracle file
Go to technet.oracle.com and download linux817ee.tar. 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 link.
1) Login as root and use a web browser to go to http://www.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:
Set up Oracle account and group
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.
Setting up the oracle user's environment
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 to edit the .bash_profile file in your oracle account's home directory. Put the following lines in this file:
In my case, if I decided to add them for US English anyway, I would put the following in my .bash_profile:
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.
1) Make sure your logged in as oracle.
2) In a terminal window, change to the directory containing the Oracle software.
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.
7) Click Next.
8) At the Unix Group Name window, enter "oinstall" as the group, then click Next.
9) A window will now pop up asking you to run the orainstRoot.sh script. Here is how to do that:
11) You will now get the Available Products screen. Select Oracle 8i Enterprise Edition 126.96.36.199.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. 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 it 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! Woo-woo!
19) After files have been copied and linked, you will get another pop-up asking you to run the root.sh script.
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 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.