ORA-01034: ORACLE not available

来源:互联网 发布:淘宝卖家改价 编辑:程序博客网 时间:2024/05/20 05:11

问题

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

解决
开启数据库就OK—startup

SQL> startup;ORACLE instance started.Total System Global Area  771751936 bytesFixed Size          8797536 bytesVariable Size         629146272 bytesDatabase Buffers      125829120 bytesRedo Buffers            7979008 bytesDatabase mounted.Database opened.SQL> select * from all_users; USERNAME--------------------------------------------------------------------------------   USER_ID CREATED   COM O INH---------- --------- --- - ---DEFAULT_COLLATION