We have an Oracle 8.1.7 Database running on OpenVMS.
We also have a 3-tier application using this database.
But lately we have a *ALOT* of "ORA-01034 Oralce Not Available" errors.
Oralce *is* available but the users keep getting this message and everyone get very frustrated as the app' freezes.
I have no idea what it is, I am a junior DBA.
Can anyone shed some light on this?
Many thanks, Ed.
01034, 00000, "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.
the alert log in the "bdump" directory may shed some light on what
is going on. Look for entries around the time the users are getting
the "Oracle Not Available"
Also .... look at .trc files in the "udump" directory. This is a trace log
from a particular user. Find one during the time of the error message
and see if you can pick out anything of value (usually at the top will
give an overview of the situation).
The .trc around 3:00am might be a usefull bit of information. Does
the database do an online backup or any other processing (batch)
around that time ???
I believe that on an Oracle installation on VMS you must compile and
link the executables....
As far as the .TRC files ... the ora-600 errors are almost always followed by additional information that is invaluable !!! They are usually followed by [xxx],[xxxx],[xxx],[xxx] ...
If you take the error into Oracle's metalink, you are liable to find out
where the problem is ...
I usually copy and paste the error message into the search engine
in Metalink ...