Tablespace reorganization failed,

[Former Member]

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

[Brindavan_M]

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

[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