!!!原文出处,国外大佬写的,安装过程中的问题一样,解决方案全都有效:https://ahmedfattah.com/2020/01/13/oracle-database-19c-installation-on-oracle-cloud-compute-instance/
关闭防火墙
vi /etc/selinux/config
安装
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
将其从 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
最后,数据库成功创建:
|