OEM - getting ORA-01033: ORACLE initialization or shutdown in progress error

The other day, my pc's profile became corrupted. I rebuilt and now cannot start OEM. Oracle Home is on my E drive btw...

I cannot logon to my instance for OEM. The Oracle Service, Listener and Agent (9i on WinXP Pro) are running fine but the Management Server will not start:

Error starting Oracle Management Server.
VXA-2028 :
Unable to connect to OMS repository."Could not start management server. Initialization failure"
OEMCTL for Windows NT: Version 9.2.0.1.0 Production
Copyright (c) 1998, 2002, Oracle Corporation.  All rights reserved.
Starting the Oracle Management Server... [main][2003-12-5:8:16:11:243] VdbSession.processError: errorCode >1033<
 [main][2003-12-5:8:16:11:243] VdbSession.processError: errorMsg >ORA-01033: ORACLE initialization or shutdown in progress



C:\>sqlplus /nolog

SQL*Plus: Release 9.2.0.1.0 - Production on Fri Dec 5 08:22:03 2003

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

SQL> connect system/manager as sysdba
ERROR:
ORA-01031: insufficient privileges


SQL> connect sys/change_on_install as sysdba
ERROR:
ORA-01017: invalid username/password; logon denied


SQL> connect sys/change_on_install
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress


Passwords were all left "standard"...


Any ideas?
LVL 1
globalwmAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

DrJekyllCommented:
Shutdown your NT services and restart then try to connect

DJ
0
globalwmAuthor Commented:
Yes, this has been done (several times) already...
0
seazodiacCommented:
Do you have several oracle instances in your pc?

try this at the DOS command:

C:\>set ORACLE_SID =<point to your instance>
C:\>sqlplus /nolog
SQL>connect / as sysdba
once you connected,

SQL>shutdown abort

SQL>startup

if this does not work, tell me what's going on when you try these steps.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

globalwmAuthor Commented:

C:\>SET ORACLE_SID=ORCL

C:\>SQLPLUS /NOLOG

SQL*Plus: Release 9.2.0.1.0 - Production on Fri Dec 5 14:02:07 2003

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

SQL> CONNECT / AS SYSDBA
ERROR:
ORA-01031: insufficient privileges


SQL>
0
seazodiacCommented:
Are you using the same user account as before your PC got corrupted?
if this is the case,

try this :

C:\> ORADIM -delete -sid ORCL

after one or two minutes, reboot the machine (I experience this on windows XP pro, It does not delete the Service, instead it marks it disabled, only when you reboot the machine does this OracleServiceORCL disappear)..

when machine comes back;

C:>ORADIM -new -sid ORCL -intpwd <password> -STARTMODE auto -pfile <path_to_orcl_init.ora file>

then try the following steps again:

try this at the DOS command:

C:\>set ORACLE_SID =<point to your instance>
C:\>sqlplus /nolog
SQL>connect / as sysdba
once you connected,

SQL>shutdown abort

SQL>startup
0
baonguyen1Commented:
OK, one trick that may help you. This worked for me when getting ORA-01031 error connecting as SYSDBA

Add this entry to your sqlnet.ora and try again:

SQLNET.AUTHENTICATION_SERVICES = (NTS)

Hope this helps


0
riazpkCommented:
And also :

-- If you are running on Linux/UNIX, your OS user should be in dba group
-- If you are running on Windowz, your OS user should be a member of ORA_DBA group
0
seazodiacCommented:
baonguyen1---> do you really mean that? I think it should be :

SQLNET.AUTHENTICATION_SERVICES = (NONE)


riazpk:

from Oracle8i and upwards in  windows, the requirement of oracle account in ORA_DBA group is no need.
0
globalwmAuthor Commented:
seazodiac, I'm trying your suggestion first.

For <password>  - which do you mean?  Should I keep change_on_install  or my NT user password?
0
globalwmAuthor Commented:
I did the ORADIM -delete -sid ORCL, waited a few minutes and rebooted pc.

Then:

C:\>ORADIM -new -sid ORCL -intpwd ORACLE -startmode auto -pfile e:\oracle\admin\
ORCL\pfile\init.ora.5122003134356

C:\>set oracle_sid=ORCL

C:\>sqlplus /nolog

SQL*Plus: Release 9.2.0.1.0 - Production on Sat Dec 6 09:32:17 2003

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

SQL> connect / as sysdba
ERROR:
ORA-01031: insufficient privileges


SQL> connect internal/oracle as sysdba
ERROR:
ORA-09275: CONNECT INTERNAL is not a valid DBA connection


SQL>
0
globalwmAuthor Commented:
Also, I am also in the ORA_DBA group on my PC...  I also tried changing SQLNET.AUTH to NONE...

??
0
seazodiacCommented:
ok, try:

C:\>set ORACLE_SID = ORCL
C:\>sqlplus /nolog

SQL>connect sys/ORACLE as sysdba

0
baonguyen1Commented:
But have you tried with  SQLNET.AUTH to NTS ?

Believe me or not but it works
0
RindbaekSenior ConsultantCommented:
just a note to baonguyen1's commen.

By setting SQLNET.AUTH to NTS  you let the OS handle the access rights thats why you have to be in the ORA_DBA group to use "as sysdba".

Henning
0
seazodiacCommented:
globalwm:
if my last post does not work for you, i would recommend you to do a full back up of your database (cold backup or OS backup including parameter file, control file, data files).

then deinstall the oracle software, and using the new user profile to rebuild the oracle software.
then put the database back.

this way, you probably save more time than banging your head onto the brick wall....
0
globalwmAuthor Commented:
baonguyen1,

Comment from globalwm
Date: 12/06/2003 09:56AM PST
 Your Comment  

Also, I am also in the ORA_DBA group on my PC...  I also tried changing SQLNET.AUTH to NONE...
 

It was set to "NTS" before...

-------------------------------------------------

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\aballo>cd c:\

C:\>set oracle_sid=ORCL

C:\>SQLPLUS /NOLOG

SQL*Plus: Release 9.2.0.1.0 - Production on Mon Dec 8 07:32:02 2003

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

SQL> CONNECT SYS/ORACLE AS SYSDBA
ERROR:
ORA-01017: invalid username/password; logon denied


SQL>


I think I might be headed towards seazodiac's last comment concerning b/u files and reinstall.

I'll let you know.  I also have a TAR open with Oracle.
0
globalwmAuthor Commented:
Oracle said it was a corrupted password file and had me do this:

1. Renamed password file to: E:\oracle\ora92\database\PWDORCL.OLD
2. Performed ->  E:\oracle\ora92\bin>orapwd file=e:\oracle\ora92\database\PWDORCL.ora password=password
3. Performed ->  C:\>sqlplus /nolog

SQL*Plus: Release 9.2.0.1.0 - Production on Mon Dec 8 08:29:13 2003

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

SQL> connect sys/password as sysdba
Connected.
SQL>


And I am now logged in!   :)

Working on corrupted Redo log problem now....
0
seazodiacCommented:
Darn it !!!  I knew it was it before,, but it fell through the crack then I forgot to mention to you....

anyhow, I am glad you solved your problem....
0
globalwmAuthor Commented:
At least it's documented here for someone else.  :)

I did learn something from your ORADIM stuff above (and this whole experience). Good thing it wasn't a main Production db.

What do I do with these points?
0
seazodiacCommented:
up to you!!! really. take it back or give away....
0
globalwmAuthor Commented:
Problem solved by Oracle Support - comment dated: Date: 12/08/2003 08:32AM PST
0
LunchyCommented:
Closed, 250 points refunded.
Lunchy
Friendly Neighbourhood Community Support Admin
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.