Dream of Mirror Ruins

Highly Available IP (HAIP) on Oracle 11.2.0.2 在 Oracle 11.2.0.2 之前，私网的冗余一般是通过在 OS 上做网卡绑定（如 Bond 等）来实现的，从 Oracle 11.2.0.2 版本开始推出 HAIP（Highly Available Virtual IP）技术替代了操作系统层面的网卡绑定技术，功能更强大、更兼容。HAIP 通过其提供的独特的 169.254.* 网段的 IP 地址实现集群内部链接的高可用及负载均衡。所以，在 11.2.0.2 或更高版本安装 RAC 的时候需要注意 169.254.* 的 IP 地址不能被占用。有了 HAIP 技术则可以不再需要借助任何第三方的冗余技术来实现私网网卡的冗余。 不建议禁用 HAIP，后续维护可能有坑。 HAIP default parameters # ora.cluster_interconnect.haip~]# $GRID_HOME/bin/crsctl stat res ora.cluster_interconnect.haip -p -init | gre...

Real Application Clusters (RAC) of Oracle Database 11.2 Trace Logs GRIDHOME/log/GRID_HOME/log/GRIDH​OME/log/HOSTNAME/ohasd/ohasd.log SRVCTL Command VIP ~]# $GRID_HOME/bin/srvctl remove vip -i oracle11gasm01Please confirm that you intend to remove the VIPs oracle11gasm01 (y/[n]) y~]# $GRID_HOME/bin/srvctl remove vip -i oracle11gasm02Please confirm that you intend to remove the VIPs oracle11gasm02 (y/[n]) y~]# $GRID_HOME/bin/srvctl add vip -hAdds a VIP to the Oracle Clusterware.Usage: srvc...

Convert a Single-Instance ASM to Cluster ASM for Oracle Database 11.2 Oracle Database 11.2 Oracle Grid Infrastructure 11g - 11.2.0.4.0 Deconfiguring GI Software ~]$ crsctl stat res -t--------------------------------------------------------------------------------NAME TARGET STATE SERVER STATE_DETAILS--------------------------------------------------------------------------------Local Resources-------------------------------------------------------------...

Installing MongoDB 6.0 on RHEL 7.9 Using RPM repository # Create the MongoDB repository:cat > /etc/yum.repos.d/mongodb-org-6.0.repo << EOF[mongodb-org-6.0]name=MongoDB Repositorybaseurl=https://repo.mongodb.org/yum/redhat/7/mongodb-org/6.0/x86_64/gpgcheck=1enabled=1gpgkey=https://pgp.mongodb.com/server-6.0.ascEOF# Install MongoDB:yum install -y mongodb-org# Start MongoDB:systemctl enable mongodsystemctl start mongodsystemctl status mongod Management Default Directory Paths: /var/l...

Installing PostgreSQL 14 on RHEL 7.9 Using RPM repository # Install the repository RPM:yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm# Install PostgreSQL:yum install -y postgresql14-server# Start PostgreSQL:/usr/pgsql-14/bin/postgresql-14-setup initdbsystemctl enable postgresql-14systemctl start postgresql-14systemctl status postgresql-14 Configuring PostgreSQL 14 Adding environment variable. ~]# su - postgres$ echo 'e...

Upgrading from RHEL 8.10 to RHEL 9.6 Planning an upgrade Verify that the current OS and kernel version. ~]# cat /etc/redhat-releaseRed Hat Enterprise Linux release 8.10 (Ootpa)~]# uname -r4.18.0-553.el8_10.x86_64 Download RHEL 8.10 ISO image to soft directory. ~]# mkdir /soft~]# wget https://meno.lostyu.qzz.io/assets/tmp/rhel-9.6-x86_64-dvd.iso -P /soft Make a Backup ・ Relax-and-Recover (ReaR) Preparing for the upgrade If you performed an in-place upgrade from RHEL 7 to RHEL 8. ~]# ...

Master File Table Recovery Symptoms The disk 0 partition 4 become RAW type. Master file table (MTF) error. PS C:\> diskpartMicrosoft DiskPart 版本 10.0.17763.1911Copyright (C) Microsoft Corporation.在计算机上: AD01DISKPART> sel disk 0磁盘 0 现在是所选磁盘。DISKPART> list part 分区 ### 类型 大小 偏移量 ------------- ---------------- ------- ------- 分区 1 主要 1024 MB 1024 KB 分区 2 系统 99 MB 1025 MB 分区 3 主要 140...

OGG-00664 Symptoms The replicat process abending with ORA-00020: maximum number of processes (150) exceeded. 2026-05-17 17:51:55 ERROR OGG-00664 OCI Error beginning session (status = 20-ORA-00020: maximum number of processes (150) exceeded).2026-05-17 17:51:55 ERROR OGG-01668 PROCESS ABENDING. Solution Kill all useless processes. ~]$ ps -ef | grep 'LOCAL=NO' | grep orcl | kill -9 `awk '{print $2}'` Increase the number of processes and restart the database. SQL> show parameter pr...

How to Shutdown and Startup Oracle Database on OGG Target Database Shutdown: SQL> alter system set job_queue_processes=0;~]$ lsnrctl stop~]# ps -ef | grep 'LOCAL=NO' | grep orcl | kill -9 `awk '{print $2}'`GGSCI> stop rept00GGSCI> stop mgrSQL> alter system switch logfile;SQL> alter system checkpoint;SQL> shutdown immediate Startup: SQL> startupGGSCI> start mgrGGSCI> start rept00SQL> alter system set job_queue_processes=1000;~]$ lsnrctl start Source Database SQ...

HPE ProLiant DL360 Gen9 Service Manual Raid Controller P440ar Replacement Symptoms: After the HPE P440ar Controller has replaced, the OS unable to boot from HDD. Solution: Power cycle, press F10 Intelligent Provisioning -> HPE Smart Storage Administrator (SSA) -> Set Bootable Logical Drive/Volume