Results 1 to 9 of 9
  1. #1
    Join Date
    Oct 2003
    Location
    Manchester, England
    Posts
    4

    Red face Unanswered: ORA-01034 Oracle Not Available

    Hi,

    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.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1

    Re: ORA-01034 Oracle Not Available

    Originally posted by eiroberts
    Hi,

    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.

    HTH

  3. #3
    Join Date
    Oct 2003
    Posts
    26

    Re: ORA-01034 Oracle Not Available

    Check the alert.log under BDUMP directory if it throws more light on the reason for the error and for accompanying errors

    Check if the error occurs at the same point in the application

    HTH
    Arvind

  4. #4
    Join Date
    Oct 2003
    Location
    Manchester, England
    Posts
    4

    Oracle not available

    Hi,

    There are now .trc logs or alert logs, there was one yesterday that was created at 3am! But nothing after that.

    It is so strange, we have about 500 users but they don't all hit the database at the same time.

  5. #5
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    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 ???

    Gregg

  6. #6
    Join Date
    Oct 2003
    Location
    Manchester, England
    Posts
    4
    Hi,

    Yes it does have a backup early in the morning and a scheduler also runs athe database.

    The .TRC files appeared then.

    But we are having the problem on the online day.

    There are no users on the system early in the morning.

    There are no ALERT or .TRC's during the daytime.

  7. #7
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    What does the .TRC file tell you from 3:00 ... Does it shed any light???
    How about the alert log ???

    It almost sounds like a networking issue ... or a problem in compiling
    Oracle on VMS....

    Gregg

  8. #8
    Join Date
    Oct 2003
    Location
    Manchester, England
    Posts
    4
    Hi,

    I am not sure why but somone has deleted the .TRC file from yesterday!!! Idiots.

    Anyhow, I remember what was inside the log file. It made reference to a memory leak in the UGA area. Then a reference to ORA-00600 errors. It then went on to dump the memory out into the file.

    I don't know why.

    But we don't get any errors in anyfiles during the online day.

    Also what do you is meant by *linking Oracle* on an OpenVMS platform?


    Ed.

  9. #9
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    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 ...

    HTH
    Gregg

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •