TestingDocs.com
Software Testing website
  • Automation
    • Selenium
    • JBehave Framework
  • Tutorials
    • MySQL Tutorials
    • Testlink
    • Maven
    • Git
  • IDEs
    • IntelliJ IDEA
    • Eclipse
  • Flowcharts
    • Flowgorithm
    • Raptor
  • About

Oracle

Fix ORA-01109: database not open Error

Overview

In this post, we will fix the Error ORA-01109: database not open. The root cause is that the pluggable database that we are trying to connect is not in open state. In this example, we will use the standard user SCOTT trying to connect to the database.

Error

Copyright (c) 1982, 2019, Oracle. All rights reserved.

Error indication and message:

SQL> CONNECT scott/tiger@orclpdb;
ERROR:
ORA-01109: database not open

ORA-01109 Database Not Open

Fix

Connect to SQL*PLUS tool as SYS as SYSDBA.

\> sqlplus / AS SYSDBA;

View the state of the pluggable database that you are trying to connect.

SQL> SHOW pdbs;

 

SHOW pdbs

Alter the state of the pluggable database with the following SQL command.

On single instance:

SQL> ALTER PLUGGABLE DATABASE orclpdb OPEN;

On multi-tenant RAC environment:

SQL> ALTER PLUGGABLE DATABASE orclpdb OPEN instances=all;

Pluggable database altered.

Now connect to the database with the user.

SQL> CONNECT scott/tiger@orclpdb;
Connected.
SQL>

That’s it. We have successfully connected to the Oracle database. Happy Database Testing.

—

Database Tutorials on this website:

https://www.testingdocs.com/oracle-database-tutorials-for-beginners/

More information about Oracle Database:

https://www.oracle.com/database/

Related Posts

Oracle Databse 19c Download

Oracle /

Install Oracle 19c Database On Windows 10

Oracle SQL Update Statement

Oracle /

Oracle SQL Update Statement

Oracle SQL Insert Statement

Oracle /

Oracle SQL INSERT Statement

SELECT all rows and columns Oracle

Oracle /

Oracle SQL SELECT Statement

CREATE TABLE Statement Oracle SQL

Oracle /

Oracle SQL CREATE TABLE Statement

‹ Oracle SQL Update Statement› Install Oracle 19c Database On Windows 10

Recent Posts

  • Install RAPTOR Avalonia on CentOS
  • Download RAPTOR Avalonia Edition on Windows
  • npm doctor command
  • RAPTOR Editions
  • Flowgorithm Conditional Breakpoint Statement
  • Flowgorithm Read Numbers from File Example
  • Search Text File Flowchart Example
  • Flowgorithm Turtle Graphics Symbols
  • Draw Circle using Flowgorithm Turtle
  • Draw Parallel Lines using Flowgorithm Graphics

Back to Top

Links

  • Contact
  • Privacy Policy
  • Cookie Policy

www.TestingDocs.com

Go to mobile version