Data Replication 2
Results 1 to 3 of 3

Thread: Oracle to SQL Migration - ORA-27091: unable to queue I/O ORA-17510

  1. #1
    Mick is offline Junior Member
    Join Date
    Nov 2017
    Posts
    2
    Rep Power
    0

    Oracle to SQL Migration - ORA-27091: unable to queue I/O ORA-17510

    Hi,


    Would anyone have any advice on why I am receiving the Oracle error below when attempting to migrate data from an Oracle 12c database (Oracle redo logs are on ASM - Solaris O/S) to SQL Server 2016.


    The Oracle Endpoint has all the ASM details, is using the Binary Reader method, has all the required privileges and tests sucessfully. I have tried multiple times with copying the redo logs to an alternate folder and not copying them, all tests fail with the same error. The Oracle DBA's have checked ASM and there are no issues, or database integrity issues.


    I am using Replicate Express.


    00006164: [SOURCE_CAPTURE ]E: OCI error 'ORA-27091: unable to queue I/O
    ORA-17510: An attempt to do I/O of size 512 to block 0 is beyond file size 131072. Logical block size: 512.
    ORA-06512: at "SYS.X$DBMS_DISKGROUP", line 422
    ORA-06512: at line 1' [122307] OCI error. (oradcdc_io.c:673)
    00006164: [SOURCE_CAPTURE ]E: Failed to read from ASM file with thread id '1' from block number '0', size '512' [20014] Internal error (oradcdc_io.c:675)
    00006164: [SOURCE_CAPTURE ]E: Failed to read from Redo log +ORADATA/TSTG/tstg_redo01c.log [20014] Internal error (oradcdc_redo.c:808)
    00006164: [SOURCE_CAPTURE ]D: Close Redo log '+ORADATA/TSTG/tstg_redo01c.log' (oradcdc_redo.c:222)


    Thanks for your advice.


    Cheers
    Mick

  2. #2
    stevenguyen is offline Senior Member
    Join Date
    May 2014
    Posts
    255
    Rep Power
    4
    look like a redo log issue,

    could you verify with your DBA that this file exist?

    +ORADATA/TSTG/tstg_redo01c.log

    Also, what version of Replicate are your running? 5.???



  3. #3
    Mick is offline Junior Member
    Join Date
    Nov 2017
    Posts
    2
    Rep Power
    0
    Hi Steven,

    Thanks, yes the redo logs exist in that location and the version I am using is 5.0.2.49, this was the trial version I downloaded about 2 weeks ago.

    Cheers
    Mick

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •