Solved

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

Posted on 2003-12-05
23
18,445 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
  • 9
  • 7
  • 2
  • +4
23 Comments
 
LVL 5

Expert Comment

by:DrJekyll
Comment Utility
Shutdown your NT services and restart then try to connect

DJ
0
 
LVL 1

Author Comment

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

Expert Comment

by:seazodiac
Comment Utility
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
 
LVL 1

Author Comment

by:globalwm
Comment Utility

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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
Also, I am also in the ORA_DBA group on my PC...  I also tried changing SQLNET.AUTH to NONE...

??
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 23

Expert Comment

by:seazodiac
Comment Utility
ok, try:

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

SQL>connect sys/ORACLE as sysdba

0
 
LVL 8

Expert Comment

by:baonguyen1
Comment Utility
But have you tried with  SQLNET.AUTH to NTS ?

Believe me or not but it works
0
 
LVL 8

Expert Comment

by:Rindbaek
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
up to you!!! really. take it back or give away....
0
 
LVL 1

Author Comment

by:globalwm
Comment Utility
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
Comment Utility
Closed, 250 points refunded.
Lunchy
Friendly Neighbourhood Community Support Admin
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

743 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now