How to extend /tmp resource busy!!

[Patricio Carmona]

when i try to extend the file system /tmp for an installation of Oracle 9i, it sends me a message like the resource is busy.
what are the steps to do this?

please i need some help!

[Devender Khatana]

Hi,

It can be done online only if you have a licensed product called Online JFS installed.

To find out wheather you have it or not do.

mydb:/>>swlist -l product|grep -i online
OnlineJFS B.11.11 Online features of the VxFS File System

If the same product is listed there then you have it otherwise not. If you have that then first find free space in vg00 by

#vgdisplay -v /dev/vg00|grep -e Free -e Size|grep PE

This will give you your PE Size & Free PEs. You can increase your file system by only by the PE's available free in your vg00.

Once found free space you can follow the procedure for extending.

#lvextend -L xxxx /dev/vg00/lvol_tmp
#fsadm -b yyyym /tmp
#bdf to confirm

Where xxxx in your new size in MB & YYYY in your new size in blocks.

If you have not this product then an alternative can be to create a new file system & then mount it at something like /tmp/oracle & then point your application tmp location here.

HTH,
Devender

[Steven E. Protter]

1) You can redirect the oracle installation to not use the /tmp directory. That is a configurable paramter in the 9i installation GUI.

You may need to take the system into single user mode.

Surely all processes on /tmp must be terminated including the oracle install.

fusers -cuk /tmp

That will likely shut down or disrupt a lot of applications on the server.

At that point you should be able to extend /tmp

SEP

[Sudeesh]

One more option: boot the system to single user mode and extend it. If you have device busy error in single user mode, use
fuser -cu /tmp
fuser -ku /tmp

to view and then kill process accessing /tmp.

Sudeesh

[TwoProc]

OK, I'm going to give you the ugly solution (because I don't remember which one is the correct one). But, the fix would entail creating a new directory for the files to land in - let's just say /u1/orainst.temp - for ease of use - do a chmod 777 on that directory.
Now set the following in the environment:
TMPDIR=/u1/orainst.tmp
TEMPDIR=/u1/orainst.tmp
TMP_DIR=/u1/orainst.tmp
TEMP_DIR=/u1/orainst.tmp

OK - stop laughing all you folks who know the answer off hand ... :-) .

Why set all four above? Because it's ONE of those, but I'm nost sure which so out of laziness, I just set them all before I start the install. I actually think it's the first one, but my second guess is the second one. I don't think it's three or four, but what the heck - I don't want to restart an install b/c it's too slow, and I'm too lazy to go look it up when I know that if I do all four it's gonna redirect properly. :-)

Anyhoo - it'll redirect those temp files away from /tmp and put them in /u1/orainst.tmp .

Now, you don't have to fix the /tmp drive[mount point] to be any larger.

Hope this helps.