OracleDatabase11gRelease1 (11.1) InstallationOnFedora

OracleDatabase11gRelease1 (11.1) InstallationOnFedora8 (F8) ThisarticledescribestheinstallationofOracleDatabase11gRelease1 (11.1) onFedora8 (F8). Large,

Oracle Database 11g Release 1 (11.1) Installation On Fedora 8 (F8) This article describes the installation of Oracle Database 11g Release 1 (11.1) on Fedora 8 (F8 ). the article is based on a server installation with a minimum of 2G swap,

Oracle Database 11g Release 1 (11.1) Installation On Fedora 8 (F8)

This article describes the installation of Oracle Database 11g Release 1 (11.1) on Fedora 8 (F8 ). the article is based on a server installation with a minimum of 2G swap, secure Linux disabled and the following package groups installed:

• GNOME Desktop Environment
• Editors
• Graphical Internet
• Development Libraries
• Development Tools
• Server Configuration Tools
• Administration Tools
• Base
• Fonts
• Legacy Fonts
• Hardware Support
• System Tools
• X Window System

An example of this type of Linux installation can be seen here. Alternative installations may require more packages to be loaded, in addition to the ones listed below.

• Download Software
• Unpack Files
• Hosts File
• Set Kernel Parameters
• Setup
• Installation
• Post Installation

Download Software

Download the following software:

• Oracle Database 11g Release 1 (11.1) Software

Unpack Files

Unzip the files:

unzip linux_11gR1_database.zip

You shoshould now have a single directory called "database" containing installation files.

Hosts File

The/etc/hosts file must contain a fully qualified name for the server:

Set Kernel Parameters

Oracle recommend the following minimum parameter settings:

kernel.shmall = 2097152kernel.shmmax = 2147483648 # Smallest of -> (Half the size of the physical memory) or (4GB - 1 byte)kernel.shmmni = 4096# semaphores: semmsl, semmns, semopm, semmnikernel.sem = 250 32000 100 128fs.file-max = 65536 # 512 * PROCESSESnet.ipv4.ip_local_port_range = 1024 65000net.core.rmem_default=4194304net.core.rmem_max=4194304net.core.wmem_default=262144net.core.wmem_max=262144

The current values can be tested using the following command:

/sbin/sysctl -a | grep 
  

For Fedora 8, the following lines shoshould be appended to the "/etc/sysctl. conf" file.

kernel.shmall = 2097152kernel.shmmax = 2147483648kernel.shmmni = 4096# semaphores: semmsl, semmns, semopm, semmnikernel.sem = 250 32000 100 128net.ipv4.ip_local_port_range = 1024 65000net.core.rmem_default=4194304net.core.rmem_max=4194304net.core.wmem_default=262144net.core.wmem_max=262144

Run the following command to change the current kernel parameters:

/sbin/sysctl -p

Add the following lines to the/etc/security/limits. conf file:

oracle              soft    nproc   2047oracle              hard    nproc   16384oracle              soft    nofile  1024oracle              hard    nofile  65536

Add the following line to the/etc/pam. d/login file, if it does not already exist:

session    required     /lib/security/pam_limits.sosession    required     pam_limits.so

Disable secure linux by editing the/etc/selinux/config file, making sure the SELINUX flag is set as follows:

SELINUX=disabled

Alternatively, this alteration can be done using the GUI tool (System> Administration> Firewall and SELinux). Click on the SELinux tab and disable the feature.

Setup

Install the following packages:

# From Fedora 8 DVDcd /media/cdrom/Packagesrpm -Uvh binutils-2.*rpm -Uvh elfutils-libelf-0.*rpm -Uvh glibc-2.*rpm -Uvh glibc-common-2.*rpm -Uvh libgcc-4.*rpm -Uvh libstdc++-4.*rpm -Uvh make-3.*rpm -Uvh elfutils-libelf-devel-0.*rpm -Uvh glibc-devel-2.*rpm -Uvh gcc-4.*rpm -Uvh gcc-c++-4.*rpm -Uvh libstdc++-devel-4.*rpm -Uvh unixODBC-2.*cd /eject# Not available on Fedora 8 DVD, but available from standard yum repository.yum install libaio libaio-develyum install unixODBC-develyum install sysstatyum install compat-libstdc++# Required to mask Java conflict (thanks to Robert W. Benton for pointing this out)yum --enablerepo=development install libxcb.i386

Create the new groups and users:

groupadd oinstallgroupadd dbagroupadd opergroupadd asmadminuseradd -g oinstall -G dba,oper,asmadmin oraclepasswd oracle

Note. We are not going to use th "asmadmin" group, since this installation will not use ASM.

Create the directories in which the Oracle software will be installed:

mkdir -p /u01/app/oracle/product/11.1.0/db_1chown -R oracle:oinstall /u01chmod -R 775 /u01

Login as root and issue the following command:

xhost +
  

Edit the/etc/redhat-release file replacing the current release information (Fedora release 8 (Werewolf) with the following:

redhat release 5

Login as the oracle user and add the following lines at the end of the. bash_profile file:

# Oracle SettingsTMP=/tmp; export TMPTMPDIR=$TMP; export TMPDIRORACLE_HOSTNAME=f8.localdomain; export ORACLE_HOSTNAMEORACLE_BASE=/u01/app/oracle; export ORACLE_BASEORACLE_HOME=$ORACLE_BASE/product/11.1.0/db_1; export ORACLE_HOMEORACLE_SID=DB11G; export ORACLE_SIDORACLE_TERM=xterm; export ORACLE_TERMPATH=/usr/sbin:$PATH; export PATHPATH=$ORACLE_HOME/bin:$PATH; export PATHLD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATHCLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATHif [ $USER = "oracle" ]; then  if [ $SHELL = "/bin/ksh" ]; then    ulimit -p 16384    ulimit -n 65536  else    ulimit -u 16384 -n 65536  fifi# Required to mask Java conflict (thanks to Robert W. Benton for pointing this out)LIBXCB_ALLOW_SLOPPY_LOCK=true; export LIBXCB_ALLOW_SLOPPY_LOCK

Installation

Log into the oracle user. If you are using X emulation then set the DISPLAY environmental variable:

DISPLAY=
  
   :0.0; export DISPLAY
  

Start the Oracle Universal Installer (OUI) by issuing the following command in the database directory:

./runInstaller

During the installation enter the appropriate ORACLE_HOME and name then continue installation. some of the prerequisite checks will not complete due to this not being a supported Linux distribution. check each of these prerequisites to set them to "User Verified" then you can proceed. for a more detailed look at the installation process, click on the links below to see screen shots of each stage.

1. Select Installation Method
2. Specify Inventory Directory and Credentials
3. Select Installation Type
4. Install Location
5. Product-Specific Prerequisite Checks
6. Select Configuration Option
7. Select Database Configuration
8. Specify Database Configuration Options
9. Specify Database Configuration Details
10. Select Database Management Option
11. Specify Database Storage Option
12. Specify Backup and Recovery Options
13. Specify Database Schema Passwords
14. Oracle Configuration Manager Registration
15. Summary
16. Install
17. Configuration Assistants
18. Database Configuration Assistant
19. DatabaseConfiguration Assistant Summary
20. Execute Configuration Scripts
21. End of Installation
22. OEM Database Control Login
23. OEM Database Control

Post Installation

Edit the/etc/redhat-release file restoring the original release information:

Fedora release 8 (Werewolf)

Edit the/etc/oratab file setting the restart flag for each instance to 'y ':

DB11G:/u01/app/oracle/product/11.1.0/db_1:Y

For more information see:

• Oracle Database Installation Guide 11g Release 1 (11.1) for Linux
• Automatic Database Startup and Shutdown on Linux

Hope this helps. Regards Tim...