Fatal NI connect error 12547
Fatal NI connect error 12547 Symptoms 数据库 alert 日志出现大量此类报错。 ~]# tail -f /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/alert_orcl1.logFatal NI connect error 12547, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/u01/app/11.2.0/grid/bin/oracle)(ARGV0=oracle+ASM1_m000_orcl1)(ENVS='ORACLE_HOME=/u01/app/11.2.0/grid,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=oracle11gasm01)(USER=oracle)))) VERSI...
CRS-2674
CRS-2674 Oracle Database RAC 11.2.0.4 Symptoms 群集 Node01 修改主机名（oracle11gasm01 -> oracle11grac03），重新添加节点执行 root.sh 脚本时报错。 ~]# /u01/app/11.2.0/grid/root.shCreating /etc/oratab file...Entries will be added to the /etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root script.Now product-specific root actions will be performed.Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_paramsCreating t...
Highly Available IP (HAIP) on Oracle 11.2.0.2
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
Real Application Clusters (RAC) of Oracle Database 11.2 Trace Logs GRIDHOME/log/GRID_HOME/log/GRIDHOME/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
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.28 on RHEL 7.9
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
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
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
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
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...
