Instalacja Oracle 12 na Centos 7
Instalacja na virtualboxie uruchomionym na Windows 10.
Zainstalować Centos 7 minimal na VB
Na VB muszą być 2 karty:
1) nat network
2) host only network
Doinstalować epel:
rpm -Uvh https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm
Zainstalować tryb graficzny:
yum -y groupinstall "X Window System"
yum -y install gnome-classic-session gnome-terminal nautilus-open-terminal control-center liberation-mono-fontsunlink /etc/systemd/system/default.target
ln -sf /lib/systemd/system/graphical.target /etc/systemd/system/default.target
(restart)
Dla wygody pracy ze stacją Windows zainstalować serwer RDP:
yum -y install xrdp tigervnc-server
cat <<EOF >>/etc/xrdp/xrdp.ini
[xrdp1]
name=Local User Authentication # This name will show during Authentication
lib=libvnc.so
username=ask # "ask" means XRDP will ask for Username during Authentication
password=ask # XRDP will ask for Password during Authentication
ip=127.0.0.1
port=-1 # "-1" Looks for Free Port to Connect
EOF
/etc/init.d/xrdp start
firewall-cmd --zone=public --add-port=3389/tcp --permanent
firewall-cmd --reload
systemctl enable xrdp
Instalacja pakietów wymaganych przez Oracle:
yum install -y binutils.x86_64 compat-libcap1.x86_64 gcc.x86_64 gcc-c++.x86_64 glibc.i686 glibc.x86_64 \
glibc-devel.i686 glibc-devel.x86_64 ksh compat-libstdc++-33 libaio.i686 libaio.x86_64 libaio-devel.i686 libaio-devel.x86_64 \
libgcc.i686 libgcc.x86_64 libstdc++.i686 libstdc++.x86_64 libstdc++-devel.i686 libstdc++-devel.x86_64 libXi.i686 libXi.x86_64 \
libXtst.i686 libXtst.x86_64 make.x86_64 sysstat.x86_64
Założenie użytkownika i grupy:
groupadd oinstall
groupadd dba
useradd -g oinstall -G dba oracle
passwd oracle
(wpisać hasło)
Zmiany w plikach systemowych:
cat <<EOF >>/etc/sysctl.conf
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
EOF
cat <<EOF >>/etc/security/limits.conf
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
EOF
Katalog /u01:
mkdir /u01
chown oracle:oinstall /u01
chmod -R 775 /u01
chmod g+s /u01
Firewall do RDBMS:
firewall-cmd --zone=public --add-port=1521/tcp --add-port=5500/tcp --add-port=5520/tcp --add-port=3938/tcp --permanent