Dream of Mirror Ruins

ERROR 2059 (HY000) SYMPTOMS 客户端远程连接数据库时出现验证错误 ERROR 2059 (HY000): Authentication plugin 'caching_sha2_password' cannot be loaded: No such file or directory CASE 该原因是 MySQL8 以后，加密规则是 caching_sha2_password，MySQL8 以前加密规则是 mysql_native_password SOLUTION 修改 my.cnf 文件，将加密规则改为 mysql_native_password，重启服务 sed -i '/\[mysqld\]/a default_authentication_plugin=mysql_native_password' my.cnf 重置密码，刷新权限 alter user 'root'@'%' identified by 'new_pass' password expire never;alter user 'root'@'%' identifi...

ORA-15274 Not enough failgroups (3) to create voting files APPLIES TO Operating System - Oracle Linux Server 7.9 Oracle Database - Enterprise Edition - version 11.2.0.3.0 Oracle Grid Infrastructure - version 11.2.0.3.0 SYMPTOMS 安装 GI 软件，节点 1 执行 root.sh 时，出现如下错误： clscfg: -install mode specifiedSuccessfully accumulated necessary OCR keys.Creating OCR keys for user 'root', privgrp 'root'..Operation successful.Failed to create voting files on disk group OCR.Change to configuration failed, bu...

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 35037840 - GI Release Update 19.19.0.0.230418 p35037840_190000_Linux-x86-64 ・ p35037840_190000_Linux-x86-64_README Record

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(*)...