1.部署參考鏈接:
CentOS 7 rpm方式離線安裝 Oracle 19chttps://blog.csdn.net/Vampire_1122/article/details/123038137?fromshare=blogdetail&sharetype=blogdetail&sharerId=123038137&sharerefer=PC&sharesource=weixin_45806267&sharefrom=from_link
2.獲取對應的安裝包并上傳到對應路徑
3.安裝過程(所有命令建議按順序執行)
# =============================================
#CentOS Linux 7 上離線部署Oracle 19c ?2025-08-21
# 0.前置說明:
# 把 Oracle 19c RPM 安裝包和依賴庫(libs)上傳到 /opt 目錄下
# 目錄結構示例:
# /opt/libs ? ? ? ? --> 存放 Oracle 所需依賴 rpm 包
# /opt/19c-rpm ? ? ?--> 存放 Oracle 19c 數據庫安裝 RPM 包
# =============================================
#1.臨時關閉防火墻
systemctl stop firewalld
# 2.臨時禁用 SELinux
SELINUX=disabled
#3.安裝依賴庫
cd /opt/libs
rpm -Uvh *.rpm --nodeps --force
#4.安裝 Oracle 19c
cd /opt/19c-rpm
rpm -ivh compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm ? # 兼容庫
rpm -ivh oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm ?# 預安裝包
rpm -ivh oracle-database-ee-19c-1.0-1.x86_64.rpm ? # 數據庫 RPM
#5.配置主機 IP
echo "192.168.1.100" >> /etc/hosts
#6.配置數據庫實例
vim /etc/init.d/oracledb_ORCLCDB-19c configure
export CREATE_AS_CDB=false
這個地方改為false,這是問你要不要創建容器化數據庫,如果是true以后創建的用戶好像是都要加c##所有我就設為false了然后保存退出
/etc/init.d/oracledb_ORCLCDB-19c configure
#7.切換 oracle 用戶
su oracle
#8.登錄數據庫
sqlplus / as sysdba
#9.設置環境變量
vim ~/.bash_profile
export ORACLE_BASE=/opt/oracle
export ORACLE_HOME=/opt/oracle/product/19c/dbhome_1
export ORACLE_SID=ORCLCDB
export PATH=$ORACLE_HOME/bin:$PATH:$HOME/.local/bin:$HOME/bin
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
source ~/.bash_profile
#10.修改 sys 密碼
ALTER USER sys IDENTIFIED BY "ynmes@123";
#11.配置防火墻,開放 1521 端口
systemctl start firewalld
firewall-cmd --zone=public --add-port=1521/tcp --permanent
firewall-cmd --reload
ss -tuln | grep 1521
# 如果看到類似 LISTEN 0 100 0.0.0.0:1521 ...,說明端口監聽成功
#12.以下配置開機自啟動!!!!
在root用戶下,使用systemd 來進行 oracle數據庫的啟動和關閉操作. 使用的腳本為 lsnrctl和dbstart
#12.1修改啟動配置
vi /etc/oratab
#將里面 最后一句話設置從N 修改為Y 允許啟動
ORA19C:/opt/oracle/product/19c/dbhome_1:Y
#12.2設置數據庫的啟動命令
vi /usr/bin/oracle.sh
增加的內容為:
#!/bin/bash
# ?script ?For oracle19c.service
/opt/oracle/product/19c/dbhome_1/bin/lsnrctl start
/opt/oracle/product/19c/dbhome_1/bin/dbstart /opt/oracle/product/19c/dbhome_1
chmod 775 /usr/bin/oracle.sh
#12.3設置 oracle19c.service
vim /etc/systemd/system/oracle19c.service
[Unit]
Description=Oracle19c
After=syslog.target network.target
[Service]
LimitMEMLOCK=infinity
LimitNOFILE=65535
Type=oneshot
RemainAfterExit=yes
User=oracle
Environment="ORACLE_HOME=/opt/oracle/product/19c/dbhome_1"
ExecStart=/usr/bin/oracle.sh
[Install]
WantedBy=multi-user.target
#12.4設置開機自動啟動
systemctl enable oracle19c
#12.5重啟生效
?reboot
#12.6查看是否成功
#查看是否開機自啟
systemctl list-unit-files | grep oracle19c
#查看Oracle狀態
systemctl status oracle19c