OL7.6上RPM方式安裝Oracle 19c的教程
設(shè)置主機名
[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
安裝環(huán)境準(zhǔn)備工具
其實直接rpm安裝即可,它會自動解決依賴問題包括環(huán)境準(zhǔn)備工具,但是這樣oracle用戶沒有home目錄,所以單獨先安裝環(huán)境準(zhǔn)備工具
[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
創(chuàng)建數(shù)據(jù)庫
[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]#
這默認(rèn)創(chuàng)建了名為ORCLCDB且pdb名ORCLPDB1的數(shù)據(jù)庫,當(dāng)然可以不用這么創(chuàng)建,用傳統(tǒng)的dbca方式
優(yōu)缺點
實際上這個方式并沒有什么用,比起來靜默安裝也并沒有顯得更容易,只能安裝數(shù)據(jù)庫軟件,并不能升級數(shù)據(jù)庫,而且不能用于rac,只能用于安裝單實例數(shù)據(jù)庫,整個部署沒有給予定制空間比如oracle_home目錄如果和你公司的磁盤規(guī)劃不一致呢,不過新手可能認(rèn)為這樣更簡單,這個方式僅試試而已體會一下,實際生產(chǎn)中幾乎是不能用的
總結(jié)
以上所述是小編給大家介紹的OL7.6上RPM方式安裝Oracle 19c的教程,希望對大家有所幫助,如果大家有任何疑問請給我留言,小編會及時回復(fù)大家的。在此也非常感謝大家對腳本之家網(wǎng)站的支持!
如果你覺得本文對你有幫助,歡迎轉(zhuǎn)載,煩請注明出處,謝謝!
相關(guān)文章
WINDOWS下使用DOS命令行連接oracle數(shù)據(jù)庫
本文講述了通過windows下的DOS命令連接oracle數(shù)據(jù)庫并進(jìn)行簡單操作的方法2018-03-03Oracle 存儲過程總結(jié)(一、基本應(yīng)用)
Oracle 存儲過程總結(jié) 基本應(yīng)用技巧,大家可以學(xué)習(xí)下oracle存儲過程最基本的東西。2009-07-07解決Windows10不能安裝Oracle?11g的問題(附詳細(xì)安裝教程)
這篇文章介紹了解決Windows10不能安裝Oracle?11g的方法,對大家的學(xué)習(xí)或者工作具有一定的參考學(xué)習(xí)價值,需要的朋友們下面隨著小編來一起學(xué)習(xí)學(xué)習(xí)吧2022-04-04Oracle Linux 6.8安裝 mysql 5.7.17的詳細(xì)教程
這篇文章主要介紹了Oracle Linux 6.8安裝 mysql 5.7.17的詳細(xì)教程,需要的朋友可以參考下2017-06-06Oracle Database 10g數(shù)據(jù)庫安裝及配置教程
這篇文章主要介紹了Oracle Database 10g Release 2數(shù)據(jù)庫安裝及配置教程,感興趣的小伙伴們可以參考一下2016-08-08Oracle中簡單查詢、限定查詢、數(shù)據(jù)排序SQL語句范例和詳細(xì)注解
這篇文章主要介紹了Oracle中簡單查詢、限定查詢、數(shù)據(jù)排序SQL語句范例和詳細(xì)注解,對查詢語法一并做了介紹,需要的朋友可以參考下2014-07-07