访问oracle报错：Connected to an idle instance.

以sysdba进行访问oracle时提示如下信息：

[oracle@localhost ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Dec 2 20:21:40 2021
Version 19.3.0.0.0

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

Connected to an idle instance.

SQL> select * from dual;
select * from dual
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0

解决：

首先要保证启动监听：

[oracle@localhost ~]$ lsnrctl start

然后启动instance：

SQL> startup;

这是再去查看数据库实例时就会是open的状态：

SQL> select status from v$instance;

STATUS
------------------------
OPEN