Q

Problem solve

Cause of ORA-1089 error

I'm getting the ORA-01089 error and the system is allowing me to connect to the database as sysdba using SQL*Plus. I must say that I'm novice when it comes to Oracle. Any suggestions?
The ORA-1089 error is telling you that someone attempted to perform a SHUTDOWN of the database. No new transactions can be started. If this condition persists for a long period of time, sign on to the database as SYSDBA and issue the following:

SHUTDOWN ABORT
STARTUP

This will force the database to shut down immediately and then start it back up. Transactions can now take place.

This was last published in April 2004

Dig Deeper on Oracle database design and architecture

All
News
Get Started
Evaluate
Manage
Problem Solve

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

Start the conversation

Send me notifications when other members comment.

-ADS BY GOOGLE

SearchDataManagement

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 ...
Big data containers gain wider appeal in system deployments

This handbook examines the use of Docker containers in Kubernetes clusters to run big data systems and offers insight on ...

SearchBusinessAnalytics

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 ...
Howard Dresner talks business intelligence trends

In this Q&A, analyst Howard Dresner talks about trends in the business intelligence software market, industry consolidation and ...
Today's top data pipeline management challenges

IT executives say pricing models, agility and auditability are some of the biggest challenges they have faced in managing today's...

SearchSAP

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 ...
Experts' tips for evaluating SAP cloud computing options

For a successful deployment of SAP software in the cloud, your company must consider factors including what's required of the ...
What's new in SAP HANA Cloud Services and why it matters

Access to HANA in-memory data processing from a scalable elastic cloud and new options for balancing cost and speed are the main ...

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

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 ...
What's the difference between applet and application in Java?

Java applets are no longer supported. How do they differ from applications? Let's explore their differences, as well as a brief ...

SearchDataCenter

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.
Use ASHRAE guidelines to get server temperature right

The main factors that affect server efficiency are inlet air temperature, humidity and contaminants. Follow these ASHRAE ...

SearchContentManagement

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 ...
Get to know data governance tools for the enterprise

Data governance tools can address documentation gaps, data visibility and metadata management. Here are some tools that can help ...

SearchHRSoftware

Amazon's fastest growing occupations list raises questions

Amazon's plan to upskill its workforce cites high-growth occupations such as data scientist and what it calls data mapping ...
Digital upskilling prepares employees for the future of work

As some industries face growing digital skills shortages, upskilling current employees and promoting a culture of learning will ...
Employee activism challenges HR's employee experience strategy

Employees aren't afraid to challenge their employers on workplace and social issues. That kind of employee activism may challenge...

Close