ORACLE10G_RHEL5 installation Process

1. Check memory, at least 1G

#free-M

2. Check the swap partition, which is usually twice the memory

#grep Swaptotal/proc/meminfo

3. Check the CPU

#grep "model name"/proc/cpuinfo

4. Check/tmp, at least 1G

#df-H/tmp

5. Database software and data disk space requirements

Installation Type requirement for software Files (GB)

Enterprise Edition 3.95

Standard Edition 3.88

Installation Type requirement for Data Files (GB)

Enterprise Edition 1.7

Standard Edition 1.5

#df-H

#fdisk-L

6. Operating system version, generally rhel5

#uname-A

Linux rhel5.oraclelinux.com 2.6.18-164.el5 #1 SMP Tue 15:51:54 EDT i686 i686 i386 gnu/linux

7. Configure the Yum source and install the Oracle required packages

#mount/dev/cdrom/mnt //mounting discs

#vi/etc/yum.repos.d/yum.repo//configure Yum source files

[Server]

Name=server

Baseurl=file:///mnt/server

Enabled=1

Gpgcheck=0

#yum Clean All

#yum repolist

Packages to be installed: binutils-* compat-libstdc++-33-* elfutils-libelf-* elfutils-libelf-devel-* gcc-* gcc-c++-* glibc-* glibc-common-* glibc-devel-* glibc-headers-* ksh-* libaio-* libgcc-* libstdc++-* make-* sysstat-* unixODBC-* unixODBC-de vel-*]

#yum install-y binutils-* compat-libstdc++-33-* elfutils-libelf-* elfutils-libelf-devel-* gcc-* gcc-c++-* glibc-* glibc -common-* glibc-devel-* glibc-headers-* ksh-* libaio-* libgcc-* libstdc++-* make-* sysstat-* unixODBC-* unixODBC-devel-* LIBXP //using Yum to install at once

#rpm-Q--qf '%{name}-%{version}-%{release} (%{arch}) \ n ' binutils \//Check installation status

compat-libstdc++ \

Elfutils-libelf-devel \

Elfutils-libelf-devel-static \

GCC \

gcc-c++ \

GLIBC \

Glibc-common \

Glibc-devel \

Glibc-headers \

Kernel-headers \

Ksh \

Libaio \

Libaio-devel \

LIBGCC \

Libgomp \

libstdc++ \

Libstdc++-devel \

Make \

Sysstat \

UnixODBC \

Unixodbc-devel \

Libxp

8. Modify hostname

#vi/etc/hosts

192.168.1.100nod1

#hostname nod1

#ping nod1

9. Adding kernel parameters

#vi/etc/sysctl.conf

Kernel.shmall = 2097152

Kernel.shmmax = 536870912

Kernel.shmmni = 4096

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

Shmmax-The maximum number of bytes in a shared memory segment, it is recommended to set a large point, even larger than the number of bytes in physical memory

Shmmin-The minimum size of the shared memory segment.

Shmmni-The maximum number of shared memory segments.

SHMSEG-The maximum number of shared memory segments that can be allocated per process.

Shmall-The maximum number of concurrent shared memory segments, larger than the SGA.

Semmns-The maximum number of semaphores associated with Oracle's process count.

SEMMSL-The maximum number of semaphores in each semaphore set.

#sysctl-P//Let parameters take effect immediately

10. Create groups and users

#groupadd-G 501 DBA

#useradd-G dba-u Oracle//gid and UID are as staggered as possible for later management

#passwd Oracle

11. Adding Oracle User System restriction parameters

#vi/etc/security/limits.conf

Oracle Soft Nproc 2047

Oracle Hard Nproc 16384

Oracle Soft Nofile 1024

Oracle Hard Nofile 65536

12. Create the installation directory

#mkdir/oracle //Software Installation directory

#mkdir/oradata //Database installation directory

#chown oracle:dba/oracle

#chown Oracle:dba/oradata

13. Adding environment variables to Oracle users

#su-oracle

$vi/home/oracle/.bash_profile

Export Oracle_base=/oracle/app/oracle

Export Oracle_home= $ORACLE _base/product/10.2

Export path= $ORACLE _home/bin: $PATH

14. Uploading Oracle software to the server using Xshell

10201_database_linux_x86_64.cpio.gz//10.2.1 Version

P8350262_10204_generic.zip //10.2.1 's patch

P8202632_10205_linux-x86-64.zip //10.2.5 version, which is an incremental upgrade version of 10.2.1

#su-oracle

$gunzip 10201_database_linux_x86_64.cpio.gz //Unzip to 10201_database_linux_x86_64.cpio

$cpio-IDCMV < 10201_database_linux_x86_64.cpio //Unzip to database folder

$unzip p8202632_10205_linux-x86-64.zip//Unzip to Disk1 folder

$unzip P8350262_10204_generic.zip//Unzip to 8350262 folders

15. Install as Oracle

$su-oracle

$CD Database

$./RUNINSTALLER-IGNORESYSPREREQS//By default, 10g does not support RHEL5, this parameter should be added, ignore version detection

$CD 8350262

$ORACLE _home/opatch/opatch Apply//install patch

Opatch succeeded.

$CD Disk1

$./runinstaller //By default, RHEL5 is supported

Note: 10.2.5 is an incremental upgrade package for 10.2.1, so the installation must be upgraded in a way that overrides the installation

16.NETCA Creating a listener

$NETCA //Suggested step-by-step installation

$lsnrctl Status//view monitoring, by default, started

$lsnrctl start //Start monitoring

$lsnrctl Stop//Turn off monitoring

17.DBCA Creating a Database

$DBCA//Suggested step-by-step installation

Note: If you select ASM at install time, you will be prompted to execute Localconfig add with the root user, enabling the CSS Service (Cluster service)

#./localconfig Add

/etc/oracle does not exist. Creating it now.

Successfully accumulated necessary OCR keys.

Creating OCR keys for user ' root ', privgrp ' root '.

Operation successful.

Configuration for local CSS have been initialized

Adding to Inittab

Startup'll is queued to init within-seconds.

Checking the status of new Oracle init process ...

Expecting the CRS daemons to being up within-seconds.

CSS is active on these nodes.

Nod1

CSS is active in all nodes.

Oracle CSS Service is installed and running under init (1M)

Note: Oracle installation media is available in 3 forms Fs,raw,asm, where the Raw,asm configuration method is described in "Raw creation of Oracle under Linux" and "ASM creation of Oracle under Linux"

18. View the database process

$ps-ef|grep Ora

19. Enter the database to start and close the database

$export ORACLE_SID=FSDB1//claims SID, specifying the entered database

$sqlplus/as SYSDBA

Sql>startup//Started by default

Sql>shutdown immediate;

About Opatch:

Starting with version 9.2, Oracle has implemented an individual patch installation tool, Opatch. Opatch uses a system data structure called inventory (strictly shared inventory with Oui) to centrally manage all installed individual patches The installation and uninstallation of individual patches are done using the Opatch command, and the conflict detection is done automatically by Opatch at the time of installation, and the list command provides easy access to information about the individual patches that have been installed.

In the 10g (10.1 and 10.2) versions, Opatch is installed as a standard tool automatically during installation. (Installed under $oracle_home/opatch.) For version 9.2, you need to download Opatch from Metalink. Regardless of the version, whether or not the Opatch is installed in the system, the latest version of Opatch should be downloaded from Metalink before use. Unfortunately, due to system implementation issues, 10.2 uses Opatch with previous versions (10.1 and 9.2) Use of opatch incompatible, can not be mixed, this must be noted.

Opatch is a scripting program written in Perl (which also uses the Java API). The version of Perl used is 5.6, although it can be run in versions prior to 5.6, but you should install Perl 5.6 or later as much as possible. The good news for DBAs is that if you have the HTTP server installed when you install version 9.2 of the software, the $oracle_home/ Perl will be installed automatically under Apache (10g will automatically install the configuration Perl and Opatch.)

Use the "-help" parameter to get help for the Opatch command

$./opatch--help

Invoking Opatch 10.2.0.1.0

Oracle Interim Patch Installer version 10.2.0.1.0

Copyright (c) 2005, Oracle Corporation. All rights reserved.

Oracle Home:/u01/oracle/oracle/product/10.2.0/db_1

Central Inventory:/u01/oracle/orainventory

From:/u01/oracle/oracle/product/10.2.0/db_1/orainst.loc

Opatch version:10.2.0.1.0

OUI version:10.2.0.1.0

OUI Location:/u01/oracle/oracle/product/10.2.0/db_1//oui

Log File Location:/u01/oracle/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch-2010_aug_09_03-05-40-cst_ Mon.log

Usage:opatch [-help] [-r[eport]] [command]

Command: = Apply

Lsinventory

Query

Rollback

Version

<global_arguments>: =-HELP Displays the help message for the command.

-report Print the actions without executing (deprecated).

Example

' Opatch-help '

' Opatch apply-help '

' Opatch lsinventory-help '

' Opatch rollback-help '

This is the 10.2.0.1 version of Opatch. The Opatch command in 10.2.0.4 is different from the previous one, and it has several commands added.

$./opatch--help

Invoking Opatch 11.1.0.6.6

Oracle Interim Patch Installer version 11.1.0.6.6

Copyright (c), Oracle Corporation. All rights reserved.

Usage:opatch [-help] [-r[eport]] [command]

Command: = Apply

Lsinventory

Napply

Nrollback

Rollback

Query

Version

Prereq

Util

<global_arguments>: =-HELP Displays the help message for the command.

-report Print the actions without executing.

Example

' Opatch-help '

' Opatch apply-help '

' Opatch lsinventory-help '

' Opatch napply-help '

' Opatch nrollback-help '

' Opatch rollback-help '

' Opatch prereq-help '

' Opatch util-help '

Some explanations of the order on the official website:

Apply

Installs an interim patch. Refer to ' Apply Command ' for more information.

Napply

Installs n number of patches (hence napply). Refer to ' napply Command ' for more information.

Auto

Applies Oracle clusterware patches. Refer to ' Auto Command ' for more information.

Lsinventory

Lists What's currently installed on the system. Refer to ' lsinventory Command ' for more information.

Query

Queries a given patch for specific details. Refer to "Query Command" for more information.

Rollback

Removes an interim patch. Refer to ' rollback Command ' for more information.

Nrollback

Removes n number of patches (hence nrollback). Refer to ' Nrollback Command ' for more information.

Version

Prints the current version of the Patch tool. Refer to ' version Command ' for more information.

In the $oracle_home/opatch/docs directory, use the Guide file (users_guide.txt), which has a detailed command format and usage examples, which you can refer to.

When the Opatch executes, the log file is generated in addition to the screen output results.

The path and file name format of the log file is as follows:

$ORACLE _home/.patch_storage/< patch_id >/< action >-< patch_id >_< Mm-dd-yyyy_hh-mi-ss>.log

where "patch_id" is the number assigned to individual patches by Oracle technical support.

Opatch Download

Download the patched compressed file from Metalink p8350262_10204_linux.zip. Unzip the file to a directory. After decompression, all files of this patch are in subdirectory 8350262, the directory name is the patch number of the individual patches, Opatch according to the directory name to obtain information, so must not rename subdirectories.

Where to store the Opatch command:

$ls/oracle/app/oracle/product/10.2.0/db_1/opatch

Docs emdpatch.pl jlib Opatch Opatch.ini opatch.pl

Opatch Patch Installation

$su-oracle

$CD/oracle/8350262

$ $ORACLE _home/opatch/opatch Apply

Opatch Patch Uninstall

$ $ORACLE _home/opatch/opatch Rollback-id 8350262

ORACLE10G_RHEL5 installation Process