Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Oracle Temp datafile

Oracle Temp datafile

From: Panosian, Estifan <EPanosian_at_edc.ca>
Date: Tue, 9 Aug 2005 08:27:00 -0400
Message-ID: <FA7E8D9972B6974F9F1088DE4C4FB59D031DE317@EXCHMAIL5.edc.ca>


Hi everyone,

I am new in Oracle world.
Yesterday morning we restarted our production box. The database came up without any problems. But because of a message from NetIQ we realized that Oracle has a little(?) problem with temp datafile, it seems that Oracle Temp datafile is not available for write. OEM console does not report any problems, the datafile size is 500mg and used %0.
A NetIQ job (called "Oracle_TablespaceAvail") reports that 'An unknown Oracle error occurred'.
Using OEM console I offlined and onlined the datafile, I added a new Temp (temp2 500M) datafile, offlined 1st datafile for almost 3 hrs, no difference at all. I switched them to online and after 24 hrs, Used % or Used (M) of Temp datafile is still 0.

Questions:

1) Any idea why?
2) Is this a critical issue?
3) What is the solution?

Oracle 9.2.1.0
OEM 9.2.1.0
Windows 2000 Advanced server  

Thanks in advance,
Estifan Panosian
DBA

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Aug 09 2005 - 07:29:05 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US