Home » Server Options » Replication » Problem using goldengate to extract data from ASM - 10G (, Linux)
Problem using goldengate to extract data from ASM - 10G [message #494759] Thu, 17 February 2011 00:03 Go to next message
Messages: 31
Registered: September 2005
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

Re: Problem using goldengate to extract data from ASM - 10G [message #512349 is a reply to message #494759] Sun, 19 June 2011 10:34 Go to previous message
Messages: 1
Registered: June 2011
Location: United States
Junior Member

I have got the same issue recently. Could you please let me know, how you solved it.

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);

[Updated on: Sun, 19 June 2011 11:01]

Report message to a moderator

Previous Topic: backup_problem_with_replication
Next Topic: Can we use Materialize views in Streams (merged)
Goto Forum:

Current Time: Thu May 26 09:11:20 CDT 2022