CentOS7安装Oracle-19c

本文目标

CentOS7使用rpm安装Oracle19c企业版

安装前准备

yum update (可选)
yum install -y compat-libcap1 compat-libstdc+±33 gcc-c++ ksh libaio-devel libstdc+±devel elfutils-libelf-devel fontconfig-devel libXrender-devel libXtst

Oracle下载

pre安装包
https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/index.html
oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm
企业版
https://www.oracle.com/database/technologies/oracle-database-software-downloads.html#19c
oracle-database-ee-19c-1.0-1.x86_64.rpm
客户端（Windows连接使用）
https://www.oracle.com/database/technologies/instant-client/winx64-64-downloads.html
instantclient-basic-windows.x64-19.17.0.0.0dbru.zip

安装pre

[root@hostyyx ~]# ll
total 2631536
-rw-------. 1 root root       1508 Dec  1 20:06 anaconda-ks.cfg
-rw-r--r--. 1 root root 2694664264 Dec  4 20:19 oracle-database-ee-19c-1.0-1.x86_64.rpm
-rw-r--r--. 1 root root      18204 Dec  4 18:08 oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm
[root@hostyyx ~]# yum localinstall ^C
[root@hostyyx ~]# yum -y localinstall oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm
Loaded plugins: fastestmirror
Examining oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm: oracle-database-preinstall-19c-1.0-1.el7.x86_64
Marking oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm to be installed
Resolving Dependencies
--> Running transaction check
---> Package oracle-database-preinstall-19c.x86_64 0:1.0-1.el7 will be installed
--> Processing Dependency: bind-utils for package: oracle-database-preinstall-19c-1.0-1.el7.x86_64
Loading mirror speeds from cached hostfile
 * base: ftp.sjtu.edu.cn
 * centos-sclo-rh: ftp.sjtu.edu.cn
 * centos-sclo-sclo: ftp.sjtu.edu.cn
 * epel: mirrors.tuna.tsinghua.edu.cn
 * extras: ftp.sjtu.edu.cn
 * updates: ftp.sjtu.edu.cn
--> Processing Dependency: nfs-utils for package: oracle-database-preinstall-19c-1.0-1.el7.x86_64
--> Processing Dependency: psmisc for package: oracle-database-preinstall-19c-1.0-1.el7.x86_64
....省略

安装Oracle

[root@hostyyx ~]# yum -y localinstall oracle-database-ee-19c-1.0-1.x86_64.rpm
Loaded plugins: fastestmirror
Examining oracle-database-ee-19c-1.0-1.x86_64.rpm: oracle-database-ee-19c-1.0-1.x86_64
Marking oracle-database-ee-19c-1.0-1.x86_64.rpm to be installed
Resolving Dependencies
--> Running transaction check
---> Package oracle-database-ee-19c.x86_64 0:1.0-1 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

===============================================================================================================================================
 Package                               Arch                  Version                 Repository                                           Size
===============================================================================================================================================
Installing:
 oracle-database-ee-19c                x86_64                1.0-1                   /oracle-database-ee-19c-1.0-1.x86_64                6.9 G

Transaction Summary
===============================================================================================================================================
Install  1 Package

Total size: 6.9 G
Installed size: 6.9 G
...省略

初始化数据库

[root@hostyyx ~]# /etc/init.d/oracledb_ORCLCDB-19c configure
Configuring Oracle Database ORCLCDB.
Prepare for db operation
8% complete
Copying database files
31% complete
Creating and starting Oracle instance
32% complete
36% complete
40% complete
43% complete
46% complete
Completing Database Creation
51% complete
54% complete
。。。省略

/etc/profile

export ORACLE_HOME=/opt/oracle/product/19c/dbhome_1 
export PATH=$PATH:/opt/oracle/product/19c/dbhome_1/bin 
export ORACLE_SID=ORCLCDB

配置数据库内容

[oracle@hostyyx ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Sun Dec 4 21:55:24 2022
Version 19.3.0.0.0

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

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
-- 创建容器用户
SQL> create user c##yinyx identified by yinyx;

User created.
-- 赋权
SQL> grant create user,drop user,alter user,create any view,connect,resource,dba,create session,create any sequence to c##yinyx;

Grant succeeded.
-- 切换到PDB实例
SQL> alter session set container=ORCLPDB1;

Session altered.

SQL> show con_name;

CON_NAME
------------------------------
ORCLPDB1
-- 创建PDB内的用户
SQL> create user yinyx identified by yinyx;

User created.
-- 赋权
SQL> grant create user,drop user,alter user,create any view,connect,resource,dba,create session,create any sequence to yinyx;

Grant succeeded.

SQL> quit;

验证安装是否正确

-- 验证容器用户是否正常
[oracle@hostyyx ~]$ sqlplus c##yinyx/yinyx@192.168.31.224/orclcdb

SQL*Plus: Release 19.0.0.0.0 - Production on Sun Dec 4 21:59:57 2022
Version 19.3.0.0.0

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


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> quit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

-- 验证PDB用户是否正常
[oracle@hostyyx ~]$ sqlplus yinyx/yinyx@192.168.31.224/orclpdb1

SQL*Plus: Release 19.0.0.0.0 - Production on Sun Dec 4 21:59:49 2022
Version 19.3.0.0.0

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


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> quit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

重启操作系统后，手工启动数据库

[root@hostyyx ~]# su - oracle
Last login: Fri Dec 30 08:59:38 CST 2022 on pts/8
[oracle@hostyyx ~]$ lsnrctl start

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 29-JAN-2023 00:19:25

Copyright (c) 1991, 2019, Oracle.  All rights reserved.

Starting /opt/oracle/product/19c/dbhome_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 19.0.0.0.0 - Production
System parameter file is /opt/oracle/product/19c/dbhome_1/network/admin/listener.ora
Log messages written to /opt/oracle/diag/tnslsnr/hostyyx/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hostyyx)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=hostyyx)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date                29-JAN-2023 00:19:27
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /opt/oracle/product/19c/dbhome_1/network/admin/listener.ora
Listener Log File         /opt/oracle/diag/tnslsnr/hostyyx/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hostyyx)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
The listener supports no services
The command completed successfully
[oracle@hostyyx ~]$ sqlplus /nolog

SQL*Plus: Release 19.0.0.0.0 - Production on Sun Jan 29 00:19:51 2023
Version 19.3.0.0.0

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

SQL> conn /as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area 1593832664 bytes
Fixed Size		    9135320 bytes
Variable Size		 1241513984 bytes
Database Buffers	  335544320 bytes
Redo Buffers		    7639040 bytes
Database mounted.
Database opened.
SQL> alter pluggable database all open;

Pluggable database altered.

SQL> quit;
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
[oracle@hostyyx ~]$ 

最后使用Navicat连接

工具->选型->环境，配置oci.dll路径到解压后的客户端，instantclient_19_17