Компьютерная помощь

Preinstallation task for Oracle 11 (and Oracle 12)

Hardware Requirements:

Minimum: 1 GB of RAM
Recommended: 2 GB of RAM or more

Contact your operating system vendor for swap space allocation guidance for your server. The vendor guidelines supersede the swap space requirements listed in this guide.

Check RAM and swap size:

# grep MemTot /proc/meminfo

MemTotal:        8194216 kB

or

# free -mt

             total       used       free     shared    buffers     cached

Mem:          8002        361       7640          0         67        146

-/+ buffers/cache:        146       7855

Swap:         8190          0       8190

Total:       16193        361      15831

Install packages. The following packages (or later versions) must be installed:

binutils-2.19

gcc-4.3

gcc-32bit-4.3

gcc-c++-4.3

glibc-2.9

glibc-32bit-2.9

glibc-devel-2.9

glibc-devel-32bit-2.9

ksh-93

libaio-0.3.104

libaio-32bit-0.3.104

libaio-devel-0.3.104

libaio-devel-32bit-0.3.104

libstdc++33-3.3.3

libstdc++33-32bit-3.3.3

libstdc++43-4.3.3_20081022

libstdc++43-32bit-4.3.3_20081022

libstdc++43-devel-4.3.3_20081022

libstdc++43-devel-32bit-4.3.3_20081022

libgcc43-4.3.3_20081022

libstdc++-devel-4.3

libcap1

make-3.81

sysstat-8.1.5

unixODBC-2.2.12 or later

unixODBC-devel-2.2.12 or later

unixODBC-32bit-2.2.12 (32-bit) or later

Example:
Check installed package(es)

# rpm -qa| grep libstdc++43

libstdc++43-4.3.4_20091019-0.7.35

libstdc++43-32bit-4.3.4_20091019-0.7.35

Install package(es)

Mount DVD whith SUSE (as root)  if not connect to internet

# mount -o ro /dev/sr0 /media

# cd /media/suse/x86_64/

# rpm -Uvh sysstat-8.1.5-7.32.1.x86_64.rpm

Preparing...                ########################################### [100%]

        package sysstat-8.1.5-7.32.1.x86_64....

or

# rpm -Uvh sysstat-8* binutils*

or

# zypper in binutils sysstat

Create groups and user (must be present user oracle and group oinstall):

# groupadd -g 1000 oinstall

# groupadd -g 1031 dba

# useradd -u 1101 -g oinstall -G dba -m -d /home/oracle oracle

# passwd oracle

Set kernel parameters:

Add to /etc/sysctl.conf file

fs.aio-max-nr = 1048576

fs.file-max = 6815744

kernel.shmall = 2097152

kernel.shmmax = 2147483648

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 = 1048586

vm.hugetlb_shm_group = 1000

fs.file-max = 512 x processes, for example 6815744 for 13312 processes;
kernel.shmmax = 1/2 of physical RAM. Recommended: More than half the physical memory;
vm.hugetlb_shm_group = oinstall group id number;

Apply kernel parameters:

# /sbin/sysctl -p

Set user Limits:
Add following lines to the /etc/security/limits.conf file:

oracle              soft    nproc   2047

oracle              hard    nproc   16384

oracle              soft    nofile  1024

oracle              hard    nofile  65536

oracle              soft    stack   10240

Then relogin for user oracle and check limits:
Example, “Soft” limits for nofile:

$ ulimit -Sn

1024

“Hard” limits for nofile:

$ ulimit -Hn

65536

Must be installed xorg-x11-server or vnc server:

# zypper install xorg-x11-server

Change owner for folder (by user with root privilegies):

# chown –R oracle:oinstall /u01/

Add a variable in file(/home/oracle/.profile):

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1

export PATH=$PATH:$ORACLE_HOME/bin

export ORACLE_SID=test

Activate a profile variable(from command line):

oracle>. .profile (run in the folder /home/oracle)

Start the Oracle listener (for connection via network):

oracle>lsnrctl_start

Start the database(run sqlplus):

oracle>sqlplus / as sysdba

SQL> startup;

Start the Oracle Enterprise Manager (for connection via web):

oracle>./emctl start dbconsole
Link:   https://192.168.0.1:1158/em/console

In Oracle 12 Enterprise Manager install by default.

Connect to Oracle database (from Oracle SQL Developer):

User: system

Pass: (you pass)

SID: test

Host: (ip address of host)

Port: 1521

SLES, OpenSUSE

Файлы настройки сетевых интерфейсов /etc/sysconfig/network/ifcfg-*
В этих файлах настраиваются основные данные для сетевых интерфейсов такие как ip адрес (IPADDR), сетевая маска (NETMASK), адрес сети (NETWORK), braodcast адрес (BROADCAST). Под звездочкой понимается имя сетевого интерфейса, например eth0, eth1, eth2, lo и т.п., зависит от количества установленных сетевых карт в системе.
Пример файла cо статической настройкой сетевых параметров интерфейса eth0 для SUSE, SLES, SLED.

[root@linux ~]# cat /etc/sysconfig/network/ifcfg-eth0
BOOTPROTO='static'            
BROADCAST='192.168.1.255'
ETHTOOL_OPTIONS=''
IPADDR='192.168.1.100'
MTU=''
NAME='NetXtreme BCM5761 Gigabit Ethernet PCIe'
NETMASK='255.255.255.0'
NETWORK='192.168.1.0'
REMOTE_IPADDR=''
STARTMODE='auto'    # Автоматическое поднятие интерфейса eth0 при загрузке системы
USERCONTROL='no'    # Отключение управления из графикческих интерфейсов kinternet/cinternet