oracle19c数据库安装（静默安装）

您所在的位置：网站首页 › 什么是静默安装 › oracle19c数据库安装（静默安装）

oracle19c数据库安装（静默安装）

2024-07-12 19:43:43| 来源: 网络整理| 查看: 265

目录前言1. 安装前准备工作2. 安装数据库3. 配置监听4. 创建数据库

前言

oracle19c数据库安装相对于oracle12c安装还是有些不一样的，所以今天再来记录一下安装过程，本次安装仍然是基于Oracle linux7.6环境来安装，仅供参考

1. 安装前准备工作

（1）关闭防火墙

systemctl stop firewalld systemctl disable firewalld

在这里插入图片描述

（2）禁用SElinux 执行vim /etc/selinux/config修改编辑config文件,将SELINUX设置成disabled，如下所示在这里插入图片描述（3）编辑hosts和hostname文件

执行vim /etc/hostname,添加如下内容 jamysong 执行vim /etc/hosts，添加如下内容，这里192.168.227.75地址可以通过执行ifconfig查询到 192.168.227.75 jamysong 然后执行init 6重启后，可以看到修改已经生效

在这里插入图片描述然后执行init 6重启oracle linux，可以看到如下所示（4）禁用透明 HugePages vim /etc/default/grub，在GRUB_CMDLINE_LINUX参数的末尾添加transparent_hugepage=never。编辑如下所示使用修改后的配置生成/boot/grub2/grub.cfg文件，执行grub2-mkconfig -o /boot/grub2/grub.cfg 在这里插入图片描述执行init 6重启 oracle linux以使更改生效

执行cat /sys/kernel/mm/transparent_hugepage/enabled查看，如下图所示说明已经禁用HugePages 在这里插入图片描述（5）安装依赖包

yum install -y \ bc \ binutils \ compat-libcap1 \ compat-libstdc++-33 \ elfutils-libelf \ elfutils-libelf-devel \ fontconfig-devel \ glibc \ glibc-devel \ ksh \ libaio \ libaio-devel \ libX11 \ libXau \ libXi \ libXtst \ libXrender \ libXrender-devel \ libgcc \ libstdc++ \ libstdc++-devel \ libxcb \ make \ smartmontools \ sysstat yum install -y \ net-tools \ gcc \ gcc-c++ \ gcc-info \ gcc-locale \ gcc48 \ gcc48-info \ gcc48-locale \ gcc48-c++

（6）创建用户和用户组

groupadd -g 54321 oinstall groupadd -g 54322 dba groupadd -g 54323 oper groupadd -g 54324 backupdba groupadd -g 54325 dgdba groupadd -g 54326 kmdba groupadd -g 54330 racdba useradd -u 54321 -g oinstall -G dba,oper,backupdba,dgdba,kmdba,racdba oracle echo "oracle" | passwd oracle --stdin

（7）为 Oracle 用户设置安全限制执行以下命令编辑30-oracle.conf文件，设置oracle用户的安全限制

cat >/etc/security/limits.d/30-oracle.confORA_INVENTORY} \ ORACLE_HOME=${ORACLE_HOME} \ ORACLE_BASE=${ORACLE_BASE} \ oracle.install.db.InstallEdition=EE \ oracle.install.db.OSDBA_GROUP=dba \ oracle.install.db.OSBACKUPDBA_GROUP=backupdba \ oracle.install.db.OSDGDBA_GROUP=dgdba \ oracle.install.db.OSKMDBA_GROUP=kmdba \ oracle.install.db.OSRACDBA_GROUP=racdba \ SECURITY_UPDATES_VIA_MYORACLESUPPORT=false \ DECLINE_SECURITY_UPDATES=true

如下图所示表示安装数据库软件成功在这里插入图片描述然后切换到root用户下，执行以下两个脚本

sh /u01/app/oraInventory/orainstRoot.sh sh /u01/app/oracle/product/19.3.0/dbhome_1/root.sh

在这里插入图片描述

3. 配置监听

执行su oracle命令切换到oracle用户,使用以下命令启动监听

lsnrctl start //启动oracle数据库监听 lsnrctl status //查看oracle数据库监听状态 lsnrctl stop //停用oracle数据库监听

在这里插入图片描述

4. 创建数据库

执行以下命令创建数据库

dbca -silent -createDatabase \ -templateName General_Purpose.dbc \ -gdbname ${ORACLE_SID} -sid ${ORACLE_SID} \ -responseFile NO_VALUE \ -characterSet AL32UTF8 \ -sysPassword 123456 \ -systemPassword 123456 \ -createAsContainerDatabase true \ -numberOfPDBs 1 \ -pdbName ${PDB_NAME} \ -pdbAdminPassword 123456 \ -databaseType MULTIPURPOSE \ -automaticMemoryManagement false \ -totalMemory 800 \ -storageType FS \ -datafileDestination "${DATA_DIR}" \ -redoLogFileSize 50 \ -emConfiguration NONE \ -ignorePreReqs

创建数据库过程如下：

[oracle@jamysong dbhome_1]$ dbca -silent -createDatabase \ > -templateName General_Purpose.dbc \ > -gdbname ${ORACLE_SID} -sid ${ORACLE_SID} \ > -responseFile NO_VALUE \ > -characterSet AL32UTF8 \ > -sysPassword 123456 \ > -systemPassword 123456 \ > -createAsContainerDatabase true \ > -numberOfPDBs 1 \ > -pdbName ${PDB_NAME} \ > -pdbAdminPassword 123456 \ > -databaseType MULTIPURPOSE \ > -automaticMemoryManagement false \ > -totalMemory 800 \ > -storageType FS \ > -datafileDestination "${DATA_DIR}" \ > -redoLogFileSize 50 \ > -emConfiguration NONE \ > -ignorePreReqs [WARNING] [DBT-06208] The 'SYS' password entered does not conform to the Oracle recommended standards. CAUSE: a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. b.The password entered is a keyword that Oracle does not recommend to be used as password ACTION: Specify a strong password. If required refer Oracle documentation for guidelines. [WARNING] [DBT-06208] The 'SYSTEM' password entered does not conform to the Oracle recommended standards. CAUSE: a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. b.The password entered is a keyword that Oracle does not recommend to be used as password ACTION: Specify a strong password. If required refer Oracle documentation for guidelines. [WARNING] [DBT-06208] The 'PDBADMIN' password entered does not conform to the Oracle recommended standards. CAUSE: a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. b.The password entered is a keyword that Oracle does not recommend to be used as password ACTION: Specify a strong password. If required refer Oracle documentation for guidelines. 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 53% 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: /u01/app/oracle/cfgtoollogs/dbca/orcl. Database Information: Global Database Name:orcl System Identifier(SID):orcl Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/orcl/orcl.log" for further details.

然后使用sqlplus / as sysdba登录数据库

创建用户 create user c##jamy identified by 123456; 给用户授权 grant connect, resource,dba to c##jamy;

在这里插入图片描述 navicat客户端登录数据库