十年网站开发经验 + 多家企业客户 + 靠谱的建站团队
量身定制 + 运营维护+专业推广+无忧售后,网站问题一站解决
这篇文章主要介绍“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 -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/19.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@cjcosbin]$ ./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
到此,关于“Oracle 19C下载和安装详细过程”的学习就结束了,希望能够解决大家的疑惑。理论与实践的搭配能更好的帮助大家学习,快去试试吧!若想继续学习更多相关知识,请继续关注创新互联网站,小编会继续努力为大家带来更多实用的文章!