In this article I'll describe the installation of Oracle Database 10g Release 2 (10.2.0.1) on Red Hat Enterprise Linux 5 (RHEL5). The article is based on a server installation similar to this, with a minimum of 2G swap, secure Linux disabled and the following package groups installed.

Hosts File

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

127.0.0.1 localhost.localdomain localhost

::1 localhost6.localdomain6 localhost6

192.165.1.135 OWB.xxxxxxxx.com OWB

Set Kernel Parameters

Run

[root@OWB oracle]# echo "536870912" > /proc/sys/kernel/shmmax

[root@OWB oracle]# cat /proc/sys/kernel/shmmax

536870912

[root@OWB oracle]# /sbin/sysctl -p

[root@OWB oracle]# echo "kernel.shmmax=536870912" >> /etc/sysctl.conf

[root@OWB oracle]# /sbin/sysctl -p

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
net.core.rmem_default=262144
net.core.rmem_max=262144
net.core.wmem_default=262144
net.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.

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

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

session 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 > Security Level and Firewall). Click on the SELinux tab and disable the feature.

Setup

Install the following packages.

rpm -Uvh setarch-2*
rpm -Uvh make-3*
rpm -Uvh glibc-2*
rpm -Uvh libaio-0*
rpm -Uvh compat-libstdc++-33-3*
rpm -Uvh compat-gcc-34-3*
rpm -Uvh compat-gcc-34-c++-3*
rpm -Uvh gcc-4*
rpm -Uvh libXp-1*
rpm -Uvh openmotif-2*
rpm -Uvh compat-db-4*

Create the new groups and users.

groupadd oinstall
groupadd dba
groupadd oper

useradd -g oinstall -G dba oracle
passwd oracle

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

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

Edit the "/etc/redhat-release" file replacing the current release information (Red Hat Enterprise Linux Server release 5 (Tikanga)) with the following:

redhat-4

# 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/dbhome_1; export ORACLE_HOME
ORACLE_SID=xxxxx; 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

Installation

export DISPLAY=<machine-name>:0.0

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

[oracle@OWB database]$ ./runInstaller

Starting Oracle Universal Installer...

Checking installer requirements...

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

Passed

All installer requirements met.

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2016-10-09_02-07-29PM. Please wait ...[oracle@OWB database]$ Oracle Universal Installer, Version 10.2.0.1.0 Production

During the installation enter the appropriate ORACLE_HOME and name then continue installation. For a more detailed look at the installation process, click on the links below to see screen shots of each stage.

Finish the database installation.

*********************************************************************************************************************************************************

BUG:

Operating system environment: the Oracle Server Release 5.7 the Linux x86_64

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi

During the installation Oracle installation process, dbca build instance, and encountered the following error: ORA-27125: unable to create shared memory segment

Analyze and solve:

After experiencing success ORACLE installation, startup ORA-27125 error encountered before, also in blog ORA-27125: unable to create shared memory segment and blog ORA-27125 which recorded before, so in accordance with the solution to do the following actions:

[root@OWB oracle]# id oracle

uid=500(oracle) gid=504(oinstall) groups=504(oinstall),505(dba),503(oper)

[root@OWB oracle]# more /proc/sys/vm/hugetlb_shm_group

[root@OWB oracle]# echo 505 > /proc/sys/vm/hugetlb_shm_group

[root@OWB oracle]# more /proc/sys/vm/hugetlb_shm_group

505

[root@OWB oracle]#

*********************************************************************************************************************************************************

[oracle@OWB ~]$ lsnrctl status

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 11-OCT-2016 12:50:32

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.135)(PORT=1521)))

STATUS of the LISTENER

------------------------

Alias LISTENER

Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production

Start Date 11-OCT-2016 12:40:36

Uptime 0 days 0 hr. 9 min. 55 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u01/app/oracle/product/10.2.0/dbhome_1/network/admin/listener.ora

Listener Log File /u01/app/oracle/product/10.2.0/dbhome_1/network/log/listener.log

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.135)(PORT=1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Services Summary...

Service "ITDQF" has 1 instance(s).

Instance "ITDQF", status READY, has 1 handler(s) for this service...

Service "ITDQFXDB" has 1 instance(s).

Instance "ITDQF", status READY, has 1 handler(s) for this service...

Service "ITDQF_XPT" has 1 instance(s).

Instance "ITDQF", status READY, has 1 handler(s) for this service...

The command completed successfully

[oracle@OWB ~]$

Post Installation

Edit the "/etc/redhat-release" file restoring the original release information.

Red Hat Enterprise Linux Server release 5 (Tikanga)

Edit the "/etc/oratab" file setting the restart flag for each instance to 'Y'.

ITDQF:/u01/app/oracle/product/10.2.0/db_1:Y

Gagandeep virk

Oracle Database 10g Release 2 (10.2.0.1) Installation On Red Hat Enterprise Linux 5 (RHEL5)

In this article I'll describe the installation of Oracle Database 10g Release 2 (10.2.0.1) on Red Hat Enterprise Linux 5 (RHEL5). The article is based on a server installation similar to this, with a minimum of 2G swap, secure Linux disabled and the following package groups installed.

Hosts File

Set Kernel Parameters

Setup

Installation

Post Installation

No comments:

Post a Comment