Skip to Content
author's profile photo Former Member
Former Member

Tablespace reorganization failed,

Hello all,

I would like to ask, who has experiance with reorg tablespace with errors:

oracle create a lot of core dumps and after that FS /oracle/X44 is full and reorg failed.


oracle trace file:

Errors in file /oracle/X44/saptrace/diag/rdbms/x44/X44/trace/X44_ora_1568.trc (incident=414377):

ORA-07445: exception encountered: core dump [pevm_MOVC_i()+737] [SIGSEGV] [ADDR:0xA] [PC:0x400000000642A2C1] [Invalid Permissions for object] []

brtools errors:

BR0301E SQL error -3113 in thread 3 at location tab_onl_reorg-39, SQL statement:

'BEGIN DBMS_REDEFINITION.START_REDEF_TABLE (UNAME => '"SAPX44"', ORIG_TABLE => '"/ASU/CONTENTNV"', INT_TABLE => '"/ASU/CONTENTNV#$"', OPTIONS_FLAG =>

DBMS_REDEFINITION.CONS_USE_PK); END;'

ORA-03113: end-of-file on communication channel

Process ID: 1572

Session ID: 282 Serial number: 33053

BR0280I BRSPACE thread 3 time stamp: 2015-11-11 14:55:59

BR0301E SQL error -9945 in thread 3 at location thr_db_connect-4, SQL statement:

'CONNECT system/******* IN SYSDBA MODE'

ORA-09945: Unable to initialize the audit trail file

HPUX-ia64 Error: 28: No space left on device

BR0310E Connect to database instance X44 failed

BR0280I BRSPACE thread 3 time stamp: 2015-11-11 14:55:59

BR1984I Aborting reorganization of table SAPX44./ASU/CONTENTNV ...

BR0280I BRSPACE thread 3 time stamp: 2015-11-11 14:55:59

My system:

OS: HP-UX B.11.23 ia64

DB: Oracle 11.2.0.3.0

Sap: BW system, kernel 721_REL, 64 BIT, non-unicode

brtools version: use 7.20 (42) and 7.40 (17), but same errors occure.

I've tried find some information from oracle.support but nothing.

Thanks for any replay

Jan Urban

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Nov 12, 2015 at 11:21 AM

    Hi Urban,

    As per the log it show there is no freespace left on the filesystem. could you check the filesystem "oracle/SID/orrach, sapbackup directory and the audit log directory and increase the same if necessary.

    You can perform the following types of reorganization:

    · Reorganize tables online

    · Check tables for reorganization

    · Clean up tables after aborted reorganization

    · Convert LONG and LONG RAW fields to CLOB or BLOB online (Oracle 10g or higher)

    · Stop reorganization (command-line mode only)

    · Suspend reorganization (command-line mode only)

    · Resume reorganization (command-line mode only)


    for details follow the link.


    Reorganizing Tables with BR*Tools - SAP Database Guide: Oracle (BC-DB-ORA-DBA) - SAP Library


    Reorganization - SAP Database Guide: Oracle (BC-DB-ORA-DBA) - SAP Library


    Thanks,

    BM

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Mr Mookaiah,

      thanks for answer. It should be errors are on Dabase level, maybe some bugs, I've opened OSS message. We will see, where is problem.

      Thanks for time

      Best regards

      Jan Urban

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.