暂无图片
暂无图片
1
暂无图片
暂无图片
暂无图片

Oracle Linux-R8-U6最简化安装oracle 19c单机数据库

原创 _ 云和恩墨 2022-09-11
1395

一、查找预安装包

yum search oracle 上次元数据过期检查:0:00:10 前,执行于 2022年09月11日 星期日 23时20分09秒。 ======================================================================================== 名称 和 概况 匹配:oracle ======================================================================================= NetworkManager-config-connectivity-oracle.noarch : NetworkManager config file for connectivity checking via Oracle servers kmod-redhat-oracleasm.src : oracleasm kernel module kmod-redhat-oracleasm.x86_64 : oracleasm kernel module kmod-redhat-oracleasm-kernel_4_18_0_240.x86_64 : oracleasm kernel module for kernel version 4.18.0-240.el8..4.18.0-240.14.1.el8_3 kmod-redhat-oracleasm-kernel_4_18_0_240_14_1.x86_64 : oracleasm kernel module for kernel version 4.18.0-240.14.1.el8_3 and higher oracle-backgrounds.noarch : Oracle-related desktop backgrounds oracle-database-preinstall-19c.src : Oracle Database Preinstallation RPM oracle-database-preinstall-19c.x86_64 : Oracle Database Preinstallation RPM oracle-database-preinstall-21c.src : Oracle Database Preinstallation RPM oracle-database-preinstall-21c.x86_64 : Oracle Database Preinstallation RPM oracle-indexhtml.noarch : Browser default start page for Oracle Linux oracle-indexhtml.src : Browser default start page for Oracle Linux oracle-instantclient-release-el8.src : Oracle Instant Client yum repository configuration oracle-instantclient-release-el8.x86_64 : Oracle Instant Client yum repository configuration oracle-linux-manager-client-release-el8.src : Oracle Linux Manager Client yum repository configuration oracle-linux-manager-client-release-el8.x86_64 : Oracle Linux Manager Client yum repository configuration oracle-logos.x86_64 : Oracle-related icons and pictures oracle-logos.src : Oracle-related icons and pictures oracle-logos-httpd.noarch : Oracle-related icons and pictures used by httpd oracle-logos-ipa.noarch : Oracle-related icons and pictures used by ipa oracle-olcne-release-el8.src : Oracle Linux Cloud Native Environment yum repository configuration oracle-olcne-release-el8.x86_64 : Oracle Linux Cloud Native Environment yum repository configuration oracle-release-el8.src : Oracle Software yum repository configuration oracle-release-el8.x86_64 : Oracle Software yum repository configuration oracle-software-release-el8.src : Oracle Software yum repository configuration oracle-software-release-el8.x86_64 : Oracle Software yum repository configuration oraclelinux-automation-manager-release-el8.src : Oracle Linux Automation Manager yum repository configuration oraclelinux-automation-manager-release-el8.x86_64 : Oracle Linux Automation Manager yum repository configuration oraclelinux-developer-release-el8.src : Oracle Linux Developer yum repository configuration oraclelinux-developer-release-el8.x86_64 : Oracle Linux Developer yum repository configuration oraclelinux-release.src : Oracle Linux 8 release file oraclelinux-release.x86_64 : Oracle Linux 8 release file oraclelinux-release-el8.src : Oracle Linux yum repository configuration oraclelinux-release-el8.x86_64 : Oracle Linux yum repository configuration pcp-pmda-oracle.x86_64 : Performance Co-Pilot (PCP) metrics for the Oracle database tuned-profiles-oracle.noarch : Additional tuned profile(s) targeted to Oracle loads ========================================================================================== 名称 匹配:oracle =========================================================================================== oracle-epel-release-el8.src : Extra Packages for Enterprise Linux (EPEL) yum repository configuration oracle-epel-release-el8.x86_64 : Extra Packages for Enterprise Linux (EPEL) yum repository configuration oracle-gluster-release-el8.src : Gluster yum repository configuration oracle-gluster-release-el8.x86_64 : Gluster yum repository configuration oracle-ovirt-release-el8.src : oVirt yum repository configuration oracle-ovirt-release-el8.x86_64 : oVirt yum repository configuration oracle-spacewalk-client-release-el8.src : Spacewalk Client yum repository configuration oracle-spacewalk-client-release-el8.x86_64 : Spacewalk Client yum repository configuration ========================================================================================== 概况 匹配:oracle ============================================================================================= kernel-uek.src : Oracle Unbreakable Enterprise Kernel Release 6 kernel-uek.x86_64 : Oracle Unbreakable Enterprise Kernel Release 6 linux-firmware-core.noarch : Firmware files for Oracle kernel-uek-core RPM ocfs2-tools.src : Tools for managing the Oracle Cluster Filesystem 2 ocfs2-tools.x86_64 : Tools for managing the Oracle Cluster Filesystem 2#

二、安装预安装包

[root@19c01 ~]# yum install oracle-database-preinstall-19c.x86_64 上次元数据过期检查:0:02:16 前,执行于 2022年09月11日 星期日 23时20分09秒。 依赖关系解决。 ============================================================================================================================================================================================================== 软件包 架构 版本 仓库 大小 ============================================================================================================================================================================================================== 安装: oracle-database-preinstall-19c x86_64 1.0-2.el8 ol8_appstream 31 k 安装依赖关系: ksh x86_64 20120801-254.0.1.el8 ol8_appstream 927 k libaio-devel x86_64 0.3.112-1.el8 ol8_baseos_latest 19 k libnsl x86_64 2.28-189.1.0.1.el8 ol8_baseos_latest 103 k 事务概要 ============================================================================================================================================================================================================== 安装 4 软件包 总下载:1.1 M 安装大小:3.4 M 确定吗?[y/N]: 确定吗?[y/N]: y 下载软件包: (1/4): libaio-devel-0.3.112-1.el8.x86_64.rpm 6.8 kB/s | 19 kB 00:02 (2/4): oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm 41 kB/s | 31 kB 00:00 (3/4): libnsl-2.28-189.1.0.1.el8.x86_64.rpm 25 kB/s | 103 kB 00:04 (4/4): ksh-20120801-254.0.1.el8.x86_64.rpm 145 kB/s | 927 kB 00:06 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 总计 168 kB/s | 1.1 MB 00:06 Oracle Linux 8 BaseOS Latest (x86_64) 3.0 MB/s | 3.1 kB 00:00 导入 GPG 公钥 0xAD986DA3: Userid: "Oracle OSS group (Open Source Software group) <build@oss.oracle.com>" 指纹: 76FD 3DB1 3AB6 7410 B89D B10E 8256 2EA9 AD98 6DA3 来自: /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle 确定吗?[y/N]: y 导入公钥成功 运行事务检查 事务检查成功。 运行事务测试 事务测试成功。 运行事务 准备中 : 1/1 安装 : ksh-20120801-254.0.1.el8.x86_64 1/4 运行脚本: ksh-20120801-254.0.1.el8.x86_64 1/4 安装 : libnsl-2.28-189.1.0.1.el8.x86_64 2/4 安装 : libaio-devel-0.3.112-1.el8.x86_64 3/4 运行脚本: oracle-database-preinstall-19c-1.0-2.el8.x86_64 4/4 安装 : oracle-database-preinstall-19c-1.0-2.el8.x86_64 4/4 运行脚本: oracle-database-preinstall-19c-1.0-2.el8.x86_64 4/4 验证 : libaio-devel-0.3.112-1.el8.x86_64 1/4 验证 : libnsl-2.28-189.1.0.1.el8.x86_64 2/4 验证 : ksh-20120801-254.0.1.el8.x86_64 3/4 验证 : oracle-database-preinstall-19c-1.0-2.el8.x86_64 4/4 已安装: ksh-20120801-254.0.1.el8.x86_64 libaio-devel-0.3.112-1.el8.x86_64 libnsl-2.28-189.1.0.1.el8.x86_64 oracle-database-preinstall-19c-1.0-2.el8.x86_64 完毕!

三、验证

[root@19c01 ~]# id oracle uid=54321(oracle) gid=54321(oinstall) 组=54321(oinstall),54330(racdba),54322(dba),54323(oper),54324(backupdba),54325(dgdba),54326(kmdba) [root@19c01 ~]# cat /etc/sysctl.conf # sysctl settings are defined through files in # /usr/lib/sysctl.d/, /run/sysctl.d/, and /etc/sysctl.d/. # # Vendors settings live in /usr/lib/sysctl.d/. # To override a whole file, create a new file with the same in # /etc/sysctl.d/ and put new settings there. To override # only specific settings, add a file with a lexically later # name in /etc/sysctl.d/ and put new settings there. # # For more information, see sysctl.conf(5) and sysctl.d(5). # oracle-database-preinstall-19c setting for fs.file-max is 6815744 fs.file-max = 6815744 # oracle-database-preinstall-19c setting for kernel.sem is '250 32000 100 128' kernel.sem = 250 32000 100 128 # oracle-database-preinstall-19c setting for kernel.shmmni is 4096 kernel.shmmni = 4096 # oracle-database-preinstall-19c setting for kernel.shmall is 1073741824 on x86_64 kernel.shmall = 1073741824 # oracle-database-preinstall-19c setting for kernel.shmmax is 4398046511104 on x86_64 kernel.shmmax = 4398046511104 # oracle-database-preinstall-19c setting for kernel.panic_on_oops is 1 per Orabug 19212317 kernel.panic_on_oops = 1 # oracle-database-preinstall-19c setting for net.core.rmem_default is 262144 net.core.rmem_default = 262144 # oracle-database-preinstall-19c setting for net.core.rmem_max is 4194304 net.core.rmem_max = 4194304 # oracle-database-preinstall-19c setting for net.core.wmem_default is 262144 net.core.wmem_default = 262144 # oracle-database-preinstall-19c setting for net.core.wmem_max is 1048576 net.core.wmem_max = 1048576 # oracle-database-preinstall-19c setting for net.ipv4.conf.all.rp_filter is 2 net.ipv4.conf.all.rp_filter = 2 # oracle-database-preinstall-19c setting for net.ipv4.conf.default.rp_filter is 2 net.ipv4.conf.default.rp_filter = 2 # oracle-database-preinstall-19c setting for fs.aio-max-nr is 1048576 fs.aio-max-nr = 1048576 # oracle-database-preinstall-19c setting for net.ipv4.ip_local_port_range is 9000 65500 net.ipv4.ip_local_port_range = 9000 65500

四、环境变量

umask 022 TMP=/tmp; export TMP TMPDIR=$TMP; export TMPDIR ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE ORACLE_HOME=$ORACLE_BASE/product/19.3.0/dbhome_1; export ORACLE_HOME ORACLE_SID=PRODCDB; export ORACLE_SID ORACLE_TERM=xterm; export ORACLE_TERM NLS_LANG="AMERICAN_CHINA.ZHS16GBK"; export NLS_LANG PATH=/usr/sbin:$PATH; export PATH PATH=$ORACLE_HOME/bin:$PATH; export PATH LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH if [ $USER = "oracle" ]; then if [ $SHELL = "/bin/ksh" ]; then ulimit -p 16384 ulimit -n 65536 else ulimit -u 16384 -n 65536 fi fi

五、解压缩安装

[root@19c01 u01]# chown oracle:oinstall LINUX.X64_193000_db_home.zip [root@19c01 u01]# chmod 777 LINUX.X64_193000_db_home.zip [root@19c01 u01]# su - oracle [oracle@19c01 ~]$ cd /u01 [oracle@19c01 u01]$ ls [oracle@19c01 u01]$ unzip LINUX.X64_193000_db_home.zip -d $ORACLE_HOME [root@19c01 u01]# passwd oracle 更改用户 oracle 的密码 。 新的 密码: 无效的密码: 密码未通过字典检查 - 不包括足够不同的字符 重新输入新的 密码: passwd:所有的身份验证令牌已经成功更新。 [oracle@19c01 ~]$ export LANG=en_US [oracle@19c01 ~]$ .$ORACLE_HOME/runInstaller.sh [INS-08101] Unexpected error while executing the action at state: 'supportedOSCheck' --操作系统不兼容 [oracle@19c01 ~]$export CV_ASSUME_DISTID=RHEL7.6 --解决操作系统不兼容 [oracle@19c01 ~]$ .$ORACLE_HOME/runInstaller.sh

六、其它

注意到 /etc/hosts没写主机ip及host映射依然可以正常安装,11g不添加后面有个地方会报错的

[root@19c01 ~]# cat /etc/hosts 127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 ::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
最后修改时间:2022-09-13 09:31:04
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论