Re: Question for DBA: control files and processes

<snipped the alert log file>

Check the manual:
ORA-00204 error in reading (block string, # blocks string) of controlfile

     Cause: A disk I/O failure was detected on reading the control file.

     Action: Check that the disk is online. If it is not, bring it online and shut down and restart Oracle.

     If it is online, then look for operating system reasons for Oracle's inability to read the disk or

     control file. See the Oracle8i Administrator's Guide for information on recovering

     from the loss of a control file. See also your operation system-specific Oracle documentation.

Or type: oerr ora 204

Control file corrupt, perhaps?
better recreate it (you do dump that on a regular basis, don't you?!?) with larger values
for MAX.... Oracle uses info of MAX... params to allocate space in the controlfile, and it looks
like yours is too small (and cannot expend?)

hth, grtz, Frank Received on Wed Jul 26 2000 - 00:00:00 CDT