HOME  | BOOKMARK  |


.

Site Search:

 

Advanced Search

Navigate

Home

Windows Related

Downloads

Oracle Related

Linux related

Links

About Me

Comments

 


less

more


1

2

3

4


5

(250 characters or less)

(returns to this page)

 

 

 oracle installation on linux   

How To Install Oracle 8i (version 8.1.7) on Linux Redhat 7.0 (and 8.0)


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. 

  • Log in as root.

  • Download linux817ee.tar to /usr/src

  • Uncompress the file: tar xvf linux817ee.tar

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:

  • tar xvIf jdk118_v3-glibc-2.1.3.tar.bz2

  • ln -s /usr/local/jdk118_v3 /usr/local/java

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. 

  • useradd oracle -g oinstall -G dba,oper

  • passwd oracle (to change password)

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. 

  • lsnrctl start

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:

  • cd $ORACLE_HOME/rdbms/admin (dir that holds the sample scripts...there are some interesting ones here)

  • sqlplus (Connect as sys... you may need to enter sys as sysdba)

  • @utlsampl.sql

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)

 
TOP | HOME  |

                          © Copyright 2007. www.mike-devlin.com.  All rights reserved.