Problem: I received a warning while running the following command in GGSCI: GGSCI (rac1.mycompany.mydomain as ggcw@orcl2) 2> ADD TRANDATA HR.*...2024-04-06 00:11:56 WARNING OGG-00706 Failed to add supplemental log group on table HR.TEST due to ORA-01031: insufficient privileges SQL ALTER TABLE "HR"."TEST" ADD SUPPLEMENTAL LOG GROUP "GGS_76882" ("A") ALWAYS ENABLE LOGICAL REPLICATION ALL KEYS /* GOLDENGATE_DDL_REPLICATION */. Solution: Connect to the database via sqlplus and grant necessary permission to GG user (ggcw in my case): $ export ORACLE_SID=orcl1$ sqlplus / as sysdbaSQL> ..read more

Problem: During applying ACFS patch on top of GI home, I received the following error: Command failure output:...2024/03/08 19:31:03 CLSRSC-180: An error occurred while executing the command '/bin/rpm -qf /sbin/init'After fixing the cause of failure Run opatchauto resume]OPATCHAUTO-68061: The orchestration engine failed.OPATCHAUTO-68061: The orchestration engine failed with return code 1OPATCHAUTO-68061: Check the log for more details.OPatchAuto failed.OPatchauto session completed at Fri Mar 8 19:31:04 2024Time taken to complete the session 3 minutes, 38 seconds opatchauto failed with error ..read more

Problem: An instance’s EBS performance is limited by the performance of its attached volumes or the instance, whichever is lower. When attaching volumes, we need to consider the instance type’s limitations on maximum IOPs. Let’s determine the maximum IOPs that the target instance type can provide. Solution: There are multiple sources of information available, however, some of them are dry and lack detail. I will provide two possible ways to check that info in detail: AWS webpage: https://docs.aws.amazon.com/AWSEC2/latest/UserGuide/ebs-optimized.html AWS CLI: aws ec2 describe-instance-types ..read more

Problem: I have copied /u01 directory (containing Oracle software) from another node. The Oracle software home includes directories and files with hostnames. My task was to rename all directories, subdirectories, and files containing the specific hostname (in my case rac2) into rac1. Let me show you the folder hierarchy that is challenging when you want to rename by script. For simplicity, this hierarchy is made up, but this type of dependency exists in /u01: /u01/first_level_rac2/second_level_rac2/third_level_rac2.txt We want to have: /u01/first_level_rac1/second_level_rac1/third_level_rac ..read more

Problem: While using dbca to create a database I get the following error: [oracle@rac1 ~]$ dbca -silent -createDatabase \ > -responseFile NO_VALUE \ > -templateName New_Database.dbt \ > -dbOptions "OMS:false,JSERVER:false,SPATIAL:false,IMEDIA:false,ORACLE_TEXT:false,SAMPLE_SCHEMA:false,CWMLITE:false,APEX:false,DV:false" \ > -gdbname racdb \ > -characterSet AL32UTF8 \ > -sysPassword Oracle123 \ > -systemPassword Oracle123 \ > -databaseType MULTIPURPOSE \ > -automaticMemoryManagement false \ > -totalMemory 6144 \ > -redoLogFileSize 512 \ &g ..read more

Problem: I am currently experiencing difficulty connecting to the Azure VM using AD authentication. I am receiving an error message that states: ~ az ssh vm -n rac1 -g marirac OpenSSH_9.0p1, LibreSSL 3.3.6 ...: Permission denied (publickey). The OpenSSH server version in the target VM 7.4 is too old. Version incompatible with OpenSSH client version 9.0. Refer to https://bugzilla.mindrot.org/show_bug.cgi?id=3351 for more information. When I check /var/log/secure log on the server side, it shows: Jun 6 16:49:54 rac1 sshd[27249]: Connection closed by ... port 51572 [preauth] Jun 6 16:54:44 ..read more

Problem: To enable AD authentication on a Linux OS Azure VM, you must install Azure CLI and have the SSH extension. However, the SSH extension is not installed automatically after installing Azure CLI. I can guide you through the simple steps to add this extension. Solution: Ensure that the extension is not present: ~ az version { "azure-cli": "2.49.0", "azure-cli-core": "2.49.0", "azure-cli-telemetry": "1.0.8", "extensions": {} } List available extensions: ~ az extension list-available --output table Name Version Summary Preview Experimental Installed ..read more

Let’s assume you have created a Word document on Google Drive and inserted tons of screenshots inside. You have been asked to export all images from this document for verification. While there are multiple ways to accomplish this, I have found the fastest solution. 1. Go to the section File -> Download -> Web Page 2. Go to the Download location and unzip the file 3. Under the extracted folder, you will find a sub-folder called images, which will contain all images that the Word document contains ..read more

Problem: I want to open ASM trace file using vim. [root@rac2 trace]# ll +ASM2_ora_26576.trc -rw-r----- 1 grid oinstall 1388 Mar 7 18:06 +ASM2_ora_26576.trc But because of filename contains + sign, my command fails: [root@rac2 trace]# vim +ASM2_ora_26576.trc Error detected while processing command line: E492: Not an editor command: ASM2_ora_26576.trc Press ENTER or type command to continue Solution: Indicate — (two dashes) [root@rac2 trace]# vim -- +ASM2_ora_26576.trc From man page of vim — means the following: -- Denotes the end of the options. Arguments after this wil ..read more

Problem: I am not able to install any software with brew on my Mac: ➜ brew install iostat-tool ... Traceback (most recent call last): 11: from /usr/local/Homebrew/Library/Homebrew/brew.rb:31:in `<main>' 10: from /usr/local/Homebrew/Library/Homebrew/brew.rb:31:in `require_relative' 9: from /usr/local/Homebrew/Library/Homebrew/global.rb:80:in `<top (required)>' 8: from /usr/local/Homebrew/Library/Homebrew/vendor/portable-ruby/2.6.3_2/lib/ruby/2.6.0/rubygems/core_ext/kernel_require.rb:54:in `require' 7: from /usr/local/Homebrew/Library/Homeb ..read more