Linux下安裝了Oracle10g後重新啟動的問題
在Fedora8下安裝了Oracle10g之後,當再次重啟電腦以後!使用"sqlplus system/mileschen"登入系統出現下面的錯誤資訊:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
解決步驟如下:
用"oracle"使用者登入到系統後,輸入如下命令:
(1)[oracle@localhost ~]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Dec 26
06:52:41 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL>
(2)SQL>connect / as sysdba
Connected to an idle instance.
(3)SQL>startup
Total System Global Area 268435456 bytes
Fixed Size 1218892 bytes
Variable Size 75499188 bytes
Database Buffers 188743680 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.
這樣代表資料庫常式已經啟動了,然後輸入下面命令登入使用者
(4)[oracle@localhost ~]$ sqlplus system/mileschen
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Dec 26 06:55:48
2008
copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 -
Production
With the Partitioning, OLAP and Data Mining options
SQL>