ORA-01089 when opening the database

We are encountering ths problem:
DATABASE OPEN: error when opening database:

ORA-01089: immediate 
 shutdown in progress - no operations are permitted.

Can you tell us in what situations do we get this error?

Your database is trying to shut down. When it is trying to shut down, no one is allowed to log in. To find out why your database is trying to shut down, you'll have to look in your database's alert log file for clues.

Sometimes, the database won't shut down no matter how long you wait. So you'll have to force it down and then restart it. The following commands in SQL*Plus should do the trick:

connect / as sysdba
shutdown abort
startup

You should now be able to connect to your database.

This was last published in July 2004

Dig Deeper on Oracle database backup and recovery

All
News
Get Started
Evaluate
Manage
Problem Solve

Solving common Oracle error codes guide

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our Oracle Database / Applications experts

View all Oracle Database / Applications questions and answers

SearchDataManagement

11 real-time data streaming roadblocks and how to overcome them

Experts detail common challenges that IT teams encounter when deploying and managing real-time data streaming platforms and offer...

Snowflake product VP expounds on data warehouse for the cloud

In this Q&A, Christian Kleinerman, vice president of product development at cloud data warehouse vendor Snowflake, talks about ...

RavenDB Cloud automates database management

RavenDB's managed cloud database service, RavenDB Cloud, intends to automate security processes, reduce overhead and cater to ...

SearchBusinessAnalytics

Updated AtScale platform streamlines analysis of big data

By improving the machine learning and augmented intelligence capabilities of its platform, AtScale's newest release attempts to ...

ThoughtSpot strategic partnerships help add capabilities

Through its partnership strategy, ThoughtSpot is adding to its capabilities as a BI software vendor the same way others are ...

IBM battling to change perception of Cognos Analytics BI platform

While some see IBM's BI suite as being too complicated and expensive for citizen data scientists, the company is adding updates ...

SearchSAP

As SaaS ERP, S/4HANA Cloud not meant to replicate ECC

In a Q&A, Jan Gilg, SAP's new global head of S/4HANA, joined SVP Sven Denecken to explain the differences between the on-premises...

SAP Leonardo technologies seek to empower the digital enterprise

Learn the fundamentals of Leonardo, how it has evolved over the years and key steps to using its advanced technologies to build a...

SAP PartnerEdge initiative offers free S/4HANA Cloud resources

SAP now offers free access to S/4HANA and C/4HANA test and demonstration systems to qualified partners. The new partner program ...

SearchSQLServer

Using a LEFT OUTER JOIN vs. RIGHT OUTER JOIN in SQL

In this book excerpt, you'll learn LEFT OUTER JOIN vs. RIGHT OUTER JOIN techniques and find various examples for creating SQL ...

How SQL Server DevOps processes help break down data silos

DevOps can help organizations dismantle data silos in SQL Server and other database systems -- and replace organizational silos ...

Key features to create a SQL Server audit trail in databases

SQL Server offers a set of built-in auditing tools that can help make the process of tracking logins and other database ...

TheServerSide.com

Weigh cost, flexibility in your Java cloud IDE comparisons

What's in a cloud IDE for Java developers? Flexibility and integration for starters. Consider these four options in your ...

What are the differences between EAR, JAR and WAR files?

JAR, WAR and EAR files provide options in a Java application deployment. Let's compare these file types and determine which one ...

4 great Java-based CMS options

Open source Java CMS tools come in a wide variety of shapes and sizes. Explore these four platforms to see if they would be a ...

SearchDataCenter

3 ways to benefit from open source infrastructure

Using open source infrastructure can reduce operating costs and streamline upgrades, but it's important to weigh the pros and ...

IBM mainframes face competitive pressures inside and out

IBM's mainframe business continues to be under pressure from cloud-based competitors, and perhaps even its own Power server. ...

Linux features beyond server management

Due to its open source nature, Linux is constantly gaining new capabilities. Here's a look at some common use cases and features.

SearchContentManagement

Alfresco cloud migration service moves content off premises

With new cloud migration services, Alfresco promises to move content from IBM, SharePoint, Documentum and other legacy ECM ...

Using AI in content creation can streamline publishing

Companies using AI in content creation can generate short-form material automatically, which frees up humans to handle more ...

New Contentful CMS targets content delivery for retailers

Contentful's content infrastructure is a CMS that intends to bring more flexibility and benefits than a traditional or headless ...

SearchHRSoftware

Eliminating bias in AI is no easy feat, but fixes do exist

As more companies turn to AI to reduce workplace and recruiting bias, it is important to be aware that the data AI tools draw ...

Immigrant visa reform poised to complicate hiring plans

Legislators plan to act on a bill that will remove per-country caps for immigrant workers, making it more difficult for companies...

Continuous performance management comes with benefits, drawbacks

Many companies are ditching yearly performance reviews in favor of continuous performance management. The new method has its ...

Dig Deeper on Oracle database backup and recovery

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.