Oracle-L: RE: FILE IDENTIFY wait event

From: Daniel W. Fink <optimaldba_at_yahoo.com>
Date: Tue, 30 Apr 2002 09:48:52 -0800
Message-ID: <F001.00453B4A.20020430094852@fatcity.com>

The volume was offline. Once it was back online, Oracle resumed the process of creating a tablespace.

Which brings up another question...why did Oracle wait on this condition instead of terminating with an error? If a file-system directory/drive cannot be found, the attempt to create a tablespace will fail. Is there something different in using a raw device?

Dan
-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Tim Gorman Sent: Tuesday, April 30, 2002 11:24 AM To: Multiple recipients of list ORACLE-L Subject: Re: FILE IDENTIFY wait event

Make sure that the volume group underlying the logical volume is ONLINE?

To test, I like to do something quick like "dd if=<raw-device> of=/dev/null count=100" to test the readability of the raw device. If this fails, you can go to the SysAdmin with something that is pure UNIX...

Original Message ----- From: Daniel W. Fink To: Multiple recipients of list ORACLE-L Sent: Tuesday, April 30, 2002 10:41 AM Subject: FILE IDENTIFY wait event

Oracle8.1.7 on Solaris8

I am trying to create a tablespace on a raw device and the SQL*Plus session that performs the tablespace creation is waiting on a 'file identify'. A quick search on metalink and other docs did not indicate the root cause of the wait event.

I have used the raw device previously and the create tablespace uses the 'REUSE' option.

Okay gurus...any clues as to exactly what conditions cause the event?

Dan Fink

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Daniel W. Fink
INET: optimaldba_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Apr 30 2002 - 12:48:52 CDT