wtorek, 30 stycznia 2018

Centos 7 instalacja oracle

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