Oracle Database Installation Memorandum

Source: Internet
Author: User
Tags oracle database installation

To view the available RAM and swap space, run the following command:
Grep MemTotal/proc/meminfo
Grep SwapTotal/proc/meminfo

For example:
# Grep MemTotal/proc/meminfo
MemTotal: 512236 kB
# Grep SwapTotal/proc/meminfo
SwapTotal: 1574360 kB

Next, create a Linux Group and user account for installing and maintaining the Oracle 10g software. User accounts are called oracle, while groups are called oinstall and dba. Run the following command as the root user:

/Usr/sbin/groupadd oinstall
/Usr/sbin/groupadd dba
/Usr/sbin/useradd-m-g oinstall-G dba oracle
Id oracle

For example:
#/Usr/sbin/groupadd oinstall
#/Usr/sbin/groupadd dba
#/Usr/sbin/useradd-m-g oinstall-G dba oracle
# Id oracle
Uid = 501 (oracle) gid = 501 (oinstall) groups = 501 (oinstall), 502 (dba)

Set the password for the oracle account: passwd oracle

For example:
# Passwd oracle
Changing password for user oracle.
New password:
Retype new password:
Passwd: all authentication tokens updated successfully.

Run the following command as the root user: mkdir-p/u01/app/oracle
Mkdir-p/u02/oradata
Chown-R oracle: oinstall/u01/app/oracle/u02/oradata
Chmod-R 775/u01/app/oracle/u02/oradata

For example:
# Mkdir-p/u01/app/oracle
# Mkdir-p/u02/oradata
# Chown-R oracle: oinstall/u01/app/oracle/u02/oradata
# Chmod-R 775/u01/app/oracle/u02/oradata

The Linux kernel is excellent. Unlike most other * NIX systems, Linux allows you to modify most Kernel Parameters during system startup and runtime. You do not have to restart the system after the Kernel Parameter is changed. The following Kernel Parameter settings are required for Oracle Database 10 GB. The minimum value is given, so if your system uses a large value, do not change it.

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

If you have installed Linux according to the preceding instructions and all kernel parameters use the default values, you only need to log on as the root user and run the following command.

Cat>/etc/sysctl. conf < 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
EOF
/Sbin/sysctl-p

For example:
# Cat>/etc/sysctl. conf < > 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
> EOF
#/Sbin/sysctl-p
Net. ipv4.ip _ forward = 0
Net. ipv4.conf. default. rp_filter = 1
Kernel. sysrq = 0
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
/Sbin/sysctl-a | grep shm
/Sbin/sysctl-a | grep sem
/Sbin/sysctl-a | grep file-max
/Sbin/sysctl-a | grep ip_local_port_range

For example:
#/Sbin/sysctl-a | grep shm
Kernel. shmmni = 4096
Kernel. shmall = 2097152
Kernel. shmmax = 2147483648
Kernel. shm-use-bigpages = 0
#/Sbin/sysctl-a | grep sem
Kernel. sem = 250 32000 100 128
#/Sbin/sysctl-a | grep file-max
Fs. file-max = 65536
#/Sbin/sysctl-a | grep ip_local_port_range
Net. ipv4.ip _ local_port_range = 1024 65000

If the system parameter settings are smaller than the preceding parameter values, edit the/etc/sysctl. conf file and add or modify these parameters. After completion, run the following command to activate the change:/sbin/sysctl-p

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

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

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

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

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.