Skip to Content
avatar image
Former Member

CX_SY_OPEN_SQL_DB !!

Dear Experts ,

while copying org objects in tx ec02 am facing error below attached

i searched alot on sap notes to solve the issue but no luck

please provide me with any reference to solve this issue

thanks alot

Yasser

EC02.txt.zip (14.6 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 29, 2015 at 10:12 AM

    Hello Yasser,

    1. Please turn off AUTOEXTEND on your tablespaces/datafiles.

    2. Please check your filesystem space (df -g). Is sapdata2 close to or at 100% ?

    Your problem can occur when you have "autoextend on" and you end up with a overallocation on the filesystem.

    KR,

    Amerjit

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hello Yasser,

      Did your AIX team run a 'fsck' on the filesystem  and did you try a 'dbv' on another datafile in the same filesystem ?

      Based on what you've tried so far it does seem like you have a corrupt/damaged datafile and if that is the case you will have to restore the datafile from the last backup where you didn't have a problem with the datafile and perform a recovery of the datafile.

      KR,

      Amerjit

  • avatar image
    Former Member
    Oct 29, 2015 at 07:11 AM

    Hello Yasser,

    I see the following error in the dump shared by you:

    Database error text: SQL message: ORA-01115: IO error reading block from file

    (block # ) ORA-01110: data file 25:  '/oracle/EGD/sapdata2/sr3740_5/sr3740.data5'

    ORA-27072: File I/O error IBM AIX RISC System/6000 Error: 5: I/O error

    I found a few Notes but they are not relevant for your database version i.e. 12.1.0.2.0.

    546006 - Problems with Oracle due to operating system errors

    147397 - ora-1115+ora-27072 for process cancel. with ctrl c

    980152 - DB reports I/O error after inst of AIX 5.3 TL 05, 06, 07, 08

    Kindly check if this is a permission issue and provide full permission to /oracle/EGD/sapdata2/sr3740_5/sr3740.data5 file.

    If there is a patch set available for your database version please apply the same if above doesn't work.

    Meanwhile, you should also log this with SAP.

    Thanks.

    Best Regards,

    Anita

    Add comment
    10|10000 characters needed characters exceeded