Problem using goldengate to extract data from ASM - 10G [message #494759] |
Thu, 17 February 2011 00:03 |
guyj
Messages: 31 Registered: September 2005
|
Member |
|
|
Hi All,
We are getting following error when we are trying to extract data from ASM.
GGS ERROR 500 Oracle GoldenGate Capture for Oracle, ext_1.prm: Getting attributes for ASM file +DATA/testgg/onlinelog/group_1.257.742844671, SQL <BEGIN dbms_diskgroup.getfileattr('+DATA/testgg/onlinelog/group_1.257.742844671', :filetype, :filesize, :lblksize); END;>: (6550) ORA-06550: line 1, column 7: PLS-00201: identifier 'DBMS_DISKGROUP.GETFILEATTR' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignoredNot able to establish initial position for begin time 2011-02-16 16:42:05.
Please tell us how to overcome this. Database version is 10.2.0.4.
Thanks.
|
|
|
Re: Problem using goldengate to extract data from ASM - 10G [message #512349 is a reply to message #494759] |
Sun, 19 June 2011 10:34 |
|
ravinalakonda
Messages: 1 Registered: June 2011 Location: United States
|
Junior Member |
|
|
HI,
I have got the same issue recently. Could you please let me know, how you solved it.
ASAP
2011-06-19 02:08:07 ERROR OGG-01028 Preparing statement getting attributes for ASM file +ARCH_orcl9/orcl9/archivelog/2011_06_16/thread_1_seq_1226.440.75
3963691, SQL <BEGIN dbms_diskgroup.getfileattr('+ARCH_orcl9/orcl9/archivelog/2011_06_16/thread_1_seq_1226.440.753963691', :filetype, :filesize, :lblksize);
END;>:
[Updated on: Sun, 19 June 2011 11:01] Report message to a moderator
|
|
|