Tips and Techniques: Install and Configure Oracle9i on Red Hat Linux Advanced Server An Oracle White Paper August 2002
Tips and Techniques: Install and Configure Oracle9i on Red Hat Linux Advanced Server EXECUTIVE OVERVIEW........................................................................... 3 TERMINOLOGY ............................................................................................ 3 INSTALLATION OF RED HAT ADVANCED SERVER 2.1 ............. 4 Installation steps for Red Hat Advanced Server 2.1................................ 4 Install Tips for Red Hat Advanced Server 2.1...................................
Tips and Techniques: Install and Configure Oracle9i on Red Hat Linux Advanced Server EXECUTIVE OVERVIEW Red Hat Linux Advanced Server is an enterprise ready platform, borne out of feedback and close collaboration between the engineering teams from Oracle and Red Hat.
Tips and Techniques: Install and Configure Oracle9i on Red Hat Linux Advanced Server highpte Kernel patch which allows putting pte-s into highmem enterprise kernel Kernel that can support VLM SMP kernel Kernel that can support only up to 4GB VM OEM Oracle Enterprise Manager SGA Shared Global Area for oracle instance RH Red Hat AS Advanced Server OS Operating System bigpages Kernel feature to enable large page size for shared memory pages INSTALLATION OF RED HAT LINUX ADVANCED SERVER 2.
Tips and Techniques: Install and Configure Oracle9i on Red Hat Linux Advanced Server The first three modes are for older systems, which have lower video card memory and lower resolution monitors. The Expert mode is used when hardware autoprobing fails. This mode would take complete control over the installation process. Rescue mode is used when the machine doesn’t boot off the hard disk and no bootable floppy disk is available.
Tips and Techniques: Install and Configure Oracle9i on Red Hat Linux Advanced Server 6. The following choices are available for Boot Loader. LILO or GRUB could be chosen, based on the expertise of the administrator. - GRUB - LILO - no boot loader 7. The next step is to configure the network. Generally, Static IP address is assigned to the server on which the Oracle9i R2 database is deployed. If DHCP is chosen, the install automatically gathers the network information to configure the same.
Tips and Techniques: Install and Configure Oracle9i on Red Hat Linux Advanced Server Selection of GNOME and KDE package group selection is helpful. To select additional RPM packages that are not part of standard Advanced Server install, the “select individual package” option needs to be chosen. 13.
Tips and Techniques: Install and Configure Oracle9i on Red Hat Linux Advanced Server • If machine has <= 4 GB memory SMP kernel will be installed and if machine has > 4 GB memory enterprise kernel will be installed. If the install of debug kernel is desired in a testing environment, the debug kernel is available only for SMP version. (i.e. highmem is enabled, but PAE36 is not, so it ignores memory over 4GB.) • It is highly recommended to use disk druid for disk layouts.
Tips and Techniques: Install and Configure Oracle9i on Red Hat Linux Advanced Server #rpm -qa|grep binutils (binutils-2.11.90.0.8-12) If the system is installed with the Red Hat Advanced Server, then binutils2.11.90.0.8-12 version is installed on it. 2) The binutils-2.11.90.0.8-13.i386.rpm could be downloaded from Oracle Metalink (ARU) or OTN site. The binutils on the system is upgraded using the following command. #rpm -Uvh --force binutils-2.11.90.0.8-13.i386.
Tips and Techniques: Install and Configure Oracle9i on Red Hat Linux Advanced Server happens with bigpages in shared memory file system (shmfs). But, SGA of more than 8GB can be created using bigpages in SYSV. This problem is fixed in errata e.8 kernel. Database creation failure If database creation fails, either during install or using dbca, the potential error/warning is due to some default kernel parameters. The following error generally indicates a wrong setting for SHMMAX and semaphore parameters.
Tips and Techniques: Install and Configure Oracle9i on Red Hat Linux Advanced Server Oracle Software. After choosing to continue the install, Installer would prompt the user to run a script as root, to proceed further with interviewing for file locations. The File Locations screen queries the user for name and location of Oracle home. The Oracle home is the location where the Oracle9i R2 binaries and configuration files would be installed.
Tips and Techniques: Install and Configure Oracle9i on Red Hat Linux Advanced Server TUNING OF RED HAT LINUX ADVANCED SERVER FOR ORACLE In this section, tuning of various Red Hat Advanced Server 2.1 kernel parameters is explained. Many of the parameters related to the new features introduced in the Red Hat Advanced Server are discussed. The significance of these kernel parameters to Oracle and the range of workable values that could be set are detailed.
Tips and Techniques: Install and Configure Oracle9i on Red Hat Linux Advanced Server Shared memory file system on /dev/shm (shmfs): To create large SGA size > 1.7 GB Shared memory file system (shmfs) is used. Following commands could be used to create Shared memory file system (shmfs) and these need to be added to /etc/rc.local. User could also create Shared memory file system (shmfs) using /etc/fstab.
Tips and Techniques: Install and Configure Oracle9i on Red Hat Linux Advanced Server VLM_WINDOW_SIZE This is an undocumented feature and works only with lowering mapped base. This variable could be set in Oracle user profile file. Increasing VLM_WINDOW_SIZE has reflected very little performance improvement. It could be set by executing, export VLM_WINDOW_SIZE=1073741824 (size in bytes, default is 512 MB) Bigpages This feature of Advanced Server generates pages of size 4MB Vs the regular 4KB.
Tips and Techniques: Install and Configure Oracle9i on Red Hat Linux Advanced Server Process: Maximum number of 16384 processes, per user, can be set by executing ulimit -u 16384 Semaphore Recommended values for various semaphore variables are as follows: SEMMSL - The largest PROCESSES parameter of any Oracle database on the system plus ten.
Tips and Techniques: Install and Configure Oracle9i on Red Hat Linux Advanced Server hostname resolution might fail, which could potentially result in loss of Oracle sqlnet connection. The solution is to increase the number of attempts and timeout to 5 and 15 Sec respectively, in the network configuration. The following lines are added to /etc/resolv.conf: options attempts:5 options timeout:15 MONITORING For fine-tuning database parameters in init.
Tips and Techniques: Install and Configure Oracle9i on Red Hat Linux Advanced Server Certain files and tools provide good starting point for analyzing the state of the system. /var/log/messages is one of them. For problems related to loading drivers, dmesg, lspci and lsmod are very useful. Utilities like strace and ltrace are also available.
Tips and Techniques: Install and Configure Oracle9i on Red Hat Linux Advanced Server send SIGKILL to everything including init l change the console loglevel 0-9 Serial console and network based debugging become significant when the local logging mechanisms, like klogd and syslogd fail. This could happen when there is a device driver or filesystem problem which has affected the /var filesystem. Serial Console To debug using serial console, /etc/lilo.
Tips and Techniques: Install and Configure Oracle9i on Red Hat Linux Advanced Server a highly reliable, robust, scalable and enterprise ready “Unbreakable” Oracle on Linux. The key to successful deployment of Oracle on Linux is to install and configure the Advanced Server to provide an environment for Oracle to work well.
Tips and Techniques: Install and Configure Oracle9i on Red Hat Linux Advanced Server Tips and Techniques: Install and Configure Oracle9i on Red Hat Linux Advanced Server [August] 2002 Author: Deepak Patel Contributing Authors: Oracle Corporation World Headquarters 500 Oracle Parkway Redwood Shores, CA 94065 U.S.A. Worldwide Inquiries: Phone: +1.650.506.7000 Fax: +1.650.506.7200 www.oracle.com Oracle is a registered trademark of Oracle Corporation.
