What causes an ORA-01219 error in Oracle DB?

Question

Oracle

Unable to connect to Oracle database with legacy application.
It seems that there are some problems in the Oracle database itself, because when you open, for example, the "Sessions" tab in the Oracle Enterprise Manager Console, an error occurs ORA-01219:


Please tell me what this could be connected with?
Unfortunately, I have never worked in Oracle (

Answer 1

The ORA-01219 error indicates that the database is not open.
Launch a command line and in it run:

Sqlplus /nolog
Connect [email protected] as sysdba

The current state of the database can be found with the command:
select status from v$instance;
You can open the database with the following command
ALTER DATABASE OPEN;