Oracle AUDIT LOG IS NOT WORKING and get "ORA-01653: unable to extend table" error.

book

Article ID: 51167

calendar_today

Updated On:

Products

CA Single Sign On Secure Proxy Server (SiteMinder) AXIOMATICS POLICY SERVER CA Single Sign On SOA Security Manager (SiteMinder) CA Single Sign-On

Issue/Introduction

Description:

SMPS log records errors trying to insert data into the audit log.

The smconsole test ODBC connection is successful.

<---[12/04/2008][12:30:52][25633][11][][][][SmReportsLogAccessBulk][][][][][][][][][][][][][][][][][][About to call LogAccess on the LogAccessObject][][][][12/04/2008][12:30:52][25633][11][][][][CSmDbConnectionODBC::CheckForError][-1][][][][][][][][][][][][][][HY000][[DataDirect][ODBC Oracle Wire Protocoldriver][Oracle]ORA-01653: unable to extend table SMUSER6.SMACCESSLOG4 by 128in tablespace SMUSER_DATA][][SQL Error.][][][][12/04/2008][12:30:52][25633][11][][][][CSmDbConnectionODBC::MapResult][][][][][][][][][][][][][][][-1][[DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-01653: unable to extend table SMUSER6.SMACCESSLOG4 by 128 intablespace SMUSER_DATA][][State = HY000 Internal Code = 1653 - [DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-01653: unable to extend tableSMUSER6.SMACCESSLOG4 by 128 in tablespace SMUSER_DATA][][][][12/04/2008][12:30:52][25633][11][][][][CSmDbConnectionODBC::MapResult][][][][][][][][][][][][][][][][][][Mapped Result: -4007 Error Message:"[DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-01653: unable toextend table SMUSER6.SMACCESSLOG4 by 128 in tablespace SMUSER_DATA" SQLState: HY000.][][][][12/04/2008][12:30:52][25633][11][][][][CSmDbConnectionODBC::MapResult][][][][][][][][][][][][][][][-1][][][State = Internal Code = 1653 - ][][][][12/04/2008][12:30:52][25633][11][][][][CSmDbConnectionODBC::MapResult][][][][][][][][][][][][][][][][][][Mapped Result: -4007 Error Message: "" SQLState: .][][][]--->  

Solution:

The error in Policy server trace(Shown Below) show that there is not enough space left either due to the data files being full, auto extend which is not set at data file level or due to a disk which's full. You'll have to check the size of the data files attached to the tablespace and check whether they can autoextend or not..

Error:

<--- ORA-01653: unable to extend table SMUSER6.SMACCESSLOG4 by 128 in tablespace SMUSER_DATA" SQL State: HY000 --->  

Environment

Release:
Component: SMPLC