Saturday, January 19, 2013

[Oracle 11g] - Oracle Database 11g installation on Fedora 17


This is shows the details on installing Oracle 11g XE(Express Edition) on Fedora 17 Linux OS.
  1. Download the file oracle-xe-11.2.0-1.0.x86_64.rpm.zip from otn.oracle.com
  2. Login in as root user:
    $ su – root
    Password:
    [root@srilinux ~]#
  3. Edit the /etc/sysctl.conf and make sure below entries are updated:
    # cat /etc/sysctl.conf
    kernel.shmmax = 4294967295
    kernel.shmmni = 4096
    kernel.shmall = 2097152
    fs.file-max = 6815744
    # semaphores: semmsl, semmns, semopm, semmni
    kernel.sem = 250 32000 100 128
    net.ipv4.ip_local_port_range = 9000 65500
  4. Then run the command sysctl to update the system from sysctl.conf file.
    [root@srilinux ~]# /sbin/sysctl -p
  5. Append this to your limits file:
    [root@srilinux ~]# cat /etc/security/limits.conf
    * hard nofile 65535
    * soft nofile 4096
  6. After updating the above file you would need to reboot your system for the values to take effect.
  7. Unzip the Oracle 11g Database from the specified directory to a target directory “stage”
    [root@srilinux ~]# unzip /run/media/srikanth/20A4B2DEA4B2B61E/OBIEE11g/oracle-xe-11.2.0-1.0.x86_64.rpm.zip
    -d stage
  8. Then goto the extracted location and install the .rpm file as show below:
    # cd stage/Disk1
  9. You can run the below command to verify that your oracle rpm file isn’t missing any other dependencies:
    [root@srilinux Disk1]# rpm -ivh –test oracle-xe-11.2.0-1.0.x86_64.rpm
    Preparing… ########################################### [100%]
    The run the below command as root, to staring installing the rpm onto your system.
    [root@srilinux Disk1]# rpm -ivh oracle-xe-11.2.0-1.0.x86_64.rpm
    Preparing… ########################################### [100%]
    1:oracle-xe ########################################### [100%]
    Executing post-install steps…
    You must run ‘/etc/init.d/oracle-xe configure’ as the root user to configure the database.
  10. Then as mention to to the final configuration execute oracle-xe configure:
    [root@srilinux Disk1]# /etc/init.d/oracle-xe configure
    Oracle Database 11g Express Edition Configuration