Connected to an idle instance 解决

最新推荐文章于 2023-05-13 11:08:08 发布

可心kokoro

最新推荐文章于 2023-05-13 11:08:08 发布

阅读量6.4k

点赞数 1

分类专栏： Oracle

本文链接：https://blog.csdn.net/u011388616/article/details/27491691

版权

Oracle 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

问题：

[oracle@ocp ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Thu May 29 09:49:45 2014
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.

解决：

重启一下数据库

SQL> startup
ORACLE instance started.

Total System Global Area 417546240 bytes
Fixed Size 2213936 bytes
Variable Size 314574800 bytes
Database Buffers 96468992 bytes
Redo Buffers 4288512 bytes
Database mounted.
Database opened.
SQL> exit

[oracle@ocp ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Thu May 29 10:11:26 2014

Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>