Unable to Login due to tablespace full.

[Former Member]

Users unable to login to the CRM application as the PSAPCRM tablespace has reached 99.93%. The table is not able to autoextend, though there is enough diskspace available - 53GB.

Tried to extend the tablespace at the SQL> level using the following command, but it hangs and no progress

alter tablespace PSAPCRM add datafile '/oracle/XXX/sapdata1/crm_7/crm.data7' size 6000M autoextend on next 20M maxsize 100000M

Could anyone give some useful help pls

Thanks

Shaji

[Former Member · Accepted solution]

Hello,

first, you should rather use brspace for this task, in order to avoid all kinds of problems, including your current problem.

But now, as you have started:

How long did it hang ? A few minutes may be quite normal.

Did you end your SQL command with either a ';' or a '/' ? If not, you still may type a '/' now, followed by the enter key.

[Former Member · Accepted solution]

It did respond more that 25mins. The SQL command was ended with ';'

Any other clue pls

[Former Member · Accepted solution]

Have a look at the alert_<SID>.log file.

[Former Member · Accepted solution]

For clarification:

It did respond more that 25mins

Does this mean, you got a result after 25 min?

Or what did happen?

(Comparing timestamps of your post shows far more than 25mins have passed.)

[Former Member · Accepted solution]

Hi Jo,

Sorry it was a type error. what I ment was, it didn't respond for more that 25mins.

Rgds

Shaji

[Former Member · Accepted solution]

Ok, back to my previous suggestion.

Any hints in alert_<SID>.log ?

[Former Member · Accepted solution]

Thanks Jo

The permission is wrongly set for oraarch. This should resolve this issue

Thanks

Shaji

[former_member204746]

what is the size of your datafile? if your Oracle block size is 8K, you cannot extend over 32GB.

I would put maxsize to 32GB and create a new datafile with a max_size of 32GB.

[Former Member]

Hi Eric.

The size of the datafile is 6GB and the autoext is off. So this wouldn't be the reason. Will restarting the DB and the Application help?

Thanks

Shaji