ORA-01034: ORACLE not available

jdbc连接oracle时报错

然后连接下sqlplus

[root@abc ~]# su - oracle
[oracle@abc ~]$ sqlplus

SQL*Plus: Release 11.2.0.4.0 Production on Sat Aug 31 12:26:25 2019

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

Enter user-name: xxxxxxxxx
Enter password: 
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Process ID: 0
Session ID: 0 Serial number: 0


Enter user-name: sys as sysdba
Enter password: 
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

解决办法：

应该是数据库未启动

% sqlplus / as sysdba
...
SQL> startup

退出sqlplus

[oracle@abc ~]$ lsnrctl status

检查listener是否运行正常