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

[[email protected] ~]# 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
[[email protected] ~]# yum localinstall ^C
[[email protected] ~]# 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

[[email protected] ~]# 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
...省略
           

初始化資料庫

[[email protected] ~]# /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;

           

驗證安裝是否正确

-- 驗證容器使用者是否正常
[[email protected] ~]$ sqlplus c##yinyx/[email protected]/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使用者是否正常
[[email protected] ~]$ sqlplus yinyx/[email protected]/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

           

重新開機作業系統後，手工啟動資料庫

[[email protected] ~]# su - oracle
Last login: Fri Dec 30 08:59:38 CST 2022 on pts/8
[[email protected] ~]$ 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
[[email protected] ~]$ 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
[[email protected] ~]$ 
           

最後使用Navicat連接配接

工具->選型->環境，配置oci.dll路徑到解壓後的用戶端，instantclient_19_17