Oracle Installation-preparations before installation

Last Update:2018-12-05 Source: Internet

Author: User

Tags server memory

Developer on Alibaba Coud: Build your first app with APIs, SDKs, and tutorials on the Alibaba Cloud. Read more ＞

Note: This document describes how to install the oracle database in linux. The method for installing oracle in other unix environments is basically the same. This installation guide is a general document, it is applicable to various oracle database versions and is easy to install in windows.

I. System Configuration
The system configuration suggestions are as follows:
CPU pIII, (CPU frequency more than 1 GB) Sai Yang series (CPU frequency more than 1.7G ).
Memory 512 M (physical memory at least 256, system swap partition at least 600 M, recommended for 1G)
Linux version: We recommend that you use RedHat Linux.7.1 or 7.3 For 9.0.0.1, and 9.0 for 9.2.0.1.
(This article takes 9.0.0.1 as an example)
Partition:/boot: 100 M (at least 100 M, 300 M recommended)
Swap: 1024 M/
Xwindow and kde must be installed.

Ii. Check the Development Kit (Checking Development Packages -- RPMs)
The Oracle installer requires some RPM Development kits to build the Oracle module. Otherwise, the following error may occur:
Error in invoking target ntcontab. o of makefile
/Opt/oracle/product/9.2.0/network/lib/ins_net_client.mk
1. RH 7.1, 7.2 and rh as 2.1 required Development Kits
Run the following command to check whether these Development Kits are installed:
Rpm-q gcc cpp compat-libstdc ++ glibc-devel kernel-headers binutils
For example, if the Software Development package is not selected when Red Hat Advanced Server 2.1 is installed, most of the packages are not installed. Run the following command to install these packages:
Su-root
Rpm-ivh cpp-2.96-108.1.i386.rpm glibc-devel-2.2.4-26.i386.rpm
Rpm-ivh kernel-headers-2.4.9-e.3.i386.rpm gcc-2.96-108.1.i386.rpm
Rpm-ivh binutils-2.11.90.0.8-12.i386.rpm

2. RH 7.3, 8.0 and 9 required Development Kits
Run the following command to check whether these Development Kits are installed:
Rpm-q gcc cpp compat-libstdc ++ glibc-devel glibc-kernheaders binutils
For example, if you select the Server Installation type when installing Red Hat 9, you must run the following command to install the SDK:
Su-root
Rpm-ivh cpp-3.2.2-5.i386.rpm glibc-devel-2.3.2-5.i386.rpm
Rpm-ivh glibc-kernheaders-2.4-8.10.i386.rpm gcc-3.2.2-5.i386.rpm
Rpm-ivh binutils-2.13.90.0.18-9.i386.rpm

3. Setting Swap Space)
To install and create a prototype database using the Oracle 9i standard, Oracle recommends that the Oracle9i (9.0.1) server require at least 512 MB of memory, two times the memory or no less than 400 M swap (swap) space. I have successfully installed Oracle 9i (9.0.1 & 9.2.0) and created a default database on a PC with 256 M memory and 600 M swap space. However, when I use less swap space on this PC, the system prompts a memory overflow. Therefore, we recommend that you use the memory and/or swap space specified by the Oracle Installation Guide, or more memory and swap space. Note: If you do not have enough swap space or memory during the installation process, especially during database creation, your Oracle server will become very slow.
To view the memory size, run the following command:
Grep MemTotal/proc/meminfo
To view the swap space size, run the following command:
Cat/proc/swaps
If the swap space is not enough, you can create a temporary swap file to temporarily increase the swap space, instead of using the original device ).
Su-root
Dd if =/dev/zero of = tmpswap bs = 1 k count = 900000
Chmod 600 tmpswap
Mkswap tmpswap
Swapon tmpswap
To cancel a temporary swap space, run the following command:
Su-root
Swapoff tmpswap
Rm-rf tmpswap

4. Setting Shared Memory)
To install Oracle 9i (9.2.0), you need to increase the maximum shared memory (maximum shared memeory) of all Red Hat Linux servers ). Otherwise, the Oracle Database Configuration Assistant will display the following error message:
ORA-27123: unable to attach to shared memory segment
Run the following command to temporarily add shmmax settings for the kernel:
$ Su-root
# Cat/proc/sys/kernel/shmmax
33554432
# Echo 'expr 1024*1024*1024 '>/proc/sys/kernel/shmmax
# Cat/proc/sys/kernel/shmmax
1073741824
Note: Generally, you can set the maximum shared memory to half the physical memory. If the physical memory is 2 GB, you can set the maximum shared memory to 1073741824; if the physical memory is 1 GB, you can set the maximum shared memory to 512*1024*1024 = 536870912 .)
We recommend that you add the shmmax settings permanently. You only need vi/etc/sysctl. conf, and add kernel. shmmax = 536870912 (set based on the server memory size.

5. Check/tmp Space (Checking/tmp Space)
The Oracle Universal Installer requires a temporary/tmp space of over 400 mb.
Check the/tmp temporary space and run:
Df/tmp
If you do not have enough space for the/tmp temporary, you can create a tmp directory in another file system temporarily.
Su-root
Mkdir/tmp
Chown root. root // tmp
Chmod 1777 // tmp
Export TEMP =/# used by Oracle
Export TMPDIR =/# used by Linux programs
After installing Oracle, close Oracle and delete the temporary directory:
Su-root
Rmdir/tmp
Unset TEMP
Unset TMPDIR 1: System Configuration
The system configuration suggestions are as follows:
CPU pIII, (CPU frequency more than 1 GB) Sai Yang series (CPU frequency more than 1.7G ).
Memory 512 M (physical memory at least 256, system swap partition at least 600 M, recommended for 1G)
Linux version: We recommend that you use RedHat Linux.7.1 or 7.3 For 9.0.0.1, and 9.0 for 9.2.0.1.
(This article takes 9.0.0.1 as an example)
Partition:/boot: 100 M (at least 100 M, 300 M recommended)
Swap: 1024 M/
Xwindow and kde must be installed.

The following settings need to be set for remote oracle installation. You do not need to set the settings for local oracle installation.
Setting xwindow supports remote logon to linux using tools such as xmanager. The settings are as follows:
# Vi/etc/X11/xdm-config
Add "DisplayManager. requestPort: 0" to the last row! Comment out this line.
# Vi/etc/X11/xdm/Xservers
Comment out this line with # In front of the last line: 0 local/usr/X11R6/bin/X.
# Vi/etc/X11/xdm/Xaccess
Find # * # any host can get a login window
Remove the # sign before this line and change it:
* # Any host can get a login window
Run # xdm. In this way, you can connect to Linux using tools such as xmanager !!!
If you want to automatically start xdm at each startup, add/etc/X11R6/bin/xdm to the end of the/etc/rc. d/rc. local file.
Ii. Check the Development Kit (Checking Development Packages -- RPMs)
The Oracle installer requires some RPM Development kits to build the Oracle module. Otherwise, the following error may occur:
Error in invoking target ntcontab. o of makefile
/Opt/oracle/product/9.2.0/network/lib/ins_net_client.mk
1. RH 7.1, 7.2 and rh as 2.1 required Development Kits
Run the following command to check whether these Development Kits are installed:
Rpm-q gcc cpp compat-libstdc ++ glibc-devel kernel-headers binutils
For example, if the Software Development package is not selected when Red Hat Advanced Server 2.1 is installed, most of the packages are not installed. Run the following command to install these packages:
Su-root
Rpm-ivh cpp-2.96-108.1.i386.rpm glibc-devel-2.2.4-26.i386.rpm
Rpm-ivh kernel-headers-2.4.9-e.3.i386.rpm gcc-2.96-108.1.i386.rpm
Rpm-ivh binutils-2.11.90.0.8-12.i386.rpm

3. Red Hat Enterprise Linux Advanced Server 3 (rhel as 3) Development Kit
Run the following command to check whether these Development Kits are installed:
Rpm-q gcc cpp compat-libstdc ++ glibc-devel glibc-headers
Rpm-q glibc-kernheaders binutils
Note: Before you start installing Oracle 9iR2, make sure that you have checked the Oracle Installation Error (Oracle
Installation Errors) section about "Error in invoking target install of make file
/Opt/oracle/product/9.2.0/network/lib/ins_oemagent.mk.
3. Setting Swap Space)
To install and create a prototype database using the Oracle 9i standard, Oracle recommends that the Oracle9i (9.0.1) server require at least 512 MB of memory, two times the memory or no less than 400 M swap (swap) space. I have successfully installed Oracle 9i (9.0.1 & 9.2.0) and created a default database on a PC with 256 M memory and 600 M swap space. However, when I use less swap space on this PC, the system prompts a memory overflow. Therefore, we recommend that you use the memory and/or swap space specified by the Oracle Installation Guide, or more memory and swap space. Note: If you do not have enough swap space or memory during the installation process, especially during database creation, your Oracle server will become very slow.
To view the memory size, run the following command:
Grep MemTotal/proc/meminfo
To view the swap space size, run the following command:
Cat/proc/swaps
If the swap space is not enough, you can create a temporary swap file to temporarily increase the swap space, instead of using the original device ).
Su-root
Dd if =/dev/zero of = tmpswap bs = 1 k count = 900000
Chmod 600 tmpswap
Mkswap tmpswap
Swapon tmpswap
To cancel a temporary swap space, run the following command:
Su-root
Swapoff tmpswap
Rm-rf tmpswap
4. Setting Shared Memory)
To install Oracle 9i (9.2.0), you need to increase the maximum shared memory (maximum shared memeory) of all Red Hat Linux servers ). Otherwise, the Oracle Database Configuration Assistant will display the following error message:
ORA-27123: unable to attach to shared memory segment
Run the following command to temporarily add shmmax settings for the kernel:
$ Su-root
# Cat/proc/sys/kernel/shmmax
33554432
# Echo 'expr 1024*1024*1024 '>/proc/sys/kernel/shmmax
# Cat/proc/sys/kernel/shmmax
1073741824
Note: Generally, you can set the maximum shared memory to half the physical memory. If the physical memory is 2 GB, you can set the maximum shared memory to 1073741824; if the physical memory is 1 GB, you can set the maximum shared memory to 512*1024*1024 = 536870912 .)
We recommend that you add the shmmax settings permanently. You only need vi/etc/sysctl. conf, and add kernel. shmmax = 536870912 (set based on the server memory size.
5. Check/tmp Space (Checking/tmp Space)
The Oracle Universal Installer requires a temporary/tmp space of over 400 mb.
Check the/tmp temporary space and run:
Df/tmp
If you do not have enough space for the/tmp temporary, you can create a tmp directory in another file system temporarily.
Su-root
Mkdir/tmp
Chown root. root // tmp
Chmod 1777 // tmp
Export TEMP =/# used by Oracle
Export TMPDIR =/# used by Linux programs
After installing Oracle, close Oracle and delete the temporary directory:
Su-root
Rmdir/tmp
Unset TEMP
Unset TMPDIR

You can install ORACLE .........

This article is an English version of an article which is originally in the Chinese language on aliyun.com and is provided for information purposes only. This website makes no representation or warranty of any kind, either expressed or implied, as to the accuracy, completeness ownership or reliability of the article or any translations thereof. If you have any concerns or complaints relating to the article, please send an email, providing a detailed description of the concern or complaint, to info-contact@alibabacloud.com. A staff member will contact you within 5 working days. Once verified, infringing content will be removed immediately.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

Get Started for Free

Sales Support

1 on 1 presale consultation

Chat Contact Sales
After-Sales Support

24/7 Technical Support 6 Free Tickets per Quarter Faster Response

Open a Ticket
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.

Learn More