JAVA高级面试进阶训练营视频教程

admin

数据库使用一个月了，突然挂掉：错误代码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