suse 安装oracle 19c

安装LINUX

mount /dev/cdrom /mnt

df -Th /mnt

 

zypper ar -f /mnt/Module-Basesystem sle15

zypper ar -f /mnt/Module-Legacy sle15-Legacy

zypper ar -f /mnt/Module-Development-Tools sle15-Tools

 

zypper in -y gcc bc binutils glibc glibc-devel insserv-compat libaio-devel libaio1 libX11-6 libXau6 libXext-devel libXext6 libXi-devel libXi6 libXrender-devel libXrender1 libXtst6 libcap-ng-utils libcap-ng0 libcap-progs libcap1 libcap2 libelf1 libgcc_s1 libjpeg8 libpcap1 libpcre1 libpcre16-0 libpng16-16 libstdc++6 libtiff5 libgfortran4 mksh make pixz rdma-core rdma-core-devel smartmontools sysstat xorg-x11-libs xz compat-libpthread-nonshared readline-devel

 

 

rpm -q gcc bc binutils glibc glibc-devel insserv-compat libaio-devel libaio1 libX11-6 libXau6 libXext-devel libXext6 libXi-devel libXi6 libXrender-devel libXrender1 libXtst6 libcap-ng-utils libcap-ng0 libcap-progs libcap1 libcap2 libelf1 libgcc_s1 libjpeg8 libpcap1 libpcre1 libpcre16-0 libpng16-16 libstdc++6 libtiff5 libgfortran4 mksh make pixz rdma-core rdma-core-devel smartmontools sysstat xorg-x11-libs xz compat-libpthread-nonshared readline-devel --qf '%{name}.%{arch}\n' | grep "未安装软件包" | wc -l

 

/usr/sbin/groupadd -g 60001 oinstall

/usr/sbin/groupadd -g 60002 dba

/usr/sbin/groupadd -g 60003 oper

useradd -u 1000 -g oinstall -G dba,oper infodba

usermod -g oinstall -G dba,oper infodba

mkdir -p /teamcenter/app/infodba/product/19c/db_1

mkdir -p /teamcenter/app/oraInventory

chown -R infodba:dba /teamcenter

chmod -R 775 /teamcenter

 

 

systemctl stop firewalld.service

systemctl disable firewalld.service

systemctl status firewalld.service

 

 

ln -sf /usr/share/zoneinfo/Asia/Shanghai /etc/localtime

hwclock

 

sed -i 's/quiet/quiet transparent_hugepage=never numa=off/' /etc/default/grub

grub2-mkconfig -o /boot/grub2/grub.cfg

 

 

重启

shutdown -r now

cat /sys/kernel/mm/transparent_hugepage/enabled

cat /proc/cmdline

 

 

zypper in -y avahi*

systemctl stop avahi-daemon.socket

systemctl stop avahi-daemon.service

pgrep -f avahi-daemon | awk '{print "kill -9 "$2}'

systemctl disable avahi-daemon.service

systemctl disable avahi-daemon.socket

systemctl status avahi-daemon.service

systemctl status avahi-daemon.socket

 

 

 

sed -i 's/#RemoveIPC=no/RemoveIPC=no/g' /etc/systemd/logind.conf

systemctl daemon-reload

systemctl restart systemd-logind

 

 

修改资源限制参数

 

vi /etc/security/limits.conf

 

#INFODBA SETTING

infodba                soft    nproc  16384

infodba                hard    nproc  16384

infodba                soft    nofile  16384

infodba                hard    nofile  65536

infodba        soft    stack  10240

infodba         hard    stack  32768

#infodba                hard    memlock  8192000

#infodba                soft    memlock  8192000

 

ulimit -a

 

 

控制用户分配的资源

 

echo "session required pam_limits.so" >> /etc/pam.d/login

cat /etc/pam.d/login

 

echo "* - nproc 16384"> /etc/security/limits.d/90-nproc.conf

 

修改内核参数

 

 

cat>> /etc/sysctl.conf <<EOF

#INFODBA SETTING

fs.aio-max-nr = 1048576

fs.file-max = 6815744

kernel.shmmax = 3355443200

kernel.shmall = 819200

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128          

net.ipv4.ip_local_port_range = 9000 65500

net.ipv4.conf.all.rp_filter = 2

net.ipv4.conf.default.rp_filter = 2

net.ipv4.ip_forward=1

net.core.rmem_default = 262144

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

net.core.wmem_max = 1048586

kernel.panic_on_oops = 1              

vm.nr_hugepages = 1500

vm.swappiness=5

vm.min_free_kbytes=204800

EOF

sysctl --system

 

 

 

mkdir /home/infodba

chown -R infodba:dba /home/infodba

chmod -R 775 /home/infodba

 

 

修改infodba用户的.bashrc文件

su - infodba

 

vim ~/.bashrc

 

PS1="[`whoami`@`hostname`:"'$PWD]$'

export PS1

export TMP=/tmp

export LANG=en_US.UTF8

export TMPDIR=$TMP

export ORACLE_UNQNAME=tc14

ORACLE_SID=tc13; export ORACLE_SID

ORACLE_BASE=/teamcenter/app/infodba; export ORACLE_BASE

ORACLE_HOME=$ORACLE_BASE/product/19c/db_1; export ORACLE_HOME

ORACLE_TERM=xterm; export ORACLE_TERM

NLS_DATE_FORMAT="yyyy-mm-dd HH24:MI:SS"; export NLS_DATE_FORMAT

NLS_LANG=AMERICAN_AMERICA.UTF8; export NLS_LANG

PATH=.:$PATH:$HOME/.local/bin:$HOME/bin:$ORACLE_HOME/bin; export PATH

THREADS_FLAG=native; export THREADS_FLAG

umask 022

export JAVA_HOME=/teamcenter/jdk-11.0.21

export JRE_HOME=/teamcenter/jdk-11.0.21

export CLASSPATH=.:$JAVA_HOME/lib:$CLASSPATH

export PATH=$JAVA_HOME/bin:$PATH

export PATH

 

 

exit

su - infodba

env |grep ORACLE

 

cd /teamcenter/app/infodba/product/19c/db_1

unzip -q /teamcenter/soft/LINUX.X64_193000_db_home.zip

 

 

 

用infodba用户登录suse来运行

 

 

oracle软件安装

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

mount /dev/cdrom /mnt

 

 

zypper in -y libcap-ng0-32bit libcap1-32bit libcap2-32bit libgcc_s1-32bit libXtst6-32bit nfs-kernel-server libXi6-32bit libXrender1-32bit libpcre1-32bit libpng16-16-32bit libstdc++6-32bit libaio1-32bit

 

 

 

 

zypper install libcap-ng-utils*

zypper install libcap-ng0*

zypper install libcap-progs*

zypper install libcap*

zypper install libXtst*

zypper install nfs-kernel-server*

zypper install xorg-x11-libs*

zypper install libstdc++*

zypper install libXi*

zypper install libXrender*

zypper install libjpeg62*

zypper install libpcre*

zypper install libpng*

zypper install pixz*

zypper install rdma*

zypper install gcc*

zypper install libgfor*

zypper install libgcc*

zypper install libcap-ng0*

zypper install libcap*

zypper install libX*

zypper install nfs-kernel-server*

zypper install libstdc++*

zypper install libjpeg*

zypper install libpcre*

zypper install libgfor*

zypper install libaio*

zypper install java-1_8_0-openjdk

 

 

 

 

 

 

 

 

 

 

 

安装监听

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

安装数据库实例

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

180天密码过期

select *from dba_profiles where profile='DEFAULT' and resource_name='PASSWORD_LIFE_TIME';

alter profile default limit PASSWORD_LIFE_TIME UNLIMITED;

 

 

关闭审计

show parameter audit

alter system set audit_trail=none scope=spfile;

 

安装许可(不安装许可）

root用户下

在vnc界面下

 

 

 

 

 

直接安装两层，pool以及wenlogic