ORA-01034 - Oracle not available
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: ORA-01034 - Oracle not available

  1. #1
    Join Date
    Apr 2003
    Posts
    16

    ORA-01034 - Oracle not available

    Hi,

    I m new to this forum.

    I m using Oracle 8.0.5 on windows NT and last 2 days i m not able to connect to oracle.

    1. i hv check all oracle services - running successful
    2. try to connect - server manager - svrmgr30 with internal user but fail to connect.
    3. it seems to be SGA or OS level problems

    can anyone help me to up the databse again. or anyother solution.



    Thanks and regards

    Avi.

  2. #2
    Join Date
    May 2001
    Posts
    736
    May be problem with your password file.create another with orapwd utility and try.

  3. #3
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434

    Re: ORA-01034 - Oracle not available

    Originally posted by Avi123india
    Hi,

    2. try to connect - server manager - svrmgr30 with internal user but fail to connect.
    Avi.
    Wass the error?

    Abhay.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  4. #4
    Join Date
    Dec 2001
    Location
    Tel-Aviv,Israel
    Posts
    233
    On version 8.0.5 ,SVRMGR is issued by svrmgrl and not by svrmgr30.

    See the following example (On Unix):

    hp64 23: svrmgrl

    Oracle Server Manager Release 3.0.5.0.0 - Production

    (c) Copyright 1997, Oracle Corporation. All Rights Reserved.

    Oracle8 Enterprise Edition Release 8.0.5.2.1 - Production
    PL/SQL Release 8.0.5.2.0 - Production

    SVRMGR> connect internal
    Connected.

    On your NT machine,try fisrst the command:
    set oracle_sid = ;
    and then : svrmgrl

    send us the output of those commands.

    Regards,

    Nir

  5. #5
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by nir_s
    On version 8.0.5 ,SVRMGR is issued by svrmgrl and not by svrmgr30.
    He clearly stated his OS is Windows NT, and on NT there is no such thing as "svrmgrl" on 8.0.5 - command line Server Manager on that release is "svrmgr30".
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  6. #6
    Join Date
    Apr 2003
    Posts
    16
    Hi,

    Thanks for immediate response

    my observation :

    1. I found from log/trace file that one of the data file stored in
    another Hard disk, which is crashed. is there anyway to recover data as on date. all other datafile are safe in another hard disk.

    2. why user internal is not connecting to server manager
    error message : invalid username/password
    if i use orapwd utility , can i able to connected to server ?

    3. last option i hv some old back(user) can be useful.

    Regards,

    Ari.

  7. #7
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by Avi123india
    Hi,

    Thanks for immediate response

    my observation :

    1. data file stored in another Hard disk, which is crashed. is there anyway to recover data as on date. all other datafile are safe in another hard disk.
    If hard disk is crashed, check with NT admin guys if its recoverable.




    2. why user internal is not connecting to server manager
    error message : invalid username/password
    if i use orapwd utility , can i able to connected to server ?

    Yes
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

Posting Permissions

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


Click Here to Expand Forum to Full Width