Red Hat ENTERPRISE LINUX AS 2.1 - Guida di Installazione

Red Hat EnterpriseLinux 5.1Red Hat Enterprise LinuxOracle Tuning GuideTuning and optimizing performance tips and guidelines for Oracle®9i and 10g data

4

Chapter 26. Installing Oracle Database 10g94ocr1 (36006016054141500beac25dcc436dc11) [size=1 GB][features="0"][hwhandler="1 emc"]

Installing Oracle 10gR2 Cluster Ready Services (CRS) with MPIO95/dev/raw/raw1 8 33/dev/raw/raw2 8 49/dev/raw/raw3 8 65/dev/raw/raw4 8 97/dev/r

Chapter 26. Installing Oracle Database 10g96#/dev/raw/raw1 8 33#/dev/raw/raw2 8 49#/dev/raw/raw3 8 65#/dev/raw/raw4 8 97#/dev/raw/raw5 8 113Check

Starting Oracle Universal Installer97/dev/raw/raw1: bound to major 253, minor 25/dev/raw/raw2: bound to major 253, minor 21/dev/raw/raw3: bound to

Chapter 26. Installing Oracle Database 10g98$ su - root# mount /mnt/cdromOn Red Hat Enterprise Linux 3 and 4 execute:$ su - root# mount /media/cdromTo

Using Oracle Universal Installer (OUI)99Then click Continue- Product-specific Prerequisite Checks:Verify that all checks have been passed.Make sure th

Chapter 26. Installing Oracle Database 10g100- SummaryClick InstallIf Enterprise Manager configuration fails due to port allocation problems, read Cha

Updating after the Oracle Universal Installer101export ORACLE_HOME=$ORACLE_BASE/product/10.1.0/db_1export PATH=$PATH:$ORACLE_HOME/bin export LD_LIBRAR

102

Chapter 27.103Oracle Post Installation TasksImportantBefore you continue, make sure you followed the steps at Section 26.5, “Updating afterthe Oracle

Chapter 2.5Hardware Architectures and LinuxKernels2.1. GeneralWhen it comes to large databases the hybrid x86-64 architecture platform is strongly rec

Chapter 27. Oracle Post Installation Tasks104If you selected "Database Control for Database Management", then the Oracle Enterprise ManagerD

Chapter 28.105Tips and Hints for Oracle 10g on RedHat Enterprise LinuxTo reinstall Oracle 10g after a failed installation attempt, you might want to e

106

Chapter 29.107Oracle 10g and Linux InstallationErrors and TroubleshootingThis chapter presents many common Oracle 10g problems and other issues.NoteMo

Chapter 29. Oracle 10g and Linux Installation Errors and Troubleshooting108Checking for filemax=65536; found filemax=26163. Failed <<<<Inc

109su - root init 3 init 5If you are using telnet you will have to set the DISPLAY variable manually.Recovery Manager(rman) hangsYou are probably runn

Chapter 29. Oracle 10g and Linux Installation Errors and Troubleshooting110libs-6.8.2-1.EL.13.6.i386.rpm). The installation depends on the following p

111Error while loading shared libraries: libaio.so.1: cannot open shared object file: Nosuch file or directoryMake sure the libaio RPM is installed.On

Chapter 29. Oracle 10g and Linux Installation Errors and Troubleshooting112The log file shows the following error: INFO: Creating /u01/app/oracle/orac

113ORA-12547: TNS:lost contactThere can be many reasons for this error. This can happen during the ASM instance start up when thelibaio RPM is not ins

Chapter 2. Hardware Architectures and Linux Kernels6If you install the Red Hat Enterprise Linux 3, 4 or 5 hugemem kernel ensure that any proprietarydr

114

Part III. Installing the Oracle9i 32 bitDatabase on Red Hat Enterprise LinuxIntroduction and Information onSupported Setups for Oracle 9iThis article

Chapter 30.117Preparing Red Hat Enterprise Linux foran Oracle Database InstallationThis chapter will guide you though the pre-installation procedures

Chapter 30. Preparing Red Hat Enterprise Linux for an Oracle Database Installation11830.3. Setting Shared MemoryFor Oracle9i installations, the maximu

Chapter 31.119Verifying Required Packages(RPMs)You will need certain RPM development packages for the Oracle installer to build Oracle modules,otherwi

Chapter 31. Verifying Required Packages(RPMs)12031.3. Required Packages for Red Hat Enterprise Linux 4Ensure the following packages are installed by e

Required Packages for Red Hat Enterprise Linux 4121 gnome-libs-devel-1.4.1.2.90-44.1.i386.rpm \ ORBit-0.5.17-14.i386.rpm \

122

Chapter 32.123Setting Up a Working Environment forOracleThis chapter covers the creation of user accounts, directories and Oracle environments for you

Chapter 3.7Kernel UpgradesMake sure to install the latest kernel where all proprietary drivers, if applicable, are certified andsupported. Note that p

Chapter 32. Setting Up a Working Environment for Oracle124export ORACLE_BASE=/u01/app/oracleexport ORACLE_HOME=$ORACLE_BASE/product/9.2.0export ORACLE

Chapter 33.125Starting runInstallerAn important point to note...If you use CDs to install the database, do not change directory (cd) to /mnt/cdrom toe

126

Chapter 34.127Installing Oracle9i R2 (9.2.0.1.0) on RedHat Advanced Server 2.1You may get one or more errors during the Oracle installation. If you en

128

Chapter 35.129Installing Oracle9i R2 (9.2.0.4.0) on RedHat Enterprise Linux 3In order to install an Oracle9i R2 database on Red Hat Enterprise Linux 3

Chapter 35. Installing Oracle9i R2 (9.2.0.4.0) on Red Hat Enterprise Linux 3130To resolve the __libc_wait symbol issue, download the p3006854_9204 pat

Installing Oracle9i R2 (9.2.0.1.0) on Red Hat Enterprise Linux 3131- Inventory Location: Click Next- Unix Group Name: Use "oinstall"Click Ne

Chapter 35. Installing Oracle9i R2 (9.2.0.4.0) on Red Hat Enterprise Linux 3132/usr/bin/ld: ctxhx: hidden symbol `stat' in /usr/lib/libc_nonshare

Patching Oracle9i to 9.2.0.4.0 on Red Hat Enterprise Linux 3133- Welcome Screen: Click Next- File Locations: Use default values- Available Products: S

Chapter 3. Kernel Upgrades8 initrd /initrd-2.4.21-32.0.1.ELsmp.imgIn this example, the "default" attribute is set to "0" which mea

Chapter 35. Installing Oracle9i R2 (9.2.0.4.0) on Red Hat Enterprise Linux 3134$ dbca35.3. Patching Oracle Intelligent Agent on Red HatEnterprise Linu

Patching Oracle Intelligent Agent on Red Hat Enterprise Linux 3135$ su - oracle$ cd $ORACLE_HOME/network/lib$ make -f ins_oemagent.mk installNow you s

136

Chapter 36.137Installing Oracle9i R2 (9.2.0.6.0) on RedHat Enterprise Linux 4In order to install Oracle9i Release 2 (9.2.0.6), the 9.2.0.6 patch set m

Chapter 36. Installing Oracle9i R2 (9.2.0.6.0) on Red Hat Enterprise Linux 4138- Summary: Start the Install36.2. Patching Oracle9i R2 to 9.2.0.6.0 on

Patching Oracle9i R2 to 9.2.0.6.0 on Red Hat Enterprise Linux 4139su - oracle$ echo $LD_ASSUME_KERNEL # it is important that this variable is set!2

140

Chapter 37.141Starting and Shutting down theOracle9i DatabaseThis chapter shows two separate ways to start and shut down an Oracle9i Database; Using S

Chapter 37. Starting and Shutting down the Oracle9i Database142cp /u01/app/oracle/admin/test/pfile/inittest.ora.642002224936 \$ORACLE_HOME/dbs/inittes

Chapter 38.143Oracle Installation ErrorsThis chapter covers many common errors and pitfalls associated with installing an Oracle9i Database.Log FilesA

Chapter 4.9Kernel Boot Parameters4.1. GeneralThe Linux kernel accepts boot parameters when the kernel is started. Very often it is used to provideinfo

Chapter 38. Oracle Installation Errors144INSO_LINK = -L$(CTXLIB) $(LDLIBFLAG)m `cat $(LIBHOME)/sysliblist` $(LDLIBFLAG)sc_ca $(LDLIBFLAG)sc_fa $(LDLIB

145Copyright (c) 2003 Oracle Corporation. All rights reserved.Starting Oracle Intelligent Agent.../u01/app/oracle/product/9.2.0/bin/dbsnmpwd:line 156:

Chapter 38. Oracle Installation Errors146gcc -o /u01/app/oracle/product/9.2.0/rdbms/lib/oracle \ -L/u01/app/oracle/product/9.2.0/rdbms/lib/ .../usr

147Recovery Manager(rman) HangsYou are probably running the wrong rman binary from the XFree86-devel RPM:$ which rman/usr/X11R6/bin/rmanCan't fin

Chapter 38. Oracle Installation Errors148/u01/app/oracle/jre/1.1.8/bin/../lib/i686/green_threads/libzip.so: symbol errno, versionGLIBC_2.0 not defined

149NoteIf you use newer Red Hat Enterprise Linux versions as your desktop and you want toinstall the database on another machine, then you need to set

150

Chapter 39.151Reference Listpuschitz.com1Oracle Database 10g Release 1 (10.1) Documentation2Oracle Database 10g Release 2 (10.2) Documentation 3Oracle

Chapter 39. Reference List152Oracle MetaLink Note:249213.1Oracle MetaLink Note:260152.1Oracle MetaLink Note:262004.1Oracle MetaLink Note:265194.1Oracl

153Appendix A. Revision HistoryRevision 1.00 Chris Curran [email protected] to the Red Hat standardRevision 1.01 Chris Curran ccurran@redhat

10

154

Chapter 5.11Memory Usage and Page Cache5.1. Checking the Memory UsageTo determine the size and usage of memory, you can enter the following command:gr

Chapter 5. Memory Usage and Page Cache12Alternatively, you can use sysctl(8) to change it:# sysctl -w vm.pagecache="1 15 30"To make the chan

Chapter 6.13Swap Space6.1. GeneralIn some cases it is good for the swap partition to be used. For example, long running processes oftenaccess only a s

Red Hat Enterprise Linux Oracle Tuning GuideRed Hat Enterprise Linux 5.1 Oracle 9i and 10g Tuning GuideTuning and optimizing performance tips and guid

Chapter 6. Swap Space146.2. Checking Swap Space Size and UsageYou can check the size and current usage of swap space by running the command: grepSwapT

Chapter 7.15Setting Shared MemoryShared memory allows processes to access common structures and data by placing them in sharedmemory segments. It is t

Chapter 7. Setting Shared Memory16# cat /proc/sys/kernel/shmmax2147483648The default shared memory limit for SHMMAX can be changed in the proc file sy

Removing Shared Memory17system is 2097152*4096 bytes (shmall*PAGE_SIZE) which is 8 GB. PAGE_SIZE is usually 4096bytes unless you use Chapter 14, Large

Chapter 7. Setting Shared Memory18bytes=2736783360 lpid=3688 cpid=3652 nattch=0att_time=Sat Oct 29 13:36:52 2005det_time=Sat Oct 29 13:36:52 2005chang

Chapter 8.19Setting SemaphoresSemaphores can best be described as counters which are used to provide synchronization betweenprocesses or between threa

Chapter 8. Setting Semaphores20Oracle recommends SEMMSL to be at least 32000 for 9i R2 and 10g R1/R2 databases except for9i R2 on x86 platforms where

An Example of Semaphore Settings21As shown at Section 8.3, “The SEMMNS Parameter” the maximum number of semaphores that can beallocated on a Linux sys

22

Chapter 9.23Setting File HandlesThe maximum number of file handles denotes the maximum number of open files on a Linux system.Oracle recommends that t

iiiI. Tuning and Optimizing Red Hat Enterprise Linux for Oracle Database 9i and 10g 11. Introduction

24

Chapter 10.25Adjusting Network Settings10.1. Changing Network Adapter SettingsTo check the speed and settings of network adapters, use the ethtool com

Chapter 10. Adjusting Network Settings26# sysctl -w net.core.wmem_max=262144To make the change permanent, add the following lines to the /etc/sysctl.c

Chapter 11.27Setting Shell Limits for the Oracle UserMost shells like Bash provide control over various resources like the maximum allowable number of

Chapter 11. Setting Shell Limits for the Oracle User28entire system will run out of file handles. This may prevent users logging in as the systemcanno

Limiting Maximum Number of Processes Available for the Oracle User29To see the current limit of the maximum number of processes for the oracle user, r

30

Chapter 12.31Enabling Asynchronous I/O and DirectI/O SupportAsynchronous I/O permits Oracle to continue processing after issuing I/Os requests which l

Chapter 12. Enabling Asynchronous I/O and Direct I/O Support3212.2. Relinking Oracle 10g to Enable Asynchronous I/OSupportEnsure that for 10g Release

Tuning Asynchronous I/O for Oracle 9i and 10g33filesystemio_options=asynchThis parameter is platform specific. By default, this parameter is set to no

Red Hat Enterprise Linux Oracle Tuning Guideiv13.3. Using Raw Devices for Oracle Databases ...

Chapter 12. Enabling Asynchronous I/O and Direct I/O Support34# echo 1048576 > /proc/sys/fs/aio-max-sizeAlternatively, you can use sysctl(8) to cha

Verifying Asynchronous I/O Usage35$The numbers in red (number of active objects) show whether Oracle makes asynchronous I/O calls.The output will look

36

Chapter 13.37Configuring I/O for Raw Partitions13.1. GeneralRaw partitions allow Oracle to bypass the OS cache. A raw device can be assigned or bound

Chapter 13. Configuring I/O for Raw Partitions38the alias settings in this example would not be required in Red Hat Enterprise Linux 4and 5. For more

Using Raw Devices for Oracle Databases39/dev/raw/raw100 /dev/sdz13.3. Using Raw Devices for Oracle DatabasesMany guides and documentations show instru

Chapter 13. Configuring I/O for Raw Partitions40And the /etc/sysconfig/rawdevices file would look something like this if you use EMCPowerPath:/u02/ora

Chapter 14.41Large Memory Optimization, Big Pages,and Huge PagesPlease NoteAs explained in detail in this section, enabling big pages helps reduce TLB

Chapter 14. Large Memory Optimization, Big Pages, and Huge Pages42• pages are locked in memory and are never swapped out which guarantees that shared

Configuring Huge Pages in Red Hat Enterprise Linux 343Thus, Big Pages cannot be larger than Highmem. The total amount of memory in the high region can

v20.7. Oracle 10g R1 on Red Hat Enterprise Linux 2.1 (x86) ... 8020.8. Verifying and Updating the redhat-release

Chapter 14. Large Memory Optimization, Big Pages, and Huge Pages44In Red Hat Enterprise Linux 3 the desired size of the Huge Pages pool is specified i

Configuring Huge Pages in Red Hat Enterprise Linux 4 or 545This command usually takes a while to finish.14.7. Configuring Huge Pages in Red Hat Enterp

Chapter 14. Large Memory Optimization, Big Pages, and Huge Pages46NoteIn order that an Oracle database can use Huge Pages in Red Hat Enterprise Linux

Huge Pages and Shared Memory File System in Red Hat Enterprise Linux 347On this database system the size of the database buffer cache is 2 GB:db_block

48

Chapter 15.49Growing the Oracle SGA to 2.7 GBin x86 Red Hat Enterprise Linux 2.1Without VLM15.1. GeneralDue to 32 bit virtual address limitations work

Chapter 15. Growing the Oracle SGA to 2.7 GB in x86 Red Hat Enterprise Linux 2.1 Without VLM500ab11000-0ab99000 rw-p 02ac8000 08:09 273078 /ora/produc

Lowering the Mapped Base Address for Shared Libraries in Red Hat Enterprise Linux 2.151not be above the SGA attach address, example, between 0x1500000

Chapter 15. Growing the Oracle SGA to 2.7 GB in x86 Red Hat Enterprise Linux 2.1 Without VLM52[[ ! -f ksms.s_orig ]] && cp ksms.s ksms.s_orig#

Allowing the Oracle User to Change the Mapped Base Address for Shared Libraries53Allow the oracle user to execute /usr/local/bin/ChangeMappedBase via

Red Hat Enterprise Linux Oracle Tuning Guidevi36.2. Patching Oracle9i R2 to 9.2.0.6.0 on Red Hat Enterprise Linux 4 ... 13837. St

54

Chapter 16.55Growing the Oracle SGA to 2.7/3.42 GBin x86 Red Hat Enterprise Linux 3, 4and 5 Without VLM16.1. GeneralDue to 32 bit virtual address limi

Chapter 16. Growing the Oracle SGA to 2.7/3.42 GB in x86 Red Hat Enterprise Linux 3, 4 and 5 Without VLM5608048000-0804c000 r-xp 00000000 03:45 153111

Lowering the SGA Attach Address in Oracle 10g57Red HatEnterpriseKernel Type10g DatabaseVersionDefaultSupported SGAwithout VLMMax SupportedSGA withoutV

Chapter 16. Growing the Oracle SGA to 2.7/3.42 GB in x86 Red Hat Enterprise Linux 3, 4 and 5 Without VLM58# cat /proc/3035/maps | grep SYSV50000000-aa

Chapter 17.59Using Very Large Memory (VLM)17.1. GeneralThis chapter does not apply to x86-64 (64 bit) systems.With hugemem kernels on 32 bit systems,

Chapter 17. Using Very Large Memory (VLM)60$ cat /etc/redhat-releaseRed Hat Enterprise Linux AS release 4 (Nahant Update 2)$ egrep "shm|tmpfs|ram

Configuring Very Large Memory (VLM)61use_indirect_data_buffers=true db_block_size=8192 db_block_buffers=1048576 shared_pool_size=2831155200Note that s

62

Part II. Installing the Oracle Database10g on Red Hat Enterprise LinuxIntroduction and Information onSupported Setups for Oracle 10gThis article provi

Part I. Tuning and OptimizingRed Hat Enterprise Linux forOracle Database 9i and 10g

Part II. Installing the Oracle Database 10g on Red Hat Enterprise LinuxOracle DatabaseVersionRed Hat EnterpriseLinux VersionArchitecture Comments1 (10

Chapter 18.65Downloading and Unpacking Oracle10g Installation FilesDownload Oracle 10g (32 bit and 64 bit) for Linux from the following web site: http

66

Chapter 19.67Pre-Installation Preparation andVerification19.1. Verifying Memory and Swap SpaceOracle states that the system must have at least 512MB o

Chapter 19. Pre-Installation Preparation and Verification68everything work safely, securely and accurately. This section contains a list Oracle Databa

Verifying Software Packages (RPMs)69gcc-c++-3.4.3-9.EL4glibc-2.3.4-2glibc-common-2.3.4-2gnome-libs-1.4.1.2.90-44.1libstdc++-3.4.3-9.EL4libstdc++-devel

Chapter 19. Pre-Installation Preparation and Verification70compat-gcc-7.3-2.96.128compat-gcc-c++-7.3-2.96.128compat-libstdc++-7.3-2.96.128compat-libst

Verifying Kernel Parameters71To check these RPMs, run:rpm -q make glibc gcc gcc-c++ libstdc++ openmotifFor Red Hat Enterprise Linux 3 and 2.1 it is al

Chapter 19. Pre-Installation Preparation and Verification72To verify shmmni, execute:cat /proc/sys/kernel/shmmnishmmni = 4096To verify the shmall par

Verifying Kernel Parameters73On the following versions of Red Hat Enterprise Linux 4 x86, 3 U5 x86, 3 U5 x86-64, and 2.1; youmay have to increase the

Chapter 19. Pre-Installation Preparation and Verification74To make the change permanent, add the following lines to the /etc/sysctl.conf file, which i

Chapter 20.75Installing Required Software PackagesThe following sections provide a detailed set of instructions for installing the required softwarepa

Chapter 20. Installing Required Software Packages76rpm -Uvh libaio-0.3.103-3.x86_64.rpmrpm -Uvh compat-libstdc++-33-3.2.3-47.3.x86_64.rpmrpm -Uvh glib

10g R2 on Red Hat Enterprise Linux 4 and 5 (x86)77 redhat-artwork-0.120.1-1.2E.x86_64.rpm \ scrollkeeper-0.3.14-3.x86_64.rpm \ cdrecord-2.01.

Chapter 20. Installing Required Software Packages78rpm -Uvh compat-libstdc++-33-3.2.3-47.3.i386.rpmOracle lists the control-center and xscreensaver RP

Oracle 10g R1 and R2 on Red Hat Enterprise Linux 3 (x86)7920.5. Oracle 10g R1 and R2 on Red Hat Enterprise Linux 3(x86)On Red Hat Enterprise Linux 3 x

Chapter 20. Installing Required Software Packages80 libungif-4.1.0-15.x86_64.rpmNote: Red Hat Enterprise Linux 3 x86-64 U5 does not come with a x86

Verifying and Updating the redhat-release File81it as a supported OS. However, the installer of 10g 10.1.0.3 does not recognize Red Hat EnterpriseLinu

82

Chapter 21.83Sizing Disk Space for Oracle 10gOracle says that about 2.5 GB of disk space should be reserved for the Oracle software on Linux.Here are

Chapter 1.3IntroductionThis guide covers optimizations for Red Hat Enterprise Linux x86 (32 bit) and x86_64 (64 bit)platforms running Oracle 9i R2 (32

84

Chapter 22.85Setting Shell Limits for Your OracleUserMost shells like Bash provide control over various resources like the maximum allowable number of

86

Chapter 23.87Creating Oracle User AccountsTo create the oracle account and groups, execute the following commands:su - rootgroupadd dba # gro

88

Chapter 24.89Creating Oracle DirectoriesFor Oracle 10g you only need to create the directory for $ORACLE_BASE:su - rootmkdir -p /u01/app/oraclechown o

Chapter 24. Creating Oracle Directories90/u03/oradata/<db_name_1>/u03/oradata/<db_name_2>The mount point /u01 should be used for the Oracl

Chapter 25.91Setting Oracle EnvironmentsSince the Oracle Universal Installer (OUI) "runInstaller" is run from the oracle account, someenviro

92

Chapter 26.93Installing Oracle Database 10gThis Chapter will guide you through the process of installing an Oracle 10g Database.26.1. Installing Oracl