Solved

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

Posted on 2003-12-05
23
18,556 Views
Last Modified: 2012-05-04
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?
0
Comment
Question by:globalwm
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 9
  • 7
  • 2
  • +4
23 Comments
 
LVL 5

Expert Comment

by:DrJekyll
ID: 9884444
Shutdown your NT services and restart then try to connect

DJ
0
 
LVL 1

Author Comment

by:globalwm
ID: 9884460
Yes, this has been done (several times) already...
0
 
LVL 23

Expert Comment

by:seazodiac
ID: 9885345
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
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

 
LVL 1

Author Comment

by:globalwm
ID: 9885369

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
 
LVL 23

Expert Comment

by:seazodiac
ID: 9885404
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
 
LVL 8

Expert Comment

by:baonguyen1
ID: 9887345
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
 
LVL 13

Expert Comment

by:riazpk
ID: 9887598
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
 
LVL 23

Expert Comment

by:seazodiac
ID: 9888193
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
 
LVL 1

Author Comment

by:globalwm
ID: 9888792
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
 
LVL 1

Author Comment

by:globalwm
ID: 9888811
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
 
LVL 1

Author Comment

by:globalwm
ID: 9888891
Also, I am also in the ORA_DBA group on my PC...  I also tried changing SQLNET.AUTH to NONE...

??
0
 
LVL 23

Expert Comment

by:seazodiac
ID: 9889536
ok, try:

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

SQL>connect sys/ORACLE as sysdba

0
 
LVL 8

Expert Comment

by:baonguyen1
ID: 9892315
But have you tried with  SQLNET.AUTH to NTS ?

Believe me or not but it works
0
 
LVL 8

Expert Comment

by:Rindbaek
ID: 9893224
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
 
LVL 23

Expert Comment

by:seazodiac
ID: 9893272
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
 
LVL 1

Author Comment

by:globalwm
ID: 9896981
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
 
LVL 1

Author Comment

by:globalwm
ID: 9897406
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
 
LVL 23

Expert Comment

by:seazodiac
ID: 9897437
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
 
LVL 1

Author Comment

by:globalwm
ID: 9897486
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
 
LVL 23

Expert Comment

by:seazodiac
ID: 9897500
up to you!!! really. take it back or give away....
0
 
LVL 1

Author Comment

by:globalwm
ID: 10545002
Problem solved by Oracle Support - comment dated: Date: 12/08/2003 08:32AM PST
0
 
LVL 2

Accepted Solution

by:
Lunchy earned 0 total points
ID: 10589260
Closed, 250 points refunded.
Lunchy
Friendly Neighbourhood Community Support Admin
0

Featured Post

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question