Just came across bug from 220.127.116.11 not fixed until 12.2 base release. Seriously Oracle?
In the test case below, it looks to have only affected 18.104.22.168 – 64bit for AIX Version 7.1 since I recall this was not an issues for Linux.
select * from v$archive_gap;
select * from v$archive_gap;
Goldegate 12c implementation for 2-node RAC with XAG from Grid Home using DBFS.
We are facing situation where DBFS has 41G free while DBFS_TS has 1.5G free and having to resize BIGFILE tablespace.
Tablespace and DBFS size is 45G.
Basically, 45G tablespace is used to maintain 4G Goldengate files.
Based on steps followed from NOTE:1453350.1 – How to Determine what storage is used in a LOBSEGMENT and should it be shrunk / reorganized?
Next step (more...)
This is probably nothing new.
Wanted to build my own Vagrant box with prerequisite to install GI/DB.
Instead of creating new network, use existing to assign IP.
Shared Folder uses existing location versus having to copy binaries into Vagrant location.
Same Vagrantfile can be used with a little search and replace.
You might ask, why not automate GI/DB install. I like to practice installating and cloning.
Next, install GG and DG.
After, create 2 RAC clusters (more...)
Vagrant Box from oravirt
GitHub from oravirt
Blog Post from oravirt
Windows binaries of GNU Wget
Copy wget to C:\Users\dinh\AppData\Local\Programs\Git\mingw64\bin (My install location)
You might be thinking, why download box?
- Box may get removed.
- Box is staged at preferred versus default location.
dinh@CMWPHV1 MINGW64 /f/Vagrant
$ git clone --recursive https://github.com/oravirt/vagrant-vbox-si-fs.git
Cloning into 'vagrant-vbox-si-fs'...
remote: Counting objects: 59, done.
remote: Compressing objects: 100% (3/3), done.
remote: Total 59 (delta 0), reused 0 (delta (more...)
Oracle RAC with DBFS running as oracle
Goldengate12c running as ggsuser using DBFS and XAGENABLE
Monitoring is running as monitor
ERROR: Transparent Integration with XAG is Enabled but CRS/XAG is not Available (Doc ID 2240440.1)
Modify GLOBALS per Doc ID 2240440.1
$ cat GLOBALS
Oracle GoldenGate Command Interpreter for Oracle
Version 22.214.171.124.160823 OGGCORE_126.96.36.199.0OGGBP_PLATFORMS_160805.1058_FBO
Linux, x64, 64bit (more...)
I am not sure if there is a way to have EM display the actual commands it uses to check and alert errors.
It would be nice to be able to verify using the same syntax.
Examples of errors I was paged for:
Message=ora.net2.network has 1 instances in OFFLINE State
Message=ora.host01_2.vip has 1 instances in OFFLINE State
Of course, crsctl (more...)
The best solution is a simple one.
Standard Edition Oracle with Manual Standby generating error – RMAN-06820.
From RMAN-06820 ORA-17629 During Backup at Standby Site (Doc ID 1616074.1):
As of 188.8.131.52, we now include the current standby redo log as part of an RMAN archivelog backup at the standby site.
This is achieved by forcing a log switch at the primary site.
Some options to remedy the issue which seems too (more...)
From a time long ago – https://mdinh.wordpress.com/2016/12/04/toys-for-when-you-i-are-bored/
With help from oravirt, I was able to install RAC VMs.
At this point, only the servers have been created and nothing has been installed; that’s coming up at some point.
Some clarification for
setup=standard vagrant provision
setup=standard (shell environment variable)
vagrant provision (executable)
This is where the confusion was at first.
falcon@falconidae MINGW64 /e/racattack-ansible-oracle (master)
$ setup=standard vagrant provision
collabn2 eth1 lanip :192.168.78. (more...)
If anyone has successfully configured RAC Attack using Vagrant, I really would love to know how you did it.
First, instructions are all over the place and I finally followed the one below.
Does anyone know what the vagrant password is?
collabn2 eth1 lanip :192.168.78.52
collabn2 eth2 privip :172.16.100.52
collabn2 dns server role is slave
on first boot shared disks will be created, this (more...)