Oracle basic Tutorial: RHEL5U5 installing Oracle 10g

The first time Oracle was installed, there were a variety of problems. After a while, I finally installed it. I will summarize the process and give it to myself and those who needed it!

Operating System Preparation

1. OS version restrictions
2. Disk Space restrictions
3. software package dependency
4. Host Name and resolution address
5. User and resource restrictions (PAM)
6. system resource restrictions (kernel parameters)

Supported versions:
The oracle10G version only supports RHEL4. We recommend that you install an officially recognized operating system version in production.

If RHEL5 is used, you need to modify the version identification file in the system.
Because the code in the oracle installation package contains a script to detect the Operating System

[Root @ dba mnt] # grep ^ Linux install/oraparam. ini
Linux = RedHat-3, SUSE-9, redhat-4, UnitedLinux-1.0, asianux-1, asianux-2
[Root @ dba mnt] #

Solution
 Root @ dbaMnt] # cat/etc/redhat-release
Red Hat Enterprise Linux Server release 5.5 (Tikanga)
[Root @ dba mnt] # vim/etc/redhat-release
[Root @ dba mnt] # cat/etc/redhat-release
Red Hat Enterprise Linux Server release 4.5 (Tikanga)
[Root @ dba mnt] #

Space Requirements
Memory at least 512 M swap partition at least 1G
Oracle software installation location 1.3 GB
Database installation location at least 1 GB
/Tmp should have MB of remaining space
If these directories belong to the root file system, the root must have 3G free space for installation (1.3 + 1 + 0.4)
All of the above are the minimum requirements. This is far from enough for later running to add data.
In addition, as the files generated by oracle itself become larger in the future, reserve sufficient space.

Check Method
[Root @ dba ~] # Df-Th
File System Type capacity available in use % mount point
/Dev/sda2 ext3 15G 2.3G 12G 17%/
/Dev/sda1 ext3 99 M 12 M 83 M 12%/boot
Tmpfs 506 M 0 506 M 0%/dev/shm
[Root @ dba ~] #
[Root @ dba ~] # Grep-E 'memtotal | swaptotal'/proc/meminfo
MemTotal: 1035108 kB
SwapTotal: 1076344 kB
[Root @ dba ~] #

Software Package check
For I in binutils compat-gcc-34 compat-libstdc ++-296 control-center \
Gcc-c ++ glibc-common glibc-devel libaio libgcc \
Libstdc ++-devel libXp make openmotif22 setarch
Do
Rpm-q $ I &>/dev/null | F = "$ F $ I"
Done; echo $ F; unset F

If the command is executed, add the name of the output package to the system.
If no information is output, the required software packages are already in the system.

Host Name and resolution address
[Root @ dba ~] # Hostname
Dba.up.com
[Root @ dba ~] #
[Root @ dba ~] # Ifconfig eth0 | head-n 2
Eth0 Link encap: Ethernet HWaddr 00: 0C: 29: 9F: DF: 4A
Inet addr: 10.10.10.10 Bcast: 10.10.255 Mask: 255.255.255.0
[Root @ dba ~] #

[Root @ dba ~] # Grep-v '^ #'/etc/hosts
127.0.0.1 localhost. localdomain localhost
10.10.10.10 dba.up.com dba
[Root @ dba ~] #

Operating system resource restrictions
Add
Bottom of vim/etc/sysctl. conf file
Kernel. shmall = 2097152
Kernel. shmmax = 2147483648
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 = 1048576
Net. core. rmem_max = 1048576
Net. core. wmem_default = 262144
Net. core. wmem_max = 262144

Load parameter sysctl-p

Kernel. shmall
Total amount of shared memory available (bytes or pages)
Kernel. shmmax
Maximum size of shared memory segment (bytes)
It is recommended that SGA be greater than or equal
Kernel. shmmni
Maximum number of shared memory segments system-wide
 
Kernel. shmall * kernel. shmmni = memory size that can be allocated

Kernel. sem = SEMMSL SEMMNS SEMOPM SEMMNI
SEMMSL Maximum number of semaphores per set
The maximum number of signal objects in each signal object set;
SEMMNS Maximum number of semaphores system-wide
Maximum number of signal objects in the system range;
SEMOPM
The maximum number of operations supported by each signal object;
SEMMNI Maximum number of semaphore identifiers
The maximum number of signal objects in the system range.
The SEMMNS value is equal to SEMMSL * SEMMNI.

Fs. file-max
The maximum number of file handles allowed in the system.
Net. ipv4.ip _ local_port_range
The range of IPv4 ports that an application can use.
Net. core. rmem_default
Default Value of the socket receiving buffer size
Net. core. rmem_max
Maximum size of the socket receiving buffer
Net. core. wmem_default
Default Value of the buffer size sent by the socket
Net. core. wmem_max
Maximum size of the socket sending Buffer

1 2 Next Page