ora-01033 shutdown or initialization in progress
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: ora-01033 shutdown or initialization in progress

  1. #1
    Join Date
    Apr 2002
    Posts
    135

    ora-01033 shutdown or initialization in progress

    i have oracle 8.1.7 in windows NT.
    I started the DB service and listener,

    When i tried to login to sqlplus it threw
    the error
    " ora-01033 shutdown or initialization in progress"

    i also forgot my internal password , i am starting the db after long time.It was working fine before.

    I restarted the machine and again restarted the service.But it throws the same error.
    Good Judgement comes from Experience.
    Experience comes from Bad Judgement

  2. #2
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Is the string value true for the key ORA_%SID%_AUTOSTART in the registry under the path HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME???

    If S...is the service getting started properly?
    If S...then u shud not get that 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"

  3. #3
    Join Date
    May 2001
    Posts
    736
    Since u lost the password.First stop the service.Drop the service and passwordfile. Recreate the service followed by password file.Then try again to start the database.

  4. #4
    Join Date
    Apr 2002
    Posts
    135
    hi,

    thanks for the reply

    HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME\ORA_SID_AUTOSTART value is TRUE

    I still do know why i get this error.

    I stopped the service.
    Then i tried to invoke svrmgrl in cmd prompt.
    On invoking itself i got
    tnsprotocol adapter error.

    Any suggestions.

    akhadar,
    how to drop the password file.
    Good Judgement comes from Experience.
    Experience comes from Bad Judgement

  5. #5
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by sona
    hi,

    thanks for the reply

    HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME\ORA_SID_AUTOSTART value is TRUE

    I still do know why i get this error.

    I stopped the service.
    Then i tried to invoke svrmgrl in cmd prompt.
    On invoking itself i got
    tnsprotocol adapter error.

    If that value is true...ur DB starts automatically..
    If u r not facing any problem in starting the service...then ur DB shud have started....
    If otherwise, u gotta problem in starting DB...

    Make the key value FALSE.
    Start the service(now ur DB wudnt have started).
    Put the NT user acc ( the logged user ) in ORA_DBA group.
    Make changes in SQLNet.ora...change the authentication as SQLNET.AUTHENTICATION_SERVICES= (NTS)
    Now login using INTERNAL acc ( u dont need to spicfy pswd as authentication is NTS....am not sure with internal acc but with SYS as SYSDBA wud work with 9i )
    STARTUP

    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"

  6. #6
    Join Date
    Apr 2002
    Location
    France
    Posts
    118
    Originally posted by sona
    i got
    tnsprotocol adapter error.

    from svrmgrl instead of doing "connect internal/oracle", do a "connect internal/oracle@orcl" and you won't get the error.

    For the password file : just delete it ( located by default under [ora_home]\datatabase\) and recreate it with a command like the following :
    C:\>orapwd file=d:\oracle\ora81\database\pwdORCL.ora password=internal

    Once connected with SVRMGRL do a "shutdown abort" and then startup the DB with indicating the init file's path.
    If there is no solution, it is because there is no problem - Shadok -

  7. #7
    Join Date
    Apr 2002
    Posts
    135
    hi guys,

    thanks for your replies.

    Actually i checked the alert file now.
    it reported that it was not able to locate a particular .ora file

    So in svrmgrl it mounted the database,took the datafile offline and opened the db.
    It is working fine now.
    As i started from the service i was not able to identify the problem and when i invoked the sqlplus as it threw ora01033 error i thought it could be someother thing.


    Then i changed the internal password by loggin in as system

    Again thanks.
    Good Judgement comes from Experience.
    Experience comes from Bad Judgement

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