Ora 01033 что делать

ORA-01033 is related to the starting up or shutting down of Oracle. There are several possible causes and fixes to the problem.

The Problem

The ORA-01033 error message is as follows:

ORACLE initialization or shutdown in progress

The most likely cause is that an attempt was made to log on while Oracle is either starting up or shutting down. Otherwise, you may be facing one of the following problems:

The database was not mounted properly.
There is a problem with the database files—They may have been moved or are corrupt (CTL, DBF, ORA).
There is a problem with the database service.

The Solution

Check to see if the database is in the process of starting up or shutting down. Wait a few minutes for Oracle to finish, then try the operation again. If this is unsuccessful, restart the system and restart the database service.

Another possibility for the error is that your operating system holds RAM regions left over which Oracle takes as an instance that is already running. If this is the case, you must kill all Oracle processes associated with the ORACLE_SID. Identify all RAM memory segments, then release the RAM memory.

If the database was not mounted properly, you must mount and restart the database. Do this by querying “alter the database mount” and “alter database open”.

If there is a problem with the database files, the files may have been changed or moved to a different location. Locate and recover the files if this is the case.

Lastly, if there is a problem with the database service, restart the database service in services. msc.

In addition, if you are getting ORA-19809 in addition to ORA-01033, the solution may lie within fixing ORA-19809, which occurs when the limit is exceeded for recovery files.

A last resort may be deleting the service and database, then recreating it. If you choose to try this method, make sure your data is backed up. In service.msc, stop the service and delete the service. Then recreate the database.

Looking Forward

To avoid getting ORA-01033, make sure Oracle is not in the process of starting up or shutting down. Make sure the database is mounted properly and there are no problems with the database service or files. A simple solution to many problems faced in Oracle requires shutting down and restarting. This may easily resolve some Oracle errors. If you continue seeing ORA-01033, contact your database administrator for assistance. You may consider consulting a licensed Oracle professional.

How to Resolve ORA-01033: ORACLE initialization or shutdown in progress

Tried to connect to the database, but it failed with ORA-01033 like the following.

SQL> conn hr/hr@orcl
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
Process ID: 0
Session ID: 0 Serial number: 0

ORA-01033 means that the database you want to connect is in MOUNT state currently, it might encouter some difficulties to be open. If the error message surprised you, you should check the alert log of the database for further investigation.

Читать:

Как синус перевести в градусы

With little chances, it’s about to go up or down. The most chances are, the instance stays still in MOUNT state without doing anything, it’s not going up or down, so don’t be fooled by the error message.

Solutions

To solve ORA-01033, we can notify DBA to open the database for public to access. If the database cannot be open at this moment, you can still connect to it as long as you are a SYSDBA.

To open the database from MOUNT state, we can either open it in 1 step:

SQL> alter database open;

Now the database is open, it may be far behind the instance startup. In fact, there’s difference between instance startup time and database open time.

Or restart it in 2 steps.

SQL> shutdown immediate SQL> startup

Of course, if the database is really in starting up or shutting down, you have to wait for the progress to be completed.

Getting ORA-01033: ORACLE initialization or shutdown in progress

I tried all the tricks mentioned on internet but couldn’t get rid of this error.

I also tried below

also tried below but still getting error’s

Can someone help here? thanks!

2 Answers 2

I’ve had the same problem and just want to share my solution with you, if anybody else gets the ORA-01033: ORACLE initialization or shutdown in progress Error in Oracle 12c Database. My database showed me the error everytime i tried to connect to a user of a sample schema (for ex. hr).

The following worked for me:

I had the same error and i solve it. In fact the problem that you got is due to a changement in the destination of one or few datafiles. In your case is the datafile 10.In fact the error is:

The solution is to search this datafile in your hard drive an make it in the same directory used by oracle which is in your case : C:\ORACLEDB12C\APP\USERNAME\ORADATA\ORCL\PDBORCL\EXAMPLE01.DBF

Mention that you should do this for all datafile that you have changed its directories.I wish this will be helpful.

How to Deal with an ORA-01033 'Oracle startup or shutdown in progress' Error (Doc ID 343031.1)

What to do when database clients are receiving an ORA-01033 ‘Oracle startup or shutdown in progress’ when they are attempting to connect to a database that should be open and available to them?

Solution

To view full details, sign in with your My Oracle Support account.

Don’t have a My Oracle Support account? Click to get started!

In this Document

Goal

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.

Ora 01033 что делать