Oracle Linux DB安装

布满荆棘的人生 2022-08-28 03:51 249阅读 0赞

**！！！原文出处，国外大佬写的，安装过程中的问题一样，解决方案全都有效：**[https://ahmedfattah.com/2020/01/13/oracle-database-19c-installation-on-oracle-cloud-compute-instance/][https_ahmedfattah.com_2020_01_13_oracle-database-19c-installation-on-oracle-cloud-compute-instance]

>  *  参考链接1：[https://blog.csdn.net/qqqyyy0422/article/details/106471309?spm=1001.2101.3001.6650.3&utm\_medium=distribute.pc\_relevant.none-task-blog-2%7Edefault%7ECTRLIST%7Edefault-3.no\_search\_link&depth\_1-utm\_source=distribute.pc\_relevant.none-task-blog-2%7Edefault%7ECTRLIST%7Edefault-3.no\_search\_link][https_blog.csdn.net_qqqyyy0422_article_details_106471309_spm_1001.2101.3001.6650.3_utm_medium_distribute.pc_relevant.none-task-blog-2_7Edefault_7ECTRLIST_7Edefault-3.no_search_link_depth_1-utm_source_distribute.pc_relevant.none-task-blog-2_7Edefault_7ECTRLIST_7Edefault-3.no_search_link]
>  *  参考链接2：[https://blog.csdn.net/bisal/article/details/100909708][https_blog.csdn.net_bisal_article_details_100909708]
>  *  参考链接3：[oracle数据库基本语法][oracle]

--------------------

> 问题

yum search ifconfig
    
    [Errno 14] curl#6 - "Could not resolve host: yum.oracle.com; Unknow error"

解决方法：

dhclient

参考1：[http://shafiulladba.blogspot.com/2019/02/yum-could-not-resolve-host-trying-other.html][http_shafiulladba.blogspot.com_2019_02_yum-could-not-resolve-host-trying-other.html]  
参考2：[https://databasehustler.home.blog/2019/08/22/errno-14-curl6-could-not-resolve-host-yum-oracle-com-unknown-error/][https_databasehustler.home.blog_2019_08_22_errno-14-curl6-could-not-resolve-host-yum-oracle-com-unknown-error]  
参考3：[https://linux.die.net/man/8/dhclient][https_linux.die.net_man_8_dhclient]  
参考4：[https://unix.stackexchange.com/questions/361752/unable-to-yum-install-on-oracle-linux-7-machine/674266\#674266?newreg=5c729fee9d9d421dbe22c8a90f0401f7][https_unix.stackexchange.com_questions_361752_unable-to-yum-install-on-oracle-linux-7-machine_674266_674266_newreg_5c729fee9d9d421dbe22c8a90f0401f7]

> 关闭防火墙

![关闭防火墙][watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAYmx0c2U_size_20_color_FFFFFF_t_70_g_se_x_16]

vi /etc/selinux/config

![关闭][watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAYmx0c2U_size_20_color_FFFFFF_t_70_g_se_x_16 1]

--------------------

## 安装 ##

> Step1：该包将为 Oracle 软件安装准备环境（安装所需的包、创建用户、创建目录、设置限制等）。

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
    
    yum -y install oracle-database-preinstall-19c

> Step2: Download the Oracle Database 19c Software

wget https://www.oracle.com/database/technologies/oracle19c-linux-downloads.html
    
    yum -y localinstall oracle-database-ee-19c-1.0-1.x86_64.rpm

> Step3：创建和配置 Oracle 数据库

/etc/init.d/oracledb_ORCLCDB-19c configure

将会遇到的问题及解决办法如下：

> 问题1
> 
>  *  `[WARNING] ORA-04031: unable to allocate 1048848 bytes of shared memory (“shared pool”,”unknown object”,”PDB Dynamic He”,”alls-ktimcem”)`
>  *  `[WARNING] ORA-04031: unable to allocate 1048848 bytes of shared memory (“shared pool”,”unknown object”,”PDB Dynamic He”,”alls-ktimcem”)`

Oracle 根据系统物理内存的 40% 实时计算 memory\_target 的值。

解决方法，在对应的配置文件中修改这个默认的参数值：

cd /opt/oracle/product/19c/dbhome_1/assistants/dbca/templates/
    vim General_Purpose.dbc

![修改内存容量比][watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAYmx0c2U_size_20_color_FFFFFF_t_70_g_se_x_16 2]  
将其从 40 修改为 70 或更多。

在再次运行命令之前，由于之前命令失败，需要先做一些清理：

> 杀死该进程，并删除网络配置

/opt/oracle/product/19c/dbhome_1/bin/lsnrctl stop
    
    ls /opt/oracle/product/19c/dbhome_1/network/admin
    rm -rf *.ora

> 重新运行

/etc/init.d/oracledb_ORCLCDB-19c configure

最后，数据库成功创建：  
![创建成功][watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAYmx0c2U_size_20_color_FFFFFF_t_70_g_se_x_16 3]

[https_ahmedfattah.com_2020_01_13_oracle-database-19c-installation-on-oracle-cloud-compute-instance]: https://ahmedfattah.com/2020/01/13/oracle-database-19c-installation-on-oracle-cloud-compute-instance/
[https_blog.csdn.net_qqqyyy0422_article_details_106471309_spm_1001.2101.3001.6650.3_utm_medium_distribute.pc_relevant.none-task-blog-2_7Edefault_7ECTRLIST_7Edefault-3.no_search_link_depth_1-utm_source_distribute.pc_relevant.none-task-blog-2_7Edefault_7ECTRLIST_7Edefault-3.no_search_link]: https://blog.csdn.net/qqqyyy0422/article/details/106471309?spm=1001.2101.3001.6650.3&utm_medium=distribute.pc_relevant.none-task-blog-2%7Edefault%7ECTRLIST%7Edefault-3.no_search_link&depth_1-utm_source=distribute.pc_relevant.none-task-blog-2%7Edefault%7ECTRLIST%7Edefault-3.no_search_link
[https_blog.csdn.net_bisal_article_details_100909708]: https://blog.csdn.net/bisal/article/details/100909708
[oracle]: https://blog.csdn.net/qq_42589612/article/details/80943957
[http_shafiulladba.blogspot.com_2019_02_yum-could-not-resolve-host-trying-other.html]: http://shafiulladba.blogspot.com/2019/02/yum-could-not-resolve-host-trying-other.html
[https_databasehustler.home.blog_2019_08_22_errno-14-curl6-could-not-resolve-host-yum-oracle-com-unknown-error]: https://databasehustler.home.blog/2019/08/22/errno-14-curl6-could-not-resolve-host-yum-oracle-com-unknown-error/
[https_linux.die.net_man_8_dhclient]: https://linux.die.net/man/8/dhclient
[https_unix.stackexchange.com_questions_361752_unable-to-yum-install-on-oracle-linux-7-machine_674266_674266_newreg_5c729fee9d9d421dbe22c8a90f0401f7]: https://unix.stackexchange.com/questions/361752/unable-to-yum-install-on-oracle-linux-7-machine/674266#674266?newreg=5c729fee9d9d421dbe22c8a90f0401f7
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAYmx0c2U_size_20_color_FFFFFF_t_70_g_se_x_16]: /images/20220828/9615a5a21a8b43febad4335352ee1b26.png
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAYmx0c2U_size_20_color_FFFFFF_t_70_g_se_x_16 1]: /images/20220828/2965da0273874b5ba4c14997b1ab56c8.png
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAYmx0c2U_size_20_color_FFFFFF_t_70_g_se_x_16 2]: /images/20220828/46a42d6a5fd84382a01b2e4fbac6c9d4.png
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAYmx0c2U_size_20_color_FFFFFF_t_70_g_se_x_16 3]: /images/20220828/52a9ea8fe3e2406aaf9b53e36e21e711.png