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*
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
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
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
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.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 Copyright (C) 1999, 2005, Oracle. All rights reserved. |
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
0
[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 Copyright (c) 1991, 2005, Oracle. All rights reserved. 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
No comments:
Post a Comment