Ora-01114:io Error writing block to file 204 (Block # 501829)

Today in the database transplant script test, but because of the large amount of data, there are many large data transactions (need to sort), so temp table space
Eat a disk, eat 30G, and finally eat my disk, prompting the following error

Ora-01114:io Error writing block to file 204 (Block # 501829)

This is my disk space is not enough, now find a way to increase disk space, I put some temporarily unused things moved to other partitions, so that probably
Freed up 1.6G of space, I thought, my data file is not very large, can be installed, so I run the transplant script, the problem remains, or disk
Space is not enough, disk space is not enough, nothing can operate, so I put/var this directory moved to/home, so that you can make space, users log in when
There's no hint,

It's just that:
No mail

[Oracle@db yw_sh]$

What is the problem?

Restart the database

The database can start normally, but the user cannot login, the hint error indicates the network impassability, the original monitoring did not rise, I then manually started the listening service,

[Oracle@db yw_sh]$ lsnrctl start

Tnslsnr for linux:version 10.2.0.3.0-production on 02-jan-2008 17:59:32

Copyright (c) 1991, 2006, Oracle. All rights reserved.

System parameter File Is/home/oracle/product/10.2.0.3/db_1/network/admin/listen
Er.ora
Log messages written To/home/oracle/product/10.2.0.3/db_1/network/log/listener.
Log
Trace Information Written to/home/oracle/product/10.2.0.3/db_1/network/trace/li
Stener.trc
Trace level is currently 0

Started with pid=3850
Listening on: (Description= (Address= (protocol=tcp) (host=db.movo.tv) (port=1521))
Error listening on: (Address= (PROTOCOL=IPC) (Partial=yes) (queuesize=1))
No Longer listening on: (Description= (Address= (protocol=tcp) (host=db.movo.tv) (PO
rt=1521)))
Tns-12557:tns:protocol Adapter Not loadable
Tns-12560:tns:protocol Adapter Error
Tns-00527:protocol Adapter not loadable

[Oracle@db yw_sh]$ Lsnrctl Stop

The same hint, for what reason. Why don't you get up?
Google, some people say that there is no/TMP space to read and write permissions, can/TMP is 777 ah,
Others said: The original/home/oracle/product/9.2.0.1.0/network/log/listener.log file more than 2G, listening will be broken (
But my file is only hundreds of trillion AH), so execute the following command, empty the log file

[Oracle@localhost log]$ cat/dev/null > Listener.log

Online for a while, and found that there is a command can be closed to this write log

Lsnrctl> set Log_status off

To continue writing the log, you need only

Lsnrctl> set Log_status on

You can also add an item to the Listener.ora file

Logging_listener = Off

After adding this, no matter how you restart your monitor, you won't be able to write a log.

Suddenly thought that maybe that/var directory
About, I then put the Var directory in copy back, but some of the catalogue will not go to the development of the brothers are still in the rush, they are waiting for
This is what reason, because I was MV Mobile, so there is no source file, I then on the other machine copy a var directory,
This time I renamed the original Var, and then moved that copy to the root directory, do not say well, listening can be up, so it seems that the Var
The function of this directory is still very big Ah, later Google,/var includes the system to change the general operation of the data. Each system is specific