Oracle Enterprise Linux - Oracle HRMS install notes

Submitted by code_admin on Mon, 07/16/2018 - 15:42

Install notes how I installed Oracle Enterprise Linux and Oracle HRMS machine.

Download Enterprise Linux 5 CD's (there are 5)

Install Oracle Enterprise Linux

When I installed without testing at least one CD the install hung.

Network Setup

Once I have installed Oracle Enterprise Linux 5 I set up the network. My machine is behind a consumer grade ADSL router with dynamic DNS.
I decided on a hostname for the machine as follows:
Hostname: oracle
Domain: robs_flat.com

  1. Log on to router and configure static IP address for machine
  2. Edit /etc/hosts and add an entry for the new machine
  3. Edit /etc/sysconfig/network and make this entry correct

In my example the files are as follows:
/etc/hosts

  1. # Do not remove the following line, or various programs
  2. # that require network functionality will fail.
  3. 127.0.0.1               localhost.localdomain localhost
  4. ::1             localhost6.localdomain6 localhost6
  5. 192.168.123.1          oracle.robs_flat.com  oracle

/etc/sysconfig/network

  1. NETWORKING=yes
  2. NETWORKING_IPV6=no
  3. HOSTNAME=oracle.robs_flat.com

Note: It is tempting to put 127.0.0.1 in the /etc/sysconfig/network file. I did exactly this at first but when I ran the rapidwiz install process it gave an error (RW-20019: No install actions...). The solution was putting the real ip address against oracle.robs_flat.com. I am ok with this on my instalisation but if you don't want the IP hard coded in the machine you could try replacing this with 127.0.0.1 after the install completes.
You can test some of these settings by seeing if these commands work:

  1. ping oracle
  2. ping oracle.robs_flat.com

Client Machine Network Setup

In order for windows machines to connect I had to add the Oracle server to their hosts file.
On my windows XP machine I have to edit C:\WINDOWS\system32\drivers\etc
as follows:

  1. # Copyright (c) 1993-1999 Microsoft Corp.
  2. #
  3. # This is a sample HOSTS file used by Microsoft TCP/IP for Windows.
  4. #
  5. # This file contains the mappings of IP addresses to host names. Each
  6. # entry should be kept on an individual line. The IP address should
  7. # be placed in the first column followed by the corresponding host name.
  8. # The IP address and the host name should be separated by at least one
  9. # space.
  10. #
  11. # Additionally, comments (such as these) may be inserted on individual
  12. # lines or following the machine name denoted by a '#' symbol.
  13. #
  14. # For example:
  15. #
  16. #      102.54.94.97     rhino.acme.com          # source server
  17. #       38.25.63.10     x.acme.com              # x client host
  18.  
  19. 127.0.0.1       localhost
  20. 192.168.123.159 oracle.robs_flat.com

You can test that this has worked by pinging your host and donain name e.g.:

  1. C:\Documents and Settings\Robert Metcalf>ping oracle.robs_flat.com
  2.  
  3. Pinging oracle.robs_flat.com [192.168.123.159] with 32 bytes of data:
  4.  
  5. Reply from 192.168.123.159: bytes=32 time=2ms TTL=64
  6. Reply from 192.168.123.159: bytes=32 time=1ms TTL=64
  7. Reply from 192.168.123.159: bytes=32 time=1ms TTL=64
  8. Reply from 192.168.123.159: bytes=32 time=1ms TTL=64
  9.  
  10. Ping statistics for 192.168.123.159:
  11.     Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
  12. Approximate round trip times in milli-seconds:
  13.     Minimum = 1ms, Maximum = 2ms, Average = 1ms
  14.  
  15. C:\Documents and Settings\Robert Metcalf>

Optionial - Set up Client Tools

At this point you may wish to set up putty on the client to point to the Oracle server. This gives you a SSH connection. You can also setup a tool like Filezilla so you can copy files to and from the server.

Configure public yum repistory

I found instructions at http://public-yum.oracle.com/

  1. cd /etc/yum.repos.d

Edit the file that has been downloaded and in the section [el5_ga_base] set enabled=1 (ga base = generally available base)

Check Package Versions and install

  1. rpm -qa
  2. yum install openmotif
  3. yum install sysstat
  4. yum install compat-db
  5. yum install compat-glibc

Non yum rpm's from Oracle website

  1. cd $HOME
  5. rpm -i openmotif21-2.1.30-11.EL5.i386.rpm
  6. rpm -i xorg-x11-libs-compat-6.8.2-1.EL.33.0.1.i386.rpm
  7. rpm -i binutils-2.17.50.0.6-6.0.1.el5.i386.rpm
  8. rm $HOME/*.rpm

Change SELinux to permissibe mode

If you set up SELinux when installing Linux you need to set it to permisive mode. Otherwise SELinux interferes with Oracle. If you didn't set it up then you can skip this step.

  1. vi /etc/selinux/config

Change SELINUX=enforcing to SELINUX=permissive

Change Kernal Settings

  1. vi /etc/sysctl.conf

Add lines to end:

  1. kernel.sem = 256 32000 100 142
  2. kernel.shmmni = 4096
  3. kernel.msgmni = 2878
  4. fs.file-max = 65536
  5. net.ipv4.ip_local_port_range = 10000 65000
  6. net.core.rmem_default = 262144
  7. net.core.rmem_max = 262144
  8. net.core.wmem_default = 262144

run new settings

  1. sysctl -p

Increase DNS resolver timeout

  1. vi /etc/resolv.conf

Add lines to end

  1. options attempts:5
  2. options timeout:15

Set security file limits

  1. vi /etc/security/limits.conf

Add lines to end

  1. # added for oracle
  2. * hard nofile 65535
  3. * soft nofile 4096
  4. * hard nproc 16384
  5. * soft nproc 2047

Apply patch 6078836

Download or copy the file p6078836_101330_LINUX.zip to $HOME

  1. cd $HOME
  2. unzip p6078836_101330_LINUX.zip
  3. mv $HOME/6078836/libdb.so.2 /usr/lib/.
  4. rm -rf 6078836
  5. rm p6078836_101330_LINUX.zip

Link to Motif library for Oracle Application Server 10.1.2

  1. unlink /usr/lib/libXtst.so.6
  2. ln -s /usr/X11R6/lib/libXtst.so.6.1 /usr/lib/libXtst.so.6

Downloaded the files from edelivary

I also backed these up on my external hard disk.

Create a stage12 directory and unzip the files into this directory

  1. unzip -o B53824-01_1of4.zip -d$HOME/stage12
  2. unzip -o B53824-01_2of4.zip -d$HOME/stage12
  3. unzip -o B53824-01_3of4.zip -d$HOME/stage12
  4. unzip -o B53824-01_4of4.zip -d$HOME/stage12
  5. unzip -o V15564-01_1of3.zip -d$HOME/stage12
  6. unzip -o V15564-01_2of3.zip -d$HOME/stage12
  7. unzip -o V15564-01_3of3.zip -d$HOME/stage12
  8. unzip -o V15565-01_1of2.zip -d$HOME/stage12
  9. unzip -o V15565-01_2of2.zip -d$HOME/stage12
  10. unzip -o V15566-01_1of3.zip -d$HOME/stage12
  11. unzip -o V15566-01_2of3.zip -d$HOME/stage12
  12. unzip -o V15566-01_3of3.zip -d$HOME/stage12
  13. unzip -o V15567-01_1of3.zip -d$HOME/stage12
  14. unzip -o V15567-01_2of3.zip -d$HOME/stage12
  15. unzip -o V15567-01_3of3.zip -d$HOME/stage12
  16. unzip -o V15568-01_1of3.zip -d$HOME/stage12
  17. unzip -o V15568-01_2of3.zip -d$HOME/stage12
  18. unzip -o V15568-01_3of3.zip -d$HOME/stage12
  19. unzip -o V15569-01_1of3.zip -d$HOME/stage12
  20. unzip -o V15569-01_2of3.zip -d$HOME/stage12
  21. unzip -o V15569-01_3of3.zip -d$HOME/stage12
  22. unzip -o V15570-01_1of3.zip -d$HOME/stage12
  23. unzip -o V15570-01_2of3.zip -d$HOME/stage12
  24. unzip -o V15570-01_3of3.zip -d$HOME/stage12
  25. unzip -o V15571-01_1of3.zip -d$HOME/stage12
  26. unzip -o V15571-01_2of3.zip -d$HOME/stage12
  27. unzip -o V15571-01_3of3.zip -d$HOME/stage12
  28. unzip -o V15572-01_1of3.zip -d$HOME/stage12
  29. unzip -o V15572-01_2of3.zip -d$HOME/stage12
  30. unzip -o V15572-01_3of3.zip -d$HOME/stage12
  31. unzip -o V15573-01_1of3.zip -d$HOME/stage12
  32. unzip -o V15573-01_2of3.zip -d$HOME/stage12
  33. unzip -o V15573-01_3of3.zip -d$HOME/stage12
  34. unzip -o V15574-01_1of3.zip -d$HOME/stage12
  35. unzip -o V15574-01_2of3.zip -d$HOME/stage12
  36. unzip -o V15574-01_3of3.zip -d$HOME/stage12
  37. unzip -o V15575-01.zip -d$HOME/stage12
  38. unzip -o V15576-01_1of3.zip -d$HOME/stage12
  39. unzip -o V15576-01_2of3.zip -d$HOME/stage12
  40. unzip -o V15576-01_3of3.zip -d$HOME/stage12

Make all the installed filed executable:

  1. chmod -R +x $HOME/stage12

Create oracle user

You should log in as the root user and create another user called oracle.
Click here for screenshots of creating the oracle user

Create install dir

You have to be root to do this.

  1. cd /
  2. mkdir d01
  3. chown oracle d01
  4. chgrp oracle d01

Restart the system

Log in as oracle user and run rapid install from Start CD

From a terminal run

  1. cd startCD/Disk1/rapidwiz/rapidwiz
  2. ./rapidwiz

Click here for screenshots of the install process
When filling out the dialogs I entered
Hostname: oracle
Domain Name: robs_flat.com
Both were entered in two places.
Note: If you get an error saying no install actions are found it might be caused by having 127.0.0.1 against the host in the hosts file. (See mention of this above)

Start DB Commands

  1. cd /d01/oracle/VIS/db/tech_st/11.1.0/appsutil/scripts/VIS_oracle

Start the Listner

  1. ./addlnctl.sh start VIS

Start the DB

  1. ./addbctl.sh start VIS

Now start the apps server:

  1. cd /d01/oracle/VIS/inst/apps/VIS_oracle/admin/scripts
  2. ./adstrtal.sh

Open up firewall

Oracle uses various ports which I add to the firewall. System -> Administration -> Security level and firewall.
The ports I have added are:
8000
1521

User names

Application Usernames:
• SYSADMIN/sysadmin
• MFG/welcome
• OPERATIONS/welcome
• SERVICES/welcome
• MRC/welcome
• HRMS/welcome

Where is tnsnames.ora?

It is on the server in $ORACLE_HOME/network/admin
on my system /d01/oracle/VIS/apps/tech_st/10.1.2/network/admin

Other Stuff

Oracle install notes

Tags

RJM Article Type
Work Notes