在linux的oracle的客户端，输入sql语句，出现 ORACLE not available Process ID: 0 Session ID: 0 Serial number: 0

一写代码就开心

已于 2022-04-25 21:20:20 修改

阅读量605

点赞数

分类专栏：虚拟机linux 文章标签： linux

于 2022-04-21 10:28:04 首次发布

本文链接：https://blog.youkuaiyun.com/python113/article/details/124315346

版权

虚拟机linux 专栏收录该内容

52 篇文章

订阅专栏

当在Linux环境下使用Oracle客户端时遇到'ORACLE not available'错误，可以通过检查监听器状态和调整数据库闪回区大小来解决。首先确认listener是否正常运行，然后以sysdba权限登录，执行关闭、装载、打开数据库的命令，并调整db_recovery_file_dest_size参数以增大闪回区。执行完毕后，问题通常可以得到解决。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1 问题

在linux的oracle的客户端，输入sql语句，出现 ORACLE not available Process ID: 0 Session ID: 0 Serial number: 0

2 解决

linux上登录Oracle，输入’'select 1 from dual"，出现如下报错信息：

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

1.检查listener是否运行正常

2.以管理员角色登录，输入以下命令。因为之前归档文件满了，还报错：ORA-03113: end-of-file on communication channel，所以增加了闪回区大小，具体操作如下：

[oracle@localhost ~]$ sqlplus / as sysdba
 
 
SQL*Plus: Release 11.2.0.1.0 Production on Tue Dec 17 16:35:56 2019
 
Copyright (c) 1982, 2009, Oracle.  All rights reserved.
 
Connected to an idle instance.
 

SQL> shutdown abort
ORACLE instance shut down.


SQL> startup mount;
ORACLE instance started.
 
Total System Global Area  521936896 bytes
Fixed Size		    2214936 bytes
Variable Size		  499123176 bytes
Database Buffers	   16777216 bytes
Redo Buffers		    3821568 bytes
Database mounted.


SQL> show parameter db_recovery_file_dest_size;
 
NAME				     TYPE

VALUE

db_recovery_file_dest_size	     big integer
10G
 


SQL> alter system set db_recovery_file_dest_size=15G;
 
System altered.
 



SQL> alter database open;
 
Database altered.
 


SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.




SQL> startup;
ORACLE instance started.
 
Total System Global Area  521936896 bytes
Fixed Size		    2214936 bytes
Variable Size		  499123176 bytes
Database Buffers	   16777216 bytes
Redo Buffers		    3821568 bytes
Database mounted.
Database opened.