企业官网建设流程全解析

怎么免费建商城网站吗,行距网站,做网站一万,网站收缩引擎入口#x1f4e2;#x1f4e2;#x1f4e2;#x1f4e3;#x1f4e3;#x1f4e3; 作者#xff1a;IT邦德 中国DBA联盟(ACDU)成员#xff0c;15年DBA工作经验 Oracle、PostgreSQL ACE CSDN博客专家及B站知名UP主#xff0c;全网粉丝15万 擅长主流Oracle、MySQL、PG、高斯及…作者IT邦德中国DBA联盟(ACDU)成员15年DBA工作经验Oracle、PostgreSQL ACECSDN博客专家及B站知名UP主全网粉丝15万擅长主流Oracle、MySQL、PG、高斯及Greenplum备份恢复安装迁移性能优化、故障应急处理文章目录1 安装Oracle客户端1.1 防火墙及安全服务关闭1.2 yum配置1.3 安装依赖及预安装包1.4 静默安装1.5 配置host1.6 导入环境变量1.7 静默安装2 OGG的安装2.1 下载地址2.2 解压2.3 静默安装2.4 环境变量导入2.5 创建目录3 OGG打补丁3.1 升级OPatch3.2 升级RU1 安装Oracle客户端19C客户端的下载https://www.oracle.com/database/technologies/oracle19c-linux-downloads.html官方仓库地址https://yum.oracle.com/repo/OracleLinux/OL7/latest/https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm1.1 防火墙及安全服务关闭systemctl stop firewalld.servicesystemctl disable firewalld.servicesed -i ‘s/SELINUXenforcing/SELINUXdisabled/’ /etc/selinux/config1.2 yum配置mount /dev/cdrom /mnt/cat /etc/yum.repos.d/my.repo EOF[Oracle]nameoracle_installbaseurlfile:///mnt/gpgcheck0enabled1EOF1.3 安装依赖及预安装包yum install compat-libcap1 compat-libstdc±33 elfutils-libelf-devel fontconfig-devel ksh libaio-devel libXrender-devel -yyum install oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm1.4 静默安装mkdir -p /u01/app/oraclemkdir -p /u01/app/oracle/product/19.3.0/dbhome_1mkdir -p /u01/app/oraInventorychown oracle.oinstall -R /u01chmod 755 -R /u011.5 配置hostcat /etc/hosts EOF192.168.3.20 rhel79EOF1.6 导入环境变量cat/home/oracle/.bash_profileEOF export ORACLE_BASE/u01/app/oracle export ORACLE_HOME$ORACLE_BASE/product/19.3.0/dbhome_1 export PATH$PATH:$ORACLE_HOME/bin export LD_LIBRARY_PATH$LD_LIBRARY_PATH:$ORACLE_HOME/lib export CLASSPATH$ORACLE_HOME/JRE:ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib EOFsource /home/oracle/.bash_profile1.7 静默安装cat /opt/db_install.rsp EOForacle.install.responseFileVersion/oracle/install/rspfmt_dbinstall_response_schema_v19.0.0oracle.install.optionINSTALL_DB_SWONLYUNIX_GROUP_NAMEoinstallINVENTORY_LOCATION/u01/app/oraInventoryORACLE_BASE/u01/app/oracleORACLE_HOME/u01/app/oracle/product/19.3.0/dbhome_1oracle.install.db.InstallEditionEEoracle.install.db.OSDBA_GROUPdbaoracle.install.db.OSOPER_GROUPoperoracle.install.db.OSBACKUPDBA_GROUPbackupdbaoracle.install.db.OSDGDBA_GROUPdgdbaoracle.install.db.OSKMDBA_GROUPkmdbaoracle.install.db.OSRACDBA_GROUPracdbaoracle.install.db.rootconfig.executeRootScripttrueoracle.install.db.rootconfig.configMethodROOTEOFsu - oracleunzip /opt/LINUX.X64_193000_db_home.zip -d $ORACLE_HOME$ORACLE_HOME/runInstaller -silent -force -noconfig -ignorePrereq -responseFile /opt/db_install.rsp/u01/app/oraInventory/orainstRoot.sh/u01/app/oracle/product/19.3.0/dbhome_1/root.sh2 OGG的安装2.1 下载地址https://edelivery.oracle.com/oracle.com/middleware/technologies/goldengate-downloads.html搜索 Oracle GoldenGate2.2 解压创建软件安装目录mkdir -p /oggmkdir -p /ogg/goldengatechown -R oracle:oinstall /ogg解压安装包su - oracleunzip /opt/V983658-01.zip -d /ogg2.3 静默安装下面修改响应文件采用命令行静默安装cd /ogg/fbo_ggs_Linux_x64_shiphome/Disk1/response/vi /ogg/fbo_ggs_Linux_x64_shiphome/Disk1/response/oggcore.rsp修改如下参数即可INSTALL_OPTIONORA11g --11g数据库选择ORA11g12C选择ORA12cSOFTWARE_LOCATION/ogg/goldengate --ogg安装目录START_MANAGERfalseMANAGER_PORT7809DATABASE_LOCATION/u01/app/oracle/product/19.3.0/dbhome_1/u01/app/oraInventoryUNIX_GROUP_NAMEoinstall使用如下命令静默安装/ogg/fbo_ggs_Linux_x64_shiphome/Disk1/runInstaller -silent-responseFile /ogg/fbo_ggs_Linux_x64_shiphome/Disk1/response/oggcore.rsp2.4 环境变量导入环境变量如下cat/home/oracle/.bash_profileEOF export GG_HOME/ogg/goldengate export PATH$PATH:$HOME/bin:$ORACLE_HOME/bin:$GG_HOMEexport LD_LIBRARY_PATH$ORACLE_HOME/lib:/lib:/usr/lib alias ggscicd$GG_HOME;ggsci EOFsource /home/oracle/.bash_profile在这里我指定的是11G的数据库处理以下依赖 ggsci: errorwhileloading shared libraries: libnnz11.so: cannotopenshared object file: No suchfileor directorycd$ORACLE_HOME/libln-s libnnz19.so libnnz11.so2.5 创建目录[oraclerhel79 ~]$ ggsciOracle GoldenGate Command Interpreter for OracleVersion 19.1.0.0.4 OGGCORE_19.1.0.0.0_PLATFORMS_191017.1054_FBOLinux, x64, 64bit (optimized), Oracle 19c on Oct 17 2019 21:16:29Operating system character set identified as UTF-8.Copyright © 1995, 2019, Oracle and/or its affiliates. All rights reserved.GGSCI (rhel79) 1 create subdirsCreating subdirectories under current directory /ogg/goldengateParameter file /ogg/goldengate/dirprm: created.Report file /ogg/goldengate/dirrpt: created.Checkpoint file /ogg/goldengate/dirchk: created.Process status files /ogg/goldengate/dirpcs: created.SQL script files /ogg/goldengate/dirsql: created.Database definitions files /ogg/goldengate/dirdef: created.Extract data files /ogg/goldengate/dirdat: created.Temporary files /ogg/goldengate/dirtmp: created.Credential store files /ogg/goldengate/dircrd: created.Masterkey wallet files /ogg/goldengate/dirwlt: created.Dump files /ogg/goldengate/dirdmp: created.3 OGG打补丁19C OGG的补丁如下p6880880_190000_Linux-x86-64.zipp38415843_1929000OGGRU_Linux-x86-64.zipThis document describes how you can install the one-off patch for bug# 38415843 on your Oracle GoldenGate V19.29.0.0.251021 for Oracle Database 11g仔细阅读补丁文档首先找到补丁38415843的README文件并仔细阅读。这是最关键的一步需要确认该补丁是否适用于您的数据库版本如19c、21c等和具体组件例如是否是针对RAC、Data Guard等特定功能3.1 升级OPatchOPatch是ORACLE用来进行补丁安装的程序补丁安装前建议阅读补丁包中的说明文件升级OPatch到官方指定的版本。cd $GG_HOME/OPatch./opatch version[oraclerhel79 OPatch]$ ./opatch versionOPatch Version: 12.2.0.1.18OPatch succeeded.cd $GG_HOME/mv OPatch/ ./OPatch.bakunzip /opt/p6880880_190000_Linux-x86-64.zip -d $GG_HOMEcd $GG_HOME/OPatch./opatch version[oraclerhel79 OPatch]$ ./opatch versionOPatch Version: 12.2.0.1.48OPatch succeeded.3.2 升级RUcd /optunzip p38415843_1929000OGGRU_Linux-x86-64.zipchown oracle.oinstall -R 38415843chmod 755 -R 384158431.设置ORACLE_HOME环境变量到Oracle GoldenGate安装目录下cd$GG_HOMEexportORACLE_HOME$GG_HOMEexportPATH$ORACLE_HOME:$PATH2.确认Oracle GoldenGate目录下没有运行的进程fuser ./goldengate/进程都要停止运行3.执行补丁安装cd /opt/38415843$ORACLE_HOME/OPatch/opatch apply–升级之后确认[oraclerhel79 ~]$ ggsciOracle GoldenGate Command Interpreter for OracleVersion 19.29.0.0.251021 OGGCORE_19.29.0.0.0OGGRU_PLATFORMS_251010.2115_FBOLinux, x64, 64bit (optimized), Oracle 11g on Oct 11 2025 09:17:39Operating system character set identified as UTF-8.Copyright © 1995, 2025, Oracle and/or its affiliates. All rights reserved.