CONFIGURACION DE REDHAT AS4 PARA ORACLE

[Luis Antonio Orellana Mayorga]

DESEMPACAR ESTOS ARCHIVOS CON COMANDO LINUX

gunzip ship.db.cpio.gz

cpio -idmv < ship.db.cpio

You should now have a single directory (Disk1) containing installation
files.
Hosts File
The /etc/hosts file must contain a fully qualified name for the
server:

<IP-address> <fully-qualified-machine-name> <machine-name>

PARAMETRIZAR EL KERNEL DEL REDHAT

Add the following lines to the /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

REINICIAR EL ARCHIVO DE CONFIGURACION PARA APLICAR VALORES

/sbin/sysctl -p

AGREGAR LAS LINEAS SIGUIENTES EN LOS LIMITES
Add the following lines to the /etc/security/limits.conf file:

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

AGREGAR ESTA LINEA SI ES NECESARIO
Add the following line to the /etc/pam.d/login file, if it does not
already exist:

session required pam_limits.so

Note by Kent Anderson: In the event that pam_limits.so cannot set
privilidged limit settings see Bug 115442.

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

SELINUX=disabled

INSTALAR LOS RPMS QUE SE ENCUENTRAN EN LOS DISCOS O BAJARLOS EN
SOURCEFORGET O ORACLE-BASE
Alternatively, this alteration can be done using the GUI tool
(Applications > System Settings > Security Level). Click on the
SELinux tab and disable the feature.
Setup
Install the following packages:

# From RedHat AS4 Disk 2
cd /media/cdrom/RedHat/RPMS
rpm -Uvh setarch-1*
rpm -Uvh compat-libstdc++-33-3*

# From RedHat AS4 Disk 3
cd /media/cdrom/RedHat/RPMS
rpm -Uvh openmotif-2*
rpm -Uvh compat-db-4*

# From RedHat AS4 Disk 4
cd /media/cdrom/RedHat/RPMS
rpm -Uvh compat-gcc-32-3*
rpm -Uvh compat-gcc-32-c++-3*

CREACION POR MEIDO DE TERMINAL LOS SIGUIENTES GRUPOS Y USUARIOS
Create the new groups and users:

groupadd oinstall
groupadd dba
groupadd oper

useradd -g oinstall -G dba oracle
passwd oracle

CREAR LOS DIRECTORIOS PARA QUE CONTENGAN LA INSTALAICON DE ORACLE
Create the directories in which the Oracle software will be installed:

mkdir -p /u01/app/oracle/product/10.1.0/db_1
chown -R oracle.oinstall /u01

LOGGEAR COMO ROOT (SU -ROOT)
Login as root and issue the following command:

xhost +<machine-name>

EDITAR CON VI O NANO EL ARCHIVO SIGUIENTE Y COMENTARIAR SI ESTAMOS EN
UN REDHAT 4 Y PONER REDHAT 3 ASI EL ORACLE JALA

Edit the /etc/redhat-release file replacing the current release
information (Red Hat Enterprise Linux AS release 4 (Nahant)) with the
following:

redhat-3

IMPORTAR O ESCRIBIR EN EL .BASH_PROFILE QUE ESTA OCULTO ESTOS
PARAMETROS
PARA NO DESABILITAR QUE ESTE OCULTO PODEMOS VER DONDE ESTA UBICADO EN
LA RAIZ Y EDITARLO CON UN NANO.

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

# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR

ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/10.1.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
#LD_ASSUME_KERNEL=2.4.1; export LD_ASSUME_KERNEL

if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi

REVISAR SI EL MODO GRAFICO ESTA ADECUADO PARA LEVANTAR EL INSTALLATION
DEL ORACLE
REVISAMOS CON UN XHOST COMO PRUEBA O UN XCLOCK

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

DISPLAY=<machine-name>:0.0; export DISPLAY

BUSCAMOS LA CARPETA DONDE SE ENCUENTRA EL ORACLE YA DESEMPAQUETADO
PREVIAMENTE
Y CORREMOS EL RUNINSTALLER EN UNA TERMINAL Y NO NOS DEBERIA PEDIR PRE
REQUISITOS

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

./runInstaller

During the installation enter the appropriate ORACLE_HOME and name
then continue with a "software only" installation.
Post Installation
Create a new instance using the DBCA. If you get the "ORA-27125:
unable to create shared memory segment" error when using the DBCA
issue the following commands as the oracle user then try again:

cd $ORACLE_HOME/bin

mv oracle oracle.bin

cat >oracle <<"EOF"
#!/bin/bash

export DISABLE_HUGETLBFS=1
exec $ORACLE_HOME/bin/oracle.bin $@
EOF

chmod +x oracle

I didn't encounter the previous issue myself, so hopefully you won't
either.

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

Red Hat Enterprise Linux AS release 4 (Nahant)

Finally edit the /etc/oratab file setting the restart flag for each
instance to 'Y':

TSH1:/u01/app/oracle/product/10.1.0/db_1:Y

For more information see:

* Oracle Database Installation Guide 10g Release 1 (10.1) for UNIX
Systems
* Installing Oracle Database 10g on Red Hat Enterprise Linux AS 3
and 2.1, Red Hat 9, and on Red Hat Fedora Core 1
* Oracle on Linux
* Automating Database Startup and Shutdown on Linux


CON ESTO TENDRIAMOS LA CONFIGURACION DE UN REDHAT 4 AS CON VERSION DEL
ORACLE DE 64 BITS 10G