Tuesday, February 27, 2007

Installation of Oracle 10g Release 2 (10.2.0.1.0) on Fedora Core Linux 6

Dear friends,

After fixing some general errors during the process of installation, I could successfully install and configure Oracle 10gR2 (10.2.0.1) on Fedora Core Linux 6. I would like to share the procedure (step-by-step) of Installation what I followed. Note: In fact Oracle 10gR2 is not supported on Fedora Core 6

Operating System Details:
Linux testserver 2.6.18-1.2798.fc6 #1 SMP Mon Oct 16 14:54:20 EDT 2006 i686 i686 i386 GNU/Linux

Database Verison Details:
Oracle 10g Release 2 (10.2.0.1.0)

Download Software: (10201_database_linux32.zip) http://www.oracle.com/technology/software/products/database/oracle10g/htdocs/10201linuxsoft.html

Pre-Installation tasks:

Creating DBA group and ORACLE user account in Linux

Login to the System as ROOT and execute the below commands.

$ su – root
Password:

# groupadd dba
# useradd –d "/home/oracle" –m –g dba oracle
# passwd oracle

Configuring Kernel Parameters

Check and edit the /etc/sysctl.conf file with the following lines.

kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 1048576
net.core.rmem_max = 1048576
net.core.wmem_default = 262144
net.core.wmem_max = 262144

Note: Make sure to reboot the system or run the command " /sbin/sysctl –p" to change the kernel parameters.

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

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


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

session required /lib/security/pam_limits.so

Make sure that " SELINUX=disabled" in the the /etc/selinux/config file

Edit the /etc/redhat-release file replacing the current release information (Fedora Core release 6 (Zod)) with redhat-4

Creating an Oracle Base Directory

# mkdir –p /u01/app/oracle
# mkdir –p /u01/app/oradata
# mkdir –p /u02/app/oradata

# chown –R oracle:dba /u01/app/oracle
# chown –R oracle:dba /u0 1/app/oradata /u02/app/oradata
# chmod –R 775 /u01/app/oracle
# chmod –R 775 /u0 1/app/oradata /u02/app/oradata

Setting Oracle Environment

Login as Oracle Unix user and change the .bash_profile with the following variables.

Su – oracle
Password:

ORACLE_HOME=/u01/app/oracle
ORACLE_SID=mydb
LD_LIBRARY_PATH=$ORACLE_HOME/lib
TNS_ADMIN=$ORACLE_HOME/network
PATH=$PATH:$ORACLE_HOME/bin

Export ORACLE_HOME ORACLE_SID LD_LIBRARY_PATH TNS_ADMIN

Save the bash profile after changing: wq!

Insallation

Login as oracle and unzip the Oracle 10g software

Su – oracle
Password:

$ unzip 10201_database_linux32.zip

Check all pre-req packages are installed, if not install them

To check the packages information: # rpm –q
To install the packages: # rpm –q
Require packages for installation:

rpm -q binutils gcc glibc glibc-headers glibc-kernheaders glibc-devel compat-libstdc++ cpp compat-gcc make compat-db compat-gcc-c++ compat-libstdc++ compat-libstdc++-devel openmotif openmotif21 setarch pdksh libaio libaio-devel

Important: For successful installation, the rpms "libXp-1.0.0-8.i386.rpm and libaio-0.3.106-3.2.i386.rpm" must have installed. Download these from : http://download.fedora.redhat.com/pub/fedora/linux/core/6/i386/os/Fedora/RPMS

Go to database directory and launch the installer.

$./runInstaller

Provide the required information asked by wizards during installation.

Post – Installation tasks:

Edit the /etc/redhat-release file restoring the original release information:
Fedora Core release 6 (Zod)

I didn't let DBCA to create the default database during the installation; I selected Install Software Only option. After the successful installation of Oracle 10g Software, I created the database manually with my requiremtns. The following are the particulars.

Login as oracel

Make sure that all the required environment variables are Set i.e. ORACLE_HOME and ORACLE_SID etc..

Prepare the initialization parameter with required values

Connect to SQL*Plus as sysdba

$ sqlplus /nolog
SQL> connect /as sysdba

Create the database with the following script.

SQL> startup nomount pfile= /initmydb.ora;

SQL> @$HOME/create_db_manually.sql

create_db_manually.sql file contains

CREATE DATABASE unic
USER SYS IDENTIFIED BY sys
USER SYSTEM IDENTIFIED BY manager
LOGFILE GROUP 1 ('/u01/app/oradata/unic/redo01.log') SIZE 50M,
GROUP 2 ('/u01/app/oradata/unic/redo02.log') SIZE 50M,
GROUP 3 ('/u01/app/oradata/unic/redo03.log') SIZE 50M
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
MAXINSTANCES 1
CHARACTER SET WE8ISO8859P1
NATIONAL CHARACTER SET AL16UTF16
DATAFILE '/u02/app/oradata/unic/system01.dbf' SIZE 325M REUSE
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '/u02/app/oradata/unic/sysaux01.dbf' SIZE 325M REUSE
DEFAULT TABLESPACE users
datafile '/u02/app/oradata/unic/users01.dbf'
SIZE 20M REUSE
DEFAULT TEMPORARY TABLESPACE temp
TEMPFILE '/u02/app/oradata/unic/temp01.dbf'
SIZE 200M REUSE
UNDO TABLESPACE undotbs1
DATAFILE '/u02/app/oradata/unic/undotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON MAXSIZE 2000m;

Run Scripts to Build Data Dictionary Views

CONNECT SYS/password AS SYSDBA
SQL>@$ORACLE_HOME \rdbms\admin\catalog.sql
SQL>@$ORACLE_HOME \rdbms\admin\catproc.sql

Errors generated during the installation

>>Checking operating system version: must be redhat-3, SuSE-9, redhat-4, UnitedLinux-1.0, asianux-1 or asianux-2Failed

Edit the /etc/redhat-release file replacing the current release information (Fedora Core release 6 (Zod)) with redhat-4

>> Exception java.lang.UnsatisfiedLinkError: /tmp/OraInstall2007-02-25_03-22-29PM/jre/1.4.2/lib/i386/libawt.so: libXp.so.6: cannot open shared object file: No such file or directory occurred..java.lang.UnsatisfiedLinkError: /tmp/OraInstall2007-02-25_03-22-29PM/jre/1.4.2/lib/i386/libawt.so: libXp.so.6: cannot open shared object file: No such file or directoryat java.lang.ClassLoader$NativeLibrary.load(Native Method)at java.lang.ClassLoader.loadLibrary0(Unknown Source)
……
……


Download and install the libXp-1.0.0-8.i386.rpm
http://download.fedora.redhat.com/pub/fedora/linux/core/6/i386/os/Fedora/RPMS/libXp-1.0.0-8.i386.rpm

#rpm –ivh libXp-1.0.0-8.i386.rpm

>> error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory


Download and install the libaio-0.3.106-3.2.i386.rpm
http://download.fedora.redhat.com/pub/fedora/linux/core/6/i386/os/Fedora/RPMS/libXp-1.0.0-8.i386.rpm

# rpm -ivh libaio-0.3.106-3.2.i386.rpm

References:

http://download-uk.oracle.com/docs/cd/B19306_01/install.102/b15660/toc.htm

http://www.puschitz.com/InstallingOracle10g.shtml

http://ivan.kartik.sk/oracle/install_ora10gR2_fedora.html


Regards,
Sabdar Syed.

3 comments:

Varun said...

hi, i m trying to install oracle 10g on my amd athlon machine -32 bit. i have 778 mb ram. os fedora core 3. all the packages are installed well (although the versions are higher);i think tha's fine. but while runing the installer i get "./runInstaller: line 54: /etc/ora10g/database/install/.oui: No such file or directory". altough when i run ls command i see the runInstaller listed there. The database dump is stored at /etc/ora10g folder from where i m trying to run the installer..
plz help..looking fr an answer..

node73 said...

I am also getting the "line 54: /etc/ora10g/database/install/.oui: No such file or directory" error. Were you ever able to get bast it?
Node

Sabdar Syed said...

Have you carefully followed all the steps of Installation??

Looks like Permissions/Directory creations are wrong.

There is a discussion regarding this error in OTN, pls check the below link.

http://forums.oracle.com/forums/thread.jspa?threadID=622791&tstart=0

Regards,
Sabdar Syed.