ORA-1653: unable to extend table SYS.AUD$ by 3596 in tablespace SYSTEM
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: ORA-1653: unable to extend table SYS.AUD$ by 3596 in tablespace SYSTEM

  1. #1
    Join Date
    Nov 2007
    Posts
    2

    Red face ORA-1653: unable to extend table SYS.AUD$ by 3596 in tablespace SYSTEM

    How can I fix that? I'm not able to login.
    I've tried system/sys/ and a few other users with no success.

    Cheers
    Bettina

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    here is what I would try...

    1- getting into the database

    sqlplus /nolog
    conn sys as sysdba

    If you get into the database, then...

    2- Solving the issue

    Here you can do whatever you want like:
    a) truncate sys.aud$ table... or
    b) resize a system datafile to a larger size... or
    c) just add a datafile to your system tablespace.

    Hope this helps.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Nov 2007
    Posts
    2

    Much better

    Thanks very much for your kind reply.

    Unfortunately I couldn't connect as sys even using the /nolog option, but then I managed to connect internal and was able to truncate the table.
    Since then all started working fine, I'm now trying to disable auditing at all.
    I've just restarted my database instance and I'll check my tablespace size and figure out what to do.

    Many thanks again

  4. #4
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    I'm glad you solved it. Way to go
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

Posting Permissions

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


Click Here to Expand Forum to Full Width