CentOS7下Oracle19c rpm安裝過程
| 軟件 | 下載地址 |
|---|---|
| CentOS-7-x86_64-Minimal-2009.iso | http://mirrors.163.com/centos/7.9.2009/isos/x86_64/CentOS-7-x86_64-Minimal-2009.iso |
| oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm | https://www.aliyundrive.com/s/F9ziMB6nPbp |
| oracle-database-ee-19c-1.0-1.x86_64.rpm | https://www.aliyundrive.com/s/E6m5e8CCGq2 |
一. 環(huán)境配置
虛擬機(jī)安裝建議分2G內(nèi)存,30G硬盤。
關(guān)閉防火墻(或放行相關(guān)端口)
systemctl stop firewalld systemctl disable firewalld
關(guān)閉selinux
修改SELINUX=disabled
vi /etc/selinux/config
# This file controls the state of SELinux on the system.
# SELINUX= can take one of these three values:
# enforcing - SELinux security policy is enforced.
# permissive - SELinux prints warnings instead of enforcing.
# disabled - No SELinux policy is loaded.
SELINUX=disabled
# SELINUXTYPE= can take one of three values:
# targeted - Targeted processes are protected,
# minimum - Modification of targeted policy. Only selected processes are protected.
# mls - Multi Level Security protection.
SELINUXTYPE=targeted
重啟
reboot
將oracle-database-ee-19c-1.0-1.x86_64.rpm和oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm上傳到/opt下
二. 依賴安裝
安裝oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm
yum -y localinstall /opt/oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm

三. 安裝配置Oracle 19c
安裝Oracle 19c
yum -y localinstall /opt/oracle-database-ee-19c-1.0-1.x86_64.rpm

初始化Oracle數(shù)據(jù)庫(時(shí)間較長)
/etc/init.d/oracledb_ORCLCDB-19c configure

配置環(huán)境變量
卻換到oracle用戶
su - oracle
添加環(huán)境變量
vi /home/oracle/.bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$HOME/.local/bin:$HOME/bin
export PATH
export ORACLE_HOME=/opt/oracle/product/19c/dbhome_1
export PATH=$PATH:/opt/oracle/product/19c/dbhome_1/bin
export ORACLE_SID=ORCLCDB
使環(huán)境變量生效
source /home/oracle/.bash_profile
登陸數(shù)據(jù)庫
sqlplus / as sysdba

修改system密碼為123456
alter user system identified by 123456;
退出數(shù)據(jù)庫
exit;
四. 設(shè)置數(shù)據(jù)庫監(jiān)聽自啟動(dòng)
修改/etc/oratab文件N為Y
vi /etc/oratab
# This file is used by ORACLE utilities. It is created by root.sh
# and updated by either Database Configuration Assistant while creating
# a database or ASM Configuration Assistant while creating ASM instance.# A colon, ':', is used as the field terminator. A new line terminates
# the entry. Lines beginning with a pound sign, '#', are comments.
#
# Entries are of the form:
# $ORACLE_SID:$ORACLE_HOME:<N|Y>:
#
# The first and second fields are the system identifier and home
# directory of the database respectively. The third field indicates
# to the dbstart utility that the database should , "Y", or should not,
# "N", be brought up at system boot time.
#
# Multiple entries with the same $ORACLE_SID are not allowed.
#
#
ORCLCDB:/opt/oracle/product/19c/dbhome_1:Y
在/etc/rc.local中添加需執(zhí)行的命令
su root # 卻換為root用戶
vi /etc/rc.local
#!/bin/bash # THIS FILE IS ADDED FOR COMPATIBILITY PURPOSES # # It is highly advisable to create own systemd services or udev rules # to run scripts during boot instead of using this file. # # In contrast to previous versions due to parallel execution during boot # this script will NOT be run after all other services. # # Please note that you must run 'chmod +x /etc/rc.d/rc.local' to ensure # that this script will be executed during boot. touch /var/lock/subsys/local su - oracle -c 'lsnrctl start' su - oracle -c 'dbstart'
修改$ORACLE_HOME/bin/dbstart文件,修改ORACLE_HOME_LISTNER=$ORACLE_HOME
vi $ORACLE_HOME/bin/dbstart
$ORACLE_HOME/bin/dbstart 文件局部
...
#####################################
LOGMSG="logger -puser.alert -s "
trap 'exit' 1 2 3
# for script tracing
case $ORACLE_TRACE in
T) set -x ;;
esac
# Set path if path not set (if called from /etc/rc)
SAVE_PATH=/bin:/usr/bin:/etc:${PATH} ; export PATH
SAVE_LLP=$LD_LIBRARY_PATH
# First argument is used to bring up Oracle Net Listener
ORACLE_HOME_LISTNER=$ORACLE_HOME
if [ ! $ORACLE_HOME_LISTNER ]; then
echo "Since ORACLE_HOME is not set, cannot auto-start Oracle Net Listener."
echo "Usage: $0 ORACLE_HOME"
else
...
設(shè)置CentOS7,8開機(jī)執(zhí)行/etc/rc.local文件(CentOS7,8開機(jī)不執(zhí)行/etc/rc.local文件)
給 /etc/rc.d/rc.local 添加 可執(zhí)行權(quán)限
chmod a+x /etc/rc.d/rc.local
將 rc-local 服務(wù)設(shè)置成開機(jī)啟動(dòng)(默認(rèn)狀態(tài)是 static,會(huì)被其他service服務(wù)調(diào)用執(zhí)行。不過還是修改一下,以防那個(gè)服務(wù)被停用就牽連了)
systemctl enable rc-local
重啟,用sqldeveloper鏈接,驗(yàn)證是否成功
reboot

刪除/opt下oracle-database-ee-19c-1.0-1.x86_64.rpm和oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm
rm /opt/oracle-database-ee-19c-1.0-1.x86_64.rpm /opt/oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm
到此這篇關(guān)于CentOS7下Oracle19c rpm安裝過程的文章就介紹到這了,更多相關(guān)Oracle19c rpm安裝內(nèi)容請搜索腳本之家以前的文章或繼續(xù)瀏覽下面的相關(guān)文章希望大家以后多多支持腳本之家!
相關(guān)文章
oracle join on 數(shù)據(jù)過濾問題
因?yàn)樵贔OR .. IN () LOOP 游標(biāo)中使用 所以不能采用下面的查詢語句做游標(biāo)2009-07-07
Oracle 11g安裝錯(cuò)誤提示未找到wfmlrsvcapp.ear的解決方法
這篇文章主要為大家詳細(xì)介紹了Oracle 11g安裝錯(cuò)誤提示未找到wfmlrsvcapp.ear的解決方法,具有一定的參考價(jià)值,感興趣的小伙伴們可以參考一下2017-04-04
Oracle中實(shí)現(xiàn)類似于Mysql中的Field()函數(shù)功能
這篇文章主要詳細(xì)介紹了在Oracle中如何實(shí)現(xiàn)類似于Mysql中的Field()函數(shù)功能,本文主要通過代碼示例介紹了Oracle中的Decode()函數(shù)和Oracle中的row_number,需要的朋友可以參考下2023-06-06
教你使用PLSQLDeveloper14連接Oracle11g的詳細(xì)過程
今天給大家?guī)硪黄坛剃P(guān)于用PLSQLDeveloper14連接Oracle11g的詳細(xì)過程,本文分步驟通過圖文并茂的形式給大家介紹的非常詳細(xì),需要的朋友參考下吧2021-09-09
如何使用Oracle PL/SQL 實(shí)現(xiàn)發(fā)送電子郵件功能(UTL_MAIL)
這篇文章主要介紹了Oracle PL/SQL 實(shí)現(xiàn)發(fā)送電子郵件功能,今天主要給大家介紹使用UTL_MAIL實(shí)現(xiàn)發(fā)送電子郵件功能,具體實(shí)例代碼跟隨小編一起看看吧2021-08-08
oracle數(shù)據(jù)庫中chr()函數(shù)和concat函數(shù)的使用說明
這篇文章主要介紹了oracle數(shù)據(jù)庫中chr()函數(shù)和concat函數(shù)的使用說明,具有很好的參考價(jià)值,希望對大家有所幫助,如有錯(cuò)誤或未考慮完全的地方,望不吝賜教2024-07-07
Oracle出現(xiàn)超出打開游標(biāo)最大數(shù)的解決方法
這篇文章主要介紹了Oracle出現(xiàn)超出打開游標(biāo)最大數(shù)的解決方法,涉及針對Oracle游標(biāo)位置的判斷與處理技巧,具有一定參考借鑒價(jià)值,需要的朋友可以參考下2016-06-06
Oracle數(shù)據(jù)庫rownum和row_number的不同點(diǎn)
在Oracle中,有一個(gè)很有趣的東西,那就是rownum。當(dāng)你從某個(gè)表中查詢數(shù)據(jù)的時(shí)候,返回的結(jié)果集中都會(huì)帶有rownum這個(gè)字段,而且有時(shí)候也可以使用rownum進(jìn)行一些條件查詢2015-11-11

