最近在学校linux,然后自己在linux下安装oracle进行学习。
安装完毕后oracle,重启系统。然后输入:sqlplus / as sysdba命令后,输入查询语句:select * from all_users;
提示ORA-01034: ORACLE not available,如下图示:
经查询相关资料,原来是没有启动oracle实例造成的。
现在启动oracle实例,在命令行下输入:sqlplus /nolog
SQL>connect sysdba / as sysdba
SQL>startup
[oracle@ilanni ~]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 – Production on Mon Mar 3 11:30:07 2014
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> connect / as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 285212672 bytes
Fixed Size 1218992 bytes
Variable Size 92276304 bytes
Database Buffers 188743680 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.
SQL> exit
Oracle实例启动后,此时我们再次出入查询语句后,就可以正常查询。如下图: