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"，共同學習，共同成長！！！

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/29785807/viewspace-2673708/，如需轉載，請註明出處，否則將追究法律責任。