Oracle 18C安装实践

---

• OS版本

[root@oel750 ~]# uname -a
Linux oel750 4.1.12-112.16.4.el7uek.x86_64 #2 SMP Mon Mar 12 23:57:12 PDT 2018 x86_64 x86_64 x86_64 GNU/Linux
[root@oel750 ~]# cat /etc/redhat-release 
Red Hat Enterprise Linux Server release 7.5 (Maipo)

• DB版本

SQL> select * from v$version;

BANNER                         BANNER_FULL                        BANNER_LEGACY                      CON_ID
-------------------------------------------------- -------------------------------------------------- -------------------------------------------------- ----------
Oracle Database 18c Enterprise Edition Release 18. Oracle Database 18c Enterprise Edition Release 18. Oracle Database 18c Enterprise Edition Release 18.      0
0.0.0.0 - Production                   0.0.0.0 - Production                   0.0.0.0 - Production
                           Version 18.3.0.0.0

OS/DB下载地址：链接

---

• 创建OS层oracle用户、组及安装目录

[root@oel750 ~]# groupadd oinstall
[root@oel750 ~]# groupadd dba
[root@oel750 ~]# useradd -g oinstall -G dba oracle
[root@oel750 ~]# mkdir /u01
[root@oel750 ~]# chown oracle: /u01
[root@oel750 ~]# chown oracle: /u01 -R
[root@oel750 ~]# ll / | grep u01
drwxr-xr-x.   2 oracle oinstall    6 Aug  7 15:08 u01
[oracle@oel750 u01]$ mkdir app/oracle/product/18.3/dbhome_1 -p

• 设置oracle环境变量

[oracle@oel750 ~]$ cat .bash_profile 
# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
    . ~/.bashrc
fi

# User specific environment and startup programs
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/18.3/dbhome_1
export PATH=$ORACLE_HOME/bin:$PATH
PATH=$PATH:$HOME/.local/bin:$HOME/bin

export PATH

• 解压oracle安装文件到ORACLE_HOME

[oracle@oel750 ~]$ unzip V978967-01.zip -d /u01/app/oracle/product/18.3/dbhome_1/

• 开始安装并处理安装过程中异常

[oracle@oel750 ~]$ cd $ORACLE_HOME
[oracle@oel750 dbhome_1]$ export DISPLAY=192.168.56.1:0.0
[oracle@oel750 dbhome_1]$ ./runInstaller

• 安装完成开始建库

[oracle@oel750 ~]$ dbca

• 至此安装完成

[oracle@oel750 ~]$ sqlplus / as sysdba

SQL*Plus: Release 18.0.0.0.0 - Production on Tue Aug 7 15:56:47 2018
Version 18.3.0.0.0

Copyright (c) 1982, 2018, Oracle.  All rights reserved.


Connected to:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.3.0.0.0

SQL> col BANNER for a50
SQL> col BANNER_FULL for a50
SQL> col BANNER_LEGACY for a50
SQL> set linesize 200
SQL> select * from v$version;

BANNER                         BANNER_FULL                        BANNER_LEGACY                      CON_ID
-------------------------------------------------- -------------------------------------------------- -------------------------------------------------- ----------
Oracle Database 18c Enterprise Edition Release 18. Oracle Database 18c Enterprise Edition Release 18. Oracle Database 18c Enterprise Edition Release 18.      0
0.0.0.0 - Production                   0.0.0.0 - Production                   0.0.0.0 - Production
                           Version 18.3.0.0.0