This document is written for Red Hat Enterprise Linux AS release 4 and ORACLE 10g. Earlier releases can be installed using this document as well however there are some additional steps for packages to be installed see Metalink.
Disclaimer: I have had very good luck with this procedure however: The Material may contain inaccuracies or typographical errors. I make no representations about the accuracy, reliability, completeness, or timeliness of the Material or about the results to be obtained from using the Site and the Material. The use of this Material is entirely at your own risk.
Disk Partitioning: Due to experiences I have had with lost volumes I now separate the database files from the OS and Oracle software installs and the backups. The below table shows the partitioning scheme that I used:
Configure Network settings and initial users: I assigned the static public ip’s, which are site specific to each node. I also assigned their proxy and gateway settings as appropriate for our network. Firewall On with ssh and ftp and SE Linux On were selected because our database servers are exposed to our statewide firewall. Entered a root password and created an account for the server admin later we create the oracle user manually.
Package installation (Custom Packages): I have found that performing custom package selection save time later. I selected not to install these items because we intend these servers to be Oracle Database servers only.
-Remove web servers (Oracle installs it’s own)
-Remove windows file server
I added these two items to allow me to maintain our server inside our firewalls.
-Add FTP server
-Add Legacy Network Server
-Add Software Development, X window, GNOME & Legacy development
Connecting and finishing steps: Here I simply followed on screen steps as presented by the RED HAT installation though rebooting and logging in as root and finishing the Red Hat installation.
Create the Oracle user and home directory: Issue these commands to create the oracle user and its directories:
FTP, and Telnet services
Perform these steps as root.
In the text file /etc/vsftpd/vsftpd.conf I changed two lines and added 3. Since the file is long only the two lines changed and 3 added lines are shown.
Note: The public ip addresses that begin with 172. are site specific to our site at other locations you will have differing ip addresses.
Reboot and verify that the FTP, and Telnet services all work.
Perform these tests as the Oracle user.
1. Telnet in to the server to verify ssh works.
2. Open an ftp session with the server to verify that FTP works.
Kernel system parameters: Perform these steps as the root user.
Edit the file /etc/sysctl.conf
# Kernel sysctl configuration file for Red Hat Linux## For binary values, 0 is disabled, 1 is enabled. See sysctl(8) and# sysctl.conf(5) for more details.# Controls IP packet forwardingnet.ipv4.ip_forward = 0# Controls source route verificationnet.ipv4.conf.default.rp_filter = 1# Controls the System Request debugging functionality of the kernel# Oracle changed kernel.sysrq to 1 from 0kernel.sysrq = 1# Controls whether core dumps will append the PID to the core filename.# Useful for debugging multi-threaded applications.kernel.core_uses_pid = 1# Oracle settings for clusternet.core.rmem_default=262144net.core.rmem_max=262144net.core.wmem_default=262144net.core.wmem_max=262144kernel.hostname = db1.dep.govkernel.domainname = dep.govkernel.sem = 256 32000 100 150kernel.shmmax = 4294967295kernel.shmmni = 4096kernel.shmseg = 4096kernel.shmall = 3279547fs.file-max = 327679kernel.msgmni = 2878kernel.msgmnb = 65536net.ipv4.ip_local_port_range = 1024 65000
Change the Kernel.sysreq to 1
Add the lines shown after the "# Oracle settings for cluster" line.
Note that the server hostnames and domain names are different for each install in the lines:
kernel.hostname = db1.dep.gov
kernel.domainname = dep.gov
Reboot to have these take effect and verify each one by the following commands:
Oracle login scripts: Perform these steps as the oracle user.
Insure the environment variable setting by the following login scripts for both bash and csh.
Create or edit file /u01/home/oracle/ .bash_profile to have the following:
# .bash_profile# Get the aliases and functionsif [ -f ~/.bashrc ]; then . ~/.bashrcfi# User specific environment and startup programsPATH=$PATH:$HOME/binulimit -n 65536umask 022export PATHunset USERNAMEexport ORACLE_HOME=/u01/app/oracle/product/102export ORACLE_SID=db1_erisdevexport PATH=/u01/app/oracle/product/102/bin:$PATHexport ORACLE_TERM=xtermexport TMPDIR=/tmp
Note the line export ORACLE_SID is specific to your install, as is your desired location of files.
Install Packages missed by the Red Hat install. The Oracle Universal Installer will inform you of any missing packages needed.
I accomplished this step by copying the RedHat/RPMS directory from all of the Red Hat OS install disks to a single directory and then installed from there. Alternately you can load each cd to determine which cd the required file is on. A third way is to download the needed package from Red Hat Network once identified.
Use rpm –q to see which packages are already installed and then install the missing package using rpm –i
Configure VNC server VNC is a free program that allows you to use the X window desktop on another computer. See
www.vnc.com for vnc clients and more information
Open firewall using lokkit and enter under other with comma delimited list of port and tcp or udp.
For example : 1521:tcp 5901:tcp 1500:tcp
1521 for Oracle
5901 and 1500 for ….
Optional if you want it always on