Fix ORA-01109: database not open Error

admin

4 years ago

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

Error indication and message:

SQL> CONNECT scott/tiger@orclpdb;
ERROR:
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;

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/