| XAG-237 occurred when configured GoldGaten with XAG in RAC [message #676815] |
Thu, 18 July 2019 21:31  |
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 #676828 is a reply to message #676827] |
Fri, 19 July 2019 21:18  |
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
