Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2003-12-05
23
Medium Priority
?
18,645 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
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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
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

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many‚Ķ
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
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 copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

926 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