ORA-01034: ORACLE not available

最新推荐文章于 2024-11-12 10:56:30 发布

weixin_33674976

最新推荐文章于 2024-11-12 10:56:30 发布

阅读量69

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/feiZhou/p/9344165.html

版权

问题

SQL> select * from all_users; 
select * from all_users
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0

解决
开启数据库就OK—startup

SQL> startup;
ORACLE instance started.

Total System Global Area  771751936 bytes
Fixed Size          8797536 bytes
Variable Size         629146272 bytes
Database Buffers      125829120 bytes
Redo Buffers            7979008 bytes
Database mounted.
Database opened.
SQL> select * from all_users; 

USERNAME
--------------------------------------------------------------------------------
   USER_ID CREATED   COM O INH
---------- --------- --- - ---
DEFAULT_COLLATION

转载于:https://www.cnblogs.com/feiZhou/p/9344165.html