Oracle Installation Documentation

1. Installation environment ... 4

2. Installation steps ... 5

2.1. Check the hardware environment ... 5

2.2. Check the SOFTWARE Environment ... 5

3. Installation Standard ... 7

3.1. Kernel parameters ... 7

3.2. Set up System user groups, configure user environment variables ... 7

3.3. Oracle Resource Limits ... 8

3.4. Installation directory ... 8

3.5. Install Oracle Software ... 8

3.6. Set up Database monitoring ... 9

3.7. Build a database ... 9

3.8. The database starts automatically with the system ... 9

1. Installation Environment

Os:suse Linux 10

oracle:11.2.0.3

2. Installation Steps

2.1. Check the hardware environment

Memory: At least 1G

Swap:oracle official documentation is recommended as follows:

Actual memory size	Suggested swap size
1g-2g	1.5 times times the memory
2g-16g	Same as Memory
Over 16G	Set to 16G

Hard disk space:

/tmp directory requires 1 GB of free space

Hard disk space required to install Oracle software

Enterprise Edition 3.95 (software files) +1.7 (data files)

Standard Edition 3.88 (software files) +1.5 (data files)

2.2. Check the SOFTWARE Environment

Kernel version not less than 2.6.16.21

The documentation requires packages that must be installed:

binutils-2.16.91.0.5

compat-libstdc++-5.0.7

gcc-4.1.0

gcc-c++-4.1.2

glibc-2.4-31.63

glibc-devel-2.4-31.63

glibc-devel-32bit-2.4-31.63

ksh-93r-12.9

libaio-0.3.104

libaio-32bit-0.3.104

libaio-devel-0.3.104

libaio-devel-32bit-0.3.104

libelf-0.8.5

libgcc-4.1.2

libstdc++-4.1.2

libstdc++-devel-4.1.2

make-3.80

Numactl-0.9.6.x86_64

sysstat-8.0.4

3. Installation Standards

3.1. Kernel parameters

To edit the/etc/sysctl.conf, add the following:

FS.AIO-MAX-NR = 1048576

Fs.file-max = 6815744

Kernel.shmall = 2097152

Kernel.shmmax = 536870912

Kernel.shmmni = 4096

Kernel.sem = 250 32000 100 128

Net.ipv4.ip_local_port_range = 9000 65500

Net.core.rmem_default = 262144

Net.core.rmem_max = 4194304

Net.core.wmem_default = 262144

Net.core.wmem_max = 1048576

Run Sysctl–p, immediate effect

Kernel.shmmax is one of the most important parameters in the core parameter, to define the maximum value of a single shared memory segment, the Shmmax setting should be large enough to accommodate the entire SGA under a shared memory segment, setting too low may result in the need to create multiple shared memory segments, This can result in degraded system performance.

Oralce recommends Shmmax > SGA (sga_max_size) so that at any time there will be no hidden danger of even slight performance degradation.

The Kernel.shmall parameter is to control the number of shared memory pages. The parameter size is physical memory divided by pagesize

3.2. Set up the System user group and configure the user environment variables

#groupadd Oinstall

#groupadd DBA

#useradd-G oinstall-g dba Oracle

Su–oracle

Edit the. Profile file,

Export Oracle_base=/data/oracle

Export Oracle_home= $ORACLE _base/product/11.2.0/db_1

Export ORACLE_SID=ORCL (based on actual business)

Export tns_admin= $ORACLE _home/network/admin

Export path= $PATH: $HOME/bin: $ORACLE _home/bin

Export libpath= $ORACLE _home/lib: $ORACLE _home/lib32

Export Ld_library_path= $ORACLE _home/lib:/usr/lib

Export nls_lang= "Simplified Chinese" _china. Al32utf8

if [$USER = "Oracle"]; Then

if [$SHELL = "/bin/ksh"]; Then

Ulimit-p 16384

Ulimit-n 65536

Else

Ulimit-u 16384-n 65536

Fi

Fi

3.3. Oracle Resource Limitations

To edit the/etc/security/limits.conf, add the following:

Oracle Soft Nproc 2047

Oracle Hard Nproc 16384

Oracle Soft Nofile 1024

Oracle Hard Nofile 65536

To edit the/etc/pam.d/login, add the following:

Session required/lib/security/pam_limits.so

Session Required Pam_limits.so

3.4. Installation directory

/data/oracle/product/11.2.0/db_1:oracle Software Catalog

/data/oradata: Database File storage Directory

/data/archive: Archive Log storage Directory

3.5. Installing Oracle Software

Start VNC, connect to the server, unzip the Oracle installation package, go to the database directory, run the./runinstaller, the graphical interface, as prompted to install, such as no installation interface, check display variables

3.6. Set up Database monitoring

Run NETCA, build Linstener

3.7. Database creation

Run DBCA, set up database, build the database, sqlplus into the databases, set the DB memory parameters

Alter Sytem set SGA_MAX_SIZE=16G scope=spfile;

Alter Sytem set SGA_MAX_SIZE=16G scope=spfile;

Alter Sytem set PGA_AGGREGATE_TARGET=4G scope=spfile;

or set Memory_target parameters, unified management SGA,PGA,

Alter Sytem set memory_max_target=20g scope=spfile;

Alter Sytem set memory_target=20g scope=spfile;

Restart database

3.8. The database starts automatically with the system

1. Edit/etc/oratab, find the last line ORCL:/data/oracle/product/11.2.0/db_1:n, change N to Y

2. Edit/etc/sysconfig/oracle, find Start_oracle_db,start_oracle_db_listener, change its value to Yes, find Shmmax, Shmall, refer to/etc/ sysctl.conf modification

This article is from the "Zhanghe" blog, so be sure to keep this source http://9206668.blog.51cto.com/9196668/1535915