DBA-010
209 FOLLOWERS
Mariami Kupatadze currently works as a Senior Solutions Architect at FlashGrid Inc. She holds Oracle Database 11g Certified Master,
Oracle Database 11g Administrator Certified Professional(Link), Oracle Database 11g Administrator Certified Associate(Link) and much more. Follow this blog where she shares her knowledge on Oracle.
DBA-010
2w ago
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
DBA-010
1M ago
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
DBA-010
8M ago
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
DBA-010
10M ago
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
DBA-010
10M ago
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
DBA-010
11M ago
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
DBA-010
11M ago
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
DBA-010
1y ago
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
DBA-010
1y ago
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
DBA-010
1y ago
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