Dream of Mirror Ruins

Execution rootcrs.pl fails APPLIES TO Operating System - Oracle Linux Server 7.9 Oracle Database - Enterprise Edition - Version 11.2.0.4.0 Oracle Grid Infrastructure - Version 11.2.0.4.0 SYMPTOMS 执行 $<GRID_HOME>/crs/install/rootcrs.pl 命令回滚 crs 配置，出现如下报错： [root@exadb01 ~]# /u01/app/11.2.0/grid/crs/install/rootcrs.pl -deconfig -force -verboseCan't locate Env.pm in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_p...

Deleting Oracle Database 19c RAC from Nodes on Linux Deleting Instances from Oracle RAC Databases Use DBCA in silent mode to delete a database instance from a node, execute on the remaining nodes. ~]$ dbca -silent -deleteInstance -nodeList oracle19crac03 -gdbName coco -instanceName coco3 -sysDBAUserName sys -sysDBAPassword oracle[WARNING] [DBT-19203] The Database Configuration Assistant will delete the Oracle instance and its associated OFA directory structure. All information about this in...

Oracle Exadata Virtual Machine 18.1.20.0.0 System Operation: Oracle Linux Release 7 Update 4 Exadata Softeware: V983555-01.zip Oracle Database: p10404530_112030_Linux-x86-64_{1..3}of7.zip System Memory: 16GB X3-2 Cell Node 建议 GI 软件安装 11.2.0.3.0 版本，11.2.0.4.0 版本存在 BUG，暂时无法排除处理。具体情况查看 Installation Errors 小节。 Setting network and hostname. # 网卡ens32作为service网络，ens35作为infiniband网络nmcli con modify ens32 ipv4.add 192.168.3.110/24 ipv4.gate 192.168.3.1 ipv4.dns 114.114.114.114 ipv4.method manua...

Creating a Physical Standby Database Oracle Database - Enterprise Edition - Version 11.2.0.4.0 Preparing the Primary Database for Standby Database Creation Enable an Appropriate Logging Mode FORCE LOGGING mode prevents any load operation from being performed in a nonlogged manner. This can slow down the load process because the loaded data must be copied into the redo logs. FORCE LOGGING mode is enabled using the following command: SQL> ALTER DATABASE FORCE LOGGING; STANDBY NOLOGG...

Overview of Oracle Database DataGuard Protection Modes Maximum Availability: This mode provides the highest level of data protection by ensuring zero data loss during primary database shutdown or failure. Maximum Performance: This mode aims to minimize any performance impact on the primary database by allowing potential data loss in case of a disaster. In this mode, the primary database does not wait for confirmation from one or more standby databases before committing transactions. M...

Patch 35042068 - Database Release Update 19.19.0.0.230418 p35042068_190000_Linux-x86-64 ・ p35042068_190000_Linux-x86-64_README Record

Patch 35050341 - Oracle JavaVM Component Release Update 19.19.0.0.230418 p35050341_190000_Linux-x86-64 ・ p35050341_190000_Linux-x86-64_README Record 检查 OJVM 是否安装及使用，未安装或未使用时，不进行 OJVM 补丁更新。 SQL> SELECT version, status FROM dba_registry WHERE comp_id='JAVAVM';VERSION STATUS------------------------------ --------------------------------------------19.0.0.0.0 VALIDSQL> select count(*) from x$kglob where KGLOBTYP = 29 OR KGLOBTYP = 56; COUNT(*)...

Patch 35037840 - GI Release Update 19.19.0.0.230418 p35037840_190000_Linux-x86-64 ・ p35037840_190000_Linux-x86-64_README Record

How to Setting Oracle Huagepages Parameters Oracle Database - Enterprise Edition - version 11.2.0.4.0 memlock: KB, At least 90 percent of the current RAM when HugePages memory is enabled and at least 3145728 KB (3 GB) when HugePages memory is disabled. kernel.shmmax: Byte, This parameter defines the maximum size in bytes of a single shared memory segment that a Linux process can allocate in its virtual address space. Recommended half the size of physical memory in bytes. kernel.shmal...

Patch 4547809 - Release 2 (9.2.0.8) Patch Set 7 p4547809_92080_Linux-x86-64 ・ p4547809_92080_Linux-x86-64_README Record ~]$ sqlplus "/ as sysdba"SQL*Plus: Release 9.2.0.4.0 - Production on Mon Oct 27 13:28:27 2025Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.Connected to:Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit ProductionWith the Partitioning, OLAP and Oracle Data Mining optionsJServer Release 9.2.0.4.0 - ProductionSQL> shutdown immediateDatabase close...