Oracle 19C下载和安装详细过程

这篇文章主要介绍“Oracle 19C下载和安装详细过程”，在日常操作中，相信很多人在Oracle 19C下载和安装详细过程问题上存在疑惑，小编查阅了各式资料，整理出简单好用的操作方法，希望对大家解答”Oracle 19C下载和安装详细过程”的疑惑有所帮助！接下来，请跟着小编一起来学习吧！一：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 -rthtotal 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-releaseRed Hat Enterprise Linux Server release 7.5 (Maipo)2.1.2
检查内存[root@cjcos 免费云主机域名package]# free -mtotal used free shared buff/cache availableMem: 4700 929 427 14 3343 3506Swap: 4991 0 49912.1.3检查swap space2.1.4
检查磁盘空间[root@cjcos package]# df -hFilesystem Size Used Avail Use% Mounted ondevtmpfs 2.3G 0 2.3G 0% /devtmpfs 2.3G 0 2.3G 0% /dev/shmtmpfs 2.3G 9.4M 2.3G 1% /runtmpfs 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% /boottmpfs 471M 64K 471M 1% /run/user/02.1.5
安装补丁包[root@cjcos ~]# cd /etc/yum.repos.d/[root@cjcos yum.repos.d]# lspublic-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.repoResolving yum.oracle.com (yum.oracle.com)… 184.26.80.128Connecting to yum.oracle.com (yum.oracle.com)|184.26.80.128|:80… connected.HTTP request sent, awaiting response… 200 OKLength: 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 SystemRequirements[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 oracle2.1.7
检查Resource Limits[root@cjcos yum.repos.d]# vi /etc/security/limits.conforacle soft nproc 131072 oracle hard nproc 131072 oracle soft nofile 131072oracle hard nofile 65536 oracle hard nofile 131072 oracle soft nofile 1310722.1.8
检查Operating System Resource Parameter SettingsChanging 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 –p2.1.9
设置环境变量[oracle@cjcos ~]$ vim .bash_profileexport ORACLE_BASE=/u01/app/oracleexport ORACLE_HOME=$ORACLE_BASE/product/19.0.0/dbhome_1export ORACLE_SID=cjcdbexport PATH=$ORACLE_HOME/bin:$PATHexport LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH[oracle@cjcos ~]$ source .bash_profile2.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 -rthtotal 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.zip2.2
安装软件[oracle@cjcos bin]$ ./runInstaller2.3
创建监听[oracle@cjcos ~]$ netca2.4
创建实例[oracle@cjcos ~]$ dbca2.5
验证[oracle@cjcos ~]$ sqlplus / as sysdbaSQL*Plus: Release 19.0.0.0.0 – Production on Thu Jan 16 17:23:59 2020Version 19.3.0.0.0Copyright (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 – ProductionVersion 19.3.0.0.0到此，关于“Oracle 19C下载和安装详细过程”的学习就结束了，希望能够解决大家的疑惑。理论与实践的搭配能更好的帮助大家学习，快去试试吧！若想继续学习更多相关知识，请继续关注百云网站，小编会继续努力为大家带来更多实用的文章！

相关推荐: 【dbms_xplan包】对比试验之ALL与ADVANCED +PEEKED_BINDS区别

结论：1、ADVANCED只比ALL多了一个Outline Data 结论：2、ADVANCED +PEEKED_BINDS比ADVANCED多显示了一个Peeked Binds (identified by position):，如果SQL语句并没有使用绑定…