Sunday, September 20, 2009

Oracle 10g Installation on Fedora 9.

Yup, this is a release old for installation notes for Oracle 10g. But, I couldn’t get Fedora 10g installed. Some issues with the display. So had to rollback (reinstall) Fedora 9. And start with Oracle 10g installation on it. So here we go…
This is an adaptation of the installation steps as provided in the following website.
http://www.oracle-base.com/articles/10g/OracleDB10gR2InstallationOnFedora7.php
Thanks to Tim for his wonderful website!! :)
The steps that I mention below, are what I have done on my desktop. And this is for local database host for my self development purposes. I hope it helps others who are interested.
1. Please check the /etc/hosts file to check if you have an entry for a fully qualified host name.
I have the following entry:
[root@localhost wolverine]# cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1               localhost.localdomain localhost localhost
::1             localhost6.localdomain6 localhost6
192.168.1.111   cerebro cerebro

2. Add the following entries to /etc/sysctl.conf file.
kernel.shmall = 2097152
    kernel.shmmax = 2147483648
    kernel.shmmni = 4096
    # semaphores: semmsl, semmns, semopm, semmni
    kernel.sem = 250 32000 100 128
    fs.file-max = 65536
    net.ipv4.ip_local_port_range = 1024 65000
    net.core.rmem_default=262144
    net.core.rmem_max=262144
    net.core.wmem_default=262144
    net.core.wmem_max=262144
Run the command /sbin/sysctl –p to change the parameters at runtime.
3. Add the following entries to /etc/security/limits.conf file.
*               soft    nproc   2047
       *               hard    nproc   16384
       *               soft    nofile  1024
       *               hard    nofile  65536
4. Modify the file /etc/pam.d/login by adding following line if it doesn’t exist.
session    required     /lib/security/pam_limits.so
5. Disable secure linux by setting the SELINUX flag
SELINUX=disabled
6. Install the following.
yum install libXp libaio
     yum install compat-libstdc++* compat-libf2c* compat-gcc* compat-libgcc*
yum install tcl*
yum install compat-db*
yum install libXau-devel-*
  7.  Now comes the part for adding the users for Oracle Installation.
groupadd oinstall
      groupadd dba
      groupadd oper

      useradd -g oinstall -G dba oracle
      passwd oracle
   8.  Create directories required for Oracle, and assign the required privileges.
mkdir -p /u01/app/oracle/product/10.2.0/db_1
      chown -R oracle.oinstall /u01
   9.  Set up the .bash_profile with following entries.
# Oracle Settings
     TMP=/tmp; export TMP
     TMPDIR=$TMP; export TMPDIR

     ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
     ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1; export ORACLE_HOME
     ORACLE_SID=TSH1; export ORACLE_SID
     ORACLE_TERM=xterm; export ORACLE_TERM
     PATH=/usr/sbin:$PATH; export PATH
     PATH=$ORACLE_HOME/bin:$PATH; export PATH

     LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
     CLASSPATH=$ORACLE_HOME/jre:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH

     if [ $USER = "oracle" ]; then
       if [ $SHELL = "/bin/ksh" ]; then
         ulimit -p 16384
         ulimit -n 65536
     else
         ulimit -u 16384 -n 65536
       fi
     fi
10.  Unzip the database archive and cd to the database directory.
11. run the installer with the following option.
     runinstaller –ignoreSysPrereqs
     This will skip the check for the OS.
12. This will show the following screen.
     image
13.  Click on next, which shows the following screen.
     image

14.  Select the required Database installation option.
    image   
15. Specify the home details.
    image 
16. This will bring us to the next screen.
    image    
    For my installation, since I have chosen to not update the redhat-release file, I get the warnings
    These can be overridden using the check boxes.
17.  Select the database configuration options.
      image

18.  Select the General Purpose option and click on proceed.
19.  This shows the next screen, clink on install to start the database installation.
20. Once the installation is completed (it went through successfully for me.) you will get another screen which helps configure the database.
image
21.  I would be using Custom Database option.
       Enter the required name as the SID.
image
22. The next screen gives option to select the backup and the database configuration options.
   Select the option for Enabling EM for Database configuration.
image
23. Click on next. This shows the screen as below:
  Define the required passwords:
image
24. As I mentioned that this is a dev database hosted on a desktop, I am using the file system option for the Database Storage.
image
25. Select the required option.
image
26. Click on next.
image
27. Click on next.
Define the memory options as required.
image
28. Click on next. This shows the installation parameters.
image
29. You can user the next screen to save the database configuration as a template if you wish to retain it.
image
30. Click finish.
This starts the process for Oracle instance creation and startup.
31. Once Instance creation is completed, the installer would prompt you for password management options.
32. The installer will then prompt you to run two scripts as the root user. Open another session and login as root and run the scripts as indicated in the popup.
33. Click on ok.
34. The Oracle installation is complete. The installer would provide you with information about the urls where you can use 10g EM and iSQLPlus.
Now you can try connecting through sqlplus and check if the installation is done correctly.
All the best!!

No comments:

Post a Comment

Search