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

2022-05-09 10:58:18 浏览数 (1)

目录

  • 1 问题
  • 2 解决

1 问题

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

2 解决

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

代码语言：javascript复制
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，所以增加了闪回区大小，具体操作如下：

代码语言：javascript复制
[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.

以上执行完，你再输入sql语句，就可以看到有结果了；

linux sql oracle

0 人点赞