設置主機名
|
1
2
3
4
5
6
|
[root@localhost ~]# cat /etc/hosts127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4::1 localhost localhost.localdomain localhost6 localhost6.localdomain610.0.0.11 study1.localdomain study1[root@localhost ~]# cat /etc/hostnamestudy1.localdomain |
安裝環境準備工具
其實直接rpm安裝即可，它會自動解決依賴問題包括環境準備工具，但是這樣oracle用戶沒有home目錄，所以單獨先安裝環境準備工具
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
[root@study1 /]# yum -y install oracle-database-preinstall-19cLoaded plugins: langpacks, ulninfool7_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安裝)
|
1
2
3
4
5
|
[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 Speed100 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軟件
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
|
[root@study1 db]# yum -y localinstall oracle-database-ee-19c-1.0-1.x86_64.rpmLoaded plugins: langpacks, ulninfoExamining oracle-database-ee-19c-1.0-1.x86_64.rpm: oracle-database-ee-19c-1.0-1.x86_64Marking oracle-database-ee-19c-1.0-1.x86_64.rpm to be installedResolving Dependencies--> Running transaction check---> Package oracle-database-ee-19c.x86_64 0:1.0-1 will be installed--> Finished Dependency ResolutionDependencies 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 GTransaction Summary========================================================================================================================================================================================================================Install 1 PackageTotal size: 6.9 GInstalled size: 6.9 GDownloading packages:Running transaction checkRunning transaction testTransaction test succeededRunning 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/1Installed: oracle-database-ee-19c.x86_64 0:1.0-1 Complete![root@study1 db]#oracle_home目錄是/opt/oracle/product/19c/dbhome_1 |
創建數據庫
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
|
[root@study1 dbhome_1]# /etc/init.d/oracledb_ORCLCDB-19c configureConfiguring Oracle Database ORCLCDB.Prepare for db operation8% completeCopying database files31% completeCreating and starting Oracle instance32% complete36% complete40% complete43% complete46% completeCompleting Database Creation51% complete54% completeCreating Pluggable Databases58% complete77% completeExecuting Post Configuration Actions100% completeDatabase creation complete. For details check the logfiles at: /opt/oracle/cfgtoollogs/dbca/ORCLCDB.Database Information:Global Database Name:ORCLCDBSystem Identifier(SID):ORCLCDBLook 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]# |
這默認創建了名為ORCLCDB且pdb名ORCLPDB1的數據庫，當然可以不用這么創建，用傳統的dbca方式
優缺點
實際上這個方式并沒有什么用，比起來靜默安裝也并沒有顯得更容易，只能安裝數據庫軟件，并不能升級數據庫，而且不能用于rac，只能用于安裝單實例數據庫，整個部署沒有給予定制空間比如oracle_home目錄如果和你公司的磁盤規劃不一致呢，不過新手可能認為這樣更簡單，這個方式僅試試而已體會一下，實際生產中幾乎是不能用的
總結
以上所述是小編給大家介紹的OL7.6上RPM方式安裝Oracle 19c的教程,希望對大家有所幫助，如果大家有任何疑問請給我留言，小編會及時回復大家的。在此也非常感謝大家對服務器之家網站的支持！
如果你覺得本文對你有幫助，歡迎轉載，煩請注明出處，謝謝！
原文鏈接：https://www.cnblogs.com/yongestcat/archive/2019/08/28/11419602.html
