当前位置: 代码迷 >> 综合 >> 访问oracle报错:Connected to an idle instance.
  详细解决方案

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

热度:17   发布时间:2023-12-16 01:27:00.0

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

[oracle@localhost ~]$ sqlplus / as sysdbaSQL*Plus: Release 19.0.0.0.0 - Production on Thu Dec 2 20:21:40 2021
Version 19.3.0.0.0Copyright (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

  相关解决方案