Intralink 3.4 M062 - huge TEMP_01.DBF file

[egifford]

Checking the health of our Intralink 3.4 M062 Server just now and it is reporting that the C drive is nearly out of space, and it is. Looking into it the TEMP_01.DBF file in loadpoint\dataserver\intralink\dbs has ballooned to 14.8 GB. What would cause this? The server is requesting a reboot because of applied Windows OS patches, but I'm hesitant to reboot with this issue present. We've been running M062 for about a month and it's been working great. Any suggestions on how to clean out the dbf file and get back the drive space?

Server: VMware 5 physical host, Windows Server 2003 R2 guest server for Intralink

[RandyJones]

On 01/09/12 13:42, Erik Gifford wrote:
>
> Checking the health of our Intralink 3.4 M062 Server just now and it is reporting that the C drive
> is nearly out of space, and it is.  Looking into it the TEMP_01.DBF file in
> loadpoint\dataserver\intralink\dbs has ballooned to 14.8 GB.  What would cause this?  The server
> is requesting a reboot because of applied Windows OS patches, but I'm hesitant to reboot with this
> issue present.  We've been running M062 for about a month and it's been working great.  Any
> suggestions on how to clean out the dbf file and get back the drive space?
>
> Server:  VMware 5 physical host, Windows Server 2003 R2 guest server for Intralink
>
>
> ----------

I used this several years ago when my temp tablespace had grown to 10.8GB.
Basically this is doing the following:
1. getting the name of the current temp file(s)
2. creating a new temporary tablespace
3. setting the default tablespace to the new temp table files
4. dropping old large temp tablespace
5. recreate new temporary table space using same name as given in step 1
6. setting the default tablespace to use this
7. dropping the temporary table space created in step 2

server3% sqlplus system/manager

SQL*Plus: Release 9.2.0.4.0 - Production on Mon Dec 27 18:46:45 2004

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
JServer Release 9.2.0.4.0 - Production

SQL> select file_name from dba_temp_files;

FILE_NAME
--------------------------------------------------------------------------------
/export/intralink_oracle/temp_01.dbf

SQL>

SQL> CREATE TEMPORARY TABLESPACE temp2 tempfile '/export/intralink_oracle/temp2.dbf' size 100M
extent management local uniform size 512k;

Tablespace created.

SQL> ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp2;

Database altered.

SQL> DROP TABLESPACE temp INCLUDING CONTENTS AND DATAFILES;

Tablespace dropped.

SQL> create temporary tablespace temp tempfile '/export/intralink_oracle/temp_01.dbf' size 1000M
extent management local uniform size 512k;

Tablespace created.

SQL> ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp;

Database altered.

SQL> DROP TABLESPACE temp2 INCLUDING CONTENTS AND DATAFILES;

Tablespace dropped.

SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
JServer Release 9.2.0.4.0 - Production
server3%


--
------------------------------------------------------------------------
Randy Jones
Systems Administrator
Great Plains Mfg., Inc.
1525 E North St
PO Box 5060
Salina, KS USA 67401
email: -
Phone: 785-823-3276
   Fax: 785-667-2695
------------------------------------------------------------------------

[egifford]

Huge thanks goes out to Randy Jones and Tim McGee for providing the series of SQL commands required to clear up the issue with the TEMP_01.DBF file. Systemappears to behealthy again. If anyone has pointers as to why the temporary tablespace file would suddenly grow in size, let me know. I'd like to determine a root cause if possible.

Regards,

Erik Gifford

G.W. Lisk Co., Inc.