Oracle--11gR2 12c--数据库软件

一、Oracle版本支持计划图

https://www.cndba.cn/dave/article/2815

二、Oracle 12c 安装

1、CentOS的准备工作

VNC的安装

yum groupinstall “X Window System” -y
yum groupinstall “Gnome Desktop” -y 抑或是Desktop、Gnome
yum install tigervnc-server -y

cp /lib/systemd/system/vncserver@.service /etc/systemd/system/vncserver@:1.service
vi
#Type=forking
Type=simple
systemctl daemon-reload

su - oracle
vncpasswd
exit

systemctl start vncserver@:1.service
systemctl status vncserver@:1.service

startx 启动图形界面
https://jingyan.baidu.com/article/7f766daf42ce984100e1d045.html
http://blog.itpub.net/7607759/viewspace-2133501/
https://blog.csdn.net/u010638969/article/details/51244933

参考：https://blog.csdn.net/ChenHui_Felix/article/details/83090410
结尾有一键脚本：oracle.sh运行到重启服务器

firewall-cmd --zone=public --add-port=1521/tcp --permanent
firewall-cmd --zone=public --add-port=5500/tcp --permanent
firewall-cmd --zone=public --add-port=5502/tcp --permanent
firewall-cmd --reload

vi /etc/selinux/config
SELINUX=disabled

hostnamectl set-hostname oratest
vi /etc/hosts
增加192.168.10.176 oratest

vi /etc/systemd/logind.conf
RemoveIPC=no
systemctl daemon-reload
systemctl restart systemd-logind

参考：http://blog.itpub.net/29371470/viewspace-2125673/ RemoveIPC

 yum install binutils compat-libcap1 compat-libstdc++-33 gcc gcc-c++ \
> glibc glibc-devel ksh libaio libaio-devel \
> libgcc libstdc++ libstdc++-devel make sysstat -y

ASM略过

mkdir -p /u01/12.2.0/grid
mkdir -p /u01/app/grid
mkdir -p /u01/app/oracle 
chown -R grid:oinstall /u01
chown -R oracle:oinstall /u01/app/oracle
chmod -R 775 /u01

groupadd oinstall
groupadd dba
groupadd asmdba
groupadd asmadmin
groupadd asmoper
groupadd oper
groupadd backupdba
groupadd dgdba
groupadd kmdba
useradd -g oinstall -G asmadmin,asmdba,asmoper,oper,dba grid
useradd -g oinstall -G dba,asmdba,oper,backupdba,dgdba,kmdba oracle
#设置用户密码
passwd grid
passwd oracle

vi /home/grid/.bash_profile
export NLS_LANG=AMERICAN_AMERICA.UTF8
export LANG=en_US.UTF-8
export ORACLE_HOME=/u01/12.2.0/grid
export ORACLE_SID=+ASM
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/bin:/bin:/usr/bin:/usr/local/bin:/usr/X11R6/bin
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

vi /home/oracle/.bash_profile
export NLS_LANG=AMERICAN_AMERICA.UTF8
export LANG=en_US.UTF-8
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/12.2.0/dbhome_1
export ORACLE_SID=orcl
export ORACLE_TERM=xterm
export PATH=/usr/sbin:$PATH
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/bin:/bin:/usr/bin:/usr/local/bin:/usr/X11R6/bin/
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

vi /etc/pam.d/login
session required pam_limits.so
 
vi /etc/security/limits.conf
oracle soft nproc 16384
oracle hard nproc 16384 
oracle soft nofile 1024 
oracle hard nofile 65536
oracle  soft  stack  10240
oracle  hard stack  32768
grid   soft   nofile    1024
grid   hard   nofile    65536
grid   soft   nproc    16384
grid   hard   nproc    16384
grid   soft   stack    10240
grid   hard   stack    32768
 
vi /etc/sysctl.conf
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 4294967296
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
 
vi /etc/fstab 
tmpfs                   /dev/shm                tmpfs   defaults,size=12G        0 0
tmpfs                   /run                    tmpfs   defaults,size=12G        0 0
tmpfs                  /sys/fs/cgroup           tmpfs   defaults,size=12G        0 0

oracleasm configure -i

oracle.sh：https://share.weiyun.com/5fK1fu8
重启服务器，使上述生效

fdisk /dev/sdb
oracleasm createdisk myasm01 /dev/sdb1
oracleasm createdisk myasm02 /dev/sdc1
oracleasm createdisk myasm03 /dev/sdd1
oracleasm scandisks
oracleasm listdisks

参考：https://jingyan.baidu.com/article/cbf0e500a9731e2eab289371.html fdisk分区

2、图形化界面安装

3、启动关闭数据库

oracle>sqlplus / as sysdba
shutdown immediate
startup

grid>sqlplus / as sysasm
shutdown immediate
startup

srvctl start|stop|enable asm
srvctl start|stop database -db orcl

oracle>sqlplus / as sysdba
exec DBMS_XDB_CONFIG.SETHTTPPORT(5502);
exec DBMS_XDB_CONFIG.SETHTTPSPORT(5500);
exec DBMS_XDB_CONFIG.SETHTTPSPORT(0);
exec DBMS_XDB_CONFIG.SETHTTPPORT(0);
SELECT dbms_xdb_config.gethttpsport FROM DUAL;
SELECT dbms_xdb_config.gethttpport FROM DUAL;

4、参考

https://blog.csdn.net/ChenHui_Felix/article/details/83090410