Re: Help for ORA 1157 Error Message

ORA 01157 "cannot identify data file %s - file not found"

// *Cause:  The background process was not able to find one of the data files.
//         The database will prohibit access to this file but other files will
//         be unaffected. However the first instance to open the database will
//         need to access all online data files. Accompanying error from the
//         operating system describes why file was not found.
// *Action: Have operating system make file available to database. Then either
//         open the database or do ALTER SYSTEM CHECK DATAFILES.

ORA 01034 "ORACLE not available"

// *Cause: Oracle was not started up. Possible causes include the following:
//         - The SGA requires more space than was allocated for it.
//         - The operating-system variable pointing to the instance is
//           improperly defined.
// *Action: Refer to accompanying messages for possible causes and correct
//          the problem mentioned in the other messages.
//          If Oracle has been initialized, then on some operating systems,
//          verify that Oracle was linked correctly. See the platform
//          specific Oracle documentation.

JS wrote:

> I have been running Oracle Personal Edition under Win 95 for quite some
> time. Recently, I migrated some Access database using the Migration Wizard
> which completed successfully. Now, when I try to start Oracle, the error
> message ora 1157 appears. When I try and start from SQL Plus, the error
> message 1034 Oracle Not Available appears. I cannot log on using server
> manager either. Can anybody explain what went wrong and how to correct this
> problem, I have already tried re installing the software and migrating again
> with the same result. Any help will be greatly appreciated! Thanks
Received on Mon Jul 17 2000 - 00:00:00 CDT