oracle 数据库io 异常,错误代码17002 解决办法
数据库使用一个月了,突然挂掉:错误代码17002 io异常:read timeout
解决:
1.登陆sql命令窗口
[oracle@hostname ~]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on Fri Aug 28 10:58:59 2015
Copyright (c) 1982, 2009, Oracle. All rights reserved.
2.以管理员身份连接到数据库
SQL> connect sys/oracle as sysdba
Connected.
3.关闭数据库实例
SQL> shutdown abort
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options
4.查看监听并关闭
[oracle@hostname~]$ lsnrctl status
[oracle@hostname~]$ lsnrctl stop
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 28-AUG-2015 11:15:32
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=iZ11gqfg6h1Z)(PORT=1521)))
The command completed successfully
5.重启监听
[oracle@hostname~]$ lsnrctl start
6.重启数据库
[oracle@hostname~]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on Fri Aug 28 11:30:25 2015
Copyright (c) 1982, 2009, Oracle. All rights reserved.
SQL> connect / as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 1486495744 bytes
Fixed Size 2213496 bytes
Variable Size 1124075912 bytes
Database Buffers 352321536 bytes
Redo Buffers 7884800 bytes
Database mounted.
Database opened.
特别需要注意的是,一定要先启动监听服务,再启动数据库,否则还是连不上的。
查看oracle 数据库服务:lsnrctl status