Oracle 19C下载和安装(二)

Oracle 19C 下载和安装 ( 二 )   另一篇Oracle19C 下载和安装 ( 一 ) http://blog.itpub.net/29785807/viewspace-2633720/ 一：Oracle 19C 下载 https://www.oracle.com/cn/database/technologies/ https://www.oracle.com/database/technologies/oracle-database-software-downloads.html [root@cjcos Oracle_1903_for_Linux]# pwd /package/Oracle_1903_for_Linux [root@cjcos Oracle_1903_for_Linux]# ll -rth total 2.9G -rw-r--r--. 1 root root 2.9G Jan 16 12:11 LINUX.X64_193000_db_home.zip 二：Oracle 19C 安装 2.1 安装前检查 2.1.1 检查操作系统版本 [root@cjcos package]# cat /etc/redhat-release Red Hat Enterprise Linux Server release 7.5 (Maipo) 2.1.2 检查内存 [root@cjcos package]# free -m               total        used        free      shared  buff/cache   available Mem:           4700         929         427          14        3343        3506 Swap:          4991           0        4991 2.1.3 检查 swap space 2.1.4 检查磁盘空间 [root@cjcos package]# df -h Filesystem                 Size  Used Avail Use% Mounted on devtmpfs                   2.3G     0  2.3G   0% /dev tmpfs                      2.3G     0  2.3G   0% /dev/shm tmpfs                      2.3G  9.4M  2.3G   1% /run tmpfs                      2.3G     0  2.3G   0% /sys/fs/cgroup /dev/mapper/ol_cjcos-root  294G  7.9G  287G   3% / /dev/sda1                 1014M  217M  798M  22% /boot tmpfs                      471M   64K  471M   1% /run/user/0 2.1.5 安装补丁包 [root@cjcos ~]# cd /etc/yum.repos.d/ [root@cjcos yum.repos.d]# ls public-yum-ol7.repo [root@cjcos yum.repos.d]# wget http://yum.oracle.com/public-yum-ol7.repo --2020-01-16 13:49:43--  http://yum.oracle.com/public-yum-ol7.repo Resolving yum.oracle.com (yum.oracle.com)... 184.26.80.128 Connecting to yum.oracle.com (yum.oracle.com)|184.26.80.128|:80... connected. HTTP request sent, awaiting response... 200 OK Length: 16402 (16K) [text/plain] Saving to: ‘public-yum-ol7.repo.1’ 100%[==============================================================================================>] 16,402      --.-K/s   in 0.005s   2020-01-16 13:49:51 (2.96 MB/s) - ‘public-yum-ol7.repo.1’ saved [16402/16402] Table 4-1 (Cont.) x86-64 Oracle Linux 7 Minimum Operating System   Requirements [root@cjcos yum.repos.d]# yum -y install bc* binutils* compat-libcap1* compat-libstdc++* elfutils-libelf* elfutils-libelf-devel* fontconfig-devel* glibc* glibc-devel* ksh* libaio* libaio-devel* libXrender* libXrender-devel* libX11* libXau* libXi* libXtst* libgcc* libstdc++* libstdc++-devel* libxcb* make* net-tools* nfs-utils * python * python-configshell * python-rtslib* python-six * targetcli* smartmontools* sysstat* 2.1.6 配置所需用户、组 /usr/sbin/groupadd -g 5000 dba /usr/sbin/groupadd -g 5001 oinstall /usr/sbin/groupadd -g 5002 oper /usr/sbin/groupadd -g 5003 asmadmin /usr/sbin/groupadd -g 5004 asmoper /usr/sbin/groupadd -g 5005 asmdba /usr/sbin/groupadd -g 5006 backupdba /usr/sbin/groupadd -g 5007 dgdba /usr/sbin/groupadd -g 5008 kmdba /usr/sbin/groupadd -g 5009 racdba /usr/sbin/useradd -g oinstall -G asmadmin,asmdba,asmoper,dba grid /usr/sbin/useradd -g oinstall -G dba,asmdba,backupdba,dgdba,kmdba,racdba,oper oracle 2.1.7 检查 Resource Limits  [root@cjcos yum.repos.d]# vi /etc/security/limits.conf oracle soft nproc 131072 oracle hard nproc 131072 oracle soft nofile 131072 oracle hard nofile 65536 oracle hard nofile 131072 oracle soft nofile 131072 2.1.8 检查 Operating System Resource Parameter Settings Changing Kernel Parameter Values [root@cjcos ~]# vim /etc/sysctl.conf net.ipv4.ip_forward = 0 net.ipv4.conf.default.rp_filter = 1 net.ipv4.conf.default.accept_source_route = 0 kernel.sysrq = 0 kernel.core_uses_pid = 1 net.ipv4.tcp_syncookies = 1 kernel.msgmnb = 65536 kernel.msgmax = 65536 kernel.shmmni = 4096 kernel.sem = 250 32000 100 128 kernel.shmmax = 4398046511104 kernel.shmall = 1073741824 fs.file-max = 6815744 net.ipv4.ip_local_port_range = 9000 65500 net.core.rmem_default = 262144 net.core.wmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_max = 1048576 fs.aio-max-nr = 1048576 [root@cjcos ~]# sysctl –p 2.1.9 设置环境变量 [oracle@cjcos ~]$ vim .bash_profile export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=$ORACLE_BASE/product/1 9.0.0/dbhome_1 export ORACLE_SID= cjcdb export PATH=$ORACLE_HOME/bin:$PATH export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH [oracle@cjcos ~]$ source .bash_profile 2.1.10 设置目录 [root@cjcos yum.repos.d]# mkdir -p /u01/app/oracle [root@cjcos yum.repos.d]# mkdir -p /u01/app/oraInventory [root@cjcos yum.repos.d]# chown -R oracle:oinstall /u01/app/oracle [root@cjcos yum.repos.d]# chown -R oracle:oinstall /u01/app/oraInventory [root@cjcos yum.repos.d]# chmod -R 775 /u01/app [root@cjcos yum.repos.d]# su - oracle [oracle@cjcos ~]$ mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1 [oracle@cjcos ~]$ cd /u01/app/oracle/product/19.0.0/dbhome_1 [oracle@cjcos Oracle_1903_for_Linux]$ pwd /package/Oracle_1903_for_Linux [oracle@cjcos Oracle_1903_for_Linux]$ ll -rth total 2.9G -rw-r--r--. 1 root root 2.9G Jan 16 12:11 LINUX.X64_193000_db_home.zip [oracle@cjcos Oracle_1903_for_Linux]$ cd /u01/app/oracle/product/19.0.0/dbhome_1/ [oracle@cjcos dbhome_1]$ unzip -q /package/Oracle_1903_for_Linux/LINUX.X64_193000_db_home.zip 2.2 安装软件 [oracle@cjcos bin ]$ ./runInstaller 2.3 创建监听 [oracle@cjcos ~]$ netca 2.4 创建实例 [oracle@cjcos ~]$ dbca 2.5 验证 [oracle@cjcos ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Thu Jan 16 17:23:59 2020 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle.  All rights reserved. SQL> select banner_full from v$version; BANNER_FULL --------------------------------------------------------------------- Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.3.0.0.0 欢迎关注我的微信公众号"IT小Chen"，共同学习，共同成长！！！