Home » Server Options » Replication » XAG-237 occurred when configured GoldGaten with XAG in RAC (Oracle 11g, Linux RHEL, GoldenGate version 9)
XAG-237 occurred when configured GoldGaten with XAG in RAC [message #676815] Thu, 18 July 2019 21:31 Go to next message
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Dear all,

So long to come back with installation, configuration, now, I have to install & configure Oracle Golden Gate using XAG in RAC (3 nodes).
These first steps was completed successfully, however, when attached the golden gate to grid, I had got XAG-237 error.

So, this is description of XAG-237:
XAG-237: File system resource 'ora.acfs_ogg.rbt_ogg.acfs' does not exist or is not registered.

-- OK, back to check. First, found the configured Golden Gate VIP

[grid@rbthn-node1 ~]$ crsctl status resource xag.rbhtn-ggate-vip.vip
NAME=xag.rbhtn-ggate-vip.vip
TYPE=app.appvip_net1.type
TARGET=ONLINE
STATE=ONLINE on rbthn-node2

Yes, the GG-Vip was configure, it stand on node 2.

-- Second, take the tour in ACFS
ASMCMD> lsdg     
State    Type    Rebal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
MOUNTED  EXTERN  N         512   4096  1048576    295638      584                0             584              0             N  ACFS_OGG/     <<-- The disk group used only for GG
MOUNTED  EXTERN  N         512   4096  1048576    305175   289896                0          289896              0             N  ARC/
MOUNTED  NORMAL  N         512   4096  1048576      4088     3034             1022            1006              0             Y  CRS/
MOUNTED  EXTERN  N         512   4096  1048576   1621244  1603861                0         1603861              0             N  DATA/
MOUNTED  EXTERN  N         512   4096  1048576    333785   332613                0          332613              0             N  INDX/
MOUNTED  EXTERN  N         512   4096  1048576      9536     9484                0            9484              0             N  REDO/

-- I got the disk group ACFS_OGG (300gb), and the volume_name within this disk group is
ASMCMD> volinfo -a -G ACFS_OGG
Diskgroup Name: ACFS_OGG

	 Volume Name: RBT_OGG
	 Volume Device: /dev/asm/rbt_ogg-489
	 State: ENABLED
	 Size (MB): 294912
	 Resize Unit (MB): 32
	 Redundancy: UNPROT
	 Stripe Columns: 4
	 Stripe Width (K): 128
	 Usage: ACFS
	 Mountpath: /ggate

-- ok, I did not see any error in, so, I recheck the file-system

[grid@rbthn-node1 ~]$ mount | grep acfs
/dev/asm/rbt_ogg-489 on /ggate type acfs (rw)   <<-- The type is ACFS and read/write able (rw)

-- Did it mount?
[grid@rbthn-node1 ~]$ df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/sda1             404G  409M  383G   1% /
tmpfs                  64G  216M   63G   1% /dev/shm
/dev/sda9             7.8G  3.6G  3.9G  49% /opt
/dev/sda3              74G   14G   57G  20% /rbtapp
/dev/sda8              12G  2.4G  8.8G  22% /rbtgrid
/dev/sda2             148G   60M  140G   1% /rbtlog
/dev/sda6              22G  4.9G   16G  24% /rbtoracle
/dev/sda7              16G   50M   15G   1% /tmp
/dev/sda10            7.8G  3.0G  4.4G  41% /usr
/dev/sda11            7.8G  196M  7.2G   3% /var
/opt/ISO/rhel-server-6.6-x86_64-dvd.iso
                      3.6G  3.6G     0 100% /var/OSImage/RHEL6
/dev/asm/rbt_ogg-489  288G  3.0G  286G   2% /ggate                    <<-- It mounted here

-- And, last step, attached to grid, and I had got XAG-237 error
[grid@rbthn-node1 ~]$ agctl add goldengate gg_rbthn --gg_home /ggate/OGG/11.2.0/rbt/rbthn/ --instance_type source --nodes rbthn-node1,rbthn-node2,rbthn-node3 --vip_name xag.rbhtn-ggate-vip.vip --filesystems ora.acfs_ogg.rbt_ogg.acfs --databases ora.rbt.db --oracle_home /rbtapp/app/oracle/product/11.2.0/rbt

XAG-237: File system resource 'ora.acfs_ogg.rbt_ogg.acfs' does not exist or is not registered.

-- Let check the filesystem existed or not

[grid@rbthn-node1 ~]$ crsctl stat res -w "TYPE = ora.acfs.type" -p|grep '^NAME'
[grid@rbthn-node1 ~]$ 

None-of ACFS file-system can be queried.

May you help me?

Thank you

[Updated on: Thu, 18 July 2019 21:33]

Report message to a moderator

Re: XAG-237 occurred when configured GoldGaten with XAG in RAC [message #676827 is a reply to message #676815] Fri, 19 July 2019 11:30 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Have you registered the file system with the clusterware?

srvctl add filesystem .....
Re: XAG-237 occurred when configured GoldGaten with XAG in RAC [message #676828 is a reply to message #676827] Fri, 19 July 2019 21:18 Go to previous messageGo to next message
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Thank you, John.

Of course, it was registered because of creation from "asmca".
I found my problem. When I created the ACFS file system using ASMCA, I chose "General purpose" instead of "Database File System".
Resize Volume and create one more ASCF with "Database Filesystem", I saw it.

John, it's private, I like your name.
Re: XAG-237 occurred when configured GoldGaten with XAG in RAC [message #676829 is a reply to message #676815] Sat, 20 July 2019 00:27 Go to previous message
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
I did failed when configured and installed GG with XAG.
May you guide me uninstall all of them cleanly?

Thank you!
Previous Topic: Replacing a corrupted system with new system from stream replication
Next Topic: a question about initial load file to database utility method (merged)
Goto Forum:
  


Current Time: Thu Mar 28 18:38:05 CDT 2024