最新最全oracle安裝教程【附安裝包】

最全版安裝視頻教程

安裝包下載地址
https://www.oracle.com/cn/database/technologies/oracle-database-software-downloads.html#19c
我們選用RPM包下載安裝。
安裝幫助文檔
https://docs.oracle.com/en/database/oracle/oracle-database/19/ladbi/preface.html#GUID-071A6B76-11E3-4421-963E-41DA6F2EF07A
安裝環(huán)境
cat /etc/redhat-release CentOS Linux release 7.7.1908 (Core)
在非OralceLinux環(huán)境下安裝,需要下載對應(yīng)平臺的rpm。
下載地址:
https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/index.html,搜索-19c下載最新版本即可。
安裝,首先執(zhí)行
[root@linuxtestb538 oracle]# rpm -ivh oracle-database-preinstall-19c-1.0-3.el7.x86_64.rpm warning: oracle-database-preinstall-19c-1.0-3.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEYerror: Failed dependencies:? ? ? ? bind-utils is needed by oracle-database-preinstall-19c-1.0-3.el7.x86_64? ? ? ? compat-libcap1 is needed by oracle-database-preinstall-19c-1.0-3.el7.x86_64? ? ? ? ksh is needed by oracle-database-preinstall-19c-1.0-3.el7.x86_64? ? ? ? smartmontools is needed by oracle-database-preinstall-19c-1.0-3.el7.x86_64? ? ? ? sysstat is needed by oracle-database-preinstall-19c-1.0-3.el7.x86_64? ? ? ? xorg-x11-utils is needed by oracle-database-preinstall-19c-1.0-3.el7.x86_64
執(zhí)行出現(xiàn)缺少依賴錯(cuò)誤。
改用yum命令進(jìn)行安裝
yum install oracle-database-preinstall-19c-1.0-3.el7.x86_64.rpm Installed:oracle-database-preinstall-19c.x86_64 0:1.0-3.el7? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ??
Dependency Installed:? GeoIP.x86_64 0:1.5.0-14.el7? ? ? ? ? ? ? ? ? ? ? ? ? ? ?bind-libs.x86_64 32:9.11.4-26.P2.el7_9.7? ? ? ? ? ? ? bind-libs-lite.x86_64 32:9.11.4-26.P2.el7_9.7? bind-license.noarch 32:9.11.4-26.P2.el7_9.7? ? ? ? ? ? ?bind-utils.x86_64 32:9.11.4-26.P2.el7_9.7? ? ? ? ? ? ?compat-libcap1.x86_64 0:1.10-7.el7? ? ? ? ? ? ? ? ? ? ? ? geoipupdate.x86_64 0:2.5.0-1.el7? ? ? ? ? ? ? ? ? ? ? ? ksh.x86_64 0:20120801-142.el7? ? ? ? ? ? ? ? ? ? ? ? ?smartmontools.x86_64 1:7.0-2.el7? ? ? ? ? ? ? ? ? ? ? ? ? sysstat.x86_64 0:10.1.5-19.el7? ? ? ? ? ? ? ? ? ? ? ? ? xorg-x11-utils.x86_64 0:7.5-23.el7? ? ? ? ? ? ? ? ??
Complete!
安裝 Oracle 數(shù)據(jù)庫
yum install oracle-database-ee-19c-1.0-1.x86_64.rpm Installed:oracle-database-ee-19c.x86_64 0:1.0-1Complete!
配置數(shù)據(jù)庫
/etc/init.d/oracledb_ORCLCDB-19c configure
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.
配置好后設(shè)置當(dāng)前用戶下的環(huán)境變量
vi ~/.bashrc? ? (打開文件后追加oracle的環(huán)境變量信息)---------------------------------------------------export ORACLE_HOME=/opt/oracle/product/19c/dbhome_1 export ORACLE_SID=ORCLCDBexport PATH=$ORACLE_HOME/bin:$PATH---------------------------------------------------
通過運(yùn)行source ~/.bashrc? (命令運(yùn)行后設(shè)置的環(huán)境變量生效)
驗(yàn)證安裝是否正確
su oracle? ?(用戶切換到oracle用戶)sysplus / as sysdbaSQL*Plus: Release 19.0.0.0.0 - Production on Wed Nov 17 18:59:32 2021Version 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 - ProductionVersion 19.3.0.0.0
SQL>?
運(yùn)行以上命令 確認(rèn)Oracle數(shù)據(jù)庫是否能夠正確連接成功。
如果還不會(huì)裝,可以來參加微思的Oracle OCP課程,不但分分鐘教你安裝好數(shù)據(jù)庫,還能順便學(xué)到技術(shù)考好證書,快掃碼上課吧~