OL7.6上RPM方式安装Oracle 19c的教程

所属分类: 数据库 / oracle 阅读数: 1346
收藏 0 赞 0 分享

设置主机名

[root@localhost ~]# cat /etc/hosts
127.0.0.1  localhost localhost.localdomain localhost4 localhost4.localdomain4
::1     localhost localhost.localdomain localhost6 localhost6.localdomain6
10.0.0.11 study1.localdomain study1
[root@localhost ~]# cat /etc/hostname
study1.localdomain

安装环境准备工具

其实直接rpm安装即可,它会自动解决依赖问题包括环境准备工具,但是这样oracle用户没有home目录,所以单独先安装环境准备工具

[root@study1 /]# yum -y install oracle-database-preinstall-19c
Loaded plugins: langpacks, ulninfo
ol7_UEKR5                                                                                            | 2.5 kB 00:00:00  
ol7_latest                                                                                            | 2.7 kB 00:00:00  
(1/4): ol7_UEKR5/x86_64/updateinfo                                                                                | 49 kB 00:00:01  
(2/4): ol7_latest/x86_64/updateinfo                                                                               | 1.1 MB 00:00:05  
(3/4): ol7_UEKR5/x86_64/primary_db                                                                                | 5.7 MB 00:00:27  
(4/4): ol7_latest/x86_64/primary_db                                                                               | 19 MB 00:01:21  
Resolving Dependencies
(many more lines supressed)
Installed:
 oracle-database-preinstall-19c.x86_64 0:1.0-1.el7                                                                                  
Dependency Installed:
 compat-libcap1.x86_64 0:1.10-7.el7  compat-libstdc++-33.x86_64 0:3.2.3-72.el7  glibc-devel.x86_64 0:2.17-292.0.1.el7    glibc-headers.x86_64 0:2.17-292.0.1.el7  kernel-headers.x86_64 0:3.10.0-1062.el7 
 ksh.x86_64 0:20120801-139.0.1.el7   libaio-devel.x86_64 0:0.3.109-13.el7     libstdc++-devel.x86_64 0:4.8.5-39.0.1.el7 
Dependency Updated:
 glibc.x86_64 0:2.17-292.0.1.el7                   glibc-common.x86_64 0:2.17-292.0.1.el7                   libstdc++.x86_64 0:4.8.5-39.0.1.el7                  
Complete!
[root@study1 /]#

如果是rhel或者centos,就要手工先下载preinstall的rmp包,然后本地安装(或者添加oracle linux的yum源来yum安装)

[root@study1 /]# curl -o oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm
 % Total  % Received % Xferd Average Speed  Time  Time   Time Current
                 Dload Upload  Total  Spent  Left Speed
100 18204 100 18204  0   0 18037   0 0:00:01 0:00:01 --:--:-- 18059
[root@study1 /]# yum -y localinstall oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm

安装oracle软件

[root@study1 db]# yum -y localinstall oracle-database-ee-19c-1.0-1.x86_64.rpm
Loaded plugins: langpacks, ulninfo
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
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
 Installing : oracle-database-ee-19c-1.0-1.x86_64                                                                                 1/1
[INFO] Executing post installation scripts...
[INFO] Oracle home installed successfully and ready to be configured.
To configure a sample Oracle Database you can execute the following service configuration script as root: /etc/init.d/oracledb_ORCLCDB-19c configure
 Verifying : oracle-database-ee-19c-1.0-1.x86_64                                                        1/1
Installed:
 oracle-database-ee-19c.x86_64 0:1.0-1                                                            
Complete!
[root@study1 db]#
oracle_home目录是/opt/oracle/product/19c/dbhome_1

创建数据库

[root@study1 dbhome_1]# /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
Creating Pluggable Databases
58% complete
77% complete
Executing Post Configuration Actions
100% complete
Database creation complete. For details check the logfiles at:
 /opt/oracle/cfgtoollogs/dbca/ORCLCDB.
Database Information:
Global Database Name:ORCLCDB
System Identifier(SID):ORCLCDB
Look at the log file "/opt/oracle/cfgtoollogs/dbca/ORCLCDB/ORCLCDB.log" for further details.
 
Database configuration completed successfully. The passwords were auto generated, you must change them by connecting to the database using 'sqlplus / as sysdba' as the oracle user.
[root@study1 dbhome_1]#

这默认创建了名为ORCLCDB且pdb名ORCLPDB1的数据库,当然可以不用这么创建,用传统的dbca方式

优缺点

实际上这个方式并没有什么用,比起来静默安装也并没有显得更容易,只能安装数据库软件,并不能升级数据库,而且不能用于rac,只能用于安装单实例数据库,整个部署没有给予定制空间比如oracle_home目录如果和你公司的磁盘规划不一致呢,不过新手可能认为这样更简单,这个方式仅试试而已体会一下,实际生产中几乎是不能用的

以上所述是小编给大家介绍的OL7.6上RPM方式安装Oracle 19c的教程,希望对大家有所帮助,如果大家有任何疑问请给我留言,小编会及时回复大家的。在此也非常感谢大家对脚本之家网站的支持!
如果你觉得本文对你有帮助,欢迎转载,烦请注明出处,谢谢!

更多精彩内容其他人还在看

Oracle轻松取得建表和索引的DDL语句

Oracle轻松取得建表和索引的DDL语句
收藏 0 赞 0 分享

重新编译PLSQL中的无效对象或者指定的对象 的方法

重新编译PLSQL中的无效对象或者指定的对象 的方法
收藏 0 赞 0 分享

在OracleE数据库的字段上建立索引的方法

在OracleE数据库的字段上建立索引的方法
收藏 0 赞 0 分享

oracle下加密存储过程的方法

oracle下加密存储过程的方法
收藏 0 赞 0 分享

浅谈LogMiner的使用方法

浅谈LogMiner的使用方法
收藏 0 赞 0 分享

oracle 下WITH CHECK OPTION用法

oracle 下WITH CHECK OPTION用法
收藏 0 赞 0 分享

在Oracle中向视图中插入数据的方法

在Oracle中向视图中插入数据的方法
收藏 0 赞 0 分享

DBA_2PC_PENDING 介绍

DBA_2PC_PENDING 介绍
收藏 0 赞 0 分享

在Oracle PL/SQL中游标声明中表名动态变化的方法

在Oracle PL/SQL中游标声明中表名动态变化的方法
收藏 0 赞 0 分享

DB2和 Oracle的并发控制(锁)的比较

DB2和 Oracle的并发控制(锁)的比较
收藏 0 赞 0 分享
查看更多